Fivetran documentation

Search the docs

/

Ascend by Partnerize

Explore the interactive ERD

Table & Field Reference

creative_performance_resource

Column	Type	Keys
`date`	Unknown	PK
`id`	Unknown	PK
`affiliate_usage`	Unknown
`click_through_rate`	Unknown
`clicks`	Unknown
`commission`	Unknown
`earnings_per_click`	Unknown
`end_date`	Unknown
`impressions`	Unknown
`items`	Unknown
`name`	Unknown
`sales`	Unknown
`start_date`	Unknown
`transactions`	Unknown
`type`	Unknown

transaction_history_resource_debit

Column	Type	Keys
`_fivetran_id`	String	PK
`commission`	Unknown
`company`	Unknown
`end_date`	Unknown
`item_id`	Unknown
`link_type`	Unknown
`order_id`	Unknown
`process_date`	Unknown
`publisher`	Unknown
`publisher_commission`	Unknown
`publisher_id`	Unknown
`publisher_type`	Unknown
`revision`	Unknown
`sale_amount`	Unknown
`sale_date`	Unknown
`site_commission`	Unknown
`start_date`	Unknown
`status`	Unknown
`transaction_id`	Unknown
`transaction_type`	Unknown
`website_url`	Unknown

transaction_history_resource_credit

Column	Type	Keys
`_fivetran_id`	String	PK
`commission`	Unknown
`company`	Unknown
`end_date`	Unknown
`item_id`	Unknown
`link_type`	Unknown
`order_id`	Unknown
`process_date`	Unknown
`publisher`	Unknown
`publisher_commission`	Unknown
`publisher_id`	Unknown
`publisher_type`	Unknown
`revision`	Unknown
`sale_amount`	Unknown
`sale_date`	Unknown
`site_commission`	Unknown
`start_date`	Unknown
`status`	Unknown
`transaction_id`	Unknown
`transaction_type`	Unknown
`website_url`	Unknown

transaction_details_resource

Column	Type	Keys
`id`	Unknown	PK
`click_date`	Unknown
`click_id`	Unknown
`commission`	Unknown
`commission_publisher`	Unknown
`commission_site`	Unknown
`company`	Unknown
`coupons`	Unknown
`creative_id`	Unknown
`device_type`	Unknown
`end_date`	Unknown
`link_type`	Unknown
`new_to_file`	Unknown
`order_id`	Unknown
`publisher`	Unknown
`publisher_id`	Unknown
`publisher_referral_url`	Unknown
`publisher_type`	Unknown
`referrer_url`	Unknown
`sale_amount`	Unknown
`sale_date`	Unknown
`start_date`	Unknown
`status`	Unknown
`type`	Unknown

creative_performance_publisher_resource

Column	Type	Keys
`creative_id`	Unknown	PK
`date`	Unknown	PK
`publisher_id`	Unknown	PK
`click_through_rate`	Unknown
`clicks`	Unknown
`commission`	Unknown
`creative_name`	Unknown
`creative_type`	Unknown
`earnings_per_click`	Unknown
`end_date`	Unknown
`impressions`	Unknown
`publisher`	Unknown
`sales`	Unknown
`start_date`	Unknown
`transactions`	Unknown