Keyword performance mismatch API vs UI

[Tiana S.]

Hi there,

Having an issue where when requesting Keyword statistics, the data returned is higher than what's shown in the UI.

Query:

SELECT ad_group_criterion.status,ad_group_criterion.criterion_id,ad_group_criterion.keyword.text,ad_group_criterion.keyword.match_type,metrics.clicks,metrics.impressions,metrics.ctr,metrics.cost_micros
FROM keyword_view
WHERE metrics.impressions > 0 AND ad_group_criterion.status IN ("ENABLED","PAUSED") AND segments.date >= '2023-06-01' AND segments.date <= '2023-06-30'

All of the metric values are higher than what is shown in the UI (for example UI shows 130 clicks and API returns 149 clicks for a keyword).

Confirmed the filters and date range are the same. 

Is this a known issue by any chance? I can of course provide more information privately. 

Thank you,

Tiana

[Google Ads API and AdWords API Forum]

Re-posting the last inquiry (https://groups.google.com/g/adwords-api/c/w3NyXeOXyRE) from the forum as it wasn't routed to our support queue.

Regards,
Google Ads API Team

[Google Ads API and AdWords API Forum]

Hi Tiana,

Thank you for raising this concern to the Google Ads API support team.

Regarding your concern, you mentioned that this is about the data returned is higher than what's shown in the UI. Kindly note that Google Ads API mirrors the Google Ads UI. Meaning, the Google Ads API should be able to retrieve or manage the Google Ads UI data. Having said that, can you please provide the uncropped screenshot of the Google Ads UI showing the data that you want to retrieve via the Google Ads API and the complete API logs below for investigation?

• request - https://developers.google.com/google-ads/api/docs/concepts/field-service#request
• response - https://developers.google.com/google-ads/api/docs/concepts/field-service#response
• request ID - https://developers.google.com/google-ads/api/docs/concepts/call-structure#request-id
• request header - https://developers.google.com/google-ads/api/docs/concepts/call-structure#request_headers

Note that these logs can be requested or provided to the developer handling the Google Ads API transactions when logging of the API requests has been enabled. You may check here (https://developers.google.com/google-ads/api/docs/best-practices/logging#client_library_logging) for the specific guideline to enable it.

In addition, I would like to specify first the following when comparing the value of the UI and API:

• Comparing the API and UI on the same level as much as possible
• The segments and fields of the API and UI should be the same
• The date range is also the same

You may then send the requested logs 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,

Google Ads API Team

On Tuesday, July 11, 2023 at 5:33:33 PM UTC+8 Tiana S. wrote:

[Vytautas Smilingis]

Hello, was this solved? We're having a seemingly similar issue with one of our clients, but we're currently waiting for more screenshots of their UI, to verify that all request parameters are the same.