Google Ads API - Location view and Ad view data discrepancies

[Giang Nguyen]

Hi Google Ads API,

I have issue with data discrepancies between 2 queries. When we got data and group up to account level then Ad View > Location View and Ad View now mostly matched with UI but still have some small discrepancies. Is there any problems with my queries or data i am getting?
Libraries: python google-ads

Start Date: 2022-01-01

End Date: 2022-06-30

Ad View:

SELECT ad_group_ad.ad.id,
               ad_group.id,
               campaign.id,
               segments.date,
               metrics.clicks,
               metrics.impressions,
               metrics.interactions,
               metrics.average_cpc,
               metrics.average_cost,
               metrics.conversions,
               metrics.conversions_value,
               metrics.all_conversions,
               metrics.all_conversions_value
        FROM ad_group_ad
        WHERE segments.date
        BETWEEN """ + "'" + start_date +  "' AND '" + end_date + "'"

Location View:

SELECT campaign_criterion.location.geo_target_constant,
               campaign.id,
               segments.date,
               metrics.clicks,
               metrics.impressions,
               metrics.interactions,
               metrics.average_cpc,
               metrics.average_cost,
               metrics.conversions,
               metrics.conversions_value,
               metrics.all_conversions,
               metrics.all_conversions_value
        FROM location_view
        WHERE segments.date
        BETWEEN """ + "'" + start_date +  "' AND '" + end_date + "'"

[Google Ads API Forum Advisor]

Hi Giang,

Thank you for reaching out to our API support team.

To investigate the issue further, could you please provide the complete request and response logs, with the request-id? If you haven't yet, logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link.You can provide it via Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead. Let me know if you have any questions. Also can you send us a full UI screenshot that shows your issue about small discrepancies.

 

Best,

Anthony Cyril Google Ads API Team

ref:_00D1U1174p._5004Q2d2PVY:ref

[Giang Nguyen]

Hi Anthony,
Which email i should send details directly? i am using python but i dont have request_id.

I will share screenshots with private email.

[Google Ads API Forum Advisor]

Hi Giang,

Thank you for the reply.

You may also have the request id by enabling logging, you may refer to this documentation for more details. Moving forward, you may send the requested details directly to our googleadsa...@google.com alias.

Best regards,

Heidi Google Ads API Team

ref:_00D1U1174p._5004Q2d2PVY:ref