Auto Placement Exclusion Script - Help w/ Functionality

[Julia D]

Hi Google Ads Scripts Team!

I added the Automatic Placement Exclusion script to my MCC account and made changes to the script so (1) it will iterate through all the accounts within the MCC and (2) report changes into an existing spreadsheet. For some reason, whenever I run the script I am not seeing any changes and I’m unsure if this is happening because there haven’t been any placements in the last 7 days that meet the threshold or if it is something else. Would you be able to take a look at the script attached to see if the modifications I made are preventing it from running the way I’ve intended?

Thanks so much in advance!!

[Google Ads Scripts Forum Advisor Prod]

HI Julia,

Can you please privately provide your CID and script name? I will need to look at the script directly in the account to investigate this.

Thanks,
Matt Yashinsky
Google Ads Scripts Team

ref:_00D1U1174p._5001UEGRX0:ref

[Claudia Kosny]

Hi there,

I have pretty much the same issue - I was hoping to use the code in this script to get a list of all video placements but it does not return anything.
After a bit of googling around it seems that the URL_PERFORMANCE_REPORT that is used in this script does not return youtube placements anymore: https://ads-developers.googleblog.com/2018/10/changes-to-url-performance-report-for.html

I have tried the AUTOMATIC_PLACEMENTS_PERFORMANCE_REPORT, but this shows only the domain 'youtube.com' instead of the exact channel. So if you find a solution how to get video placement data via Google Ads scripts I would appreciate if you could post the solution here.

Thanks

Claudia

[Julia D]

Hi Matt,

Just wanted to make sure you received my private reply. Were you able to see the issue?

[Google Ads Scripts Forum Advisor Prod]

Hi Julia and Claudia,

I replied privately -- here is my reply:

The query in the getReportResults function,

  var query = 'SELECT CampaignId, Url' +
    ' FROM URL_PERFORMANCE_REPORT' +
    ' WHERE Impressions >= ' + MIN_IMPRESSIONS +
    ' AND VideoViewRate < ' + (VIEW_RATE_THRESHOLD / 100) +
    ' DURING LAST_7_DAYS';

is returning an empty report. One way to test this is to use log statements such as:

  var report = AdsApp.report(query);
  var rows = report.rows();
  Logger.log(rows.hasNext()); //This returned false for each run

However, it appears the issue is likely directly related to the changes made to the URL performance report, which is used in this solution. Eventually, we will have improved placement reports in the new Google Ads API.

In the meantime, you may try leveraging the placement performance report in place of the URL performance report.

Regards,
Matt
Google Ads Scripts Team

ref:_00D1U1174p._5001UEGRX0:ref

[Claudia]

Hello Matt,

Thank you for your reply. Unfortunately the placement performance report just returns 'youtube.com' when I run it, not the channel where the ad was shown. Maybe I am looking just at the wrong data though - could you try whether that report returns the exact channel in your case?

Thanks

Claudia

ref:_00D1U1174p._5001UEGRX0:ref --
-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---
You received this message because you are subscribed to a topic in the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-scripts/BjDz9FzP5-w/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-scrip...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/5Vtng000000000000000000000000000000000000000000000PVF4K400z28dTi4zQ6auVdF8cjd4Eg%40sfdc.net.

[Google Ads Scripts Forum Advisor Prod]

Hi Claudia,

So, at the moment, there is not a workaround in the current API version, but according to the blog post, there will be new, improved placement reports in the upcoming API release. We appreciate your patience on these changes.