# Google Search Console schema ERD

Table and field reference for the Fivetran Google Search Console connector.

## Table & Field Reference

### keyword_site_report_by_site

| Column | Type | Keys |
| --- | --- | --- |
| country | String | PK |
| date | LocalDate | PK |
| device | String | PK |
| query | String | PK |
| search_type | String | PK |
| site | String | PK |
| clicks | Double |  |
| ctr | Double |  |
| impressions | Double |  |
| position | Double |  |

### keyword_page_report

| Column | Type | Keys |
| --- | --- | --- |
| country | String | PK |
| date | LocalDate | PK |
| device | String | PK |
| page | String | PK |
| query | String | PK |
| search_type | String | PK |
| site | String | PK |
| clicks | Double |  |
| ctr | Double |  |
| impressions | Double |  |
| position | Double |  |

### page_report

| Column | Type | Keys |
| --- | --- | --- |
| country | String | PK |
| date | LocalDate | PK |
| device | String | PK |
| page | String | PK |
| search_type | String | PK |
| site | String | PK |
| clicks | Double |  |
| ctr | Double |  |
| impressions | Double |  |
| position | Double |  |

### hourly_keyword_site_report_by_site

| Column | Type | Keys |
| --- | --- | --- |
| country | String | PK |
| device | String | PK |
| hour | Instant | PK |
| query | String | PK |
| search_type | String | PK |
| site | String | PK |
| clicks | Double |  |
| ctr | Double |  |
| impressions | Double |  |
| position | Double |  |

### sitemap

| Column | Type | Keys |
| --- | --- | --- |
| last_downloaded | Instant | PK |
| last_submitted | Instant | PK |
| path | String | PK |
| site | String | PK |
| type | String | PK |
| errors | Long |  |
| indexed | Long |  |
| submitted | Long |  |
| warnings | Long |  |

### hourly_keyword_site_report_by_page

| Column | Type | Keys |
| --- | --- | --- |
| country | String | PK |
| device | String | PK |
| hour | Instant | PK |
| query | String | PK |
| search_type | String | PK |
| site | String | PK |
| clicks | Double |  |
| ctr | Double |  |
| impressions | Double |  |
| position | Double |  |

### hourly_keyword_page_report

| Column | Type | Keys |
| --- | --- | --- |
| country | String | PK |
| device | String | PK |
| hour | Instant | PK |
| page | String | PK |
| query | String | PK |
| search_type | String | PK |
| site | String | PK |
| clicks | Double |  |
| ctr | Double |  |
| impressions | Double |  |
| position | Double |  |

### hourly_site_report_by_site

| Column | Type | Keys |
| --- | --- | --- |
| country | String | PK |
| device | String | PK |
| hour | Instant | PK |
| search_type | String | PK |
| site | String | PK |
| clicks | Double |  |
| ctr | Double |  |
| impressions | Double |  |
| position | Double |  |

### hourly_page_report

| Column | Type | Keys |
| --- | --- | --- |
| country | String | PK |
| device | String | PK |
| hour | Instant | PK |
| page | String | PK |
| search_type | String | PK |
| site | String | PK |
| clicks | Double |  |
| ctr | Double |  |
| impressions | Double |  |
| position | Double |  |

### site_report_by_site

| Column | Type | Keys |
| --- | --- | --- |
| country | String | PK |
| date | LocalDate | PK |
| device | String | PK |
| search_type | String | PK |
| site | String | PK |
| clicks | Double |  |
| ctr | Double |  |
| impressions | Double |  |
| position | Double |  |

### hourly_site_report_by_page

| Column | Type | Keys |
| --- | --- | --- |
| country | String | PK |
| device | String | PK |
| hour | Instant | PK |
| search_type | String | PK |
| site | String | PK |
| clicks | Double |  |
| ctr | Double |  |
| impressions | Double |  |
| position | Double |  |

### keyword_site_report_by_page

| Column | Type | Keys |
| --- | --- | --- |
| country | String | PK |
| date | LocalDate | PK |
| device | String | PK |
| query | String | PK |
| search_type | String | PK |
| site | String | PK |
| clicks | Double |  |
| ctr | Double |  |
| impressions | Double |  |
| position | Double |  |

### site_report_by_page

| Column | Type | Keys |
| --- | --- | --- |
| country | String | PK |
| date | LocalDate | PK |
| device | String | PK |
| search_type | String | PK |
| site | String | PK |
| clicks | Double |  |
| ctr | Double |  |
| impressions | Double |  |
| position | Double |  |