Tradedoubler data warehouse table groups

  • Updated on Oct 6, 2025
  • Published on Aug 5, 2025
Prev Next

Table: PROGRAM

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
program__click_commission
Display name Click commission (Publisher)
Description The amount of click commission (Publisher)
Field type metric
Data type float.currency.value
program__click_commission_td
Display name Click commission (Tradedoubler)
Description The amount of click commission (Tradedoubler)
Field type metric
Data type float.currency.value
program__clicks
Display name Clicks
Description The number of clicks
Field type metric
Data type int.number.value
program__commission
Display name Publisher commission
Description The amount publisher commission
Field type metric
Data type float.currency.value
program__commission_td
Display name Tradedoubler commission
Description The amount of Tradedoubler commission
Field type metric
Data type float.currency.value
program__date
Display name Date
Field type dimension
Data type string.time.date
program__deposit
Display name Deposit
Description The amount deposited
Field type metric
Data type float.currency.value
program__ilead_commission
Display name iLead commission (Publisher)
Description The amount of iLead commission (Publisher)
Field type metric
Data type float.currency.value
program__ilead_commission_td
Display name iLead commission (Tradedoubler)
Description The amount of iLead commission (Tradedoubler)
Field type metric
Data type float.currency.value
program__impression_commission
Display name Impression commission (Publisher)
Description The amount of impression commission (Publisher)
Field type metric
Data type float.currency.value
program__impression_commission_td
Display name Impression commission (Tradedoubler)
Description The amount of impression commission (Tradedoubler)
Field type metric
Data type float.currency.value
program__impressions
Display name Impressions
Description The number of impressions
Field type metric
Data type int.number.value
program__isales
Display name iSales
Description The number of iSales
Field type metric
Data type float.currency.value
program__isales_commission
Display name iSales commission (Publisher)
Description The amount of iSales commission (Publisher)
Field type metric
Data type float.currency.value
program__isales_commission_td
Display name iSales commission (Tradedoubler)
Description The amount of iSales commission (Tradedoubler)
Field type metric
Data type float.currency.value
program__lead_commission
Display name Lead commission (Publisher)
Description The amount of unique lead commission (Publisher)
Field type metric
Data type float.currency.value
program__lead_commission_td
Display name Lead commission (Tradedoubler)
Description The amount of lead commission (Tradedoubler)
Field type metric
Data type float.currency.value
program__leads
Display name Leads
Description The number of leads
Field type metric
Data type int.number.value
program__order_value
Display name Order value
Description The value of the orders
Field type metric
Data type float.currency.value
program__program_country_code
Display name Program country code
Description The country code of the program
Field type dimension
Data type string.geo.country.twolettercode
program__program_id
Display name Program ID
Description The unique ID of the program
Field type dimension
Data type string.text.value
program__program_name
Display name Program name
Description The name of the program
Field type dimension
Data type string.text.value
program__sales
Display name Sales
Description The number of sales
Field type metric
Data type float.currency.value
program__sales_commission
Display name Sales commission (Publisher)
Description The amount of sales commission (Publisher)
Field type metric
Data type float.currency.value
program__sales_commission_td
Display name Sales commission (Tradedoubler)
Description The amount of sales commission (Tradedoubler)
Field type metric
Data type float.currency.value
program__uv_commission
Display name Unique visitors commission (Publisher)
Description The amount of unique visitors commission (Publisher)
Field type metric
Data type float.currency.value
program__uv_commission_td
Display name Unique visitors commission (Tradedoubler)
Description The amount of unique visitors commission (Tradedoubler)
Field type metric
Data type float.currency.value
program__withdraw
Display name Withdraw
Description The amount withdrawn
Field type metric
Data type float.currency.value

Table: AFFILIATE

affiliate_site__click_commission
Display name Click commission (Publisher)
Description The amount of click commission (Publisher)
Field type metric
Data type float.currency.value
affiliate_site__click_commission_td
Display name Click commission (Tradedoubler)
Description The amount of click commission (Tradedoubler)
Field type metric
Data type float.currency.value
affiliate_site__clicks
Display name Clicks
Description The number of clicks
Field type metric
Data type int.number.value
affiliate_site__commission
Display name Publisher commission
Description The amount publisher commission
Field type metric
Data type float.currency.value
affiliate_site__commission_td
Display name Tradedoubler commission
Description The amount of Tradedoubler commission
Field type metric
Data type float.currency.value
affiliate_site__currency
Display name Reporting currency
Description The selected reporting currency
Field type dimension
Data type string.currency.code
affiliate_site__date
Display name Date
Field type dimension
Data type string.time.date
affiliate_site__deposit
Display name Deposit
Description The amount deposited
Field type metric
Data type float.currency.value
affiliate_site__ilead_commission
Display name iLead commission (Publisher)
Description The amount of iLead commission (Publisher)
Field type metric
Data type float.currency.value
affiliate_site__ilead_commission_td
Display name iLead commission (Tradedoubler)
Description The amount of iLead commission (Tradedoubler)
Field type metric
Data type float.currency.value
affiliate_site__impression_commission
Display name Impression commission (Publisher)
Description The amount of impression commission (Publisher)
Field type metric
Data type float.currency.value
affiliate_site__impression_commission_td
Display name Impression commission (Tradedoubler)
Description The amount of impression commission (Tradedoubler)
Field type metric
Data type float.currency.value
affiliate_site__impressions
Display name Impressions
Description The number of impressions
Field type metric
Data type int.number.value
affiliate_site__isales
Display name iSales
Description The number of iSales
Field type metric
Data type float.currency.value
affiliate_site__isales_commission
Display name iSales commission (Publisher)
Description The amount of iSales commission (Publisher)
Field type metric
Data type float.currency.value
affiliate_site__isales_commission_td
Display name iSales commission (Tradedoubler)
Description The amount of iSales commission (Tradedoubler)
Field type metric
Data type float.currency.value
affiliate_site__lead_commission
Display name Lead commission (Publisher)
Description The amount of unique lead commission (Publisher)
Field type metric
Data type float.currency.value
affiliate_site__lead_commission_td
Display name Lead commission (Tradedoubler)
Description The amount of lead commission (Tradedoubler)
Field type metric
Data type float.currency.value
affiliate_site__leads
Display name Leads
Description The number of leads
Field type metric
Data type int.number.value
affiliate_site__order_value
Display name Order value
Description The value of the orders
Field type metric
Data type float.currency.value
affiliate_site__sales
Display name Sales
Description The number of sales
Field type metric
Data type float.currency.value
affiliate_site__sales_commission
Display name Sales commission (Publisher)
Description The amount of sales commission (Publisher)
Field type metric
Data type float.currency.value
affiliate_site__sales_commission_td
Display name Sales commission (Tradedoubler)
Description The amount of sales commission (Tradedoubler)
Field type metric
Data type float.currency.value
affiliate_site__site_country_code
Display name Site country code
Description The country code of the affiliate site
Field type dimension
Data type string.geo.country.twolettercode
affiliate_site__site_id
Display name Site ID
Description The unique ID of the affiliate site
Field type dimension
Data type string.text.value
affiliate_site__site_name
Display name Site name
Description The name of the affiliate site
Field type dimension
Data type string.text.value
affiliate_site__uv_commission
Display name Unique visitors commission (Publisher)
Description The amount of unique visitors commission (Publisher)
Field type metric
Data type float.currency.value
affiliate_site__uv_commission_td
Display name Unique visitors commission (Tradedoubler)
Description The amount of unique visitors commission (Tradedoubler)
Field type metric
Data type float.currency.value
affiliate_site__withdraw
Display name Withdraw
Description The amount withdrawn
Field type metric
Data type float.currency.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value

Table: AD

ad__ad_category_id
Display name Ad category ID
Description The unique ID of the ad category
Field type dimension
Data type string.text.value
ad__ad_category_name
Display name Ad category name
Description The name of the ad category
Field type dimension
Data type string.text.value
ad__ad_group
Display name Ad group name
Description The name of the ad group
Field type dimension
Data type string.text.value
ad__ad_group_id
Display name Ad group ID
Description The unique ID of the ad group
Field type dimension
Data type string.text.value
ad__ad_id
Display name Ad ID
Description The unique ID of the ad
Field type dimension
Data type string.text.value
ad__ad_name
Display name Ad name
Description The name of the ad
Field type dimension
Data type string.text.value
ad__ad_size
Display name Ad size
Description The size of the ad
Field type dimension
Data type string.text.value
ad__ad_type
Display name Ad type
Description The name of the ad type
Field type dimension
Data type string.text.value
ad__ad_type_id
Display name Ad type ID
Description The unique ID of the ad type
Field type dimension
Data type string.text.value
ad__click_commission
Display name Click commission (Publisher)
Description The amount of click commission (Publisher)
Field type metric
Data type float.currency.value
ad__click_commission_td
Display name Click commission (Tradedoubler)
Description The amount of click commission (Tradedoubler)
Field type metric
Data type float.currency.value
ad__clicks
Display name Clicks
Description The number of clicks
Field type metric
Data type int.number.value
ad__commission
Display name Publisher commission
Description The amount publisher commission
Field type metric
Data type float.currency.value
ad__commission_td
Display name Tradedoubler commission
Description The amount of Tradedoubler commission
Field type metric
Data type float.currency.value
ad__currency
Display name Reporting currency
Description The selected reporting currency
Field type dimension
Data type string.currency.code
ad__date
Display name Date
Field type dimension
Data type string.time.date
ad__deposit
Display name Deposit
Description The amount deposited
Field type metric
Data type float.currency.value
ad__ilead_commission
Display name iLead commission (Publisher)
Description The amount of iLead commission (Publisher)
Field type metric
Data type float.currency.value
ad__ilead_commission_td
Display name iLead commission (Tradedoubler)
Description The amount of iLead commission (Tradedoubler)
Field type metric
Data type float.currency.value
ad__impression_commission
Display name Impression commission (Publisher)
Description The amount of impression commission (Publisher)
Field type metric
Data type float.currency.value
ad__impression_commission_td
Display name Impression commission (Tradedoubler)
Description The amount of impression commission (Tradedoubler)
Field type metric
Data type float.currency.value
ad__impressions
Display name Impressions
Description The number of impressions
Field type metric
Data type int.number.value
ad__isales
Display name iSales
Description The number of iSales
Field type metric
Data type float.currency.value
ad__isales_commission
Display name iSales commission (Publisher)
Description The amount of iSales commission (Publisher)
Field type metric
Data type float.currency.value
ad__isales_commission_td
Display name iSales commission (Tradedoubler)
Description The amount of iSales commission (Tradedoubler)
Field type metric
Data type float.currency.value
ad__lead_commission
Display name Lead commission (Publisher)
Description The amount of unique lead commission (Publisher)
Field type metric
Data type float.currency.value
ad__lead_commission_td
Display name Lead commission (Tradedoubler)
Description The amount of lead commission (Tradedoubler)
Field type metric
Data type float.currency.value
ad__leads
Display name Leads
Description The number of leads
Field type metric
Data type int.number.value
ad__order_value
Display name Order value
Description The value of the orders
Field type metric
Data type float.currency.value
ad__sales
Display name Sales
Description The number of sales
Field type metric
Data type float.currency.value
ad__sales_commission
Display name Sales commission (Publisher)
Description The amount of sales commission (Publisher)
Field type metric
Data type float.currency.value
ad__sales_commission_td
Display name Sales commission (Tradedoubler)
Description The amount of sales commission (Tradedoubler)
Field type metric
Data type float.currency.value
ad__uv_commission
Display name Unique visitors commission (Publisher)
Description The amount of unique visitors commission (Publisher)
Field type metric
Data type float.currency.value
ad__uv_commission_td
Display name Unique visitors commission (Tradedoubler)
Description The amount of unique visitors commission (Tradedoubler)
Field type metric
Data type float.currency.value
ad__withdraw
Display name Withdraw
Description The amount withdrawn
Field type metric
Data type float.currency.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value