What is the column name for Keyword in the Keyword Performance Report?

[Eric Christoph]

I feel silly writing this question, but I'm stumped. I'm writing an AWQL query to pull into a database:

function getAWKeywordReport(popDuration){

  var report = AdWordsApp.report(

    "SELECT Id" +

        ", Keyword" +

        ", KeywordMatchType" +

        ", CampaignName" +

        ", AdNetworkType1" +

        ", AdNetworkType2" +

        ", Device" +

        ", Month" +

        ", Impressions" +     

        ", Clicks" +        

        ", Cost" +

        ", Conversions" +

        ", ConversionValue" +

        " " +

    "FROM KEYWORDS_PERFORMANCE_REPORT " +

    "DURING " + popDuration);

  

  Logger.log("Keyword Performance Report generated for period: " + popDuration)

  

  return report

}

I get this error: 

Column 'Keyword' is not valid for report type KEYWORDS_PERFORMANCE_REPORT. Double-check your SELECT clause. (line 77)

When I go to the documentation, I can find no attribute for Keyword, SearchTerm, etc.:

https://developers.google.com/adwords/api/docs/appendix/reports/keywords-performance-report

What am I missing? How do I query the actual keyword?

[Shwetha Vastrad (AdWords API Team)]

Hi Eric,

You need to use the "Criteria" field in the report query to include the Keyword column in the downloaded Keywords Performance Report. To get statistics for the search terms you can use the Search Query Performance Report. 

Regards,

Shwetha, AdWords API Team.