AdWords
5.3K members online now
5.3K members online now
Use AdWords conversion tracking and reporting to measure your results. Have a question about Google Analytics? Post it here, on the Google Analytics Community!
Guide Me
star_border
Reply

most efficient way to get account summary stats (structure?)

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Dear Colleagues,

 

What is the fastest way to get account (structure?) summary information :

 
per-account: how many campaigns
per-campaign: how many adgroups
per-adgroup: how many ads
per-ad: how many keywords
 
Is it really true that one must:
- request 4 or more (performance) reports, download values to local RDBMS and then use SQL?
OR
- get all keywords per Ad per Adgroup per Campaign per Account and then summarize
 
I must do this for many accounts and want to do it most efficiently. Would be nice to not have to download all keywords just to get counts .
 
Thank you
 
 

Re: most efficient way to get account summary stats (structure?)

Follower ✭ ✭ ✭
# 2
Follower ✭ ✭ ✭
Hi Zach,

If you are comfortable with JavaScript, or at least computer programming in general, you can try Apps Script:

https://developers.google.com/adwords/scripts/

You can get the answers you want programmatically, and would probably be more efficient than a download and counting with excel macros.

Re: most efficient way to get account summary stats (structure?)

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
Hi George,
Thank you for responding. Sadly Adwords scripts are helpful for adding value to the UI. I need technology that can be called from servers that want to download bulk data. Scripts seems unsuitable for that.

Re: most efficient way to get account summary stats (structure?)

Follower ✭ ✭ ✭
# 4
Follower ✭ ✭ ✭
Hi Zach,

Perhaps you could pose this question to this community:

https://groups.google.com/forum/#!forum/adwords-scripts

or

https://plus.google.com/+GoogleAdsDevelopers/posts

Perhaps there is someone with expertise there that can help, either through Apps Script, or another solution.