Campaign level assets and statistics from UAC

[Aman Igdirov]

Hi,

I'm trying to get campaign_asset statistics from UAC campaigns

But my report is empty 

How to fix it?
My script:

function main() {

   var spreadsheet = SpreadsheetApp.create("Report output");

   var report = AdsApp.report("SELECT metrics.clicks, asset.id " +

       "FROM campaign_asset ");

   report.exportToSheet(spreadsheet.getActiveSheet());

   Logger.log("Report available at " + spreadsheet.getUrl());

}

[Google Ads Scripts Forum Advisor]

Hello,

Thank you for reaching out to us.

With regard to your concern, the asset.id field does not exist in campaign_asset which is the reason that you're getting an empty report. You may want to review the field list here.

Regards,

Teejay Wennie Pimentel Google Ads Scripts Team

ref:_00D1U1174p._5004Q2R6n20:ref