# Skimlinks schema ERD

Table and field reference for the Fivetran Skimlinks connector.

## Table & Field Reference

### merchant_country

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| merchant_id | Unknown | PK, FK |
| name | Unknown |  |

### merchant_domain

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| merchant_id | Unknown | PK, FK |
| domain | Unknown |  |

### merchant_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| merchant_id | Unknown | PK, FK |
| id | Unknown |  |

### merchant_network_payout_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| merchant_id | Unknown | PK, FK |
| type | Unknown |  |

### merchant_program_payout_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| merchant_id | Unknown | PK, FK |
| type | Unknown |  |

### merchant_vertical

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| merchant_id | Unknown | PK, FK |
| id | Unknown |  |
| name | Unknown |  |

### merchant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_id | Unknown |  |
| best_rate_performance_based_aggregation_type | Unknown |  |
| best_rate_performance_based_base_rate | Unknown |  |
| best_rate_performance_based_currency | Unknown |  |
| best_rate_performance_based_description | Unknown |  |
| best_rate_performance_based_end_date | Unknown |  |
| best_rate_performance_based_increased_rate | Unknown |  |
| best_rate_performance_based_payout_type | Unknown |  |
| best_rate_performance_based_rate_type | Unknown |  |
| best_rate_performance_based_start_date | Unknown |  |
| best_rate_traffic_based | Json |  |
| calculated_average_daily_sales | Unknown |  |
| calculated_average_order_value | Unknown |  |
| calculated_commission_rate | Unknown |  |
| calculated_conversion_rate | Unknown |  |
| calculated_ecpc | Unknown |  |
| domain | Unknown |  |
| estimated_reversal_rate | Unknown |  |
| exclusive | Unknown |  |
| favourite | Unknown |  |
| maximum_rate_aggregation_type | Unknown |  |
| maximum_rate_base | Unknown |  |
| maximum_rate_currency | Unknown |  |
| maximum_rate_description | Unknown |  |
| maximum_rate_end_date | Unknown |  |
| maximum_rate_increased | Unknown |  |
| maximum_rate_payout_type | Unknown |  |
| maximum_rate_start_date | Unknown |  |
| maximum_rate_type | Unknown |  |
| minimum_end_date | Unknown |  |
| minimum_rate_aggregation_type | Unknown |  |
| minimum_rate_base | Unknown |  |
| minimum_rate_currency | Unknown |  |
| minimum_rate_description | Unknown |  |
| minimum_rate_increased | Unknown |  |
| minimum_rate_payout_type | Unknown |  |
| minimum_rate_type | Unknown |  |
| minimum_start_date | Unknown |  |
| name | Unknown |  |
| partner_type | Unknown |  |
| custom_** |  |  |

### aggregated_report_by_link

| Column | Type | Keys |
| --- | --- | --- |
| end_date | Unknown | PK |
| start_date | Unknown | PK |
| target_url | Unknown | PK |
| clicks_affiliated | Unknown |  |
| conversion_rate | Unknown |  |
| ctr_affiliated | Unknown |  |
| epc | Unknown |  |
| impressions | Unknown |  |
| order_amount | Unknown |  |
| publisher_commission_amount | Unknown |  |
| rpm | Unknown |  |
| sales | Unknown |  |

### trending_product_merchant_country

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| trending_product_report_fivetran_id | Unknown | PK, FK |
| merchant_country | Unknown |  |

### trending_product_merchant_vertical

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| trending_product_report_fivetran_id | Unknown | PK, FK |
| merchant_vertical | Unknown |  |

### trending_product_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_id | Unknown |  |
| advertiser_name | Unknown |  |
| conversion_rate | Unknown |  |
| currency | Unknown |  |
| epc | Unknown |  |
| is_available | Unknown |  |
| order_rank | Unknown |  |
| popular_rank | Unknown |  |
| previous_popular_rank | Unknown |  |
| product_brand | Unknown |  |
| product_image_url | Unknown |  |
| product_name | Unknown |  |
| product_url | Unknown |  |
| publisher_currency | Unknown |  |
| publisher_id | Unknown |  |
| rank_rate_change | Unknown |  |
| rank_rate_change_trend | Unknown |  |
| trending_rank | Unknown |  |

### product_bought_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_id | Unknown |  |
| advertiser_name | Unknown |  |
| currency | Unknown |  |
| end_date | Unknown |  |
| order_amount | Unknown |  |
| product_name | Unknown |  |
| publisher_commission_amount | Unknown |  |
| quantity | Unknown |  |
| sku | Unknown |  |
| start_date | Unknown |  |

### aggregated_report_by_date

| Column | Type | Keys |
| --- | --- | --- |
| isodate | Unknown | PK |
| clicks_affiliated | Unknown |  |
| conversion_rate | Unknown |  |
| ctr_affiliated | Unknown |  |
| epc | Unknown |  |
| impressions | Unknown |  |
| order_amount | Unknown |  |
| publisher_commission_amount | Unknown |  |
| rpm | Unknown |  |
| sales | Unknown |  |

### aggregated_report_by_device

| Column | Type | Keys |
| --- | --- | --- |
| device_type | Unknown | PK |
| end_date | Unknown | PK |
| start_date | Unknown | PK |
| clicks_affiliated | Unknown |  |
| conversion_rate | Unknown |  |
| ctr_affiliated | Unknown |  |
| epc | Unknown |  |
| impressions | Unknown |  |
| order_amount | Unknown |  |
| publisher_commission_amount | Unknown |  |
| rpm | Unknown |  |
| sales | Unknown |  |

### aggregated_report_by_country

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| clicks_affiliated | Unknown |  |
| conversion_rate | Unknown |  |
| ctr_affiliated | Unknown |  |
| end_date | Unknown |  |
| epc | Unknown |  |
| impressions | Unknown |  |
| order_amount | Unknown |  |
| publisher_commission_amount | Unknown |  |
| rpm | Unknown |  |
| sales | Unknown |  |
| start_date | Unknown |  |
| user_ip_country | Unknown |  |

### aggregated_report_by_page

| Column | Type | Keys |
| --- | --- | --- |
| end_date | Unknown | PK |
| page_url | Unknown | PK |
| start_date | Unknown | PK |
| clicks_affiliated | Unknown |  |
| conversion_rate | Unknown |  |
| ctr_affiliated | Unknown |  |
| epc | Unknown |  |
| impressions | Unknown |  |
| order_amount | Unknown |  |
| publisher_commission_amount | Unknown |  |
| rpm | Unknown |  |
| sales | Unknown |  |

### aggregated_report_by_domain

| Column | Type | Keys |
| --- | --- | --- |
| domain_id | Unknown | PK |
| end_date | Unknown | PK |
| start_date | Unknown | PK |
| clicks_affiliated | Unknown |  |
| conversion_rate | Unknown |  |
| ctr_affiliated | Unknown |  |
| domain | Unknown |  |
| epc | Unknown |  |
| impressions | Unknown |  |
| order_amount | Unknown |  |
| publisher_commission_amount | Unknown |  |
| rpm | Unknown |  |
| sales | Unknown |  |

### aggregated_report_by_merchant

| Column | Type | Keys |
| --- | --- | --- |
| advertiser_id | Unknown | PK |
| end_date | Unknown | PK |
| start_date | Unknown | PK |
| advertiser_name | Unknown |  |
| clicks_affiliated | Unknown |  |
| commission_rate_base_rate_revenue | Unknown |  |
| commission_rate_currency | Unknown |  |
| commission_rate_is_exclusive_rate | Unknown |  |
| commission_rate_max_base_rate | Unknown |  |
| commission_rate_max_increased_rate | Unknown |  |
| commission_rate_max_uplift_rate | Unknown |  |
| commission_rate_min_base_rate | Unknown |  |
| commission_rate_min_increased_rate | Unknown |  |
| commission_rate_min_uplift_rate | Unknown |  |
| commission_rate_rate_type | Unknown |  |
| commission_rate_uplift_rate_revenue | Unknown |  |
| conversion_rate | Unknown |  |
| ctr_affiliated | Unknown |  |
| epc | Unknown |  |
| impressions | Unknown |  |
| is_dynamic_active | Unknown |  |
| network_payout_type | Json |  |
| order_amount | Unknown |  |
| partner_program_type | Unknown |  |
| publisher_commission_amount | Unknown |  |
| rpm | Unknown |  |
| sales | Unknown |  |

## Relationships

- merchant_country(merchant_id) → merchant(id)
- merchant_domain(merchant_id) → merchant(id)
- merchant_id(merchant_id) → merchant(id)
- merchant_network_payout_type(merchant_id) → merchant(id)
- merchant_program_payout_type(merchant_id) → merchant(id)
- merchant_vertical(merchant_id) → merchant(id)
- trending_product_merchant_country(trending_product_report_fivetran_id) → trending_product_report(_fivetran_id)
- trending_product_merchant_vertical(trending_product_report_fivetran_id) → trending_product_report(_fivetran_id)