# Google Search Console datasets and fields

> The 7 datasets Maven lands from Google Search Console, every field in them, and how the connection syncs.

Source: https://mavendata.ai/docs/integrations/gsc

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](https://mavendata.ai/integrations/gsc).

## 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 |
