Adtraction data warehouse table groups

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

Table: ADVERTISER_CHANNEL

adv_channels__affiliate_id
Display name Partner ID
Description Numerical ID of a partner account
Field type dimension
Data type string.text.value
adv_channels__affiliate_name
Display name Partner name
Description Name of the partner. Individual or company
Field type dimension
Data type string.text.value
adv_channels__approval_status
Display name Approval status
Description Approval status of a channel for a partner program: 0 = rejected, 1 = approved, 2 = pending review
Field type dimension
Data type int.number.value
adv_channels__channel_description
Display name Channel description
Description A description of a channel
Field type dimension
Data type string.text.value
adv_channels__channel_id
Display name Channel ID
Description Numerical ID of a channel
Field type dimension
Data type string.text.value
adv_channels__channel_name
Display name Channel name
Description Name of a channel
Field type dimension
Data type string.text.value
adv_channels__channel_type
Display name Channel type
Description The type of a channel, such as Blog, Content, Facebook, Cashback, etc
Field type dimension
Data type string.text.value
adv_channels__channel_url
Display name Channel URL
Description The URL of a channel, if applicable
Field type dimension
Data type string.text.url
adv_channels__count
Display name Number of channels
Description Number of channels
Field type metric
Data type int.number.value
adv_statistics_channel__aov
Display name Average order value
Description Average order value, obtained by dividing order value by number of sale transactions
Field type metric
Data type float.currency.value
adv_statistics_channel__channel_id
Display name Channel ID
Description ID of the channel
Field type dimension
Data type string.text.value
adv_statistics_channel__channel_name
Display name Channel name
Description Name of the channel
Field type dimension
Data type string.text.value
adv_statistics_channel__clicks
Display name Clicks
Description Number of clicks
Field type metric
Data type int.number.value
adv_statistics_channel__clicks_unique
Display name Clicks unique
Description Number of unique clicks
Field type metric
Data type int.number.value
adv_statistics_channel__conversion_ratio
Display name Conversion ratio
Description Conversion Ratio, obtained by dividing sales by clicksUnique
Field type metric
Data type float.number.ratio
adv_statistics_channel__cost
Display name Cost
Description The total cost of the transaction, including partner commission and network fee
Field type metric
Data type int.number.value
adv_statistics_channel__ctr
Display name CTR
Description Click Through Ratio, obtained by dividing clicks by impressions
Field type metric
Data type float.number.ratio
adv_statistics_channel__impressions
Display name Impressions
Description Number of banner / links impressions
Field type metric
Data type int.number.value
adv_statistics_channel__impressions_unique
Display name Impressions unique
Description Number of unique banner / links impressions
Field type metric
Data type int.number.value
adv_statistics_channel__lead_ratio
Display name Lead ratio
Description Lead Ratio, obtained by dividing leads by clicksUnique
Field type metric
Data type float.number.ratio
adv_statistics_channel__leads
Display name Leads
Description Number of lead transactions
Field type metric
Data type int.number.value
adv_statistics_channel__order_value
Display name Order value
Description Order value of the sale transactions
Field type metric
Data type float.number.value
adv_statistics_channel__sales
Display name Sales
Description Number of sale transactions
Field type metric
Data type int.number.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: ADVERTISER_CLICK

adv_clicks__ad_id
Display name Ad ID
Description Numerical ID of an ad
Field type dimension
Data type string.text.value
adv_clicks__ad_name
Display name Ad name
Description Name of banner or link
Field type dimension
Data type string.text.value
adv_clicks__ad_type
Display name Ad type
Description Type of banner or link
Field type dimension
Data type string.text.value
adv_clicks__channel_id
Display name Channel ID
Description Numerical ID of a channel
Field type dimension
Data type string.text.value
adv_clicks__count
Display name Number of clicks
Description Number of clicks
Field type metric
Data type int.number.value
adv_clicks__status
Display name Click status
Description Current status of the click, where Fresh means still in cookie duration and Stale means outside cookie duration
Field type dimension
Data type string.text.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: ADVERTISER_TRANSACTION

adv_transactions__ad_id
Display name Ad ID
Description Numerical ID of an ad
Field type dimension
Data type string.text.value
adv_transactions__ad_name
Display name Ad name
Description Name of banner or link
Field type dimension
Data type string.text.value
adv_transactions__ad_type
Display name Ad type
Description Type of banner or link
Field type dimension
Data type string.text.value
adv_transactions__auto_approval_date
Display name Auto approval date
Description Date when a pending transaction (transactionStatus = 2) will be automatically approved unless already approved or rejected
Field type dimension
Data type string.time.date
adv_transactions__channel_id
Display name Channel ID
Description Numerical ID of a channel
Field type dimension
Data type string.text.value
adv_transactions__channel_name
Display name Channel name
Description Name of a channel
Field type dimension
Data type string.text.value
adv_transactions__click_date
Display name Click date
Description Date of the click that generated the transaction
Field type dimension
Data type string.time.date
adv_transactions__click_time
Display name Click time
Description UTC timestamp of the click that generated the transaction
Field type dimension
Data type string.time.datetime
adv_transactions__cost
Display name Cost
Description The cost of the transaction, including partner commission and Adtraction network fee
Field type metric
Data type float.currency.value
adv_transactions__count
Display name Number of clicks
Description Number of clicks
Field type metric
Data type int.number.value
adv_transactions__device
Display name Device
Description The type of device that was used to complete the transaction
Field type dimension
Data type string.text.value
adv_transactions__geo_location
Display name Geo location
Description The geographic market where the transaction was completed, defined by an ISO 3166-1 Alpha-2 country code
Field type dimension
Data type string.geo.country.twolettercode
adv_transactions__last_updated
Display name Last updated
Description UTC timestamp of when the transactionStatus or orderValue of the transaction was last updated. Only available for transactions where transactionStatus or orderValue has been updated
Field type dimension
Data type string.time.datetime
adv_transactions__last_updated_date
Display name Last updated date
Description Date of when the transactionStatus or orderValue of the transaction was last updated. Only available for transactions where transactionStatus or orderValue has been updated
Field type dimension
Data type string.time.date
adv_transactions__operating_system
Display name Operating system
Description The operating system used on the device that was used to complete the transaction
Field type dimension
Data type string.text.value
adv_transactions__order_value
Display name Order value
Description Order value of the transaction
Field type metric
Data type float.currency.value
adv_transactions__payment_status
Display name Payment status
Description Specifies what payment status of transaction should be included in the dataset. 1 = not invoiced, 2 = invoiced to advertiser, 3 = ready for payment, 4 = paid to partner
Field type dimension
Data type int.number.value
adv_transactions__reason_text
Display name Rejection reason
Description For rejected transactions (transactionStatus = 5) you may choose to provide the reason for the transaction being rejected
Field type dimension
Data type string.text.value
adv_transactions__status
Display name Click status
Description Current status of the click, where Fresh means still in cookie duration and Stale means outside cookie duration
Field type dimension
Data type string.text.value
adv_transactions__transaction_name
Display name Transaction name
Description Name of the transaction
Field type dimension
Data type string.text.value
adv_transactions__transaction_status
Display name Transaction status
Description The status of the transactions to be included in the dataset. Impressions and clicks are not affected by this input. 1 = approved, 2 = pending, 3 = approved + pending, 4 = open claims, 5 = rejected
Field type dimension
Data type int.number.value
adv_transactions__unique_id
Display name Unique ID
Description Unique ID for the transaction
Field type dimension
Data type string.text.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: ADVERTISER_STATISTICS

adv_statistics__account_name
Display name Account name
Description Account name
Field type dimension
Data type string.text.value
adv_statistics__aov
Display name Average order value
Description Average order value, obtained by dividing order value by number of sale transactions
Field type metric
Data type float.currency.value
adv_statistics__clicks
Display name Clicks
Description Number of clicks
Field type metric
Data type int.number.value
adv_statistics__clicks_unique
Display name Clicks unique
Description Number of unique clicks
Field type metric
Data type int.number.value
adv_statistics__conversion_ratio
Display name Conversion ratio
Description Conversion Ratio, obtained by dividing sales by clicksUnique
Field type metric
Data type float.number.ratio
adv_statistics__cost
Display name Cost
Description The total cost of the transaction, including partner commission and network fee
Field type metric
Data type int.number.value
adv_statistics__ctr
Display name CTR
Description Click Through Ratio, obtained by dividing clicks by impressions
Field type metric
Data type float.number.ratio
adv_statistics__impressions
Display name Impressions
Description Number of banner / links impressions
Field type metric
Data type int.number.value
adv_statistics__impressions_unique
Display name Impressions unique
Description Number of unique banner / links impressions
Field type metric
Data type int.number.value
adv_statistics__lead_ratio
Display name Lead ratio
Description Lead Ratio, obtained by dividing leads by clicksUnique
Field type metric
Data type float.number.ratio
adv_statistics__leads
Display name Leads
Description Number of lead transactions
Field type metric
Data type int.number.value
adv_statistics__order_value
Display name Order value
Description Order value of the sale transactions
Field type metric
Data type float.number.value
adv_statistics__sales
Display name Sales
Description Number of sale transactions
Field type metric
Data type int.number.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: ADVERTISER_AD

adv_statistics_ads__ad_id
Display name Ad ID
Description ID of the ad
Field type dimension
Data type string.text.value
adv_statistics_ads__ad_name
Display name Ad name
Description Name of the ad
Field type dimension
Data type string.text.value
adv_statistics_ads__aov
Display name Average order value
Description Average order value, obtained by dividing order value by number of sale transactions
Field type metric
Data type float.currency.value
adv_statistics_ads__clicks
Display name Clicks
Description Number of clicks
Field type metric
Data type int.number.value
adv_statistics_ads__clicks_unique
Display name Clicks unique
Description Number of unique clicks
Field type metric
Data type int.number.value
adv_statistics_ads__conversion_ratio
Display name Conversion ratio
Description Conversion Ratio, obtained by dividing sales by clicksUnique
Field type metric
Data type float.number.ratio
adv_statistics_ads__cost
Display name Cost
Description The total cost of the transaction, including partner commission and network fee
Field type metric
Data type int.number.value
adv_statistics_ads__ctr
Display name CTR
Description Click Through Ratio, obtained by dividing clicks by impressions
Field type metric
Data type float.number.ratio
adv_statistics_ads__impressions
Display name Impressions
Description Number of banner / links impressions
Field type metric
Data type int.number.value
adv_statistics_ads__impressions_unique
Display name Impressions unique
Description Number of unique banner / links impressions
Field type metric
Data type int.number.value
adv_statistics_ads__lead_ratio
Display name Lead ratio
Description Lead Ratio, obtained by dividing leads by clicksUnique
Field type metric
Data type float.number.ratio
adv_statistics_ads__leads
Display name Leads
Description Number of lead transactions
Field type metric
Data type int.number.value
adv_statistics_ads__order_value
Display name Order value
Description Order value of the sale transactions
Field type metric
Data type float.number.value
adv_statistics_ads__sales
Display name Sales
Description Number of sale transactions
Field type metric
Data type int.number.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: ADVERTISER_CHANNEL

adv_channels__affiliate_id
Display name Partner ID
Description Numerical ID of a partner account
Field type dimension
Data type string.text.value
adv_channels__affiliate_name
Display name Partner name
Description Name of the partner. Individual or company
Field type dimension
Data type string.text.value
adv_channels__approval_status
Display name Approval status
Description Approval status of a channel for a partner program: 0 = rejected, 1 = approved, 2 = pending review
Field type dimension
Data type int.number.value
adv_channels__channel_description
Display name Channel description
Description A description of a channel
Field type dimension
Data type string.text.value
adv_channels__channel_id
Display name Channel ID
Description Numerical ID of a channel
Field type dimension
Data type string.text.value
adv_channels__channel_name
Display name Channel name
Description Name of a channel
Field type dimension
Data type string.text.value
adv_channels__channel_type
Display name Channel type
Description The type of a channel, such as Blog, Content, Facebook, Cashback, etc
Field type dimension
Data type string.text.value
adv_channels__channel_url
Display name Channel URL
Description The URL of a channel, if applicable
Field type dimension
Data type string.text.url
adv_channels__count
Display name Number of channels
Description Number of channels
Field type metric
Data type int.number.value
adv_statistics_channel__aov
Display name Average order value
Description Average order value, obtained by dividing order value by number of sale transactions
Field type metric
Data type float.currency.value
adv_statistics_channel__channel_id
Display name Channel ID
Description ID of the channel
Field type dimension
Data type string.text.value
adv_statistics_channel__channel_name
Display name Channel name
Description Name of the channel
Field type dimension
Data type string.text.value
adv_statistics_channel__clicks
Display name Clicks
Description Number of clicks
Field type metric
Data type int.number.value
adv_statistics_channel__clicks_unique
Display name Clicks unique
Description Number of unique clicks
Field type metric
Data type int.number.value
adv_statistics_channel__conversion_ratio
Display name Conversion ratio
Description Conversion Ratio, obtained by dividing sales by clicksUnique
Field type metric
Data type float.number.ratio
adv_statistics_channel__cost
Display name Cost
Description The total cost of the transaction, including partner commission and network fee
Field type metric
Data type int.number.value
adv_statistics_channel__ctr
Display name CTR
Description Click Through Ratio, obtained by dividing clicks by impressions
Field type metric
Data type float.number.ratio
adv_statistics_channel__impressions
Display name Impressions
Description Number of banner / links impressions
Field type metric
Data type int.number.value
adv_statistics_channel__impressions_unique
Display name Impressions unique
Description Number of unique banner / links impressions
Field type metric
Data type int.number.value
adv_statistics_channel__lead_ratio
Display name Lead ratio
Description Lead Ratio, obtained by dividing leads by clicksUnique
Field type metric
Data type float.number.ratio
adv_statistics_channel__leads
Display name Leads
Description Number of lead transactions
Field type metric
Data type int.number.value
adv_statistics_channel__order_value
Display name Order value
Description Order value of the sale transactions
Field type metric
Data type float.number.value
adv_statistics_channel__sales
Display name Sales
Description Number of sale transactions
Field type metric
Data type int.number.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: ADVERTISER_DAILY_STATISTICS

adv_statistics_days__clicks
Display name Clicks
Description Number of clicks
Field type metric
Data type int.number.value
adv_statistics_days__clicks_unique
Display name Clicks unique
Description Number of unique clicks
Field type metric
Data type int.number.value
adv_statistics_days__conversion_ratio
Display name Conversion ratio
Description Conversion Ratio, obtained by dividing sales by clicksUnique
Field type metric
Data type float.number.ratio
adv_statistics_days__cost
Display name Cost
Description The total cost of the transaction, including partner commission and network fee
Field type metric
Data type int.number.value
adv_statistics_days__date
Display name Date
Field type dimension
Data type string.time.date
adv_statistics_days__impressions
Display name Impressions
Description Number of banner / links impressions
Field type metric
Data type int.number.value
adv_statistics_days__impressions_unique
Display name Impressions unique
Description Number of unique banner / links impressions
Field type metric
Data type int.number.value
adv_statistics_days__leads
Display name Leads
Description Number of lead transactions
Field type metric
Data type int.number.value
adv_statistics_days__order_value
Display name Order value
Description Order value of the sale transactions
Field type metric
Data type float.number.value
adv_statistics_days__sales
Display name Sales
Description Number of sale transactions
Field type metric
Data type int.number.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: ADVERTISER_SEGMENT

adv_statistics_segments__aov
Display name Average order value
Description Average order value, obtained by dividing order value by number of sale transactions
Field type metric
Data type float.currency.value
adv_statistics_segments__clicks
Display name Clicks
Description Number of clicks
Field type metric
Data type int.number.value
adv_statistics_segments__clicks_unique
Display name Clicks unique
Description Number of unique clicks
Field type metric
Data type int.number.value
adv_statistics_segments__conversion_ratio
Display name Conversion ratio
Description Conversion Ratio, obtained by dividing sales by clicksUnique
Field type metric
Data type float.number.ratio
adv_statistics_segments__cost
Display name Cost
Description The total cost of the transaction, including partner commission and network fee
Field type metric
Data type int.number.value
adv_statistics_segments__ctr
Display name CTR
Description Click Through Ratio, obtained by dividing clicks by impressions
Field type metric
Data type float.number.ratio
adv_statistics_segments__impressions
Display name Impressions
Description Number of banner / links impressions
Field type metric
Data type int.number.value
adv_statistics_segments__impressions_unique
Display name Impressions unique
Description Number of unique banner / links impressions
Field type metric
Data type int.number.value
adv_statistics_segments__lead_ratio
Display name Lead ratio
Description Lead Ratio, obtained by dividing leads by clicksUnique
Field type metric
Data type float.number.ratio
adv_statistics_segments__leads
Display name Leads
Description Number of lead transactions
Field type metric
Data type int.number.value
adv_statistics_segments__order_value
Display name Order value
Description Order value of the sale transactions
Field type metric
Data type float.number.value
adv_statistics_segments__sales
Display name Sales
Description Number of sale transactions
Field type metric
Data type int.number.value
adv_statistics_segments__segment_id
Display name Segment ID
Description Numerical ID of a commission segment
Field type dimension
Data type string.text.value
adv_statistics_segments__segment_name
Display name Segment name
Description Name of a commission segment
Field type dimension
Data type string.text.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