Create our own search engine rank-checking tool, like the dozens that are already out there-- potentially leveraging open source code or scrapers. Must dump results to MySQL and show tabular results via our front-end in PHP. Note: this is a phased project which will include several other later steps-- integration with another tool being built. Do not bid if you do not have experience with scrapers and web API's. I prefer coders from the United States and Canada, but can make exceptions, depending on your experience and client skills. Questions? Please feel free to ask.
## Deliverables
Steps: - Client provides a list of up to 40 keywords that are important to them via a standalone form. - Bot goes out on the first day of each month and does a search on those terms across the major search engines (Google, Yahoo, MSN-- and more enginges if easily done), checking for natural rankings within the first 100 results. It stores those results down to a table that has client_id (or can be url to be checked for), date (when check was performed), engine (Google, Yahoo, MSN), and rank. If there happen to be more than 1 ranking, which happens often (if you have the 4th and 5th result-- then that counts at 2 top 10 rankings), then multiple records are inserted. - Client can login to see report that shows keywords down the side and engine across the top. The row and column totals count the number of first page rankings. Row grand totals are shown first. So if we have 40 keywords and 5 search engines, then we'd have 200 data cells in this report, plus an extra row and column for totals. - Email of this report is sent out after report is run, just showing the data chart. We'd like to compare against the previous month-- counting the change in number of first page rankings. - Optional: include client logo in top left, as we've done with Equifax. Should make this an automated process-- so rather than manually insert, we should be able to upload a logo upon account set-up, which is used in the header for that client. After logging into [login to view URL], the client should see links to both their SEO and SEM reports. And from within each report, see a link to the other one. Note: we don't want the bot to check rankings more than twice a month, as that could affect rankings. ======================== 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
PHP/MySQL