Hello There,
I've implemented this at our firm. First thing you need to do is request a developer key from google for your MCC account. You can't access the API without it, and it took our firm over three months to get one from them. So, it is probably best to engage
your marketing department early on and let them know that this might take awhile due to matters outside of your control. Their timeliness might have changed in the last year, but this was my experience a year ago when we got our key.
Everything you need to do is laid out here.
https://developers.google.com/adwords/api/
There is a C# library that you'll need to download. Their soap API isn't clean like some other SaaS vendors. So, you can't just point visual studio at the WSDL and create a usable reference. The library takes care of all the additional
work needed to connect for you, and in all honesty, using it is pretty easy.
When I wrote our implementation, I wrote a console app that dumped the Adwords data to a csv files and just had SSIS call the console app and read in the csv files.
In the 201209 update, they added the ability to query reports via a SQL like language called AWQL. It is the easiest way I found to get usable data out of the API. After it went live, the only time I accessed the objects directly for
were things like a full list of campaigns or adgroups. It really does make life easier.
https://developers.google.com/adwords/api/docs/guides/awql
I'd give you my source code as a starting point if I could, but it is the property of the company.
Hope that helps,
Kenneth
