Datapipe
Search analytics
A Google Search Console report of search analytics.
Live
Google Search Console for agencies and in-house teams
SEO leads and agencies use Google Search Console in Datapipe to see the searches, pages, clicks, and average rank behind the organic traffic.
What connects
The same Google sign-in, with the Search Console scope webmasters.readonly. Sites already verified in Search Console are listed. You pick a site URL or a domain property.
What you can report on
- Query (dimension). The search query from searchAnalytics, one row per query.
- Page (dimension). The page URL from searchAnalytics, in a separate report from queries.
- Clicks (metric). Clicks from the Search Analytics query.
- Impressions (metric). Impressions, shown as times shown.
- CTR (metric). ctr on the query report, shown as click rate.
- Position (metric). Average position, shown as rank. 1 is the top.
What you set up
- Sign in with Google. Search Console uses the same consent as Analytics.
- Pick the site. Domain properties look like sc-domain:example.com.
- Create the search or page report. Dates follow the rolling window, and Search Analytics data is delayed by a couple of days.
Limitations
Query and page are separate reports. A row is not query plus page together. The pull pages through searchAnalytics at 100 rows, up to five pages. Discover, country, and device are not requested. Testing mode covers 100 Google test users.
Last reviewed 2026-10-29. Owner: Datapipe.
Connection
Live
Live with the same Google sign-in as Analytics. Testing mode covers up to 100 test users.
Fields
Search Analytics query dimensions and metrics, plus the site and sitemap resource fields published in the Search Console API reference. The query method accepts only these dimensions. Source: https://developers.google.com/webmaster-tools/v1/searchanalytics/query. Read on 2026-10-27. 20 fields.
Synced today
- Date
date - Query
query - Country
country - Clicks
clicks - Impressions
impressions - CTR
ctr - Position
position
Advertising
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Clicks · Synced today | clicks | How many times a user clicked through to the site. | metric · integer | Advertising | Clicks |
| Impressions · Synced today | impressions | How many times a page was shown in search. | metric · integer | Advertising | Impressions |
| Click-through rate · Synced today | ctr | Clicks divided by impressions. | metric · percent | Advertising |
Content
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Page | page | The final URL that appears in search results. | dimension · string | Content | |
| Site URL | site.siteUrl | The site or domain property in Search Console. | dimension · string | Content | |
| Sitemap path | sitemap.path | The sitemap URL. | dimension · string | Content |
Dimensions
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Search appearance | searchAppearance | How the result appeared, such as a rich result. | dimension · string | Dimensions | |
| Permission | site.permissionLevel | Whether the account is a site owner or a user. | dimension · string | Dimensions |
Ecommerce
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Last submitted | sitemap.lastSubmitted | When the sitemap was last submitted. | dimension · string | Ecommerce | |
| Pending | sitemap.isPending | Whether the sitemap is still being processed. | dimension · string | Ecommerce | |
| Sitemap index | sitemap.isSitemapsIndex | Whether this file is a sitemap index. | dimension · string | Ecommerce | |
| Sitemap type | sitemap.type | The kind of sitemap. | dimension · string | Ecommerce | |
| Last downloaded | sitemap.lastDownloaded | When Google last downloaded the sitemap. | dimension · string | Ecommerce | |
| Warnings | sitemap.warnings | Warning count from the last download. | metric · integer | Ecommerce | |
| Errors | sitemap.errors | Error count from the last download. | metric · integer | Ecommerce |
Geography
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Country · Synced today | country | The country the search came from, as an ISO code. | dimension · string | Geography |
Technology
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Device | device | Desktop, mobile, or tablet. | dimension · string | Technology | |
| Position · Synced today | position | The average position in search results. | metric · number | Technology |
Time
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Date · Synced today | date | The day of the search data. | dimension · date | Time |
Traffic
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Query · Synced today | query | The search query the user typed. | dimension · string | Traffic |
Cross-channel metrics
Spend, Impressions, Clicks, Conversions, and Revenue roll up on All channels when a field maps to them. ROAS is revenue divided by spend. CPA is spend divided by conversions. The Cross-channel column above shows the match.
Example reports
Destinations
Google Search Console to Google Sheets
A sheet you can open, share, and refresh.
Included on every plan.
Google Search Console to Looker Studio
Charts that read the Google Sheet this integration keeps up to date.
Included on every plan. Looker reads the sheet. There is no separate Looker install.
Google Search Console to BigQuery
A warehouse table for the same columns.
Pro and Agency plans.
Google Search Console to AI and MCP
Ask a question in plain English, or let another tool read the report through MCP.
Included on every plan. An AI key is optional.
Google Search Console to the API
Download the rows as CSV or JSON from the report.
Included on every plan.
Google Search Console to Google Drive
CSV, Excel, and an optional JSON file in a Drive folder you pick. Each client gets a Datapipe folder. The file can overwrite itself or keep the date in the name.
Included on every plan. Drive API v3 with the drive.file scope only. Enable the Google Drive API in the GCP project. Hourly, daily, or weekly.
How to connect
- Create a free account.
- Open Connections and choose Sign in with Google.
- Pick the property or channel when the report is created.
- Choose Sheets, Excel, or a daily email of the CSV. The report refreshes on your plan.
Refresh by plan
| Plan | Refresh | BigQuery | Price |
|---|---|---|---|
| Free | Daily | No | $0/mo |
| Starter | Daily | No | $15/mo |
| Pro | Hourly | Yes | $49/mo |
| Agency | 15 minutes | Yes | $149/mo |
FAQ
Is the Google Search Console connection live?
Live with the same Google sign-in as Analytics. Testing mode covers up to 100 test users.
Do I have to talk to sales?
No. Create an account, connect the source, and the first report is on Home. Sample numbers stay available when a key is missing.
How often do the numbers refresh?
Free and Starter refresh daily. Pro refreshes hourly. Agency refreshes every 15 minutes on up to 50 accounts and hourly on the rest. We keep the history for you: 90 days on Free, and for as long as you subscribe on paid plans. No warehouse to set up.
Which fields are synced today?
The list marks Synced today on the fields the current connector pulls. The rest of the list is what the platform publishes, so you can see it before you sign up.