Get Disapproved Ads Extension With Google Ads Scripts

[Mario Vasile]

Hi, 

I am trying to get all disapproved ads extensions with a Google Ads Script but I get different results than the ones showing in Google Ads Account Dashboard. Since I cannot get the Ads Extension Name, it's difficult to figure out which ads extensions are returned by the Report. I am getting the fallowing attributes for the Ads Extension: Status, AdGroupName, CampaignName, CampaignStatus, PlaceholderType (Ad extension type) 

var report = AdWordsApp.report("SELECT ValidationDetails, AdGroupName, CampaignName, CampaignStatus, PlaceholderType  " +
    "FROM PLACEHOLDER_FEED_ITEM_REPORT where CampaignStatus = 'ENABLED' ", {
        apiVersion: 'v201809'
    });


var totalAdsExtensions = 0;
var disapprovedAdsExtensions = 0;
var disapprovedRows = "";


var rows = report.rows();
while (rows.hasNext()) {
    var row = rows.next();
    //Logger.log(JSON.stringify(row))
    var validationDetails = row['ValidationDetails'];
    var adGroupName = row['AdGroupName'];
    var campaignName = row['CampaignName'];
    var campaignStatus = row['CampaignStatus'];
    var placeholderType = row['PlaceholderType'];


    totalAdsExtensions += 1;
    if (validationDetails == 'Disapproved') { // If a row has Approval Status of 'Disapproved', and increase counter by one
        disapprovedRows += 'Ad extension status: ' + validationDetails + ' | Campaign name:  ' + campaignName +
           ' | Campaign Status' + campaignStatus + ' | Ad Group Name:  ' + adGroupName + ' | ' + placeholderType + '\n';
        disapprovedAdsExtensions += 1;
    }
}

The disapproved Ads Extensions got by the script are fewer than the ones from Google Ads Dashboard. Also the campaigns name for the disapproved ads are different than the ones from the Dashboard and when I checked on that campaigns in the Dashboard, they didn't had any disapproved Ads Extension or Ads. The results from the Script report is totally different than the ones from the Dashboard. 

I've also tried to get fewer attributes in the select clause like bellow and still same problem.

var report = AdWordsApp.report("SELECT ValidationDetails, PlaceholderType  " +
    "FROM PLACEHOLDER_FEED_ITEM_REPORT where CampaignStatus = 'ENABLED' ", {
        apiVersion: 'v201809'
    });

I've tried also to put duration and compared with the ones from Dashboard and still different results.

I've tried also to run without the CampaignStatus = 'ENABLED' clause and still different results. 

I tried to follow these posts when I created the scripts: https://groups.google.com/forum/#!topic/adwords-scripts/IvqF_PBI3z4 , https://groups.google.com/forum/#!topic/adwords-scripts/kmCvDe8Uhio

Can you help me please, I am doing something wrong ? 

[Google Ads Scripts Forum Advisor Prod]

Hi Mario,

With regard to data discrepancy between Placeholder Feed Item Report and Google Ads UI, could you confirm if you are following Ad Extensions Report section in this guide? The guide maps the concepts and naming conventions for reports in the Google Ads UI to the comparable AdWords API reports.

After confirming this and if you still experiencing the data discrepancy, so I can investigate the issue, could you provide the following information via Reply privately to author?

• CID
• Script name
• Screenshots of the Google Ads UI which you are comparing with

Please let me know if you have any concerns.

Regards,
Hiroyuki
Google Ads Scripts Team

ref:_00D1U1174p._5001UAqVLt:ref

[Mario Vasile]

Hi Hiroyuki

Do you have any updates? 

Thanks,

Mario

[Google Ads Scripts Forum Advisor Prod]

Hello,

I responded on May 28, but it looks like that response may have been lost.

We are still investigating.

Regards,
Mike, Google Ads Scripts Team

ref:_00D1U1174p._5001UAqVLt:ref

[Mario Vasile]

Hello Mike,

Do you have any updates?