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?
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups
"AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/64310da0-b8d8-4b29-a5fe-9508d312dad4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
