We are using a script to pull cost and week data from Google Ads and we
think that ACCOUNT_PERFORMANCE_REPORT is responsible for displaying
incorrect cost numbers, as it does not include the Performance Max
campaigns.
Here's the code and it was working normally before the introduction of
Pmaxes.
Can someone please help with it?
We wonder if the AdWordsApp.report part in the code (as opposed to using
the new AdsApp.report) is not causing it, or is it rather Pmax not being
supported right now?
*Here's the text version of the script below as well:*
function main() {
var SPREADSHEET_URL = 'X';
// Name of the specific sheet in the spreadsheet.
var SHEET_NAME = 'AT';
var ss = SpreadsheetApp.openByUrl(SPREADSHEET_URL);
var sheet = ss.getSheetByName(SHEET_NAME);
//Append the row header is sheet is empty
if (sheet.getLastRow() == 0) {
sheet.appendRow(['Week from', 'Cost (Mon-Sun)']);
}
var report = AdWordsApp.report(
'SELECT Cost ' +
'FROM ACCOUNT_PERFORMANCE_REPORT ' +
'DURING LAST_WEEK');
var rows = report.rows();
var timeZone = AdWordsApp.currentAccount().getTimeZone();
var now = new Date;
var startDate = new Date(now.getTime() - (7 * 24 * 3600 * 1000));
var formatedDate = Utilities.formatDate(startDate, timeZone,
'dd/MM/YYYY');
while (rows.hasNext()) {
var row = rows.next();
sheet.appendRow([formatedDate,row['Cost']]);
}
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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
"Google Ads API and AdWords 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/4e6380d2-7ff4-4b14-9a9c-063d2de1441an%40googlegroups.com.
