Fivetran documentation

Search the docs

/

Retently

Explore the interactive ERD

Table & Field Reference

latest_score

Column	Type	Keys
`_fivetran_id`	String	PK
`detractors`	Unknown
`detractors_count`	Unknown
`metrics_type`	Unknown
`passives`	Unknown
`passives_count`	Unknown
`promoters`	Unknown
`promoters_count`	Unknown
`score`	Unknown
`score_sum`	Unknown
`total_responses`	Unknown

customer_tag

Column	Type	Keys
`tag_name`	Unknown	PK
`customer_id`	Unknown	PKFK

customer_property

Column	Type	Keys
`index`	Unknown	PK
`customer_id`	Unknown	PKFK
`label`	Unknown
`name`	Unknown
`type`	Unknown
`value`	Unknown

customer

Column	Type	Keys
`id`	Unknown	PK
`company_id`	Unknown	FK
`created_date`	Unknown
`email`	Unknown
`first_name`	Unknown
`last_name`	Unknown

template

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

campaign

Column	Type	Keys
`id`	Unknown	PK
`template_id`	Unknown	FK
`channel`	Unknown
`is_active`	Unknown
`metric`	Unknown
`name`	Unknown
`type`	Unknown

outbox_additional_recipient

Column	Type	Keys
`index`	Unknown	PK
`customer_id`	Unknown	PKFK
`mandrill_message_id`	Unknown	FK
`email`	Unknown
`type`	Unknown

outbox_customer_tag

Column	Type	Keys
`tag_name`	Unknown	PK
`outbox_customer_id`	Unknown	PKFK

outbox

Column	Type	Keys
`customer_id`	Unknown	PKFK
`campaign_id`	Unknown	FK
`company_id`	Unknown	FK
`survey_template_id`	Unknown	FK
`channel`	Unknown
`detailed_status_has_feedback`	Unknown
`detailed_status_is_bounced`	Unknown
`detailed_status_is_opened`	Unknown
`detailed_status_is_opted_out`	Unknown
`detailed_status_is_responded`	Unknown
`detailed_status_opened_date`	Unknown
`detailed_status_responded_date`	Unknown
`email`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`mandrill_message_id`	Unknown
`person_tags`	Json
`sent_by`	Unknown
`sent_date`	Unknown
`status`	Unknown
`subject`	Unknown
`template_id`	Unknown
`custom_`

report_question_stats

Column	Type	Keys
`uuid`	Unknown	PK
`report_campaign_id`	Unknown	PKFK
`is_on_main`	Unknown
`is_starred`	Unknown
`metrics_type`	Unknown
`position`	Unknown
`stats_first_day`	Unknown
`stats_first_detractors`	Unknown
`stats_first_opened`	Unknown
`stats_first_passives`	Unknown
`stats_first_promoters`	Unknown
`stats_first_responded`	Unknown
`stats_first_score`	Unknown
`stats_first_score_sum`	Unknown
`stats_first_skipped`	Unknown
`stats_first_total`	Unknown
`stats_last_day`	Unknown
`stats_last_detractors`	Unknown
`stats_last_opened`	Unknown
`stats_last_passives`	Unknown
`stats_last_promoters`	Unknown
`stats_last_responded`	Unknown
`stats_last_score`	Unknown
`stats_last_score_sum`	Unknown
`stats_last_skipped`	Unknown
`stats_last_total`	Unknown
`title`	Unknown

report_trend

Column	Type	Keys
`index`	Unknown	PK
`report_campaign_id`	Unknown	PKFK
`day`	Unknown
`detractor`	Unknown
`passive`	Unknown
`promoter`	Unknown
`score`	Unknown
`total`	Unknown

report

Column	Type	Keys
`campaign_id`	Unknown	PKFK
`delivery_stats_id`	Unknown
`delivery_stats_is_bounced`	Unknown
`delivery_stats_opened`	Unknown
`delivery_stats_opted_out`	Unknown
`delivery_stats_responded`	Unknown
`delivery_stats_total_count`	Unknown
`detractor`	Unknown
`passive`	Unknown
`promoter`	Unknown
`score`	Unknown
`total`	Unknown

company_tag

Column	Type	Keys
`tag_name`	Unknown	PK
`company_id`	Unknown	PKFK

company

Column	Type	Keys
`id`	Unknown	PK
`contacts_count`	Unknown
`created_date`	Unknown
`cx_metrics_ces`	Unknown
`cx_metrics_csat`	Unknown
`cx_metrics_nps`	Unknown
`cx_metrics_star`	Unknown
`cx_metrics_xsa`	Unknown
`domain`	Unknown
`industry_name`	Unknown
`name`	Unknown

feedback_note

Column	Type	Keys
`index`	Unknown	PK
`feedback_id`	Unknown	PKFK
`author`	Unknown
`content`	Unknown
`date`	Unknown
`metrics_type`	Unknown

feedback_additional_question

Column	Type	Keys
`index`	Unknown	PK
`feedback_id`	Unknown	PKFK
`answer`	Unknown
`consent`	Unknown
`metrics_type`	Unknown
`question_text`	Unknown
`title`	Unknown
`type`	Unknown

feedback_tag

Column	Type	Keys
`tag_name`	Unknown	PK
`feedback_id`	Unknown	PKFK

feedback_topic

Column	Type	Keys
`index`	Unknown	PK
`feedback_id`	Unknown	PKFK
`name`	Unknown
`sentiment`	Unknown

feedback_response_tag

Column	Type	Keys
`tag_name`	Unknown	PK
`feedback_id`	Unknown	PKFK

feedback

Column	Type	Keys
`id`	Unknown	PK
`campaign_id`	Unknown	FK
`company_id`	Unknown	FK
`customer_id`	Unknown	FK
`assigned`	Unknown
`channel`	Unknown
`checkbox`	Unknown
`city`	Unknown
`comment`	Unknown
`country`	Unknown
`created_date`	Unknown
`email`	Unknown
`first_name`	Unknown
`is_bogus`	Unknown
`job_title`	Unknown
`last_name`	Unknown
`metrics_type`	Unknown
`rating_category`	Unknown
`resolved`	Unknown
`score`	Unknown
`state`	Unknown
`status`	Unknown
`custom_`