Tradedoubler fields

Prev Next

Supermetrics brings all your Tradedoubler data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

101 metrics110 dimensions

AD

ad__ad_id
ad__ad_name
ad__ad_category_id
ad__ad_category_name
ad__ad_type_id
ad__ad_type
ad__ad_group_id
ad__ad_group
ad__ad_size

ADJUSTMENT

finance_adjustments__adjustment_id
finance_adjustments__site_id
finance_adjustments__site_name
finance_adjustments__program_id
finance_adjustments__program_name
finance_adjustments__event_id
finance_adjustments__event
finance_adjustments__description
finance_adjustments__paid_to_publisher
finance_adjustments__invoiced
finance_adjustments__invoice_number
finance_adjustments__created_by
finance_adjustments__amount

AFFILIATE SITE

affiliate_site__site_id
affiliate_site__site_name
affiliate_site__site_country_code
affiliate_site__site_segment_name

CLICKS

program__clicks
program__ctr
affiliate_site__clicks
affiliate_site__ctr
ad__clicks
ad__ctr

COMMISSION

program__commission
program__commission_td
program__impression_commission
program__impression_commission_td
program__unique_impression_commission
program__unique_impression_commission_td
program__click_commission
program__click_commission_td
program__uv_commission
program__uv_commission_td
program__lead_commission
program__lead_commission_td
program__ilead_commission
program__ilead_commission_td
program__sales_commission
program__sales_commission_td
program__isales_commission
program__isales_commission_td
affiliate_site__commission
affiliate_site__commission_td
affiliate_site__impression_commission
affiliate_site__impression_commission_td
affiliate_site__unique_impression_commission
affiliate_site__unique_impression_commission_td
affiliate_site__click_commission
affiliate_site__click_commission_td
affiliate_site__uv_commission
affiliate_site__uv_commission_td
affiliate_site__lead_commission
affiliate_site__lead_commission_td
affiliate_site__ilead_commission
affiliate_site__ilead_commission_td
affiliate_site__sales_commission
affiliate_site__sales_commission_td
affiliate_site__isales_commission
affiliate_site__isales_commission_td
ad__commission
ad__commission_td
ad__impression_commission
ad__impression_commission_td
ad__unique_impression_commission
ad__unique_impression_commission_td
ad__click_commission
ad__click_commission_td
ad__uv_commission
ad__uv_commission_td
ad__lead_commission
ad__lead_commission_td
ad__ilead_commission
ad__ilead_commission_td
ad__sales_commission
ad__sales_commission_td
ad__isales_commission
ad__isales_commission_td

CONVERSIONS

program__cr
affiliate_site__cr
ad__cr

DATASOURCE

dataSourceName
system_metadata.data_source_logins
system_metadata.data_source_login_owners

DEPOSIT/WITHDRAW

program__deposit
program__withdraw
affiliate_site__deposit
affiliate_site__withdraw
ad__deposit
ad__withdraw

DIGITAL WALLET

program__digital_wallet__invoice_id
program__digital_wallet__invoice_source_id
program__digital_wallet__source_name
program__digital_wallet__invoice_event_name
program__digital_wallet__invoice_event_id
program__digital_wallet__invoice_description
program__digital_wallet__invoice_number
program__digital_wallet__invoiced
program__digital_wallet__invoice_created_at
program__digital_wallet__invoice_amount

IMPRESSIONS

program__impressions
program__unique_impressions
affiliate_site__impressions
affiliate_site__unique_impressions
ad__impressions
ad__unique_impressions

LEADS

program__leads
program__lr
affiliate_site__leads
affiliate_site__lr
ad__leads
ad__lr

ORDER

program__order_value
program__aov
program__cpo
affiliate_site__order_value
affiliate_site__aov
affiliate_site__cpo
ad__order_value
ad__aov
ad__cpo

OTHER

program__currency
affiliate_site__currency
ad__currency

PROGRAM

program__program_id
program__program_name
program__program_country_code
affiliate_site__program_id
ad__program_id

QUERY

system_metadata.query_date_range_start
system_metadata.query_date_range_end
system_metadata.query_timezone
system_metadata.query_filters
system_metadata.query_date_start
system_metadata.query_date_end
system_metadata.query_duration
system_metadata.query_accounts

SALES

program__sales
program__isales
program__epc
affiliate_site__sales
affiliate_site__isales
affiliate_site__epc
ad__sales
ad__isales
ad__epc

TIME

today
program__year
program__year_of_week
program__year_of_week_iso
program__year_month
program__month
program__year_week
program__year_week_iso
program__week
program__week_iso
program__day_of_month
program__day_of_week_name
program__day_of_week_name_iso
program__date
program__atom
affiliate_site__year
affiliate_site__year_of_week
affiliate_site__year_of_week_iso
affiliate_site__year_month
affiliate_site__month
affiliate_site__year_week
affiliate_site__year_week_iso
affiliate_site__week
affiliate_site__week_iso
affiliate_site__day_of_month
affiliate_site__day_of_week_name
affiliate_site__day_of_week_name_iso
affiliate_site__date
affiliate_site__atom
ad__year
ad__year_of_week
ad__year_of_week_iso
ad__year_month
ad__month
ad__year_week
ad__year_week_iso
ad__week
ad__week_iso
ad__day_of_month
ad__day_of_week_name
ad__day_of_week_name_iso
ad__date
ad__atom
finance_adjustments__year
finance_adjustments__year_of_week
finance_adjustments__year_of_week_iso
finance_adjustments__year_month
finance_adjustments__month
finance_adjustments__year_week
finance_adjustments__year_week_iso
finance_adjustments__week
finance_adjustments__week_iso
finance_adjustments__day_of_month
finance_adjustments__day_of_week_name
finance_adjustments__day_of_week_name_iso
finance_adjustments__date
finance_adjustments__atom