Skimlinks
Explore the interactive ERD
Table & Field Reference
merchant_country
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
merchant_id | Unknown | PKFK |
name | Unknown |
merchant_domain
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
merchant_id | Unknown | PKFK |
domain | Unknown |
merchant_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
merchant_id | Unknown | PKFK |
id | Unknown |
merchant_network_payout_type
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
merchant_id | Unknown | PKFK |
type | Unknown |
merchant_program_payout_type
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
merchant_id | Unknown | PKFK |
type | Unknown |
merchant_vertical
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
merchant_id | Unknown | PKFK |
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 | PKFK |
merchant_country | Unknown |
trending_product_merchant_vertical
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
trending_product_report_fivetran_id | Unknown | PKFK |
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 |