What is best practice to extract general data at all levels of granularity?

[csca...@dotandbo.com]

I want to extract some basic data from adwords into our data warehouse, but I want to have it at multiple levels of granularity.

I'm looking at the different services right now and I don't see a way to get information from each level in one call.

For instance if I start at a very granular level (AdGroupAd), I can get most of the data I need for all AdGroupAds with one call. But if I want to know something about the parent AdGroups (the name and the bid type for example), I would then need to make another call and tie them together manually. This gets even more complicated when Campaign is added to the mix.

With Facebook Ads, even if you request data at the ad level, you can also ask for the campaign name that ad is in. Is something like this possible with Adwords?

To simplify the question, what is the easiest way to get Campaign names when extracting data at the AdGroupAd level?

Thanks,

Chris

P.S. I do not want to make a call for each campaign and ad group, and I'd prefer not to have to tie it together manually, but it seems like that may be unavoidable.

[Yin Niu]

Hi Chris, 

You won't be able to retrieve Campaign or AdGroup details from AdGroupAdService, but you could use Ad Performance Report to get the data you need. 

Thanks,

Yin, AdWords API Team.

[csca...@dotandbo.com]

This is exactly what I was looking for, not sure how I missed it. Thanks!