There are data discrepancies between the Google Search Console UI and the warehouse.
Connector: Google Search Console
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.
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.
When comparing data for the report table
- 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`
country = 'usa'
and date = '2022-02-27'
and device = 'DESKTOP'
and search_type = 'web'
and site = 'fivetran.com'
- In the Google Search Console UI, view the report at the page level.
- 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.