[Issue] Google Ads script - BigQuery Exporter

[Ruslan Obolonsky]

Hello.

I am trying to use this script for retrieving costs, metrics and clicks 

Everything works well, I use this kind of report (below).

But I've faced the problem. I have big discrepancies with Google Ads UI in some Accounts. Big discrepancies in impressions and costs for some days.

1. Please, help me to solve this problem.

2. Maybe you have a script that uses a new version of Google Ads API instead AdWords API v201809? It will be great if you share it with me.

REPORTS: [{NAME: 'AD_PERFORMANCE_REPORT',
             //https://developers.google.com/adwords/api/docs/appendix/reports/ad-performance-report
     CONDITIONS: '',
     FIELDS: {'CampaignName' : 'STRING',
              'CampaignId' : 'INTEGER',
              'CampaignStatus' : 'STRING',
              'ClickType' : 'STRING',
              'ImageCreativeName' : 'STRING',
              'AdGroupName' : 'STRING',
              'AdGroupId' : 'INTEGER',
              'AdType' :  'STRING',
              'Id' : 'INTEGER',
              'DisplayUrl' : 'STRING',
              'CreativeFinalUrls' : 'STRING',
              'CreativeTrackingUrlTemplate' : 'STRING',
              'Cost' : 'FLOAT',
              'Clicks' : 'INTEGER',              
              'Impressions' : 'INTEGER',
              'AccountCurrencyCode' : 'STRING',
              'Date' : 'DATE'
             }
    }]

[Google Ads API Forum Advisor Prod]

Hello,

Unfortunately, there is no way to use Scripts to pull data using Google Ads API. It currently pulls using the same queries as AdWords API.

Since your issue is more specific to Scripts, please post on their forum since they are better suited to handle these issues.

Regards,
Anthony

Anthony Google Ads API Team

ref:_00D1U1174p._5004Q2CQ02I:ref