Ads script - Get data from "Where your ads showed" tab

[Luuk]

Hi,

I've set up a script and I would like to retrieve the data showed in the tab "Where your ads showed" from the placements tab in the Ads interface. I tried using PLACEMENT_PERFORMANCE_REPORT and VIDEO_PERFORMANCE_REPORT and I get some data, but unfortunately, none of them show me the same data as shown in the "Where your ads showed" tab.

I'm using the Google Ads script functionality. Could you point me in the right direction?

Regards,

Luuk

[Google Ads Scripts Forum Advisor]

Hi Luuk,

Thanks for raising your concern.

Could you confirm if you are pertaining to the specific specific UI that showed in the attached screenshot? If yes, in order to get the data on the WHERE ADS SHOWED tab, you can use the Automatic Placements Performance Report instead as this report type maps to said UI.

Let me know if you have questions/clarifications.

Regards,
Ejay
Google Ads Scripts Team

ref:_00D1U1174p._5001UOF56v:ref

[Luuk]

Hi Ejay,

Thanks for your help. I indeed mean the tab you showed on your screenshot. The thing is that the script only seems to fetch the site placements but not the YouTube channels. Unfortunately, I'm specifically looking for the channels, instead of the websites my ads were shown on. Below is the AWQL I'm using, but as far as I can see there's nothing wrong with that. Are the YouTube channel urls from that report in the UI also available in Ads scripts?

Regards,

Luuk

  var report = AdsApp.report(

    "SELECT CampaignName, DisplayName, Impressions" +

    " FROM AUTOMATIC_PLACEMENTS_PERFORMANCE_REPORT" +

    " WHERE CampaignName CONTAINS '(Y) - Affiniteit - In-stream'" +

    " DURING YESTERDAY"

  );

Op maandag 23 december 2019 03:25:02 UTC+1 schreef adsscriptsforumadvisor:

[Google Ads Scripts Forum Advisor]

Hi Luuk,

Thanks for your reply.

The Automatic Placements Performance Report is the only report type that maps to the 'WHERE ADS SHOWED' tab in UI. However, I am afraid that this report type couldn't be able to return the YouTube channels and its url.

Let me know if you have further questions.

Regards,
Ejay
Google Ads Scripts Team

ref:_00D1U1174p._5001UOF56v:ref

[Luuk]

Hi Ejay,

That's too bad, but thanks for helping out!

Regards,

Luuk

Op maandag 23 december 2019 10:28:39 UTC+1 schreef adsscriptsforumadvisor: