Integrations
Google Search Console datasets and fields
The 7 datasets Maven lands from Google Search Console, every field in them, and how the connection syncs.
Maven lands 7 datasets from Google Search Console in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the Google Search Console integration page.
Connection and sync#
You connect Google Search Console by signing in to it and approving access, so nobody shares a password.
The first Google Search Console sync pulls the most recent 30 days so the workspace fills quickly. A follow-up backfill then adds older history, up to 480 days in total. After that, each scheduled sync re-reads the last 3 days, so late changes are picked up.
Datasets#
Gsc query performance#
Search query metrics — daily history plus unified rolling hourly rows.
| Field | Type |
|---|---|
| date | Date |
| hour | Text |
| hour label | Text |
| grain key | Text |
| query | Text |
| clicks | Integer |
| impressions | Integer |
| CTR | Number |
| position | Number |
| account ID | Text |
| data grain | Text |
| data state | Text |
| source timezone | Text |
Gsc page performance#
Page-level search metrics — daily history plus unified rolling hourly rows.
| Field | Type |
|---|---|
| date | Date |
| hour | Text |
| hour label | Text |
| grain key | Text |
| page | Text |
| clicks | Integer |
| impressions | Integer |
| CTR | Number |
| position | Number |
| account ID | Text |
| data grain | Text |
| data state | Text |
| source timezone | Text |
Gsc country performance#
Search performance by country — daily history plus unified rolling hourly rows.
| Field | Type |
|---|---|
| date | Date |
| hour | Text |
| hour label | Text |
| grain key | Text |
| country | Text |
| clicks | Integer |
| impressions | Integer |
| CTR | Number |
| position | Number |
| account ID | Text |
| data grain | Text |
| data state | Text |
| source timezone | Text |
Gsc device performance#
Search performance by device type — daily history plus unified rolling hourly rows.
| Field | Type |
|---|---|
| date | Date |
| hour | Text |
| hour label | Text |
| grain key | Text |
| device | Text |
| clicks | Integer |
| impressions | Integer |
| CTR | Number |
| position | Number |
| account ID | Text |
| data grain | Text |
| data state | Text |
| source timezone | Text |
Gsc query page performance#
Query-to-page mapping with metrics — daily history plus unified rolling hourly rows.
| Field | Type |
|---|---|
| date | Date |
| hour | Text |
| hour label | Text |
| grain key | Text |
| query | Text |
| page | Text |
| clicks | Integer |
| impressions | Integer |
| CTR | Number |
| position | Number |
| account ID | Text |
| data grain | Text |
| data state | Text |
| source timezone | Text |
Gsc hourly page performance#
Hourly page-level search metrics over GSC's rolling ~10-day hourly window (hour is Pacific Time; date is the PT calendar date derived from it).
| Field | Type |
|---|---|
| date | Date |
| hour | Text |
| page | Text |
| clicks | Integer |
| impressions | Integer |
| CTR | Number |
| position | Number |
| account ID | Text |
Gsc hourly query page performance#
Hourly query-to-page search metrics split by device and country over GSC's rolling ~10-day hourly window.
| Field | Type |
|---|---|
| date | Date |
| hour | Text |
| query | Text |
| page | Text |
| device | Text |
| country | Text |
| clicks | Integer |
| impressions | Integer |
| CTR | Number |
| position | Number |
| account ID | Text |