Database Sync with AdWords MCC

[jake...@justmedia.com]

There's a ton of useful intelligence hidden in the data of our agency's MCC, so we'd like to (1) setup a database, (2) sync the database with AdWords using Java in Eclipse, and (3) run queries to help answer questions like "what's the avg. CTR for 728x90 banners in the network security industry?", etc. On 9/29/08, AdWords announced the launch of an "AdWords API Local Database Sync project". Sadly, it's been discontinued, so my question is whether or not Google has a replacement solution? I'm thinking of trying an open source database and using AdWords API to sync it with our MCC, but knowing where to start is a bit tricky.

[Vishal Vinayak (Adwords API Team)]

Hi Jake,

Unfortunately, there isn't a replica alternative available for the API local database sync project. You can, however, use the AdWords API to extract data using various reports and sync that data in your local database. If your environment is Java based, you can also take a look at the aw-reporting framework, which can help you with extracting data using various reports. However, please note that the data available via the API has a certain lag. Please refer to this article to determine freshness of your data. 

To be able to use the API, you would first need to sign up for API access and then follow these steps to setup your local environment and make the first API call. 

Regards,

Vishal, AdWords API Team

[jake...@justmedia.com]

Thanks, the aw-reporting framework is exactly what I need.