We have a list of domains.
We look for a script who display results (Stats value, Keywords rank, PR) for each domains:
This is the list of task that the script have to do for each domains and Per month : (The script must be deal when a year is over it start to store data in a new table.)
- Get the Google Pagerank and store it in the database.
- Get the Stats visit value and the stats Pages value from a webpage, available on the web but protected by .htaccess. (I’ll give you the Url when bid has won) and store it in the database. (This page is a result from Webdruid, so it could be easy to parse it to get the right data).
- Get the rank In Google and Yahoo for each keywords and store it in the database.
The script could be split in 2 parts :
1st part : The displaying result !
In a html table it must display all domains name with them associated values : Pagerank value, keywords position, statistic values
This html table could be classified by domains, Pagerank value, keywords position, statistic values. This html table can be displayed by Month too...
A button on the page must generate a popup ( or something else)who contains a Chart (Jpgrah or Flash charts)with selected domain to compare the evolution per month.
On the page, we've choosen 3 domains to compare. We click on a button to generate the chart and in a popup we have by default, the pagerank evolution by month.
On the chart, we can switch between the evolution of Pagerank, keywords position, statistics values for the 3 domains selected.
2nd part : the backoffice
Manage the domain name list (Add/modify, delete, View all)
Manage the keywords list (Add/modify, delete, View all)
Button to launch the script manually.
Export /import data from file.
One mysql database who contains:
Table for : Domains names, url domains, small snapshot from the main page
Table for : keywords
Table for : data à pagerank for each Domains name, per month and per Year.
Table for : data à Keywords ranks (google and Yahoo) for each keywords and per Domains name, per month and per Year.
Table for : data à stats parsed from a webpage protected by .htaccess (Visits, Pages) for each Domains name, per month and per Year.
( It’s an example for the Mysql database structure and if you think there’s a better way , don’t hesitate.)
Please feel free to ask any questions about it.