Fivetran documentation

Search the docs

/

Google Search Console

Explore the interactive ERD

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