Google Search Console schema and ERD

25 tables

Joins between these tables aren't mapped yet.

Loading diagram…

sites

site_url

string

permission_level

string

_weld_synced

date

keyword_page_analytics_web

site

string

country

string

date

device

string

page

string

query

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

keyword_page_analytics_image

site

string

country

string

date

device

string

page

string

query

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

keyword_page_analytics_video

site

string

country

string

date

device

string

page

string

query

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

keyword_page_analytics_news

site

string

country

string

date

device

string

page

string

query

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

keyword_site_analytics_web

site

string

country

string

date

device

string

query

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

keyword_site_analytics_image

site

string

country

string

date

device

string

query

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

keyword_site_analytics_video

site

string

country

string

date

device

string

query

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

keyword_site_analytics_news

site

string

country

string

date

device

string

query

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

keyword_site_analytics_by_page_web

site

string

country

string

date

device

string

query

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

keyword_site_analytics_by_page_image

site

string

country

string

date

device

string

query

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

keyword_site_analytics_by_page_video

site

string

country

string

date

device

string

query

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

keyword_site_analytics_by_page_news

site

string

country

string

date

device

string

query

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

page_analytics_web

site

string

country

string

date

device

string

page

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

page_analytics_image

site

string

country

string

date

device

string

page

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

page_analytics_video

site

string

country

string

date

device

string

page

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

page_analytics_news

site

string

country

string

date

device

string

page

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

site_analytics_web

site

string

date

country

string

device

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

site_analytics_image

site

string

date

country

string

device

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

site_analytics_video

site

string

date

country

string

device

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

site_analytics_news

site

string

date

country

string

device

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

site_analytics_by_page_web

site

string

date

country

string

device

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

site_analytics_by_page_image

site

string

date

country

string

device

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

site_analytics_by_page_video

site

string

date

country

string

device

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date

site_analytics_by_page_news

site

string

date

country

string

device

string

clicks

double

impressions

double

ctr

double

position

double

search_type

string

_weld_synced

date