Exception: Column 'HistoricalQualityScore' is not valid for report type KEYWORDS_PERFORMANCE_REPORT. Double-check your SELECT clause.

27 views
Skip to first unread message

ric...@precisdigital.com

unread,
Jul 11, 2017, 11:54:33 AM7/11/17
to AdWords API Forum
var report = AdWordsApp.report("SELECT CampaignName, AdGroupName, Criteria, HistoricalQualityScore, HistoricalCreativeQualityScore, HistoricalLandingPageQualityScore, HistoricalSearchPredictedCtr, AverageCpc, Clicks " +
        " FROM KEYWORDS_PERFORMANCE_REPORT " +
        " WHERE Clicks > " + limit +
        " AND HasQualityScore = TRUE " +
        " DURING LAST_30_DAYS");


Gives me the "Exception: Column 'HistoricalQualityScore' is not valid for report type KEYWORDS_PERFORMANCE_REPORT. Double-check your SELECT clause." exception..

Does anyone know why this isn´t working - according to the "https://developers.google.com/adwords/api/docs/appendix/reports/keywords-performance-report" there is support for HistoricalQualityScore?


Shwetha Vastrad (AdWords API Team)

unread,
Jul 11, 2017, 2:41:29 PM7/11/17
to AdWords API Forum
Hi,

These fields were added to Keywords Performance Report in AdWords API v201705. Please see the release notes for more details. Since this question is related to AdWords Scripts, I would suggest that you post it in the AdWords Scripts Forum.

Regards,
Shwetha, AdWords API Team.
Reply all
Reply to author
Forward
0 new messages