Deliverable: Build a web-based application for the purpose of tracking search engine rank (SERP) of multiple sites and keyphrases into a database, along with the ability to group records, and add multiple notes (with date) to each record.
Primary components identified by an end user:
(1) Database (e.g. MySQL) -- for storing keyphrases, their associated Google estimated monthly (Exact, Global) search volume (updated monthly), daily/weekly updates of Google rank (SERP), and for including a web-based administration interface for running dynamic queries against DB.
(2) Google Data Interface (e.g. AJAX / XML API) --
(a) for automatically collecting and storing Google SERP data for multiple web sites (e.g. 20) with multiple keyphrases each (e.g. 100), on daily or weekly cycle;
(b) for automatically collecting and storing the Google estimated monthly (Exact, Global) searches of the keyphrase on a monthly or quarterly cycle (Google Adwords API perhaps);
(c) including a web-based administration interface for setting preferences.
(3) Google Charts Interface (e.g. AJAX / XML API) -- for displaying a line graph of a keyphrase (or keyphrases) historical Google SERP (stored in the database), an alt-text style marker for notes (stored in the database), including a web-based administration interface for setting preferences.
Here's what I want to see of the finished features - as an end user:
(a) A web-based table (grid, sortable) showing all keyphrases, the ranked URL(s), Google estimated monthly (Exact, Global) searches of the keyphrase, the current search engine rank (SERP) of the URL for that keyphrase, the last update date, a link/icon for one-click historical rank chart, an edit record link/icon, and a checkbox for multiple record graphing/deleting/grouping.
(b) A web-page that shows a line graph chart of a web page's position for a target keyphrase. (see attached image)
(c) The chart will include markers with alt text / popups for notes saved in the database (via the admin page) such as "Mar 04 2010: Built 21 backlinks."
(d) The ability to choose to display 1 or multiple line graphs by selecting from a web-based table showing all keyphrases, their associated URL (may be 1 or more), and the current search engine rank (SERP). (see attached image)
(e) Web-based administration pages for setting chart preferences, conducting dynamic database table queries, and setting Google preferences (e.g. update frequency)
*Note 1: Dynamic field references over hard-coded field references is strongly preferred.
*Note 2: Graph interface examples the end user has liked are:
[login to view URL]
[login to view URL] (with the Dividend or Stock Split symbols showing)
Review: I anticipate initial questions to clarify database fields, et cetera, plus proofing initial screen shots prior to development. If you wish to limit the number of proofing sessions (aka revisions), please specify in your bid.
NOTICE: For any job responses, please start your message with the word "SERP" so that I know that you've read the job description. Any message/bid not leading with the word "SERP" will be discarded as a spam reply. Thanks. :)