# AvantLink schema ERD

Table and field reference for the Fivetran AvantLink connector.

## 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 |  |