I want you to create a AdWords script that will collect data about the AdWords account and its campaigns, and then send that information in a formatted email. I want the script to be able to run on a daily basis.
See the attachment for a document illustrating what I want
Here is what I want the script to collect:
1. Cost, Average CPC, CTR, Average Position, Impressions, Clicks
- I want this data to be displayed in columns broken down into separate days for the week, with a total/average column at the end.
1. I want the report to show the following information about the campaigns
- Status (active, paused), End date, daily budget, projected cost (has to be calculated), total cost for the campaign
- There are a few places where I want to be able to predefined text such as the budget for a campaign etc. so that that information will be included in the email. I also want two boxes where I can predefined text. See the attachment for an illustration.
If the information needs to be stored in a Google Spreadsheet in order to get this to work that is fine but it is not a requirement.
Please include any relevant cases/experience you have/done in your bid.
Automatic/generic applications will most likely be ignored!