My Google Ads organic Search data is not matching between API and UI

[Pawan Rai]

Table Name API:  paid_organic_search_term_view

Query: SELECT 

                ad_group.id, 
                ad_group.name,
                campaign.id,
                campaign.name,
                customer.id,
                customer.descriptive_name,
                customer.currency_code,
                customer.manager,
                metrics.clicks,
                metrics.combined_clicks,
                metrics.combined_clicks_per_query,
                metrics.combined_queries,
                metrics.impressions,
                metrics.ctr, 
                metrics.organic_clicks,
                metrics.organic_clicks_per_query,
                metrics.organic_impressions,
                metrics.organic_impressions_per_query,
                metrics.organic_queries,
                segments.date, segments.device,
                paid_organic_search_term_view.resource_name,
                paid_organic_search_term_view.search_term
                FROM paid_organic_search_term_view
                WHERE segments.date BETWEEN '{}' AND '{}' 

When I checked 2 to 3 days back data on the UI of google ads and the Same data fetching from Google Ads API and Doing the data comparison its not match.

I tried multiple dates and the result is same data does not match.

Any suggestion and solution?

 

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

After reviewing your concern, I understand that you are seeing the discrepancies while retrieving the data between the Google Ads UI and the Google Ads API. Kindly note that the Google Ads API mirrors the Google Ads UI. We would like to specify first the following when comparing the value of the Google Ads UI and the Google Ads API.

• The segments and fields of the API and UI should be the same.
• The date range should also be the same.
• Comparing the API and UI at the same level as possible.

With that, please provide us with the complete API logs (request and response with request-id and request header) generated along with the uncropped UI screenshot of the Google Ads account at your end to better assist you.

If you are using a client library and haven't enabled the logging yet, I would request you to enable logging for the specific client library that you are using. You can refer to the guides Java, .Net, PHP, Python, Ruby or Perl to enable logging at your end. For REST interface requests, you can enable logging via the curl command by using the -i flag. 

You can send the details via Reply privately to the author option, or direct private reply to this email.

 

This message is in relation to case "ref:!00D1U01174p.!5004Q02pTzk9:ref"

Thanks,
 

Google Ads API Team