Fivetran documentation

Search the docs

/

Profound

Explore the interactive ERD

Table & Field Reference

report_citation

Column	Type	Keys
`_fivetran_id`	String	PK
`category_id`	Unknown	FK
`prompt_id`	Unknown	FK
`topic_id`	Unknown	FK
`citation_category`	Unknown
`citation_share`	Unknown
`count`	Unknown
`date`	Unknown
`hostname`	Unknown
`model`	Unknown
`path`	Unknown
`persona`	Unknown
`region`	Unknown
`root_domain`	Unknown
`tags`	Unknown
`url`	Unknown

category_topic

Column	Type	Keys
`id`	Unknown	PK
`category_id`	Unknown	PKFK
`name`	Unknown
`status`	Unknown

optimization

Column	Type	Keys
`id`	Unknown	PK
`asset_id`	Unknown	PKFK
`created_at`	Instant
`extracted_input`	Unknown
`status`	Unknown
`title`	Unknown
`type`	Unknown

model

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown

persona_employment_industry

Column	Type	Keys
`index`	Unknown	PK
`persona_id`	Unknown	PKFK
`industry`	Unknown

persona_employment_job_title

Column	Type	Keys
`index`	Unknown	PK
`persona_id`	Unknown	PKFK
`job_title`	Unknown

persona_employment_company_size

Column	Type	Keys
`index`	Unknown	PK
`persona_id`	Unknown	PKFK
`company_size`	Unknown

persona_employment_role_seniority

Column	Type	Keys
`index`	Unknown	PK
`persona_id`	Unknown	PKFK
`role_seniority`	Unknown

persona_demographics_age_range

Column	Type	Keys
`index`	Unknown	PK
`persona_id`	Unknown	PKFK
`age_range`	Unknown

persona

Column	Type	Keys
`id`	Unknown	PK
`category_id`	Unknown	FK
`behavior_motivations`	Unknown
`behavior_pain_points`	Unknown
`name`	Unknown
`organization_id`	Unknown
`organization_name`	Unknown

report_fanout

Column	Type	Keys
`_fivetran_id`	String	PK
`category_id`	Unknown	FK
`date`	Unknown
`fanouts_per_execution`	Unknown
`model`	Unknown
`prompt`	Unknown
`query`	Unknown
`region`	Unknown
`share`	Unknown
`total_fanouts`	Unknown

report_sentiment

Column	Type	Keys
`_fivetran_id`	String	PK
`asset_id`	Unknown	FK
`category_id`	Unknown	FK
`prompt_id`	Unknown	FK
`topic_id`	Unknown	FK
`date`	Unknown
`model`	Unknown
`negative`	Unknown
`occurrences`	Unknown
`persona`	Unknown
`positive`	Unknown
`region`	Unknown
`sentiment_type`	Unknown
`tags`	Unknown
`theme`	Unknown

answer_tag

Column	Type	Keys
`index`	Unknown	PK
`category_id`	Unknown	PKFK
`run_id`	Unknown	PKFK
`tags`	Unknown

answer_mention

Column	Type	Keys
`index`	Unknown	PK
`category_id`	Unknown	PKFK
`run_id`	Unknown	PKFK
`mention`	Unknown

answer_citation

Column	Type	Keys
`index`	Unknown	PK
`category_id`	Unknown	PKFK
`run_id`	Unknown	PKFK
`citation`	Unknown

answer_search_query

Column	Type	Keys
`index`	Unknown	PK
`category_id`	Unknown	PKFK
`run_id`	Unknown	PKFK
`search_query`	Unknown

answer_sentiment_theme

Column	Type	Keys
`index`	Unknown	PK
`category_id`	Unknown	PKFK
`run_id`	Unknown	PKFK
`name`	Unknown
`type`	Unknown

answer

Column	Type	Keys
`run_id`	Unknown	PK
`category_id`	Unknown	PKFK
`asset_id`	Unknown	FK
`model_id`	Unknown	FK
`prompt_id`	Unknown	FK
`topic_id`	Unknown	FK
`created_at`	Unknown
`persona`	Unknown
`region`	Unknown
`response`	Unknown

category_tag

Column	Type	Keys
`id`	Unknown	PK
`category_id`	Unknown	PKFK
`name`	Unknown

domain

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Instant
`name`	Unknown
`organization_id`	Unknown
`organization_name`	Unknown

report_visibility

Column	Type	Keys
`_fivetran_id`	String	PK
`asset_id`	Unknown	FK
`category_id`	Unknown	FK
`prompt_id`	Unknown	FK
`topic_id`	Unknown	FK
`average_position`	Unknown
`date`	Unknown
`executions`	Unknown
`mentions_count`	Unknown
`model`	Unknown
`persona`	Unknown
`region`	Unknown
`share_of_voice`	Unknown
`tags`	Unknown
`visibility_score`	Unknown

asset_alternate_domain

Column	Type	Keys
`index`	Unknown	PK
`asset_id`	Unknown	PKFK
`domain`	Unknown

asset

Column	Type	Keys
`id`	Unknown	PK
`category_id`	Unknown	FK
`created_at`	Instant
`is_owned`	Unknown
`logo_url`	Unknown
`name`	Unknown
`organization_id`	Unknown
`organization_name`	Unknown
`website`	Unknown

region

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown

category

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown
`organization_id`	Unknown
`organization_name`	Unknown

prompt_region

Column	Type	Keys
`index`	Unknown	PK
`prompt_id`	Unknown	PKFK
`region_id`	Unknown	FK

prompt_platform

Column	Type	Keys
`index`	Unknown	PK
`prompt_id`	Unknown	PKFK
`name`	Unknown
`platform_id`	Unknown

prompt_analysis_type

Column	Type	Keys
`index`	Unknown	PK
`prompt_id`	Unknown	PKFK
`analysis_type`	Unknown

prompt

Column	Type	Keys
`id`	Unknown	PK
`category_id`	Unknown	PKFK
`topic_id`	Unknown	FK
`created_at`	Instant
`languages`	Unknown
`personas`	Json
`prompt`	Unknown
`tags`	Json