Skip to main content
Analytics & Measurement Raw data only

Organic search performance in your warehouse

Organic clicks, impressions, and rankings live in Search Console, apart from paid media and orders. Sign in with Google to land them as raw tables.

Access
Sign in with Google as an owner or user of the Search Console property
History
16 months, the most Search Console keeps
Delivery
Raw warehouse tables, for plans with a dedicated warehouse

Google Search Console

Site behavior and attribution systems used to reconcile session-to-order performance.

Why Google Search Console?

SourceMedium reads daily Search Console performance for the properties you pick, by page, query, country, and device, back 16 months. You query the tables yourself; there is no modeled SEO dashboard.

Daily search performance

Clicks, impressions, click-through rate, and average position for every property you connect, refreshed daily.

Pages, queries, and devices

Separate daily views by page, by query, and by country and device, plus complete property totals.

16 months of history

The first sync loads all the history Google keeps for each property.

Before you analyze

Boundaries that change how Google Search Console numbers should be read.

Page and query detail is top rows

Google caps detail at 50,000 rows a day per property, so on very large sites the page and query views hold the top rows. Daily totals stay complete.

Details in the docs

Joins with other integrations

Google Search Console data is designed to join with your other data sources for unified analysis.

How it works

Setup depends on the source. We confirm access requirements, history, cadence, and customer responsibilities before implementation begins.

1

Sign in with Google

Choose Google Search Console in your connector picker and approve read-only access.

2

Pick your properties

Select the Search Console properties to sync. Domain and URL-prefix properties are listed separately.

3

Query raw tables

On a dedicated warehouse, pick the tables you want and query them in BigQuery.

Ready to stop debating the numbers?

In 30 minutes, we will

  1. Map your current systems and reporting gaps.

  2. Show one workflow relevant to your team.

  3. Outline likely fit, implementation scope, and next steps.

Book a walkthrough

Share a little context, then choose a time immediately after submitting.

Takes under a minute. Then pick a time.

How we use your details