Missing clicks in geographic_view

[TommyTek]

Hello,

  I'm having issues with the data retrieved through geographic_view

This is my query with Google Ads API v8:

SELECT customer.descriptive_name, campaign.id, campaign.name, geographic_view.country_criterion_id, segments.date, metrics.clicks, metrics.conversions, metrics.conversions_value, metrics.cost_micros, metrics.impressions, metrics.view_through_conversions FROM geographic_view

WHERE geographic_view.location_type = LOCATION_OF_PRESENCE AND segments.date BETWEEN '2021-10-21' AND '2021-10-21'

I'm running the query on the Google Ads account 503-220-2150 (I guess this is not confidential).

From the UI I can see 2101 clicks for the whole account on the 2021-10-21; using the old Google Adwords API I was able to get the same amount of clicks (LocationType', 'EQUALS', ['LOCATION_OF_PRESENCE'] + IsTargetingLocation', 'IN', ['true','false']), but from new APIs I get 2075 clicks

Eg in the old report for the country_criteria_id = 2076 and campaign_id = 885148015 I've 21 clicks, while in the new one 19 (2 are missing). I've click discrepancies on 17 returned rows, and impression discrepancies on 344 rows.

Can you tell me what is wrong with my query? I've not found a way to pass the old clause IsTargetingLocation', 'IN', ['true','false']

Thank you!

[Google Ads API Forum Advisor]

Hi,

Thanks for reaching out to us.

Since you’ve noticed a discrepancy, then for us to investigate further discrepancies between the UI and API, could you please provide us with the following details below?
 

• For AdWords API report, provide the complete SOAP request and response logs generated on your end or the complete report definition 
• As for Google Ads API report, you can provide the complete request and response logs with request ID generated on your end
• Screenshots from the UI showing those discrepancies
• Sample comparison of the AdWords API and Google Ads API report data where we can see the said discrepancies

For the Google Ads API, logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link.

For the AdWords API, you can enable logging by going to the steps discussed in the respective Github documentation of your chosen client library.

You may then send the all the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2QFicX:ref

[TommyTek]

Hello,

  I privately provided the information asked last week, but got no feedback.

Do you have any update for me?

Thank you

[Google Ads API Forum Advisor]

Hi Tommy

It appears that you did not receive the response that I've sent. If you're having trouble receiving private replies from us, please check your Spam folder. Additionally, please add the 'From address' on that email to your contact list to ensure we aren't flagged as Spam in future messages. If you don't see a message from us in your Spam folder, please email us directly at googleadsapi-support@google.com referring to your forum case.

Moving forward, please see the response below that I've sent previously and let me know if you have follow up questions about it:
"Thank you for providing further details to your concern. I am also a member of the Google Ads API team and let me provide support to your concern.

It appears that the UI is not the correct mapping of the said report type. Please note that the provided UI is to get the metrics of the targeted location not the location of the presence. With this, you will need to use the location_view instead as it summarizes the performance of campaigns by Location criteria.

If you want to know the equivalent UI of the location of the presence, then I would suggest to reach out to the product team via this link as they are more knowledgeable with the UI."

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2QFicX:ref

[TommyTek]

Hello Ernie,
  yes, it seems that I didn't receive one of your email (but the first answer was received). Now I've whitelisted both adwor...@googlegroups.com and googleadsa...@google.com on my mail server.

I've tried to download the data using location_view and now it works properly (I've the same amount of clicks and just 5 impressions of difference on 33000)

Thank you for your support.

Best,

Tom

On Wednesday, November 3, 2021 at 4:21:48 AM UTC+1 adsapi wrote:

Hi Tommy

It appears that you did not receive the response that I've sent. If you're having trouble receiving private replies from us, please check your Spam folder. Additionally, please add the 'From address' on that email to your contact list to ensure we aren't flagged as Spam in future messages. If you don't see a message from us in your Spam folder, please email us directly at googleadsa...@google.com referring to your forum case.