You have chosen to sponsor your bid up to a maximum amount of .
Currently, we have a PHP script to collect Google Adwords report data and insert it into our MySQL Database.
This script is functional for version 13 and uses the http://google-apility.sourceforge.net/ APIlity PHP library.
We get a full keyword report regularly via XML which is parsed for database insertion, the fields we get data from are shown below.
'Campaign', 'CampaignStatus', 'AdGroup',
'Keyword', 'KeywordDestUrlDisplay', 'KeywordStatus',
'KeywordTypeDisplay', 'KeywordMinCPC', 'MaximumCPC', 'MaximumCPM',
'AveragePosition', 'Impressions', 'Clicks',
'Cost', 'CPC', 'CPM ', 'CTR'
The fields broadly follow a standard keyword report as you would do it from the UI
Our script follows a set template where we can either input a date as a parameter OR the script will pull yesterdays data from Google Adwords.
the script can then be crontabbed to execute when we want.
We use PHP 5.2.13 on a RedHat Linux Enterprise Box.
However with version 13 due to sunset we need to move our data collection to version 2009
Take our existing template and adapt the script to v2009 methods and libraries. We will supply a current example with users and passwords redacted.
You will be able to use the google sandbox for testing.
We will test the php produced internally against our googleadwords data and verify its effectiveness.