SEO reporting with Search Console and GA4, joined properly

Why don’t Search Console and GA4 numbers match?

Because they count different things at different moments. Search Console records a click when someone clicks your result on Google Search. GA4 records a session when your page loads, the Google tag runs, and the visitor’s consent allows measurement. Between those two moments, visitors bounce before the tag fires, block scripts, decline cookies, or arrive on pages without the tag. Google’s documentation notes that tools such as Google Analytics only track users with JavaScript enabled, and that Search Console processes its data differently, for example by removing duplicates and bot visits¹Source 1 · Google Search Console HelpAbout Search Console datasupport.google.com.

The time zone difference alone explains many "the numbers changed overnight" questions: Search Console tracks daily data according to local time in California, while Google Analytics uses the site owner’s time zone, so daily figures will not align exactly¹Source 1 · Google Search Console HelpAbout Search Console datasupport.google.com. Weekly aggregation removes most of this noise.

What exactly does each tool measure?

Search Console

In the Performance report, an impression is counted whenever your result appears in the current page of results, a click is counted when a user clicks through to an external page, and position is the topmost position of your link, averaged across queries. Crucially, click, impression and position data are attributed to the canonical URL of the link, and when you group by property, one search element containing several of your URLs counts as a single impression²Source 2 · Google Search Console HelpHow are impressions, position, and clicks counted?support.google.com. That is why property totals and page-level sums differ.

GA4

GA4 attributes sessions to channels using its default channel group. Traffic is Organic Search when the source matches a list of search sites or the medium is exactly organic³Source 3 · Google Analytics Help[GA4] Default channel groupsupport.google.com, which includes Bing, DuckDuckGo and others alongside Google. For a fair comparison with Search Console, filter to session source google and session medium organic.

The built-in GA4 Search Console reports

Linking the two products adds two GA4 reports. Google Organic Search Queries shows queries with Search Console metrics, and Google Organic Search Traffic shows landing pages with both Search Console and Analytics metrics. Search Console metrics are only compatible with Search Console dimensions plus landing page, device and country; data appears 48 hours after collection, and only 16 months are available⁴Source 4 · Google Analytics HelpConnect Search Console to Google Analyticssupport.google.com. These reports are useful for quick checks, but they do not support custom joins, longer history or revenue from your CRM. For that, you join the data yourself.

How big should the gap be?

There is no universal benchmark, and you should be wary of anyone who quotes one: the gap depends on your consent rate, page speed, audience and tag setup. What matters is that the ratio between GA4 Google-organic sessions and Search Console clicks is stable. Track it weekly. A sudden drop usually means a tracking problem (a template without the tag, a consent banner change, a redirect stripping the referrer), not an SEO problem.

How do you join Search Console and GA4 data?

Join at the landing-page level, by week, with country and device as optional dimensions. Queries cannot be joined to GA4, because GA4 does not receive the query; keep query analysis on the Search Console side and bring pages across.

1. 1
   Step 1:

   Pull Search Console at page grain

   Use the API or the bulk data export, not UI exports. The UI exports at most 1,000 rows; the API and Looker Studio connector allow up to 50,000 rows per day per site per search type⁵Source 5 · Google Search Central Blog, 2022A deep dive into Search Console performance data filtering and limitsdevelopers.google.com.

2. 2
   Step 2:

   Pull GA4 landing-page sessions for Google organic

   Filter session source to google and session medium to organic. Include engaged sessions, key events and, if available, revenue.

3. 3
   Step 3:

   Normalize URLs on both sides

   Strip protocol, host, query string and fragment, lowercase, and remove trailing slashes, so both tools agree on the page key. Search Console already reports the canonical URL; GA4 reports what was loaded.

4. 4
   Step 4:

   Aggregate to weeks

   Weekly grain absorbs the Pacific-time versus property-time difference and the 48-hour Search Console lag.

5. 5
   Step 5:

   Join and keep both sides

   Use a full outer join so pages with clicks but no sessions (tag missing) and sessions but no clicks (non-indexable or Discover traffic) are both visible.

123456789101112131415161718192021222324252627282930313233343536with gsc as (
    select
        date_trunc('week', date)                                        as week,
        rtrim(lower(regexp_replace(url, '^https?://[^/]+|[?#].*$', '', 'g')), '/') as page,
        sum(clicks)                                                      as clicks,
        sum(impressions)                                                 as impressions,
        sum(sum_position) / nullif(sum(impressions), 0) + 1              as avg_position
    from searchconsole.searchdata_url_impression
    where search_type = 'web'
    group by 1, 2
),
ga as (
    select
        date_trunc('week', date)                                         as week,
        rtrim(lower(regexp_replace(landing_page, '[?#].*$', '', 'g')), '/') as page,
        sum(sessions)                                                    as sessions,
        sum(engaged_sessions)                                            as engaged_sessions,
        sum(key_events)                                                  as key_events
    from ga4_landing_pages_daily
    where session_source = 'google' and session_medium = 'organic'
    group by 1, 2
)
select
    coalesce(gsc.week, ga.week)         as week,
    coalesce(nullif(gsc.page, ''), nullif(ga.page, ''), '/') as page,
    gsc.impressions,
    gsc.clicks,
    gsc.clicks::float / nullif(gsc.impressions, 0) as ctr,
    gsc.avg_position,
    ga.sessions,
    ga.engaged_sessions,
    ga.key_events,
    ga.sessions::float / nullif(gsc.clicks, 0)     as capture_ratio
from gsc
full outer join ga
    on gsc.week = ga.week and gsc.page = ga.page

Anonymized queries and row limits

Query-level reports never add up to the total. Google defines anonymized queries as those not issued by more than a few dozen users over a two-to-three month period; their text is hidden, but they are included in chart totals unless you filter by query⁵Source 5 · Google Search Central Blog, 2022A deep dive into Search Console performance data filtering and limitsdevelopers.google.com. The bulk data export to BigQuery includes all performance data for the property except anonymized query text⁶Source 6 · Google Search Console HelpBulk data export of Search Console performance datasupport.google.com. For sites with long-tail traffic, the hidden share can be large.

Practical consequences: analyze topics and pages rather than individual long-tail queries, use the bulk export to avoid sampling rows away, and store history in your own model because Search Console retains 16 months⁴Source 4 · Google Analytics HelpConnect Search Console to Google Analyticssupport.google.com. In Kimo, the Search Console connector keeps history from the day you connect; the setup doc explains property choices.

The SEO dashboard worth keeping

Most SEO dashboards are a wall of rankings. The one worth keeping follows the funnel from visibility to revenue, separates branded from non-branded demand, and surfaces pages that need action.

Branded vs non-branded

Branded searches reflect awareness built elsewhere; non-branded searches reflect SEO reach. Search Console’s branded queries filter, rolled out from November 2025 for top-level properties with enough volume, splits Performance data into branded and non-branded using an AI-assisted classifier rather than regular expressions, and may occasionally misclassify queries⁷Source 7 · Google Search Central Blog, 2025Introducing the branded queries filter in Search Consoledevelopers.google.com. Where it is not available, maintain your own brand-term list and apply it in the model.

AI Overviews and AI Mode

Google states that sites appearing in AI features are reported in the Performance report within the Web search type, with no separate breakdown, and that no special optimization is required to appear there⁸Source 8 · Google Search CentralAI features and your websitedevelopers.google.com. Watch for pages where impressions rise while CTR falls: that pattern is consistent with answers being satisfied on the results page. Pair it with AI-search visibility tracking, described in the whitepaper One View of Marketing and our post on generative engine optimization.

From sessions to revenue

Join organic landing-page sessions to sign-ups and then to CRM opportunities or orders by the session or user identifiers your product records. The SEO funnel template ships this model, and our post on the SEO-to-signup funnel explains the attribution choices. In the app, the SEO page shows the result on simulated data.

How should you run a weekly SEO review?

A good SEO dashboard supports a 20-minute weekly review with a fixed agenda. Use complete weeks only (skip the last two to three days, which are still settling), compare with the previous four weeks and the same week last year, and end with a short list of actions with owners.

1. 1Measurement health (2 minutes): is the capture ratio stable? Any pages with clicks but no sessions? If something broke, fix it before discussing performance.
2. 2Demand (5 minutes): are non-branded impressions growing by topic? Is branded demand moving after campaigns or press coverage?
3. 3Capture (5 minutes): which page groups gained or lost clicks, and was it position, CTR or demand? A click change with stable position and falling CTR points to a SERP change, not a ranking change.
4. 4Outcomes (5 minutes): key events and pipeline from organic landing pages, with conversion rate per page group.
5. 5Actions (3 minutes): pick up to five items from the action list below, assign owners, and log them next to the dashboard.

Monthly, add a content review: which new pages reached the top ten, which older pages are decaying, and which topics have demand but no page. Quarterly, revisit the brand-term list, page groups and targets. If SEO is one channel among several, roll its outcome numbers into the cross-channel overview described in our guide to setting up a unified marketing dashboard, so organic search is judged on the same revenue basis as paid media in Kimo Marketing.

Which pages need attention?

Combine position, CTR and trend to build a weekly action list. Four patterns cover most cases.

123456789select page, sum(impressions) as impressions, sum(clicks) as clicks,
       sum(clicks)::float / nullif(sum(impressions), 0) as ctr,
       avg(avg_position) as position
from seo_pages_weekly
where week >= current_date - interval '28 days'
group by page
having avg(avg_position) between 4 and 15 and sum(impressions) > 1000
order by impressions desc
limit 25

Troubleshooting

GA4 shows more Google-organic sessions than Search Console clicks

Check whether Discover or Google News traffic is being classified as organic in GA4; Search Console reports those under separate search types or reports. Also check for session restarts caused by UTM-tagged internal links or cross-domain issues.

Page totals do not add up to the property total

This is expected. By property, one search element with several of your URLs counts as one impression; by page, impressions are split per URL²Source 2 · Google Search Console HelpHow are impressions, position, and clicks counted?support.google.com.

Yesterday’s numbers changed

The newest Search Console data is preliminary and might change in the next few hours⁹Source 9 · Google Search Console HelpPerformance report (Search results)support.google.com, and GA4 shows Search Console data 48 hours after collection⁴Source 4 · Google Analytics HelpConnect Search Console to Google Analyticssupport.google.com. Exclude the last two to three days from week-over-week comparisons.