Url Performance Report displays not all URLs

36 views
Skip to first unread message

Mihail Ma

unread,
Jun 28, 2018, 6:08:22 AM6/28/18
to AdWords API and Google Ads API Forum
Hi all! 
I need to get all URLs by company, where my videoAd had been displayed. If I see it from AdWords web interface - for example for 25.06.2018 - there is about 4000 youtube channels, where AD been displayed. But if I get it from Url Performance Report by script - there only 180 urls((( WHY?????

There is my script:

var period = '20180625, 20180625';
function main() {
 var videoIdList = [];

  var report = AdWordsApp.report(
     'SELECT CampaignName, Url, AdGroupName ' +
    'FROM  URL_PERFORMANCE_REPORT ' +
    'WHERE CampaignId = 1177713739 ' +
  //   'AND AdNetworkType1 IN [YOUTUBE_SEARCH, YOUTUBE_WATCH] ' +
    'DURING ' + period, { includeZeroImpressions : true });

  var rows = report.rows();

  while (rows.hasNext()) {
    var row = rows.next();
    var videoId = row['Url'];
    videoIdList.push(videoId);
  Logger.log(row['CampaignName'] + " - " + row['AdGroupName'] + " - " + row['Url']);
   }
Logger.log("Total Rows - " + videoIdList.length);
}


Milind Sankeshware (AdWords API Team)

unread,
Jun 28, 2018, 2:29:32 PM6/28/18
to AdWords API and Google Ads API Forum
Hi Mihail,

I ran the URL Performance report and I received 183 rows which are matching with AdWords UI. Could you please share the web interface screenshot where you are seeing 4000 youtube channels. You could refer this mapping guide between AdWords report stats and AdWords UI. Also, you could choose "Reply privately to author' option while responding. 

Thanks,
Milind, AdWords API Team.
Reply all
Reply to author
Forward
0 new messages