Thank you Anthony!
I've tried the Placeholder Feed Item Report, it seems to work but the only
problem is that the value isn't there
[image: Screen Shot 2563-05-30 at 10.29.37.png] <about:invalid#zClosurez>
Here is the query I use
var QUERIES = [{'query' : 'SELECT AdGroupId, AdGroupName, Conversions,
ConversionRate, ConversionTypeName ' +
'FROM ADGROUP_PERFORMANCE_REPORT ' +
'DURING 20191001,20200430',
'spreadsheetUrl' :
'https://docs.google.com/spreadsheets/d/xxx/edit#gid=xx',
'tabName' : 'ConversionTypeName',
'reportVersion' : 'v201809'
},
{'query' : 'SELECT CampaignName, Clicks, Impressions, Cost '
+
'FROM CAMPAIGN_PERFORMANCE_REPORT ' +
'WHERE Impressions > 10 ' +
'DURING 20191001,20200430',
'spreadsheetUrl' :
'https://docs.google.com/spreadsheets/d/xxx/edit#gid=xx',
'tabName' : 'Campaigns',
'reportVersion' : 'v201809'
},
{'query' : 'SELECT FeedItemId, AdGroupId, Conversions,
ConversionRate ' +
'FROM PLACEHOLDER_FEED_ITEM_REPORT ' +
'WHERE Impressions > 1 ' +
'AND FeedId = xxxxxxx ' +
'DURING 20191001,20200430',
'spreadsheetUrl' :
'https://docs.google.com/spreadsheets/d/xxx/edit#gid=xx',
'tabName' : 'Feed Item',
'reportVersion' : 'v201809'
}
];
function main() {
for(var i in QUERIES) {
var queryObject = QUERIES[i];
var query = queryObject.query;
var spreadsheetUrl = queryObject.spreadsheetUrl;
var tabName = queryObject.tabName;
var reportVersion = queryObject.reportVersion;
//Logger.log(spreadsheetUrl + " " + query);
var spreadsheet = SpreadsheetApp.openByUrl(spreadsheetUrl);
var sheet = spreadsheet.getSheetByName(tabName);
var report = AdWordsApp.report(query, {apiVersion: reportVersion});
report.exportToSheet(sheet);
}
}
> The report from ADGROUP_PERFORMANCE_REPORT and CAMPAIGN_PERFORMANCE_REPORT
> work perfectly, please let me know what have I done wrong with the
> PLACEHOLDER_FEED_ITEM_REPORT.
> Would be highly appreciated guys.
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads 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 and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/4e3acd3d-9f65-40bb-8f85-e83338dadc41%40googlegroups.com.
