I would like to have a script created that is capable of access Google Adwords data via the API and create a reporting system. This script is to be created in PHP/MySQL and usable via a web server. Would need three sets with customizable date ranges. Campaign Summaries (Clicks, Impressions, CTR, Conversions, Conversion->Click Ratio, Budget Spent and Cost Per Conversion). Broken down by each campaign in the account. Summarized Adgroup reporting (Same as above but include cost per click as well. Should be broken down by adgroups in a campaign Summarized Keyword/Ads reporting (Same as above but also include quality score. Should be broken down by keywords/ads per adgroup) The reporting would need graphs as well as text data and be able to be setup via cron to be autogenerated (based on whatever criteria we specify) and emailed to us in PDF format. we need to be able to do comparison analysises as well. Two types: 1) Previous period analysis. Have the report show the % (increase or decrease) in clicks, impressions, CTR, etc compared to the previous period of the same length. So if I’m showing a 30 day report, it will compare based on the 30 days previous to that 2) Historical comparison. Be able to see growth/decline in all stats based on up to 3 specified time periods. Let me know if you need more clarification. Comparisons will need to be doable on a per client basis as well as per MCC basis (including subMCC accounts) Design of the PDFs will be provided, you will simply need to setup your scripting I will need to be able to create reports manually as well as setup automatically run reports. These reports should then be set to be emailed to the addresses of my choice and a log maintained of reports created and when they were sent. Any questions, please send me a message
## Deliverables
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 Adwords API