Fivetran documentation

Search the docs

/

Trisolute

Explore the interactive ERD

Table & Field Reference

keyword_category

Column	Type	Keys
`category`	Unknown	PK
`index`	Unknown	PK
`keyword_added`	Unknown	PKFK
`keyword_keyword`	Unknown	PKFK

keyword

Column	Type	Keys
`added`	Unknown	PK
`keyword`	Unknown	PK
`crawl_interval`	Unknown
`ignored`	Unknown
`priority`	Unknown
`relevance`	Unknown
`source`	Unknown
`updated`	Unknown

serp_drilldown_keyword

Column	Type	Keys
`keyword`	Unknown	PK
`object_type`	Unknown	PK
`total_ranking_count`	Unknown

serp_publisher

Column	Type	Keys
`publisher`	Unknown	PK
`keyword`	Unknown	PKFK
`object_type`	Unknown	PKFK
`ranking_count`	Unknown

ranking_detail

Column	Type	Keys
`_fivetran_id`	String	PK
`ranking_identifier`	Unknown	FK
`ranking_keyword`	Unknown	FK
`amp`	Unknown
`crawl_date`	Unknown
`device`	Unknown
`object_type`	Unknown
`position`	Unknown
`position_in_ranking_type`	Unknown
`ranking_lost`	Unknown
`ranking_type`	Unknown
`title`	Unknown
`url`	Unknown
`video`	Unknown

ranking

Column	Type	Keys
`identifier`	Unknown	PK
`keyword`	Unknown	PK
`news_tab_crawl_date`	Unknown
`news_tab_title`	Unknown
`news_tab_url`	Unknown
`object_type`	Unknown

keyword_without_article_ranking

Column	Type	Keys
`_fivetran_id`	String	PK
`amp`	Unknown
`crawl_date`	Unknown
`device`	Unknown
`keyword_with_article_identifier`	Unknown
`keyword_with_article_keyword`	Unknown
`position`	Unknown
`position_in_ranking_type`	Unknown
`ranking_lost`	Unknown
`ranking_type`	Unknown
`title`	Unknown
`url`	Unknown
`video`	Unknown

keyword_with_article

Column	Type	Keys
`_fivetran_id`	String	PK
`keyword`	Unknown	FK
`identifier`	Unknown
`news_tab_crawl_date`	Unknown
`news_tab_title`	Unknown
`news_tab_url`	Unknown

serp_drilldown_article

Column	Type	Keys
`type`	Unknown	PK
`url`	Unknown	PK
`score_percentage_within_top_hit`	Unknown
`title`	Unknown

missing_topic

Column	Type	Keys
`date_filter`	Unknown	PK
`key`	Unknown	PKFK

serp_visibility_value

Column	Type	Keys
`date`	Unknown	PK
`publisher`	Unknown	PK
`object_type`	Unknown
`value`	Unknown

articles_without_ranking_keyword

Column	Type	Keys
`index`	Unknown	PK
`title`	Unknown	PK
`url`	Unknown	PK
`keyword`	Unknown

category_distribution_chart

Column	Type	Keys
`category`	Unknown	PK
`date`	Unknown	PK
`publisher`	Unknown	PK
`value`	Unknown

google_news_visibility_chart

Column	Type	Keys
`date`	Unknown	PK
`google_chart_publisher`	Unknown	PK
`value`	Unknown

general_keyword_category

Column	Type	Keys
`index`	Unknown	PK
`general_keyword_keyword`	Unknown	PKFK
`general_object`	Unknown	PKFK
`category`	Unknown

general_keyword

Column	Type	Keys
`keyword`	Unknown	PK
`type`	Unknown	PK
`relevance`	Unknown

topic_coverage_chart

Column	Type	Keys
`date`	Unknown	PK
`publisher`	Unknown	PK
`value`	Unknown

indexed_article

Column	Type	Keys
`indexed`	Unknown	PK
`url`	Unknown	PK
`title`	Unknown

index_rate_chart

Column	Type	Keys
`date`	Unknown	PK
`index_chart_publisher`	Unknown	PK
`value`	Unknown