Keywords don't show in the Keywords Performance Report

[Bastiaan Bijl]

Hi all,

I am trying to write an AWQL script to parse data from the Keyword Performance Report to Google Sheets for offline analysis.

I have generated an AWQL query to do this with the handy generator from ScriptNinja.

However, the data I get back does not include the actual Keyword itself for some reason, and I cannot add it. How do I get the actual Keyword with the rest of the metrics combined from the report?

The query I am using is:

// Select Query
var query = 'SELECT Id, CampaignName, AdGroupName, AverageCpc, Ctr, Clicks, Conversions, Impressions, InteractionRate, PostClickQualityScore, QualityScore, HistoricalQualityScore ' +
'FROM KEYWORDS_PERFORMANCE_REPORT ' +
'WHERE CampaignStatus = ENABLED ' +
'AND CampaignName CONTAINS \'General\' ' +
'DURING LAST_30_DAYS '

If I put 'Keyword' in the SELECT clause, I get an error.

I'm a bot lost here so I hope someone can help out.

Thanks!

Bas

[Google Ads API Forum Advisor Prod]

Hi Bas,

This forum is for Google Ads API related issues. However, the field you will need is Criteria. If you face any other issues, I'd suggest reaching out to the Google Ads Scripts forum.

Cheers,
Anthony
Google Ads API Team  

ref:_00D1U1174p._5001UZX7du:ref

[Bastiaan Bijl]

Hi Anthony,

Thanks for your answer! That is exactly what I needed!

Really appreciated.

Best, Bas