AvantLink

Explore the interactive ERD

Table & Field Reference

calender_period_trending

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_impressions_current`	Unknown
`ad_impressions_previous`	Unknown
`average_sale_amount_current`	Unknown
`average_sale_amount_previous`	Unknown
`click_through_rate_current`	Unknown
`click_through_rate_previous`	Unknown
`click_throughs_current`	Unknown
`click_throughs_previous`	Unknown
`commissions_current`	Unknown
`commissions_previous`	Unknown
`conversion_rate_current`	Unknown
`conversion_rate_previous`	Unknown
`cpc_fees_current`	Unknown
`cpc_fees_previous`	Unknown
`date_range_current`	Unknown
`date_range_previous`	Unknown
`incentives_current`	Unknown
`incentives_previous`	Unknown
`mobile_sales_current`	Unknown
`mobile_sales_previous`	Unknown
`network_commissions_current`	Unknown
`network_commissions_previous`	Unknown
`network_cpc_fees_current`	Unknown
`network_cpc_fees_previous`	Unknown
`new_customer_`	Unknown
`new_customer_sales_current`	Unknown
`new_customer_sales_previous`	Unknown
`new_customers_current`	Unknown
`new_customers_previous`	Unknown
`number_of_adjustments_current`	Unknown
`number_of_adjustments_previous`	Unknown
`number_of_mobile_sales_current`	Unknown
`number_of_mobile_sales_previous`	Unknown
`number_of_sales_current`	Unknown
`number_of_sales_previous`	Unknown
`percent_change_in_ad_impressions`	Unknown
`percent_change_in_average_sale_amount`	Unknown
`percent_change_in_click_through_rate`	Unknown
`percent_change_in_click_throughs`	Unknown
`percent_change_in_commissions`	Unknown
`percent_change_in_conversion_rate`	Unknown
`percent_change_in_cpc_fees`	Unknown
`percent_change_in_incentives`	Unknown
`percent_change_in_mobile_sales`	Unknown
`percent_change_in_network_commissions`	Unknown
`percent_change_in_network_cpc_fees`	Unknown
`percent_change_in_new_customer_sales`	Unknown
`percent_change_in_new_customers`	Unknown
`percent_change_in_number_of_adjustments`	Unknown
`percent_change_in_number_of_mobile_sales`	Unknown
`percent_change_in_number_of_sales`	Unknown
`percent_change_in_sales`	Unknown
`percent_change_in_total_commissions_fees`	Unknown
`sales_current`	Unknown
`sales_previous`	Unknown
`total_commissions_fees_current`	Unknown
`total_commissions_fees_previous`	Unknown

ad_impression

Column	Type	Keys
`_fivetran_id`	String	PK
`affiliate_id`	Unknown
`affiliate_tags`	Json
`affiliate_website`	Unknown
`merchant`	Unknown
`total_ad_impressions`	Unknown

performance_summary_by_week

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_impressions`	Unknown
`average_sale_amount`	Unknown
`click_through_rate`	Unknown
`click_throughs`	Unknown
`commissions`	Unknown
`conversion_rate`	Unknown
`cpc_fees`	Unknown
`incentives`	Unknown
`mobile_sales`	Unknown
`network_commissions`	Unknown
`network_cpc_fees`	Unknown
`network_placement_fees`	Unknown
`new_customer_`	Unknown
`new_customer_sales`	Unknown
`new_customers`	Unknown
`number_of_adjustments`	Unknown
`number_of_mobile_sales`	Unknown
`number_of_sales`	Unknown
`placement_fees`	Unknown
`sales`	Unknown
`total_commissions_fees`	Unknown
`week`	Unknown

performance_summary_by_day

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_impressions`	Unknown
`average_sale_amount`	Unknown
`click_through_rate`	Unknown
`click_throughs`	Unknown
`commissions`	Unknown
`conversion_rate`	Unknown
`cpc_fees`	Unknown
`date`	Unknown
`incentives`	Unknown
`merchant`	Unknown
`mobile_sales`	Unknown
`network_commissions`	Unknown
`network_cpc_fees`	Unknown
`new_customer_`	Unknown
`new_customer_sales`	Unknown
`new_customers`	Unknown
`number_of_adjustments`	Unknown
`number_of_mobile_sales`	Unknown
`number_of_sales`	Unknown
`sales`	Unknown
`total_commissions_fees`	Unknown
`weekday`	Unknown

calendar_period_trending_by_affiliate

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_impressions_current`	Unknown
`ad_impressions_previous`	Unknown
`affiliate`	Unknown
`affiliate_id`	Unknown
`affiliate_name`	Unknown
`affiliate_tags`	Json
`average_sale_amount_current`	Unknown
`average_sale_amount_previous`	Unknown
`click_through_rate_current`	Unknown
`click_through_rate_previous`	Unknown
`click_throughs_current`	Unknown
`click_throughs_previous`	Unknown
`commissions_current`	Unknown
`commissions_previous`	Unknown
`conversion_rate_current`	Unknown
`conversion_rate_previous`	Unknown
`cpc_fees_current`	Unknown
`cpc_fees_previous`	Unknown
`date_range_current`	Unknown
`date_range_previous`	Unknown
`incentives_current`	Unknown
`incentives_previous`	Unknown
`merchant`	Unknown
`mobile_sales_current`	Unknown
`mobile_sales_previous`	Unknown
`network_commissions_current`	Unknown
`network_commissions_previous`	Unknown
`network_cpc_fees_current`	Unknown
`network_cpc_fees_previous`	Unknown
`new_customer_`	Unknown
`new_customer_sales_current`	Unknown
`new_customer_sales_previous`	Unknown
`new_customers_current`	Unknown
`new_customers_previous`	Unknown
`number_of_adjustments_current`	Unknown
`number_of_adjustments_previous`	Unknown
`number_of_mobile_sales_current`	Unknown
`number_of_mobile_sales_previous`	Unknown
`number_of_sales_current`	Unknown
`number_of_sales_previous`	Unknown
`percent_change_in_ad_impressions`	Unknown
`percent_change_in_average_sale_amount`	Unknown
`percent_change_in_click_through_rate`	Unknown
`percent_change_in_click_throughs`	Unknown
`percent_change_in_commissions`	Unknown
`percent_change_in_conversion_rate`	Unknown
`percent_change_in_cpc_fees`	Unknown
`percent_change_in_incentives`	Unknown
`percent_change_in_mobile_sales`	Unknown
`percent_change_in_network_commissions`	Unknown
`percent_change_in_network_cpc_fees`	Unknown
`percent_change_in_new_customer_sales`	Unknown
`percent_change_in_new_customers`	Unknown
`percent_change_in_number_of_adjustments`	Unknown
`percent_change_in_number_of_mobile_sales`	Unknown
`percent_change_in_number_of_sales`	Unknown
`percent_change_in_sales`	Unknown
`percent_change_in_total_commissions_fees`	Unknown
`sales_current`	Unknown
`sales_previous`	Unknown
`total_commissions_fees_current`	Unknown
`total_commissions_fees_previous`	Unknown

performance_summary

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_impressions`	Unknown
`average_sale_amount`	Unknown
`click_through_rate`	Unknown
`click_throughs`	Unknown
`commissions`	Unknown
`conversion_rate`	Unknown
`cpc_fees`	Unknown
`incentives`	Unknown
`merchant`	Unknown
`mobile_sales`	Unknown
`network_commissions`	Unknown
`network_cpc_fees`	Unknown
`network_placement_fees`	Unknown
`new_customer_`	Unknown
`new_customer_sales`	Unknown
`new_customers`	Unknown
`number_of_adjustments`	Unknown
`number_of_mobile_sales`	Unknown
`number_of_sales`	Unknown
`placement_fees`	Unknown
`sales`	Unknown
`total_commissions_fees`	Unknown

performance_summary_by_ad_tool

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_impressions`	Unknown
`average_sale_amount`	Unknown
`click_through_rate`	Unknown
`click_throughs`	Unknown
`commissions`	Unknown
`conversion_rate`	Unknown
`cpc_fees`	Unknown
`incentives`	Unknown
`merchant`	Unknown
`mobile_sales`	Unknown
`network_commissions`	Unknown
`network_cpc_fees`	Unknown
`new_customer_`	Unknown
`new_customer_sales`	Unknown
`new_customers`	Unknown
`number_of_adjustments`	Unknown
`number_of_mobile_sales`	Unknown
`number_of_sales`	Unknown
`sales`	Unknown
`tool_type`	Unknown
`total_commissions_fees`	Unknown

performance_summary_by_affiliate

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_impressions`	Unknown
`affiliate`	Unknown
`affiliate_name`	Unknown
`affiliate_tags`	Json
`afiliate_id`	Unknown
`average_sale_amount`	Unknown
`click_through_rate`	Unknown
`click_throughs`	Unknown
`commissions`	Unknown
`conversion_rate`	Unknown
`cpc_fees`	Unknown
`incentives`	Unknown
`merchant`	Unknown
`mobile_sales`	Unknown
`network_commissions`	Unknown
`network_cpc_fees`	Unknown
`network_placement_fees`	Unknown
`new_customer_`	Unknown
`new_customer_sales`	Unknown
`new_customers`	Unknown
`number_of_adjustments`	Unknown
`number_of_mobile_sales`	Unknown
`number_of_sales`	Unknown
`placement_fees`	Unknown
`sales`	Unknown
`total_commissions_fees`	Unknown

performance_summary_by_hour

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_impressions`	Unknown
`average_sale_amount`	Unknown
`click_through_rate`	Unknown
`click_throughs`	Unknown
`commissions`	Unknown
`conversion_rate`	Unknown
`cpc_fees`	Unknown
`incentives`	Unknown
`mobile_sales`	Unknown
`network_commissions`	Unknown
`network_cpc_fees`	Unknown
`new_customer_`	Unknown
`new_customer_sales`	Unknown
`new_customers`	Unknown
`number_of_adjustments`	Unknown
`number_of_mobile_sales`	Unknown
`number_of_sales`	Unknown
`sales`	Unknown
`time_of_day`	Unknown
`total_commissions_fees`	Unknown

rolling_period_trending_by_affiliate

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_impressions_current`	Unknown
`ad_impressions_previous`	Unknown
`affiliate`	Unknown
`affiliate_id`	Unknown
`affiliate_name`	Unknown
`affiliate_tags`	Json
`average_sale_amount_current`	Unknown
`average_sale_amount_previous`	Unknown
`click_through_rate_current`	Unknown
`click_through_rate_previous`	Unknown
`click_throughs_current`	Unknown
`click_throughs_previous`	Unknown
`commissions_current`	Unknown
`commissions_previous`	Unknown
`conversion_rate_current`	Unknown
`conversion_rate_previous`	Unknown
`cpc_fees_current`	Unknown
`cpc_fees_previous`	Unknown
`date_range_current`	Unknown
`date_range_previous`	Unknown
`incentives_current`	Unknown
`incentives_previous`	Unknown
`merchant`	Unknown
`mobile_sales_current`	Unknown
`mobile_sales_previous`	Unknown
`network_commissions_current`	Unknown
`network_commissions_previous`	Unknown
`network_cpc_fees_current`	Unknown
`network_cpc_fees_previous`	Unknown
`new_customer_`	Unknown
`new_customer_sales_current`	Unknown
`new_customer_sales_previous`	Unknown
`new_customers_current`	Unknown
`new_customers_previous`	Unknown
`number_of_adjustments_current`	Unknown
`number_of_adjustments_previous`	Unknown
`number_of_mobile_sales_current`	Unknown
`number_of_mobile_sales_previous`	Unknown
`number_of_sales_current`	Unknown
`number_of_sales_previous`	Unknown
`percent_change_in_ad_impressions`	Unknown
`percent_change_in_average_sale_amount`	Unknown
`percent_change_in_click_through_rate`	Unknown
`percent_change_in_click_throughs`	Unknown
`percent_change_in_commissions`	Unknown
`percent_change_in_conversion_rate`	Unknown
`percent_change_in_cpc_fees`	Unknown
`percent_change_in_incentives`	Unknown
`percent_change_in_mobile_sales`	Unknown
`percent_change_in_network_commissions`	Unknown
`percent_change_in_network_cpc_fees`	Unknown
`percent_change_in_new_customer_sales`	Unknown
`percent_change_in_new_customers`	Unknown
`percent_change_in_number_of_adjustments`	Unknown
`percent_change_in_number_of_mobile_sales`	Unknown
`percent_change_in_number_of_sales`	Unknown
`percent_change_in_sales`	Unknown
`percent_change_in_total_commissions_fees`	Unknown
`sales_current`	Unknown
`sales_previous`	Unknown
`total_commissions_fees_current`	Unknown
`total_commissions_fees_previous`	Unknown

sale_hit_tracking_trails

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_campaign_subscription`	Unknown
`affiliate_id`	Unknown
`affiliate_website`	Unknown
`custom_tracking_code`	Unknown
`date`	Unknown
`hit_type`	Unknown
`merchant`	Unknown
`product`	Unknown
`referrer_url`	Unknown
`tool_name`	Unknown
`transaction_amount`	Unknown
`transaction_id`	Unknown

sales

Column	Type	Keys
`_fivetran_id`	String	PK
`affiliate_business_classifications`	Unknown
`affiliate_id`	Unknown
`avant_link_transaction_id`	Unknown
`base_commission`	Unknown
`campaign_product_link`	Unknown
`commission_status`	Unknown
`coupon_code`	Unknown
`custom_tracking_code`	Unknown
`incentive_commission`	Unknown
`item_count`	Unknown
`last_click_through`	Unknown
`merchant`	Unknown
`merchant_id`	Unknown
`mobile_order`	Unknown
`network_commission`	Unknown
`new_customer`	Unknown
`order_id`	Unknown
`payment_id`	Unknown
`sub_affiliate_domain`	Unknown
`tool_name`	Unknown
`total_commission`	Unknown
`transaction_amount`	Unknown
`transaction_date`	Unknown
`transaction_type`	Unknown
`website`	Unknown
`website_id`	Unknown

data_feed_download_summary

Column	Type	Keys
`_fivetran_id`	String	PK
`affiliate_id`	Unknown
`affiliate_tags`	Unknown
`affiliate_website`	Unknown
`downloads`	Unknown
`first_download`	Unknown
`last_download`	Unknown
`merchant`	Unknown

performance_summary_by_ad_campaign

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_campaign_subscription`	Unknown
`ad_id`	Unknown
`ad_impressions`	Unknown
`ad_type`	Unknown
`average_sale_amount`	Unknown
`click_through_rate`	Unknown
`click_throughs`	Unknown
`commissions`	Unknown
`conversion_rate`	Unknown
`cpc_fees`	Unknown
`incentives`	Unknown
`merchant`	Unknown
`mobile_sales`	Unknown
`network_commissions`	Unknown
`network_cpc_fees`	Unknown
`new_customer_`	Unknown
`new_customer_sales`	Unknown
`new_customers`	Unknown
`number_of_adjustments`	Unknown
`number_of_mobile_sales`	Unknown
`number_of_sales`	Unknown
`sales`	Unknown
`total_commissions_fees`	Unknown

first_click_through_sale_summary

Column	Type	Keys
`_fivetran_id`	String	PK
`_0_24_hours`	Unknown
`_121_days`	Unknown
`_1_7_days`	Unknown
`_31_60_days`	Unknown
`_61_90_days`	Unknown
`_8_30_days`	Unknown
`_91_120_days`	Unknown
`cookie_duration`	Unknown
`merchant`	Unknown
`total_sales`	Unknown
`unknown`	Unknown

rolling_period_trending

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_impressions_current`	Unknown
`ad_impressions_previous`	Unknown
`average_sale_amount_current`	Unknown
`average_sale_amount_previous`	Unknown
`click_through_rate_current`	Unknown
`click_through_rate_previous`	Unknown
`click_throughs_current`	Unknown
`click_throughs_previous`	Unknown
`commissions_current`	Unknown
`commissions_previous`	Unknown
`conversion_rate_current`	Unknown
`conversion_rate_previous`	Unknown
`cpc_fees_current`	Unknown
`cpc_fees_previous`	Unknown
`date_range_current`	Unknown
`date_range_previous`	Unknown
`incentives_current`	Unknown
`incentives_previous`	Unknown
`mobile_sales_current`	Unknown
`mobile_sales_previous`	Unknown
`network_commissions_current`	Unknown
`network_commissions_previous`	Unknown
`network_cpc_fees_current`	Unknown
`network_cpc_fees_previous`	Unknown
`new_customer_`	Unknown
`new_customer_sales_current`	Unknown
`new_customer_sales_previous`	Unknown
`new_customers_current`	Unknown
`new_customers_previous`	Unknown
`number_of_adjustments_current`	Unknown
`number_of_adjustments_previous`	Unknown
`number_of_mobile_sales_current`	Unknown
`number_of_mobile_sales_previous`	Unknown
`number_of_sales_current`	Unknown
`number_of_sales_previous`	Unknown
`percent_change_in_ad_impressions`	Unknown
`percent_change_in_average_sale_amount`	Unknown
`percent_change_in_click_through_rate`	Unknown
`percent_change_in_click_throughs`	Unknown
`percent_change_in_commissions`	Unknown
`percent_change_in_conversion_rate`	Unknown
`percent_change_in_cpc_fees`	Unknown
`percent_change_in_incentives`	Unknown
`percent_change_in_mobile_sales`	Unknown
`percent_change_in_network_commissions`	Unknown
`percent_change_in_network_cpc_fees`	Unknown
`percent_change_in_new_customer_sales`	Unknown
`percent_change_in_new_customers`	Unknown
`percent_change_in_number_of_adjustments`	Unknown
`percent_change_in_number_of_mobile_sales`	Unknown
`percent_change_in_number_of_sales`	Unknown
`percent_change_in_sales`	Unknown
`percent_change_in_total_commissions_fees`	Unknown
`sales_current`	Unknown
`sales_previous`	Unknown
`total_commissions_fees_current`	Unknown
`total_commissions_fees_previous`	Unknown

click_through

Column	Type	Keys
`_fivetran_id`	String	PK
`affiliate_id`	Unknown
`affiliate_tags`	Json
`affiliate_website`	Unknown
`merchant`	Unknown
`tool_name`	Unknown
`total_click_throughs`	Unknown

referral_domain_by_affiliate

Column	Type	Keys
`_fivetran_id`	String	PK
`affiliate_id`	Unknown
`affiliate_tags`	Unknown
`affiliate_website`	Unknown
`clicks`	Unknown
`merchant`	Unknown
`referral_domain`	Unknown

performance_summary_by_affiliate_website

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_impressions`	Unknown
`affiliate_category`	Unknown
`affiliate_id`	Unknown
`affiliate_tags`	Json
`affiliate_website`	Unknown
`affiliate_website_name`	Unknown
`average_sale_amount`	Unknown
`click_through_rate`	Unknown
`click_throughs`	Unknown
`commissions`	Unknown
`conversion_rate`	Unknown
`cpc_fees`	Unknown
`incentives`	Unknown
`mobile_sales`	Unknown
`network_commissions`	Unknown
`network_cpc_fees`	Unknown
`network_placement_fees`	Unknown
`new_customer_`	Unknown
`new_customer_sales`	Unknown
`new_customers`	Unknown
`number_of_adjustments`	Unknown
`number_of_mobile_sales`	Unknown
`number_of_sales`	Unknown
`placement_fees`	Unknown
`sales`	Unknown
`total_commissions_fees`	Unknown
`website_category`	Unknown
`website_id`	Unknown

rolling_period_trending_by_affiliate_website

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_impressions_current`	Unknown
`ad_impressions_previous`	Unknown
`affiliate`	Unknown
`affiliate_id`	Unknown
`affiliate_name`	Unknown
`affiliate_tags`	Json
`average_sale_amount_current`	Unknown
`average_sale_amount_previous`	Unknown
`click_through_rate_current`	Unknown
`click_through_rate_previous`	Unknown
`click_throughs_current`	Unknown
`click_throughs_previous`	Unknown
`commissions_current`	Unknown
`commissions_previous`	Unknown
`conversion_rate_current`	Unknown
`conversion_rate_previous`	Unknown
`cpc_fees_current`	Unknown
`cpc_fees_previous`	Unknown
`date_range_current`	Unknown
`date_range_previous`	Unknown
`incentives_current`	Unknown
`incentives_previous`	Unknown
`merchant`	Unknown
`mobile_sales_current`	Unknown
`mobile_sales_previous`	Unknown
`network_commissions_current`	Unknown
`network_commissions_previous`	Unknown
`network_cpc_fees_current`	Unknown
`network_cpc_fees_previous`	Unknown
`new_customer_`	Unknown
`new_customer_sales_current`	Unknown
`new_customer_sales_previous`	Unknown
`new_customers_current`	Unknown
`new_customers_previous`	Unknown
`number_of_adjustments_current`	Unknown
`number_of_adjustments_previous`	Unknown
`number_of_mobile_sales_current`	Unknown
`number_of_mobile_sales_previous`	Unknown
`number_of_sales_current`	Unknown
`number_of_sales_previous`	Unknown
`percent_change_in_ad_impressions`	Unknown
`percent_change_in_average_sale_amount`	Unknown
`percent_change_in_click_through_rate`	Unknown
`percent_change_in_click_throughs`	Unknown
`percent_change_in_commissions`	Unknown
`percent_change_in_conversion_rate`	Unknown
`percent_change_in_cpc_fees`	Unknown
`percent_change_in_incentives`	Unknown
`percent_change_in_mobile_sales`	Unknown
`percent_change_in_network_commissions`	Unknown
`percent_change_in_network_cpc_fees`	Unknown
`percent_change_in_new_customer_sales`	Unknown
`percent_change_in_new_customers`	Unknown
`percent_change_in_number_of_adjustments`	Unknown
`percent_change_in_number_of_mobile_sales`	Unknown
`percent_change_in_number_of_sales`	Unknown
`percent_change_in_sales`	Unknown
`percent_change_in_total_commissions_fees`	Unknown
`sales_current`	Unknown
`sales_previous`	Unknown
`total_commissions_fees_current`	Unknown
`total_commissions_fees_previous`	Unknown

performance_summary_by_month

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_impressions`	Unknown
`average_sale_amount`	Unknown
`click_through_rate`	Unknown
`click_throughs`	Unknown
`commissions`	Unknown
`conversion_rate`	Unknown
`cpc_fees`	Unknown
`incentives`	Unknown
`mobile_sales`	Unknown
`month`	Unknown
`network_commissions`	Unknown
`network_cpc_fees`	Unknown
`network_placement_fees`	Unknown
`new_customer_`	Unknown
`new_customer_sales`	Unknown
`new_customers`	Unknown
`number_of_adjustments`	Unknown
`number_of_mobile_sales`	Unknown
`number_of_sales`	Unknown
`placement_fees`	Unknown
`sales`	Unknown
`total_commissions_fees`	Unknown

last_click_through_sale_summary

Column	Type	Keys
`_fivetran_id`	String	PK
`_0_24_hours`	Unknown
`_121_days`	Unknown
`_1_7_days`	Unknown
`_31_60_days`	Unknown
`_61_90_days`	Unknown
`_8_30_days`	Unknown
`_91_120_days`	Unknown
`cookie_duration`	Unknown
`merchant`	Unknown
`total_sales`	Unknown
`unknown`	Unknown

performance_summary_by_affiliate_tag_group

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_impressions`	Unknown
`affiliate_grouping`	Unknown
`average_sale_amount`	Unknown
`click_through_rate`	Unknown
`click_throughs`	Unknown
`commissions`	Unknown
`conversion_rate`	Unknown
`cpc_fees`	Unknown
`incentives`	Unknown
`mobile_sales`	Unknown
`network_commissions`	Unknown
`network_cpc_fees`	Unknown
`network_placement_fees`	Unknown
`new_customer_`	Unknown
`new_customer_sales`	Unknown
`new_customers`	Unknown
`number_of_adjustments`	Unknown
`number_of_mobile_sales`	Unknown
`number_of_sales`	Unknown
`placement_fees`	Unknown
`sales`	Unknown
`total_commissions_fees`	Unknown

calendar_period_trending_by_affiliate_website

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_impressions_current`	Unknown
`ad_impressions_previous`	Unknown
`affiliate_category`	Unknown
`affiliate_id`	Unknown
`affiliate_tags`	Json
`affiliate_website`	Unknown
`affiliate_website_name`	Unknown
`average_sale_amount_current`	Unknown
`average_sale_amount_previous`	Unknown
`click_through_rate_current`	Unknown
`click_through_rate_previous`	Unknown
`click_throughs_current`	Unknown
`click_throughs_previous`	Unknown
`commissions_current`	Unknown
`commissions_previous`	Unknown
`conversion_rate_current`	Unknown
`conversion_rate_previous`	Unknown
`cpc_fees_current`	Unknown
`cpc_fees_previous`	Unknown
`date_range_current`	Unknown
`date_range_previous`	Unknown
`incentives_current`	Unknown
`incentives_previous`	Unknown
`mobile_sales_current`	Unknown
`mobile_sales_previous`	Unknown
`network_commissions_current`	Unknown
`network_commissions_previous`	Unknown
`network_cpc_fees_current`	Unknown
`network_cpc_fees_previous`	Unknown
`new_customer_`	Unknown
`new_customer_sales_current`	Unknown
`new_customer_sales_previous`	Unknown
`new_customers_current`	Unknown
`new_customers_previous`	Unknown
`number_of_adjustments_current`	Unknown
`number_of_adjustments_previous`	Unknown
`number_of_mobile_sales_current`	Unknown
`number_of_mobile_sales_previous`	Unknown
`number_of_sales_current`	Unknown
`number_of_sales_previous`	Unknown
`percent_change_in_ad_impressions`	Unknown
`percent_change_in_average_sale_amount`	Unknown
`percent_change_in_click_through_rate`	Unknown
`percent_change_in_click_throughs`	Unknown
`percent_change_in_commissions`	Unknown
`percent_change_in_conversion_rate`	Unknown
`percent_change_in_cpc_fees`	Unknown
`percent_change_in_incentives`	Unknown
`percent_change_in_mobile_sales`	Unknown
`percent_change_in_network_commissions`	Unknown
`percent_change_in_network_cpc_fees`	Unknown
`percent_change_in_new_customer_sales`	Unknown
`percent_change_in_new_customers`	Unknown
`percent_change_in_number_of_adjustments`	Unknown
`percent_change_in_number_of_mobile_sales`	Unknown
`percent_change_in_number_of_sales`	Unknown
`percent_change_in_sales`	Unknown
`percent_change_in_total_commissions_fees`	Unknown
`sales_current`	Unknown
`sales_previous`	Unknown
`total_commissions_fees_current`	Unknown
`total_commissions_fees_previous`	Unknown
`website_category`	Unknown
`website_id`	Unknown

performance_summary_by_sub_affliliate_partner

Column	Type	Keys
`_fivetran_id`	String	PK
`affiliate`	Unknown
`affiliate_id`	Unknown
`affiliate_name`	Unknown
`affiliate_tags`	Json
`average_sale_amount`	Unknown
`click_through_rate`	Unknown
`click_throughs`	Unknown
`commissions`	Unknown
`conversion_rate`	Unknown
`cpc_fees`	Unknown
`incentives`	Unknown
`merchant`	Unknown
`mobile_sales`	Unknown
`network_commissions`	Unknown
`network_cpc_fees`	Unknown
`new_customer_`	Unknown
`new_customer_sales`	Unknown
`new_customers`	Unknown
`number_of_adjustments`	Unknown
`number_of_mobile_sales`	Unknown
`number_of_sales`	Unknown
`sales`	Unknown
`sub_affiliate_domain`	Unknown
`total_commissions_fees`	Unknown

performance_summary_by_custom_tracking_code

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_impressions`	Unknown
`average_sale_amount`	Unknown
`click_through_rate`	Unknown
`click_throughs`	Unknown
`commissions`	Unknown
`conversion_rate`	Unknown
`cpc_fees`	Unknown
`custom_tracking_code`	Unknown
`custom_tracking_code_id`	Unknown
`incentives`	Unknown
`mobile_sales`	Unknown
`network_commissions`	Unknown
`network_cpc_fees`	Unknown
`new_customer_`	Unknown
`new_customer_sales`	Unknown
`new_customers`	Unknown
`number_of_adjustments`	Unknown
`number_of_mobile_sales`	Unknown
`number_of_sales`	Unknown
`sales`	Unknown
`total_commissions_fees`	Unknown