Incorrect data in PLACEHOLDER_FEED_ITEM_REPORT (Performance grouping not does not match in UI and in report data)

[Игорь Тирский]

Hello, I try to get PLACEHOLDER_FEED_ITEM_REPORT with this Google Ads Script (and get it - it is ok, but data inside report is incorrect)

function main() {
  runReport();
}

function runReport() {
  var currentdate = new Date();
  var currentAccount = AdsApp.currentAccount();
  var datetime = ": " + currentdate.getDate() + "/"
                + (currentdate.getMonth()+1)  + "/"
                + currentdate.getFullYear() + " @ " 
                + currentdate.getHours() + ":" 
                + currentdate.getMinutes() + ":"
                + currentdate.getSeconds();
 
  folderId = '119cfctQ7FSURhyHV-SUPER_SECRET_DIR';
 
  var cycles = 2
  var folder = DriveApp.getFolderById(folderId);
 
 
  for(var i=1; i<=cycles; i++)
  {
    var date_from = new Date(currentdate - (i*14)*24*60*60*1000)
    var date_to = new Date(currentdate - (i-1)*14*24*60*60*1000)

    day = ('0' + date_from.getDate()).slice(-2);
    month = ('0' + (date_from.getMonth()+1)).slice(-2);
    var load_date_from = date_from.getFullYear()+month+day;
   
    day = ('0' + date_to.getDate()).slice(-2);
    month = ('0' + (date_to.getMonth()+1)).slice(-2);
    var load_date_to = date_to.getFullYear()+month+day;
   
    filename_stat = currentAccount.getCustomerId() + '_stat_'+load_date_from+'_'+load_date_to
    filename_conv = currentAccount.getCustomerId() + '_conversions_'+load_date_from+'_'+load_date_to
   
    var spreadsheet = SpreadsheetApp.create(filename_stat);
    var file = DriveApp.getFileById(spreadsheet.getId());
    folder.addFile(file)
    var report = AdsApp.report('SELECT AccountDescriptiveName, Date, FeedItemId, AttributeValues, Clicks,Cost, Impressions, VideoViews FROM PLACEHOLDER_FEED_ITEM_REPORT Where Impressions>0 DURING '+ load_date_from+','+load_date_to);
    report.exportToSheet(spreadsheet.getActiveSheet());


    var spreadsheet = SpreadsheetApp.create(filename_conv);
    var file = DriveApp.getFileById(spreadsheet.getId());
    folder.addFile(file)
    var report = AdsApp.report('SELECT AccountDescriptiveName, Date, FeedItemId, AttributeValues, ConversionTypeName, Conversions, AllConversions FROM PLACEHOLDER_FEED_ITEM_REPORT Where AllConversions>0 DURING '+ load_date_from+','+load_date_to);
    report.exportToSheet(spreadsheet.getActiveSheet()); report.exportToSheet(spreadsheet.getActiveSheet());
  }
}

But in UI (Google Ads UI in Ad assets section (App install ad)) I see, same feed item id has performance group Good in the UI but in the report - 2 = "learning"

in UI:

in the report file (Google spreadsheet, then report loaded after script finish)

I hid some sensitive data, but can send it in private message (and account id too)

Why performace grouping mismatch in report and in UI?

[Google Ads Scripts Forum Advisor]

Hello,

Can you please reply privately and provide your CID and script name so we can investigate directly in your account? Since we may not have access to the folder on the drive, we will need you to share access to the spreadsheet created by this script. When you reply privately, I can provide the support emails that should receive access. If you can also point us to the date/time that this script executed and you noticed this discrepancy, that will also be helpful.

Thanks,
Matt 
Google Ads Scripts Team

ref:_00D1U1174p._5001USx4Dt:ref

[Google Ads Scripts Forum Advisor]

[Игорь Тирский]

Hello, I sent to you all information, when me to wait the answer. Thank you!

среда, 29 января 2020 г., 23:14:55 UTC+3 пользователь adsscriptsforumadvisor написал: