AWQL: Filter by CampaignName in ACCOUNT_PERFORMANCE_REPORT

[Joseba U]

Hey there,

I'd like to have the performance report for certain campaigns within an account, something like this:

SELECT Cost, AverageCpc, Ctr, AveragePosition, Impressions, Clicks
FROM ACCOUNT_PERFORMANCE_REPORT
WHERE CampaignName CONTAINS "Search"

But that WHERE condition does not work, I get a parsing error. What am I doing wrong?

Thank you very much!

[BadriNarayanan Srinivasan]

Hi Joseba -

Account performance report does not support campaign name / campaign. Please refer appendix table https://developers.google.com/adwords/api/docs/appendix/reports#account for more details.

If you would like to filter through campaigns, you can use Campaign performance report.

Hope this helps,
Badri