Adtraction fields

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

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

154 metrics165 dimensions

AD

adv_clicks__ad_id
Field label Ad ID
Description Numerical ID of an ad
Field type dimension
Data type string.text.value
adv_clicks__ad_name
Field label Ad name
Description Name of banner or link
Field type dimension
Data type string.text.value
adv_clicks__ad_type
Field label Ad type
Description Type of banner or link
Field type dimension
Data type string.text.value
adv_transactions__ad_id
Field label Ad ID
Description Numerical ID of an ad
Field type dimension
Data type string.text.value
adv_transactions__ad_name
Field label Ad name
Description Name of banner or link
Field type dimension
Data type string.text.value
adv_transactions__ad_type
Field label Ad type
Description Type of banner or link
Field type dimension
Data type string.text.value
adv_statistics_ads__ad_id
Field label Ad ID
Description ID of the ad
Field type dimension
Data type string.text.value
adv_statistics_ads__ad_name
Field label Ad name
Description Name of the ad
Field type dimension
Data type string.text.value
aff_clicks__ad_id
Field label Ad ID
Description Numerical ID of an ad
Field type dimension
Data type string.text.value
aff_clicks__ad_name
Field label Ad name
Description Name of banner or link
Field type dimension
Data type string.text.value
aff_clicks__ad_type
Field label Ad type
Description Type of banner or link
Field type dimension
Data type string.text.value
aff_transactions__ad_id
Field label Ad ID
Description Numerical ID of an ad
Field type dimension
Data type string.text.value
aff_transactions__ad_name
Field label Ad name
Description Name of banner or link
Field type dimension
Data type string.text.value
aff_transactions__ad_type
Field label Ad type
Description Type of banner or link
Field type dimension
Data type string.text.value
aff_transactions_latest__ad_id
Field label Ad ID
Description Numerical ID of an ad
Field type dimension
Data type string.text.value
aff_transactions_latest__ad_name
Field label Ad name
Description Name of banner or link
Field type dimension
Data type string.text.value
aff_transactions_latest__ad_type
Field label Ad type
Description Type of banner or link
Field type dimension
Data type string.text.value
aff_statistics_ads__ad_id
Field label Ad ID
Description ID of the ad
Field type dimension
Data type string.text.value
aff_statistics_ads__ad_name
Field label Ad name
Description Name of the ad
Field type dimension
Data type string.text.value

ADVERTISER

adv_statistics__account_name
Field label Account name
Description Account name
Field type dimension
Data type string.text.value

APPLICATION

aff_applications__channel_id
Field label Channel ID
Description Numerical ID of a channel
Field type dimension
Data type string.text.value
aff_applications__channel_name
Field label Channel name
Description Name of a publisher channel
Field type dimension
Data type string.text.value
aff_applications__status
Field label Status
Description Status of the channel's application for the specified program. 0 = rejected, 1 = approved, 2 = pending
Field type dimension
Data type string.text.value
aff_applications__program_id
Field label Program ID
Description Numerical ID of a partner program
Field type dimension
Data type string.text.value
aff_applications__program_name
Field label Program name
Description Name of a partner program
Field type dimension
Data type string.text.value

CHANNEL

adv_channels__channel_id
Field label Channel ID
Description Numerical ID of a channel
Field type dimension
Data type string.text.value
adv_channels__channel_name
Field label Channel name
Description Name of a channel
Field type dimension
Data type string.text.value
adv_channels__channel_description
Field label Channel description
Description A description of a channel
Field type dimension
Data type string.text.value
adv_channels__channel_url
Field label Channel URL
Description The URL of a channel, if applicable
Field type dimension
Data type string.text.url
adv_channels__channel_type
Field label 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__approval_status
Field label 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_clicks__channel_id
Field label Channel ID
Description Numerical ID of a channel
Field type dimension
Data type string.text.value
adv_transactions__channel_id
Field label Channel ID
Description Numerical ID of a channel
Field type dimension
Data type string.text.value
adv_transactions__channel_name
Field label Channel name
Description Name of a channel
Field type dimension
Data type string.text.value
adv_statistics_channel__channel_id
Field label Channel ID
Description ID of the channel
Field type dimension
Data type string.text.value
adv_statistics_channel__channel_name
Field label Channel name
Description Name of the channel
Field type dimension
Data type string.text.value
aff_channels__channel_id
Field label Channel ID
Description Numerical ID of the channel
Field type dimension
Data type string.text.value
aff_channels__channel_name
Field label Channel name
Description Name of the channel
Field type dimension
Data type string.text.value
aff_channels__channel_url
Field label Channel URL
Description The URL of a channel, if applicable
Field type dimension
Data type string.text.url
aff_statistics_channel__channel_id
Field label Channel ID
Description ID of the channel
Field type dimension
Data type string.text.value
aff_statistics_channel__channel_name
Field label Channel name
Description Name of the channel
Field type dimension
Data type string.text.value

CLICK

adv_clicks__status
Field label 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__click_time
Field label Click time
Description UTC timestamp of the click that generated the transaction
Field type dimension
Data type string.time.datetime
adv_transactions__click_date
Field label Click date
Description Date of the click that generated the transaction
Field type dimension
Data type string.time.date
adv_transactions__status
Field label 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
aff_clicks__count
Field label Count
Description Number of clicks
Field type metric
Data type int.number.value

CLICK INFO

aff_clicks__channel_id
Field label Channel ID
Description Numerical ID of a channel. Your Channel IDs can be found by navigating to "Account" > "My channels" in your Adtraction account
Field type dimension
Data type string.text.value
aff_clicks__click_datetime
Field label Click datetime
Description UTC timestamp of the click that generated the transaction
Field type dimension
Data type string.time.datetime
aff_clicks__click_date
Field label Click date
Description UTC date of the click that generated the transaction
Field type dimension
Data type string.time.date
aff_clicks__referrer
Field label Referrer
Description HTTP referrer for the click
Field type dimension
Data type string.text.url
aff_clicks__program_id
Field label Program ID
Description Numerical ID of a partner program
Field type dimension
Data type string.text.value
aff_clicks__program_name
Field label Program name
Description Name of a partner program
Field type dimension
Data type string.text.value
aff_clicks__status
Field label 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
aff_clicks__epi
Field label EPI
Description EPI extracted from the tracking link that generated the click
Field type dimension
Data type string.text.value
aff_clicks__gclid
Field label Google click ID
Description Google Click ID. Extracted from the tracking link that generated the transaction
Field type dimension
Data type string.text.value
aff_transactions__channel_id
Field label Channel ID
Description Numerical ID of a channel. Your Channel IDs can be found by navigating to "Account" > "My channels" in your Adtraction account
Field type dimension
Data type string.text.value
aff_transactions__click_datetime
Field label Click datetime
Description UTC timestamp of the click that generated the transaction
Field type dimension
Data type string.time.datetime
aff_transactions__click_date
Field label Click date
Description UTC date of the click that generated the transaction
Field type dimension
Data type string.time.date
aff_transactions__referrer
Field label Referrer
Description HTTP referrer for the click
Field type dimension
Data type string.text.url
aff_transactions__program_id
Field label Program ID
Description Numerical ID of a partner program
Field type dimension
Data type string.text.value
aff_transactions__program_name
Field label Program name
Description Name of a partner program
Field type dimension
Data type string.text.value
aff_transactions__status
Field label 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
aff_transactions__epi
Field label EPI
Description EPI extracted from the tracking link that generated the click
Field type dimension
Data type string.text.value
aff_transactions__gclid
Field label Google click ID
Description Google Click ID. Extracted from the tracking link that generated the transaction
Field type dimension
Data type string.text.value
aff_transactions_latest__channel_id
Field label Channel ID
Description Numerical ID of a channel. Your Channel IDs can be found by navigating to "Account" > "My channels" in your Adtraction account
Field type dimension
Data type string.text.value
aff_transactions_latest__click_datetime
Field label Click datetime
Description UTC timestamp of the click that generated the transaction
Field type dimension
Data type string.time.datetime
aff_transactions_latest__click_date
Field label Click date
Description UTC date of the click that generated the transaction
Field type dimension
Data type string.time.date
aff_transactions_latest__referrer
Field label Referrer
Description HTTP referrer for the click
Field type dimension
Data type string.text.url
aff_transactions_latest__program_id
Field label Program ID
Description Numerical ID of a partner program
Field type dimension
Data type string.text.value
aff_transactions_latest__program_name
Field label Program name
Description Name of a partner program
Field type dimension
Data type string.text.value
aff_transactions_latest__status
Field label 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
aff_transactions_latest__epi
Field label EPI
Description EPI extracted from the tracking link that generated the click
Field type dimension
Data type string.text.value
aff_transactions_latest__gclid
Field label Google click ID
Description Google Click ID. Extracted from the tracking link that generated the transaction
Field type dimension
Data type string.text.value

COUNT

adv_channels__count
Field label Number of channels
Description Number of channels
Field type metric
Data type int.number.value
adv_clicks__count
Field label Number of clicks
Description Number of clicks
Field type metric
Data type int.number.value

CURRENCY

aff_currencies__currency
Field label Currency
Description Currency in ISO 4217 format
Field type dimension
Data type string.currency.code
aff_currencies__currency_id
Field label Currency ID
Description Numerical ID of the currency
Field type dimension
Data type string.text.value
aff_statistics__currency
Field label Currency
Description Currency in ISO 4217 format
Field type dimension
Data type string.currency.code

DATASOURCE

dataSourceName
Field label 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
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

DEVICE

adv_transactions__device
Field label Device
Description The type of device that was used to complete the transaction
Field type dimension
Data type string.text.value
adv_transactions__operating_system
Field label 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
aff_transactions__device
Field label Device
Description The type of device that was used to complete the transaction
Field type dimension
Data type string.text.value
aff_transactions__operating_system
Field label 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
aff_transactions_latest__device
Field label Device
Description The type of device that was used to complete the transaction
Field type dimension
Data type string.text.value
aff_transactions_latest__operating_system
Field label 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

GEO

adv_transactions__geo_location
Field label 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
aff_transactions__geo_location
Field label 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
aff_transactions_latest__geo_location
Field label 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

MARKET

aff_markets__market_code
Field label Market code
Description ISO 3166-1 Alpha-2 country code
Field type dimension
Data type string.geo.country.twolettercode
aff_markets__market_name
Field label Market name
Description Name of the market
Field type dimension
Data type string.text.value
aff_markets__market_id
Field label Market ID
Description Numerical Adtraction ID of the market
Field type dimension
Data type string.text.value

PARTNER

adv_channels__affiliate_id
Field label Partner ID
Description Numerical ID of a partner account
Field type dimension
Data type string.text.value
adv_channels__affiliate_name
Field label Partner name
Description Name of the partner. Individual or company
Field type dimension
Data type string.text.value

PROGRAM

aff_statistics_program__program_id
Field label Program ID
Description Numerical ID of a partner program
Field type dimension
Data type string.text.value
aff_statistics_program__program_name
Field label Program name
Description Name of a partner program
Field type dimension
Data type string.text.value

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

SEGMENT

adv_statistics_segments__segment_id
Field label Segment ID
Description Numerical ID of a commission segment
Field type dimension
Data type string.text.value
adv_statistics_segments__segment_name
Field label Segment name
Description Name of a commission segment
Field type dimension
Data type string.text.value

STATISTICS

adv_statistics__clicks
Field label Clicks
Description Number of clicks
Field type metric
Data type int.number.value
adv_statistics__clicks_unique
Field label Clicks unique
Description Number of unique clicks
Field type metric
Data type int.number.value
adv_statistics__cost
Field label Cost
Description The total cost of the transaction, including partner commission and network fee
Field type metric
Data type int.number.value
adv_statistics__impressions
Field label Impressions
Description Number of banner / links impressions
Field type metric
Data type int.number.value
adv_statistics__impressions_unique
Field label Impressions unique
Description Number of unique banner / links impressions
Field type metric
Data type int.number.value
adv_statistics__order_value
Field label Order value
Description Order value of the sale transactions
Field type metric
Data type float.number.value
adv_statistics__leads
Field label Leads
Description Number of lead transactions
Field type metric
Data type int.number.value
adv_statistics__sales
Field label Sales
Description Number of sale transactions
Field type metric
Data type int.number.value
adv_statistics__ctr
Field label CTR
Description Click Through Ratio, obtained by dividing clicks by impressions
Field type metric
Data type float.number.ratio
adv_statistics__lead_ratio
Field label Lead ratio
Description Lead Ratio, obtained by dividing leads by clicksUnique
Field type metric
Data type float.number.ratio
adv_statistics__conversion_ratio
Field label Conversion ratio
Description Conversion Ratio, obtained by dividing sales by clicksUnique
Field type metric
Data type float.number.ratio
adv_statistics__aov
Field label 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
Field label Clicks
Description Number of clicks
Field type metric
Data type int.number.value
adv_statistics_ads__clicks_unique
Field label Clicks unique
Description Number of unique clicks
Field type metric
Data type int.number.value
adv_statistics_ads__cost
Field label 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__impressions
Field label Impressions
Description Number of banner / links impressions
Field type metric
Data type int.number.value
adv_statistics_ads__impressions_unique
Field label Impressions unique
Description Number of unique banner / links impressions
Field type metric
Data type int.number.value
adv_statistics_ads__order_value
Field label Order value
Description Order value of the sale transactions
Field type metric
Data type float.number.value
adv_statistics_ads__leads
Field label Leads
Description Number of lead transactions
Field type metric
Data type int.number.value
adv_statistics_ads__sales
Field label Sales
Description Number of sale transactions
Field type metric
Data type int.number.value
adv_statistics_ads__ctr
Field label CTR
Description Click Through Ratio, obtained by dividing clicks by impressions
Field type metric
Data type float.number.ratio
adv_statistics_ads__lead_ratio
Field label Lead ratio
Description Lead Ratio, obtained by dividing leads by clicksUnique
Field type metric
Data type float.number.ratio
adv_statistics_ads__conversion_ratio
Field label Conversion ratio
Description Conversion Ratio, obtained by dividing sales by clicksUnique
Field type metric
Data type float.number.ratio
adv_statistics_ads__aov
Field label 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__clicks
Field label Clicks
Description Number of clicks
Field type metric
Data type int.number.value
adv_statistics_channel__clicks_unique
Field label Clicks unique
Description Number of unique clicks
Field type metric
Data type int.number.value
adv_statistics_channel__cost
Field label 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__impressions
Field label Impressions
Description Number of banner / links impressions
Field type metric
Data type int.number.value
adv_statistics_channel__impressions_unique
Field label Impressions unique
Description Number of unique banner / links impressions
Field type metric
Data type int.number.value
adv_statistics_channel__order_value
Field label Order value
Description Order value of the sale transactions
Field type metric
Data type float.number.value
adv_statistics_channel__leads
Field label Leads
Description Number of lead transactions
Field type metric
Data type int.number.value
adv_statistics_channel__sales
Field label Sales
Description Number of sale transactions
Field type metric
Data type int.number.value
adv_statistics_channel__ctr
Field label CTR
Description Click Through Ratio, obtained by dividing clicks by impressions
Field type metric
Data type float.number.ratio
adv_statistics_channel__lead_ratio
Field label Lead ratio
Description Lead Ratio, obtained by dividing leads by clicksUnique
Field type metric
Data type float.number.ratio
adv_statistics_channel__conversion_ratio
Field label Conversion ratio
Description Conversion Ratio, obtained by dividing sales by clicksUnique
Field type metric
Data type float.number.ratio
adv_statistics_channel__aov
Field label 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_days__clicks
Field label Clicks
Description Number of clicks
Field type metric
Data type int.number.value
adv_statistics_days__clicks_unique
Field label Clicks unique
Description Number of unique clicks
Field type metric
Data type int.number.value
adv_statistics_days__cost
Field label 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__impressions
Field label Impressions
Description Number of banner / links impressions
Field type metric
Data type int.number.value
adv_statistics_days__impressions_unique
Field label Impressions unique
Description Number of unique banner / links impressions
Field type metric
Data type int.number.value
adv_statistics_days__order_value
Field label Order value
Description Order value of the sale transactions
Field type metric
Data type float.number.value
adv_statistics_days__leads
Field label Leads
Description Number of lead transactions
Field type metric
Data type int.number.value
adv_statistics_days__sales
Field label Sales
Description Number of sale transactions
Field type metric
Data type int.number.value
adv_statistics_days__ctr
Field label CTR
Description Click Through Ratio, obtained by dividing clicks by impressions
Field type metric
Data type float.number.ratio
adv_statistics_days__lead_ratio
Field label Lead ratio
Description Lead Ratio, obtained by dividing leads by clicksUnique
Field type metric
Data type float.number.ratio
adv_statistics_days__conversion_ratio
Field label Conversion ratio
Description Conversion Ratio, obtained by dividing sales by clicksUnique
Field type metric
Data type float.number.ratio
adv_statistics_days__aov
Field label 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
Field label Clicks
Description Number of clicks
Field type metric
Data type int.number.value
adv_statistics_segments__clicks_unique
Field label Clicks unique
Description Number of unique clicks
Field type metric
Data type int.number.value
adv_statistics_segments__cost
Field label 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__impressions
Field label Impressions
Description Number of banner / links impressions
Field type metric
Data type int.number.value
adv_statistics_segments__impressions_unique
Field label Impressions unique
Description Number of unique banner / links impressions
Field type metric
Data type int.number.value
adv_statistics_segments__order_value
Field label Order value
Description Order value of the sale transactions
Field type metric
Data type float.number.value
adv_statistics_segments__leads
Field label Leads
Description Number of lead transactions
Field type metric
Data type int.number.value
adv_statistics_segments__sales
Field label Sales
Description Number of sale transactions
Field type metric
Data type int.number.value
adv_statistics_segments__ctr
Field label CTR
Description Click Through Ratio, obtained by dividing clicks by impressions
Field type metric
Data type float.number.ratio
adv_statistics_segments__lead_ratio
Field label Lead ratio
Description Lead Ratio, obtained by dividing leads by clicksUnique
Field type metric
Data type float.number.ratio
adv_statistics_segments__conversion_ratio
Field label Conversion ratio
Description Conversion Ratio, obtained by dividing sales by clicksUnique
Field type metric
Data type float.number.ratio
adv_statistics_segments__aov
Field label 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
aff_statistics__clicks
Field label Clicks
Description Number of clicks
Field type metric
Data type int.number.value
aff_statistics__clicks_unique
Field label Clicks unique
Description Number of unique clicks
Field type metric
Data type int.number.value
aff_statistics__commission
Field label Commission
Description Amount of partner commission
Field type metric
Data type float.currency.value
aff_statistics__impressions
Field label Impressions
Description Number of banner / links impressions
Field type metric
Data type int.number.value
aff_statistics__impressions_unique
Field label Impressions unique
Description Number of unique banner / links impressions
Field type metric
Data type int.number.value
aff_statistics__order_value
Field label Order value
Description Order value of the sale transactions
Field type metric
Data type float.currency.value
aff_statistics__leads
Field label Leads
Description Number of lead transactions
Field type metric
Data type int.number.value
aff_statistics__sales
Field label Sales
Description Number of sale transactions
Field type metric
Data type int.number.value
aff_statistics__ctr
Field label CTR
Description Click Through Ratio, obtained by dividing clicks by impressions
Field type metric
Data type float.number.ratio
aff_statistics__lead_ratio
Field label Lead ratio
Description Lead Ratio, obtained by dividing leads by clicksUnique
Field type metric
Data type float.number.ratio
aff_statistics__conversion_ratio
Field label Conversion ratio
Description Conversion Ratio, obtained by dividing sales by clicksUnique
Field type metric
Data type float.number.ratio
aff_statistics__aov
Field label 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
aff_statistics__epc
Field label EPC
Description Earnings Per Click obtained by dividing the commission by clicksUnique
Field type metric
Data type float.currency.value
aff_statistics_ads__clicks
Field label Clicks
Description Number of clicks
Field type metric
Data type int.number.value
aff_statistics_ads__clicks_unique
Field label Clicks unique
Description Number of unique clicks
Field type metric
Data type int.number.value
aff_statistics_ads__commission
Field label Commission
Description Amount of partner commission
Field type metric
Data type float.currency.value
aff_statistics_ads__impressions
Field label Impressions
Description Number of banner / links impressions
Field type metric
Data type int.number.value
aff_statistics_ads__impressions_unique
Field label Impressions unique
Description Number of unique banner / links impressions
Field type metric
Data type int.number.value
aff_statistics_ads__order_value
Field label Order value
Description Order value of the sale transactions
Field type metric
Data type float.currency.value
aff_statistics_ads__leads
Field label Leads
Description Number of lead transactions
Field type metric
Data type int.number.value
aff_statistics_ads__sales
Field label Sales
Description Number of sale transactions
Field type metric
Data type int.number.value
aff_statistics_ads__ctr
Field label CTR
Description Click Through Ratio, obtained by dividing clicks by impressions
Field type metric
Data type float.number.ratio
aff_statistics_ads__lead_ratio
Field label Lead ratio
Description Lead Ratio, obtained by dividing leads by clicksUnique
Field type metric
Data type float.number.ratio
aff_statistics_ads__conversion_ratio
Field label Conversion ratio
Description Conversion Ratio, obtained by dividing sales by clicksUnique
Field type metric
Data type float.number.ratio
aff_statistics_ads__aov
Field label 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
aff_statistics_ads__epc
Field label EPC
Description Earnings Per Click obtained by dividing the commission by clicksUnique
Field type metric
Data type float.currency.value
aff_statistics_channel__clicks
Field label Clicks
Description Number of clicks
Field type metric
Data type int.number.value
aff_statistics_channel__clicks_unique
Field label Clicks unique
Description Number of unique clicks
Field type metric
Data type int.number.value
aff_statistics_channel__commission
Field label Commission
Description Amount of partner commission
Field type metric
Data type float.currency.value
aff_statistics_channel__impressions
Field label Impressions
Description Number of banner / links impressions
Field type metric
Data type int.number.value
aff_statistics_channel__impressions_unique
Field label Impressions unique
Description Number of unique banner / links impressions
Field type metric
Data type int.number.value
aff_statistics_channel__order_value
Field label Order value
Description Order value of the sale transactions
Field type metric
Data type float.currency.value
aff_statistics_channel__leads
Field label Leads
Description Number of lead transactions
Field type metric
Data type int.number.value
aff_statistics_channel__sales
Field label Sales
Description Number of sale transactions
Field type metric
Data type int.number.value
aff_statistics_channel__ctr
Field label CTR
Description Click Through Ratio, obtained by dividing clicks by impressions
Field type metric
Data type float.number.ratio
aff_statistics_channel__lead_ratio
Field label Lead ratio
Description Lead Ratio, obtained by dividing leads by clicksUnique
Field type metric
Data type float.number.ratio
aff_statistics_channel__conversion_ratio
Field label Conversion ratio
Description Conversion Ratio, obtained by dividing sales by clicksUnique
Field type metric
Data type float.number.ratio
aff_statistics_channel__aov
Field label 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
aff_statistics_channel__epc
Field label EPC
Description Earnings Per Click obtained by dividing the commission by clicksUnique
Field type metric
Data type float.currency.value
aff_statistics_day__clicks
Field label Clicks
Description Number of clicks
Field type metric
Data type int.number.value
aff_statistics_day__clicks_unique
Field label Clicks unique
Description Number of unique clicks
Field type metric
Data type int.number.value
aff_statistics_day__commission
Field label Commission
Description Amount of partner commission
Field type metric
Data type float.currency.value
aff_statistics_day__impressions
Field label Impressions
Description Number of banner / links impressions
Field type metric
Data type int.number.value
aff_statistics_day__impressions_unique
Field label Impressions unique
Description Number of unique banner / links impressions
Field type metric
Data type int.number.value
aff_statistics_day__order_value
Field label Order value
Description Order value of the sale transactions
Field type metric
Data type float.currency.value
aff_statistics_day__leads
Field label Leads
Description Number of lead transactions
Field type metric
Data type int.number.value
aff_statistics_day__sales
Field label Sales
Description Number of sale transactions
Field type metric
Data type int.number.value
aff_statistics_day__ctr
Field label CTR
Description Click Through Ratio, obtained by dividing clicks by impressions
Field type metric
Data type float.number.ratio
aff_statistics_day__lead_ratio
Field label Lead ratio
Description Lead Ratio, obtained by dividing leads by clicksUnique
Field type metric
Data type float.number.ratio
aff_statistics_day__conversion_ratio
Field label Conversion ratio
Description Conversion Ratio, obtained by dividing sales by clicksUnique
Field type metric
Data type float.number.ratio
aff_statistics_day__aov
Field label 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
aff_statistics_day__epc
Field label EPC
Description Earnings Per Click obtained by dividing the commission by clicksUnique
Field type metric
Data type float.currency.value
aff_statistics_epi__clicks
Field label Clicks
Description Number of clicks
Field type metric
Data type int.number.value
aff_statistics_epi__clicks_unique
Field label Clicks unique
Description Number of unique clicks
Field type metric
Data type int.number.value
aff_statistics_epi__commission
Field label Commission
Description Amount of partner commission
Field type metric
Data type float.currency.value
aff_statistics_epi__impressions
Field label Impressions
Description Number of banner / links impressions
Field type metric
Data type int.number.value
aff_statistics_epi__impressions_unique
Field label Impressions unique
Description Number of unique banner / links impressions
Field type metric
Data type int.number.value
aff_statistics_epi__order_value
Field label Order value
Description Order value of the sale transactions
Field type metric
Data type float.currency.value
aff_statistics_epi__leads
Field label Leads
Description Number of lead transactions
Field type metric
Data type int.number.value
aff_statistics_epi__sales
Field label Sales
Description Number of sale transactions
Field type metric
Data type int.number.value
aff_statistics_epi__ctr
Field label CTR
Description Click Through Ratio, obtained by dividing clicks by impressions
Field type metric
Data type float.number.ratio
aff_statistics_epi__lead_ratio
Field label Lead ratio
Description Lead Ratio, obtained by dividing leads by clicksUnique
Field type metric
Data type float.number.ratio
aff_statistics_epi__conversion_ratio
Field label Conversion ratio
Description Conversion Ratio, obtained by dividing sales by clicksUnique
Field type metric
Data type float.number.ratio
aff_statistics_epi__aov
Field label 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
aff_statistics_epi__epc
Field label EPC
Description Earnings Per Click obtained by dividing the commission by clicksUnique
Field type metric
Data type float.currency.value
aff_statistics_program__clicks
Field label Clicks
Description Number of clicks
Field type metric
Data type int.number.value
aff_statistics_program__clicks_unique
Field label Clicks unique
Description Number of unique clicks
Field type metric
Data type int.number.value
aff_statistics_program__commission
Field label Commission
Description Amount of partner commission
Field type metric
Data type float.currency.value
aff_statistics_program__impressions
Field label Impressions
Description Number of banner / links impressions
Field type metric
Data type int.number.value
aff_statistics_program__impressions_unique
Field label Impressions unique
Description Number of unique banner / links impressions
Field type metric
Data type int.number.value
aff_statistics_program__order_value
Field label Order value
Description Order value of the sale transactions
Field type metric
Data type float.currency.value
aff_statistics_program__leads
Field label Leads
Description Number of lead transactions
Field type metric
Data type int.number.value
aff_statistics_program__sales
Field label Sales
Description Number of sale transactions
Field type metric
Data type int.number.value
aff_statistics_program__ctr
Field label CTR
Description Click Through Ratio, obtained by dividing clicks by impressions
Field type metric
Data type float.number.ratio
aff_statistics_program__lead_ratio
Field label Lead ratio
Description Lead Ratio, obtained by dividing leads by clicksUnique
Field type metric
Data type float.number.ratio
aff_statistics_program__conversion_ratio
Field label Conversion ratio
Description Conversion Ratio, obtained by dividing sales by clicksUnique
Field type metric
Data type float.number.ratio
aff_statistics_program__aov
Field label 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
aff_statistics_program__epc
Field label EPC
Description Earnings Per Click obtained by dividing the commission by clicksUnique
Field type metric
Data type float.currency.value

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
adv_statistics_days__year
Field label Year
Field type dimension
Data type string.time.year
adv_statistics_days__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
adv_statistics_days__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
adv_statistics_days__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
adv_statistics_days__month
Field label Month
Field type dimension
Data type string.time.month
adv_statistics_days__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
adv_statistics_days__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
adv_statistics_days__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
adv_statistics_days__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
adv_statistics_days__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
adv_statistics_days__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
adv_statistics_days__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
adv_statistics_days__date
Field label Date
Field type dimension
Data type string.time.date
adv_statistics_days__atom
Field label Datetime
Field type dimension
Data type string.time.datetime
aff_statistics_day__year
Field label Year
Field type dimension
Data type string.time.year
aff_statistics_day__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
aff_statistics_day__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
aff_statistics_day__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
aff_statistics_day__month
Field label Month
Field type dimension
Data type string.time.month
aff_statistics_day__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
aff_statistics_day__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
aff_statistics_day__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
aff_statistics_day__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
aff_statistics_day__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
aff_statistics_day__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
aff_statistics_day__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
aff_statistics_day__date
Field label Date
Field type dimension
Data type string.time.date
aff_statistics_day__atom
Field label Datetime
Field type dimension
Data type string.time.datetime

TRANSACTION

adv_transactions__unique_id
Field label Unique ID
Description Unique ID for the transaction
Field type dimension
Data type string.text.value
adv_transactions__transaction_name
Field label Transaction name
Description Name of the transaction
Field type dimension
Data type string.text.value
adv_transactions__transaction_status
Field label 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__reason_text
Field label 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__payment_status
Field label 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__last_updated
Field label 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
Field label 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__auto_approval_date
Field label 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
aff_transactions__unique_id
Field label Transaction ID
Description Unique ID for the transaction
Field type dimension
Data type string.text.value
aff_transactions__transaction_name
Field label Transaction name
Description Name of the transaction
Field type dimension
Data type string.text.value
aff_transactions__transaction_type
Field label Transaction type
Description Specifies the type of the transaction where: 3 = Sale, 4 = Lead, 31 = iSale (post impression Sale), 41 = iLead (post impression Lead)
Field type dimension
Data type string.text.value
aff_transactions__transaction_status
Field label 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 string.text.value
aff_transactions__currency
Field label Currency
Description Currency in ISO 4217 format
Field type dimension
Data type string.currency.code
aff_transactions__payment_status
Field label 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
aff_transactions__reason_text
Field label Reason text
Description For rejected transactions (transactionStatus = 5) the advertiser can may choose to provide the reason for the transaction being rejected
Field type dimension
Data type string.text.value
aff_transactions__transaction_datetime
Field label Transaction datetime
Description UTC timestamp of when the transaction was reported by the advertiser
Field type dimension
Data type string.time.datetime
aff_transactions__transaction_date
Field label Transaction date
Description UTC date of when the transaction was reported by the advertiser
Field type dimension
Data type string.time.date
aff_transactions__last_updated_datetime
Field label Last updated datetime
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
aff_transactions__last_updated_date
Field label Last updated date
Description UTC 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
aff_transactions__auto_approval_date
Field label Last updated date
Description Date when a pending transaction (transactionStatus = 2) will be automatically approved unless already approved or rejected by the advertiser
Field type dimension
Data type string.time.date
aff_transactions_latest__unique_id
Field label Transaction ID
Description Unique ID for the transaction
Field type dimension
Data type string.text.value
aff_transactions_latest__transaction_name
Field label Transaction name
Description Name of the transaction
Field type dimension
Data type string.text.value
aff_transactions_latest__transaction_type
Field label Transaction type
Description Specifies the type of the transaction where: 3 = Sale, 4 = Lead, 31 = iSale (post impression Sale), 41 = iLead (post impression Lead)
Field type dimension
Data type string.text.value
aff_transactions_latest__transaction_status
Field label 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 string.text.value
aff_transactions_latest__currency
Field label Currency
Description Currency in ISO 4217 format
Field type dimension
Data type string.currency.code
aff_transactions_latest__payment_status
Field label 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
aff_transactions_latest__reason_text
Field label Reason text
Description For rejected transactions (transactionStatus = 5) the advertiser can may choose to provide the reason for the transaction being rejected
Field type dimension
Data type string.text.value
aff_transactions_latest__transaction_datetime
Field label Transaction datetime
Description UTC timestamp of when the transaction was reported by the advertiser
Field type dimension
Data type string.time.datetime
aff_transactions_latest__transaction_date
Field label Transaction date
Description UTC date of when the transaction was reported by the advertiser
Field type dimension
Data type string.time.date
aff_transactions_latest__last_updated_datetime
Field label Last updated datetime
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
aff_transactions_latest__last_updated_date
Field label Last updated date
Description UTC 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
aff_transactions_latest__auto_approval_date
Field label Last updated date
Description Date when a pending transaction (transactionStatus = 2) will be automatically approved unless already approved or rejected by the advertiser
Field type dimension
Data type string.time.date
adv_transactions__count
Field label Number of clicks
Description Number of clicks
Field type metric
Data type int.number.value
adv_transactions__cost
Field label Cost
Description The cost of the transaction, including partner commission and Adtraction network fee
Field type metric
Data type float.currency.value
adv_transactions__order_value
Field label Order value
Description Order value of the transaction
Field type metric
Data type float.currency.value
aff_transactions__count
Field label Count
Description Number of transactions
Field type metric
Data type int.number.value
aff_transactions__commission
Field label Commission
Description The partner commission for the transaction. If the commission amount has been updated after the creation of the transaction, this parameter will hold the updated commission amount
Field type metric
Data type float.currency.value
aff_transactions__order_value
Field label Order value
Description Order value of the transaction
Field type metric
Data type float.currency.value
aff_transactions__original_commission
Field label Original commission
Description Partner commission for the transaction. If the commission amount has been updated after the creation of the transaction, this parameter will hold the commission amount that existed before the update
Field type metric
Data type float.currency.value
aff_transactions__original_order_value
Field label Original order value
Description Advertiser order value for the transaction. If the order value has been updated after the creation of the transaction, this parameter will hold the order value that existed before the update
Field type metric
Data type float.currency.value
aff_transactions_latest__count
Field label Count
Description Number of transactions
Field type metric
Data type int.number.value
aff_transactions_latest__commission
Field label Commission
Description The partner commission for the transaction. If the commission amount has been updated after the creation of the transaction, this parameter will hold the updated commission amount
Field type metric
Data type float.currency.value
aff_transactions_latest__order_value
Field label Order value
Description Order value of the transaction
Field type metric
Data type float.currency.value
aff_transactions_latest__original_commission
Field label Original commission
Description Partner commission for the transaction. If the commission amount has been updated after the creation of the transaction, this parameter will hold the commission amount that existed before the update
Field type metric
Data type float.currency.value
aff_transactions_latest__original_order_value
Field label Original order value
Description Advertiser order value for the transaction. If the order value has been updated after the creation of the transaction, this parameter will hold the order value that existed before the update
Field type metric
Data type float.currency.value