Fivetran documentation

Search the docs

/

Awin

Explore the interactive ERD

Table & Field Reference

reports_aggregated_by_campaign

Column	Type	Keys
`_fivetran_id`	String	PK
`advertiser_id`	Unknown	PKFK
`publisher_id`	Unknown	FK
`campaign`	Unknown
`commission_amount_approved`	Unknown
`commission_amount_bonus`	Unknown
`commission_amount_declined`	Unknown
`commission_amount_pending`	Unknown
`commission_amount_total`	Unknown
`date`	Unknown
`end_date`	Unknown
`publisher_name`	Unknown
`quantity_approved`	Unknown
`quantity_bonus`	Unknown
`quantity_click`	Unknown
`quantity_declined`	Unknown
`quantity_pending`	Unknown
`quantity_total`	Unknown
`sale_amount_approved`	Unknown
`sale_amount_bonus`	Unknown
`sale_amount_declined`	Unknown
`sale_amount_pending`	Unknown
`sale_amount_total`	Unknown
`start_date`	Unknown

reports_aggregated_by_creative

Column	Type	Keys
`_fivetran_id`	String	PK
`advertiser_id`	Unknown	FK
`publisher_id`	Unknown	FK
`advertiser_name`	Unknown
`bonus_commission`	Unknown
`bonus_number`	Unknown
`bonus_value`	Unknown
`click`	Unknown
`confirmed_commission`	Unknown
`confirmed_number`	Unknown
`confirmed_value`	Unknown
`creative_id`	Unknown
`creative_name`	Unknown
`currency`	Unknown
`declined_commission`	Unknown
`declined_number`	Unknown
`declined_value`	Unknown
`impression`	Unknown
`pending_commission`	Unknown
`pending_number`	Unknown
`pending_value`	Unknown
`publisher_name`	Unknown
`region`	Unknown
`tag_name`	Unknown
`total_commission`	Unknown
`total_number`	Unknown
`total_value`	Unknown

publisher_transaction_query

Column	Type	Keys
`enquiry_id`	Unknown	PK
`publisher_id`	Unknown	PKFK
`advertiser_id`	Unknown
`advertiser_name`	Unknown
`click_ref`	Unknown
`commission_amount`	Unknown
`commission_currency`	Unknown
`decline_reason`	Unknown
`description`	Unknown
`enquiry_date`	Unknown
`enquiry_status`	Unknown
`enquiry_type`	Unknown
`order_ref`	Unknown
`sale_amount`	Unknown
`sale_currency`	Unknown
`transaction_date`	Unknown
`validation_date`	Unknown

reports_aggregated_by_publisher

Column	Type	Keys
`_fivetran_id`	String	PK
`advertiser_id`	Unknown	FK
`publisher_id`	Unknown	FK
`advertiser_name`	Unknown
`bonus_commission`	Unknown
`bonus_number`	Unknown
`bonus_value`	Unknown
`click`	Unknown
`confirmed_commission`	Unknown
`confirmed_number`	Unknown
`confirmed_value`	Unknown
`currency`	Unknown
`declined_commission`	Unknown
`declined_number`	Unknown
`declined_value`	Unknown
`impression`	Unknown
`pending_commission`	Unknown
`pending_number`	Unknown
`pending_value`	Unknown
`publisher_name`	Unknown
`region`	Unknown
`tags`	Json
`total_commission`	Unknown
`total_number`	Unknown
`total_value`	Unknown

publisher_tracked_part

Column	Type	Keys
`index`	Unknown	PK
`publisher_transaction_id`	Unknown	PKFK
`publisher_transaction_part_commission_group_id`	Unknown	PKFK
`amount`	Unknown
`code`	Unknown
`currency`	Unknown

publisher_transaction_part

Column	Type	Keys
`commission_group_id`	Unknown	PK
`publisher_transaction_id`	Unknown	PKFK
`amount`	Unknown
`commission_amount`	Unknown
`commission_group_code`	Unknown
`commission_group_name`	Unknown

publisher_custom_parameter

Column	Type	Keys
`key`	Unknown	PK
`publisher_transaction_id`	Unknown	PKFK
`value`	Unknown

publisher_transaction

Column	Type	Keys
`id`	Unknown	PK
`advertiser_id`	Unknown	FK
`publisher_id`	Unknown	FK
`advertiser_country`	Unknown
`amend_reason`	Unknown
`amended`	Unknown
`campaign`	Unknown
`click_date`	Unknown
`click_device`	Unknown
`commission_amount`	Unknown
`commission_currency`	Unknown
`commission_sharing_publisher_id`	Unknown
`commission_sharing_selected_rate_publisher_id`	Unknown
`commission_status`	Unknown
`customer_country`	Unknown
`decline_reason`	Unknown
`ip_hash`	Unknown
`lapse_time`	Unknown
`old_commission_amount`	Unknown
`old_sale_amount`	Unknown
`order_ref`	Unknown
`original_sale_amount`	Unknown
`paid_to_publisher`	Unknown
`payment_id`	Unknown
`publisher_url`	Unknown
`sale_amount`	Unknown
`sale_currency`	Unknown
`site_name`	Unknown
`transaction_date`	Unknown
`transaction_device`	Unknown
`transaction_query_id`	Unknown
`type`	Unknown
`url`	Unknown
`validation_date`	Unknown
`voucher_code`	Unknown
`voucher_code_used`	Unknown
`custom_`

advertiser_account

Column	Type	Keys
`id`	Unknown	PK
`account_name`	Unknown
`account_type`	Unknown
`user_role`	Unknown

sales_region

Column	Type	Keys
`index`	Unknown	PK
`publisher_id`	Unknown	PKFK
`sales_region`	Unknown

publisher

Column	Type	Keys
`id`	Unknown	PK
`advertiser_account_id`	Unknown	PKFK
`name`	Unknown
`primary_region`	Unknown
`primary_type`	Unknown

basket_product

Column	Type	Keys
`product_id`	Unknown	PK
`transaction_id`	Unknown	PKFK
`category`	Unknown
`commission_group_code`	Unknown
`product_name`	Unknown
`quantity`	Unknown
`sku_code`	Unknown
`unit_price`	Unknown

tracked_part

Column	Type	Keys
`index`	Unknown	PK
`transaction_id`	Unknown	PKFK
`transaction_part_commission_group_id`	Unknown	PKFK
`amount`	Unknown
`code`	Unknown
`currency`	Unknown

transaction_part

Column	Type	Keys
`commission_group_id`	Unknown	PK
`transaction_id`	Unknown	PKFK
`advertiser_cost`	Unknown
`amount`	Unknown
`commission_amount`	Unknown
`commission_group_code`	Unknown
`commission_group_name`	Unknown

custom_parameter

Column	Type	Keys
`key`	Unknown	PK
`transaction_id`	Unknown	PKFK
`value`	Unknown

transaction

Column	Type	Keys
`id`	Unknown	PK
`advertiser_id`	Unknown	FK
`publisher_id`	Unknown	FK
`advertiser_cost_amount`	Unknown
`advertiser_cost_currency`	Unknown
`advertiser_country`	Unknown
`amend_reason`	Unknown
`amended`	Unknown
`campaign`	Unknown
`click_date`	Unknown
`click_device`	Unknown
`click_ref`	Unknown
`commission_amount`	Unknown
`commission_currency`	Unknown
`commission_sharing_publisher_id`	Unknown
`commission_sharing_selected_rate_publisher_id`	Unknown
`commission_status`	Unknown
`customer_acquisition`	Unknown
`customer_country`	Unknown
`decline_reason`	Unknown
`ip_hash`	Unknown
`lapse_time`	Unknown
`network_fee_amount`	Unknown
`network_fee_currency`	Unknown
`old_commission_amount`	Unknown
`old_sale_amount`	Unknown
`order_ref`	Unknown
`original_sale_amount`	Unknown
`paid_to_publisher`	Unknown
`payment_id`	Unknown
`publisher_url`	Unknown
`sale_amount`	Unknown
`sale_currency`	Unknown
`site_name`	Unknown
`tracked_amount`	Unknown
`tracked_currency`	Unknown
`transaction_date`	Unknown
`transaction_device`	Unknown
`transaction_query_id`	Unknown
`type`	Unknown
`url`	Unknown
`validation_date`	Unknown
`voucher_code`	Unknown
`voucher_code_used`	Unknown

publisher_account

Column	Type	Keys
`id`	Unknown	PK
`account_name`	Unknown
`account_type`	Unknown
`user_role`	Unknown