Fivetran documentation

Search the docs

/

Impact Partner

Explore the interactive ERD

Table & Field Reference

action_update

Column	Type	Keys
`id`	Unknown	PK
`action_id`	Unknown	PKFK
`action_date`	Unknown
`action_tracker_id`	Unknown
`action_uri`	Unknown
`ad_id`	Unknown
`campaign_id`	Unknown
`catalog_category`	Unknown
`catalog_description`	Unknown
`catalog_manufacturer`	Unknown
`catalog_name`	Unknown
`catalog_original_format_category`	Unknown
`catalog_sub_category`	Unknown
`category`	Unknown
`clearing_date`	Unknown
`contract_id`	Unknown
`currency`	Unknown
`default_payout`	Unknown
`default_payout_currency`	Unknown
`delta_amount`	Unknown
`delta_payout`	Unknown
`event_code`	Unknown
`event_type_id`	Unknown
`event_type_name`	Unknown
`locking_date`	Unknown
`o_id`	Unknown
`payout_level`	Unknown
`paystub_id`	Unknown
`quantity`	Unknown
`reporting_state`	Unknown
`shared_id`	Unknown
`sku`	Unknown
`state`	Unknown
`state_detail`	Unknown
`state_detail_description`	Unknown
`sub_category`	Unknown
`sub_id_1`	Unknown
`sub_id_2`	Unknown
`sub_id_3`	Unknown
`update_date`	Unknown
`uri`	Unknown

catalog_item_promotion

Column	Type	Keys
`catalog_id`	Unknown	PKFK
`catalog_item_id`	Unknown	PKFK
`promotion_id`	Unknown	PKFK

catalog_item_advertiser_format_categorogies

Column	Type	Keys
`index`	Unknown	PK
`catalog_id`	Unknown	PKFK
`catalog_item_id`	Unknown	PKFK
`advertiser_format_categories`	Unknown

catalog_item_color

Column	Type	Keys
`index`	Unknown	PK
`catalog_id`	Unknown	PKFK
`catalog_item_id`	Unknown	PKFK
`colors`	Unknown

catalog_item

Column	Type	Keys
`id`	Unknown	PK
`catalog_id`	Unknown	PKFK
`additional_image_url`	Json
`adult`	Unknown
`age_group`	Unknown
`age_range_max`	Unknown
`age_range_min`	Unknown
`age_range_unit`	Unknown
`asin`	Unknown
`bullet`	Json
`campaign_id`	Unknown
`campaign_name`	Unknown
`catalog_item_id`	Unknown
`category`	Unknown
`condition`	Unknown
`currency`	Unknown
`current_price`	Unknown
`description`	Unknown
`discount_percentage`	Unknown
`estimated_ship_date`	Unknown
`expiration_date`	Unknown
`gender`	Unknown
`gtin`	Unknown
`gtin_type`	Unknown
`image_url`	Unknown
`is_parent`	Unknown
`item_group_id`	Unknown
`label`	Json
`launch_date`	Unknown
`manufacturer`	Unknown
`material`	Unknown
`mobile_url`	Unknown
`money_1`	Unknown
`money_2`	Unknown
`money_3`	Unknown
`mpn`	Unknown
`multi_pack`	Unknown
`name`	Unknown
`numeric_1`	Unknown
`numeric_2`	Unknown
`numeric_3`	Unknown
`original_format_category`	Unknown
`original_format_category_id`	Unknown
`original_price`	Unknown
`parent_name`	Unknown
`parent_sku`	Unknown
`pattern`	Unknown
`product_bid`	Unknown
`shipping_height`	Unknown
`shipping_label`	Unknown
`shipping_length`	Unknown
`shipping_length_unit`	Unknown
`shipping_rate`	Unknown
`shipping_weight`	Unknown
`shipping_weight_unit`	Unknown
`shipping_width`	Unknown
`size`	Unknown
`size_unit`	Unknown
`stock_availability`	Unknown
`sub_category`	Unknown
`text_1`	Unknown
`text_2`	Unknown
`text_3`	Unknown
`uri`	Unknown
`url`	Unknown
`weight`	Unknown
`weight_unit`	Unknown

catalog_service_area

Column	Type	Keys
`index`	Unknown	PK
`catalog_id`	Unknown	PKFK
`service_area`	Unknown

catalog_location

Column	Type	Keys
`index`	Unknown	PK
`catalog_id`	Unknown	PKFK
`location`	Unknown

catalog

Column	Type	Keys
`id`	Unknown	PK
`advertiser_id`	Unknown
`advertiser_location`	Unknown
`advertiser_name`	Unknown
`campaign_id`	Unknown
`campaign_name`	Unknown
`currency`	Unknown
`date_last_updated`	Unknown
`ftp_locations`	Json
`items_uri`	Unknown
`languages`	Unknown
`name`	Unknown
`number_of_item`	Unknown
`uri`	Unknown

action

Column	Type	Keys
`action_tracker_id`	Unknown	PK
`ad_id`	Unknown	PK
`campaign_id`	Unknown	PK
`id`	Unknown	PK
`action_tracker_name`	Unknown
`amount`	Unknown
`campaign_name`	Unknown
`cleared_date`	Unknown
`creation_date`	Unknown
`currency`	Unknown
`customer_area`	Unknown
`customer_city`	Unknown
`customer_country`	Unknown
`customer_region`	Unknown
`delta_amount`	Unknown
`delta_payout`	Unknown
`event_code`	Unknown
`event_date`	Unknown
`intended_amount`	Unknown
`intended_payout`	Unknown
`locking_date`	Unknown
`order_id`	Unknown
`payout`	Unknown
`promo_code`	Unknown
`referring_date`	Unknown
`referring_domain`	Unknown
`referring_type`	Unknown
`shared_id`	Unknown
`state`	Unknown
`sub_id_1`	Unknown
`sub_id_2`	Unknown
`sub_id_3`	Unknown
`uri`	Unknown

promotion

Column	Type	Keys
`id`	Unknown	PK
`advertiser_id`	Unknown
`advertiser_location`	Unknown
`advertiser_name`	Unknown
`effective_date`	Unknown
`file_id`	Unknown
`generic_redemption_code`	Unknown
`item_uri`	Unknown
`title`	Unknown
`uri`	Unknown

user_access_right_permission

Column	Type	Keys
`index`	Unknown	PK
`access_right_role`	Unknown	PKFK
`user_id`	Unknown	PKFK
`permission`	Unknown

user_access_right

Column	Type	Keys
`role`	Unknown	PK
`user_id`	Unknown	PKFK

users

Column	Type	Keys
`id`	Unknown	PK
`created_by`	Unknown
`date_last_updated`	Unknown
`first_name`	Unknown
`invitee_name`	Unknown
`joined_date`	Unknown
`languages`	Unknown
`last_name`	Unknown
`last_updated_by`	Unknown
`state`	Unknown
`type`	Unknown
`uri`	Unknown
`username`	Unknown

click_brand_related

Column	Type	Keys
`index`	Unknown	PK
`click_id`	Unknown	PKFK
`ad_campaign`	Unknown
`ad_group`	Unknown
`channel`	Unknown
`keyword`	Unknown
`match_type`	Unknown

click_partner_related

Column	Type	Keys
`index`	Unknown	PK
`click_id`	Unknown	PKFK
`sub_id_1`	Unknown
`sub_id_2`	Unknown
`sub_id_3`	Unknown

click

Column	Type	Keys
`id`	Unknown	PK
`ad_id`	Unknown
`ad_name`	Unknown
`ad_type`	Unknown
`bid_keyword`	Unknown
`browser`	Unknown
`campaign_id`	Unknown
`campaign_name`	Unknown
`cpc_bid`	Unknown
`customer_area`	Unknown
`customer_city`	Unknown
`customer_country`	Unknown
`customer_region`	Unknown
`deal_name`	Unknown
`deal_scope`	Unknown
`deal_type`	Unknown
`device_family`	Unknown
`device_type`	Unknown
`event_date`	Unknown
`ip_address`	Unknown
`landing_page_url`	Unknown
`media_id`	Unknown
`media_name`	Unknown
`os`	Unknown
`payout`	Unknown
`product_sku`	Unknown
`profile_id`	Unknown
`referring_domain`	Unknown
`referring_url`	Unknown
`search_text`	Unknown
`shared_id`	Unknown
`traffic_category`	Unknown
`traffic_source`	Unknown
`unique_click`	Unknown