Can we just keep ad performance report and roll up to different levels?

[Susie Zhao]

Hi,

If we just want to keep a lowest level report such as ad performance report and use this report to roll up to different levels, such as keyword, ad group or campaign, account level.

1. Is this the right way to roll up?

2. Keyword_id is included in ad performance report,(here is criterion_id actually). But keyword is not included in this report.

So do you have any dimension tables(such as criterion tables which contain id, name and state) which we can join the ad performance report with.

In this way, if it works, we don't need to keep reports in different granularity.

Thanks,

Susie

[Thanet Knack Praneenararat (AdWords API Team)]

Hi, 

You can use the ad performance report as the lowest level report and use it to roll up to ad group, campaign, account levels, but not keywords.

This is because keywords do not belong to ads or vice versa, but both have an ad group as their parents in a hierarchy.

(There are relationships between keywords and ads but not parental relationship like account -> campaign -> ad group -> ad)

You may use keyword performance report to look up a keyword (actually criterion) ID you've found in the ad performance report and get its other details like keyword texts.

To summarize, for your question 1, the answer is yes, but not for keywords.

For question 2, you may have a look at keyword performance report.

Cheers,

Thanet, AdWords API Support