Issue

There are data discrepancies between the Google Search Console UI and the warehouse.

Environment

Connector: Google Search Console

Resolution

Cause of Discrepancies

The reason is often due to how the reports can be configured within the UI compared with the pre-defined reports synced by the connector. If there is a difference in Dimensions, this is likely to cause discrepancies. 

For more information, please visit our Documentation. There is also Google Search Console Documentation informing of other potential reasons for discrepancies.

How to match data between the Google Search Console UI and Warehouse

To match the numbers between the UI and the destination, specify in the UI all (or almost all) filters that are used as Dimensions in the report you are querying in the destination.

Example:

When comparing data for the report table keyword_site_report_by_page:

1. Use a select statement that sets each of the dimensions to a specific value: 
   select sum(clicks) as clicks, sum(impressions) as impressions from `<schema>.keyword_site_report_by_page`
where
country = 'usa'
and date = '2022-02-27'
and device = 'DESKTOP'
and search_type = 'web'
and site = 'fivetran.com'
2. In the Google Search Console UI, view the report at the page level. 
3. Create filters for each of the dimensions, setting them equal to the same values as the warehouse query:

The outcome of this will show matching click and impression counts for the Source UI and Warehouse Output.