Most efficient way of pulling criterion data for large accounts

[Sam]

Hi,

I'm trying to pull all keywords contained within an account in order to output the details (e.g. # of keywords, # of campaign negatives, #ad groups with over x keywords, etc).

My understanding is that in order to be able to retrieve a criterion with it's associated ad group ID, the data needs to come from AdGroupCriterionService. However, some of my accounts contains 10k+ ad groups and 500k+ keywords, making iterating through ad group level calls slow and feeling very inefficient. As far as I can tell, this can't be filtered at a campaign level, meaning that a call unfiltered by AdGroupId can fail due to the 100k paging startIndex limit.

Is there a more efficient way to pull large amounts of criterion data whilst still having a full view of the criterion's information?

Thanks

Sam

[Jason Stedman]

Sam,

A Criteria Performance Report(link) can get you a criterion along with it's associated ad group id. By also getting a campaign or adgroup performance report and then combining them on your side, you can almost always get the data you need. 

If you have not used ad-hoc reporting for AdWords API before, this page is very helpful.

Hope this helps!

[road11]

Forget the AdGroupCriterionService. With that many kw, the api cost will kill you. Use reports. I use Criteria Performance report and Keyword Performance Report. The only thing I use AdGroupCriterionService for is bidding. If all you're doing is consuming data, use reports; they're free.

Eric

On Sunday, February 22, 2015 at 5:07:02 AM UTC-5, Sam wrote: