Raw data only. Google Search Console lands as raw warehouse tables, not modeled dashboards or AI analysis. Raw tables are delivered only to organizations on a dedicated warehouse, for the tables picked under Warehouse → Raw data in your SourceMedium workspace. See Foundation and Pro.
Sign in to SourceMedium, open your store, then choose Data sources → Connect data source and select the platform. You need an Admin or Editor workspace role.After you connect explains the first sync and connection statuses.
Vendor documentation
Requirements
- A Google account that is an owner or a user of each Search Console property you want to connect. Settings > Users and permissions in Search Console shows who has access. A property the account sees only as unverified is not offered.
- No API key. You connect by signing in with Google, and SourceMedium asks only for read-only access to Search Console. It does not change anything in Search Console.
How to connect
1
Start the connection
Find Google Search Console in the connector picker and click Connect.
2
Sign in with Google
Click Authorize with Google Search Console. SourceMedium sends you to Google to approve read-only Search Console access, then brings you back. Sign in with the Google account that has access to your properties.
3
Select your properties
Pick the Search Console properties to sync, then save. You can pick more than one. A Domain property (shown as
sc-domain:example.com) and a URL-prefix property (shown as https://www.example.com/) are separate properties with separate data, so pick the ones you report on.4
Confirm it is connected
Before saving, SourceMedium checks with Google again that the account can read every property you picked. The connection reads Awaiting first data until the first sync lands, then Connected. Expect the first rows within about three days, because Google finalizes Search Console data two to three days after the fact.
What data syncs
Web search performance for each selected property, by day: clicks (clicks), impressions (impressions), click-through rate (ctr), and average position (position). Every row names its property (site_url) and search type (search_type, always web). Image, video, news, and Discover results are not included.
Select the tables you want under Warehouse → Raw data in your SourceMedium workspace to receive them in
your_project.sm_sources.
Refresh and history
- Refresh: once a day. Each sync re-reads the last 7 days and replaces them, so Google’s late changes overwrite the earlier rows.
- Dates: Pacific time, as Search Console reports them. SourceMedium loads only final data, so the newest date is usually about three days old.
- History: the first sync loads 16 months, the most Search Console keeps. Older data no longer exists at Google, so it cannot be loaded later.
Known gaps
- Daily row cap. Google’s API returns at most 50,000 rows per property, per search type, per day. On a day that reaches the cap, the page and query tables are missing the rows past it. The totals table is always complete.
- Page and query tables are top rows. They do not add up to the totals: Google leaves out anonymized queries and groups page results by canonical page. Use
google_search_console__search_totals_dailyfor property totals. - Lost access stops the sync. If the signed-in account loses access to a selected property, syncing stops until access is restored in Search Console or the property is removed from the connection.
Troubleshooting
- No properties to pick? The Google account you signed in with cannot see any verified Search Console property. Start the connection again and sign in with an owner or user of the property.
- A property is missing from the list? Check Settings > Users and permissions for that property in Search Console. A Domain property and its URL-prefix variants are listed separately.