Awin fields

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

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

79 metrics110 dimensions

ACCOUNT

pub__advertiser_id
Field label Advertiser ID
Description ID of the advertiser
Field type dimension
Data type string.text.value
pub__advertiser_name
Field label Advertiser name
Description Name of the advertiser
Field type dimension
Data type string.text.value
pub__publisher_id
Field label Publisher ID
Description ID of the publisher
Field type dimension
Data type string.text.value
pub__publisher_name
Field label Publisher name
Description Name of the publisher
Field type dimension
Data type string.text.value
pub__creative_id
Field label Creative ID
Field type dimension
Data type string.text.value
pub__creative_name
Field label Creative name
Description Name of the creative
Field type dimension
Data type string.text.value
pub__tag_name
Field label Tag name
Description Tag name of the creative, used by the advertiser to group creatives
Field type dimension
Data type string.text.value
pub_dwh__advertiser_id
Field label Advertiser ID
Description ID of the advertiser
Field type dimension
Data type string.text.value
pub_dwh__advertiser_name
Field label Advertiser name
Description Name of the advertiser
Field type dimension
Data type string.text.value
pub_dwh__publisher_id
Field label Publisher ID
Description ID of the publisher
Field type dimension
Data type string.text.value
pub_dwh__publisher_name
Field label Publisher name
Description Name of the publisher
Field type dimension
Data type string.text.value
pub_dwh__creative_id
Field label Creative ID
Field type dimension
Data type string.text.value
pub_dwh__creative_name
Field label Creative name
Description Name of the creative
Field type dimension
Data type string.text.value
pub_dwh__tag_name
Field label Tag name
Description Tag name of the creative, used by the advertiser to group creatives
Field type dimension
Data type string.text.value
crea__advertiser_id
Field label Advertiser ID
Description ID of the advertiser
Field type dimension
Data type string.text.value
crea__advertiser_name
Field label Advertiser name
Description Name of the advertiser
Field type dimension
Data type string.text.value
crea__publisher_id
Field label Publisher ID
Description ID of the publisher
Field type dimension
Data type string.text.value
crea__publisher_name
Field label Publisher name
Description Name of the publisher
Field type dimension
Data type string.text.value
crea__creative_id
Field label Creative ID
Field type dimension
Data type string.text.value
crea__creative_name
Field label Creative name
Description Name of the creative
Field type dimension
Data type string.text.value
crea__tag_name
Field label Tag name
Description Tag name of the creative, used by the advertiser to group creatives
Field type dimension
Data type string.text.value
crea_dwh__advertiser_id
Field label Advertiser ID
Description ID of the advertiser
Field type dimension
Data type string.text.value
crea_dwh__advertiser_name
Field label Advertiser name
Description Name of the advertiser
Field type dimension
Data type string.text.value
crea_dwh__publisher_id
Field label Publisher ID
Description ID of the publisher
Field type dimension
Data type string.text.value
crea_dwh__publisher_name
Field label Publisher name
Description Name of the publisher
Field type dimension
Data type string.text.value
crea_dwh__creative_id
Field label Creative ID
Field type dimension
Data type string.text.value
crea_dwh__creative_name
Field label Creative name
Description Name of the creative
Field type dimension
Data type string.text.value
crea_dwh__tag_name
Field label Tag name
Description Tag name of the creative, used by the advertiser to group creatives
Field type dimension
Data type string.text.value

ADVERTISER

trans__advertiser_id
Field label Advertiser ID
Description ID of the advertiser
Field type dimension
Data type string.text.value
trans__advertiser_country
Field label Advertiser country
Description The country of the advertiser
Field type dimension
Data type string.geo.country.twolettercode

CLICK

trans__click_ref
Field label Click reference
Description Click reference for transaction
Field type dimension
Data type string.text.value
trans__click_date
Field label Click date
Description The date of the click
Field type dimension
Data type string.time.date
trans__click_date_time
Field label Click date and time
Description The date and time of the click
Field type dimension
Data type string.time.datetime
trans__click_device
Field label Click device
Description Device where click happened
Field type dimension
Data type string.text.value

COMMISSION

trans__order_ref
Field label Order reference
Description The reference of the order
Field type dimension
Data type string.text.value
trans__sale_currency
Field label Sale currency
Description Currency of the sale
Field type dimension
Data type string.text.value
trans__commission_currency
Field label Commission currency
Description Currency of the commission
Field type dimension
Data type string.text.value
trans__commission_status
Field label Commission status
Description Status of the commission
Field type dimension
Data type string.text.value
trans__paid_to_publisher
Field label Paid to publisher
Description Whether transaction commission has been paid to publisher or not
Field type dimension
Data type bool
trans__payment_id
Field label Payment ID
Description The unique ID of the payment
Field type dimension
Data type string.text.value

CUSTOMER

trans__customer_country
Field label Customer country
Description Country of the customer
Field type dimension
Data type string.text.value
trans__ip_hash
Field label IP hash
Description Hash of the IP address
Field type dimension
Data type string.text.value

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

PERFORMANCE

pub__impressions
Field label Impressions
Description Number of impressions
Field type metric
Data type int.number.value
pub__clicks
Field label Clicks
Description Number of clicks
Field type metric
Data type int.number.value
pub__ctr
Field label CTR
Description Clicks / Impressions
Field type metric
Data type float.number.percentage
pub_dwh__impressions
Field label Impressions
Description Number of impressions
Field type metric
Data type int.number.value
pub_dwh__clicks
Field label Clicks
Description Number of clicks
Field type metric
Data type int.number.value
pub_dwh__ctr
Field label CTR
Description Clicks / Impressions
Field type metric
Data type float.number.percentage
crea__impressions
Field label Impressions
Description Number of impressions
Field type metric
Data type int.number.value
crea__clicks
Field label Clicks
Description Number of clicks
Field type metric
Data type int.number.value
crea__ctr
Field label CTR
Description Clicks / Impressions
Field type metric
Data type float.number.percentage
crea_dwh__impressions
Field label Impressions
Description Number of impressions
Field type metric
Data type int.number.value
crea_dwh__clicks
Field label Clicks
Description Number of clicks
Field type metric
Data type int.number.value
crea_dwh__ctr
Field label CTR
Description Clicks / Impressions
Field type metric
Data type float.number.percentage

PUBLISHER

trans__publisher_id
Field label Publisher ID
Description ID of the publisher
Field type dimension
Data type string.text.value
trans__site_name
Field label Site name
Description Name of the site
Field type dimension
Data type string.text.value
trans__publisher_url
Field label Publisher URL
Description The URL of the publisher
Field type dimension
Data type string.text.url
trans__commission_sharing_publisher_id
Field label Commission sharing publisher ID
Description ID of the commission sharing publisher
Field type dimension
Data type string.text.value
trans__commission_sharing_selected_rate_publisher_id
Field label Commission sharing selected rate publisher ID
Description ID of the commission sharing selected rate publisher
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

REGION

pub__region
Field label Region
Field type dimension
Data type string.geo.country.twolettercode
pub__currency
Field label Currency
Field type dimension
Data type string.currency.code
pub_dwh__region
Field label Region
Field type dimension
Data type string.geo.country.twolettercode
pub_dwh__currency
Field label Currency
Field type dimension
Data type string.currency.code
crea__region
Field label Region
Field type dimension
Data type string.geo.country.twolettercode
crea__currency
Field label Currency
Field type dimension
Data type string.currency.code
crea_dwh__region
Field label Region
Field type dimension
Data type string.geo.country.twolettercode
crea_dwh__currency
Field label Currency
Field type dimension
Data type string.currency.code

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
pub__year
Field label Year
Description Year
Field type dimension
Data type string.time.year
pub__yearmonth
Field label Year & month
Description Year and month
Field type dimension
Data type string.time.yearmonth
pub__month
Field label Month
Description Month
Field type dimension
Data type string.time.month
pub_dwh__year
Field label Year
Description Year
Field type dimension
Data type string.time.year
pub_dwh__yearmonth
Field label Year & month
Description Year and month
Field type dimension
Data type string.time.yearmonth
pub_dwh__month
Field label Month
Description Month
Field type dimension
Data type string.time.month
pub_dwh__date
Field label Date
Description Date
Field type dimension
Data type string.time.date
crea__year
Field label Year
Description Year
Field type dimension
Data type string.time.year
crea__yearmonth
Field label Year & month
Description Year and month
Field type dimension
Data type string.time.yearmonth
crea__month
Field label Month
Description Month
Field type dimension
Data type string.time.month
crea_dwh__year
Field label Year
Description Year
Field type dimension
Data type string.time.year
crea_dwh__yearmonth
Field label Year & month
Description Year and month
Field type dimension
Data type string.time.yearmonth
crea_dwh__month
Field label Month
Description Month
Field type dimension
Data type string.time.month
crea_dwh__date
Field label Date
Description Date
Field type dimension
Data type string.time.date
trans__year
Field label Year
Field type dimension
Data type string.time.year
trans__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
trans__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
trans__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
trans__month
Field label Month
Field type dimension
Data type string.time.month
trans__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
trans__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
trans__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
trans__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
trans__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
trans__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
trans__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
trans__date
Field label Date
Field type dimension
Data type string.time.date
trans__atom
Field label Datetime
Field type dimension
Data type string.time.datetime

TRANSACTION

trans__campaign
Field label Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
trans__transaction_id
Field label Transaction ID
Description ID of the transaction
Field type dimension
Data type string.text.value
trans__transaction_query_id
Field label Transaction query ID
Description The unique ID of the transaction query
Field type dimension
Data type string.text.value
trans__type
Field label Transaction type
Description The type of the transaction
Field type dimension
Data type string.text.value
trans__transaction_url
Field label Transaction URL
Description URL of the transaction
Field type dimension
Data type string.text.url
trans__transaction_date
Field label Transaction date
Description The date and time of the click
Field type dimension
Data type string.time.date
trans__transaction_date_time
Field label Transaction date and time
Description The date and time of the transaction
Field type dimension
Data type string.time.datetime
trans__decline_reason
Field label Transaction decline reason
Description The decline reason of the transaction
Field type dimension
Data type string.text.value
trans__transaction_device
Field label Transaction device
Description Device where transaction happened
Field type dimension
Data type string.text.value
trans__voucher_code_used
Field label Voucher code used
Description Whether voucher code was used or not for transaction
Field type dimension
Data type bool
trans__voucher_code
Field label Voucher code
Description The voucher code that was used for the transaction
Field type dimension
Data type string.text.value
trans__amended
Field label Amended
Description Whether transaction has been amended or not
Field type dimension
Data type bool
trans__amend_reason
Field label Amend reason
Description Reason why transaction was amended
Field type dimension
Data type string.text.value
trans__transaction_parts
Field label Transaction parts
Description Transaction parts
Field type dimension
Data type string.text.value
trans__custom_parameters
Field label Custom parameters
Description List of custom parameters and values
Field type dimension
Data type string.text.value
trans__commission_amount
Field label Commission amount
Description The amount of commission
Field type metric
Data type float.currency.value
trans__sale_amount
Field label Sale amount
Description The amount of sale
Field type metric
Data type float.currency.value
trans__old_sale_amount
Field label Old sale amount
Field type metric
Data type float.currency.value
trans__old_commission_amount
Field label Old commission amount
Field type metric
Data type float.currency.value
trans__original_sale_amount
Field label Original sale amount
Description The original sale amount
Field type metric
Data type float.currency.value
trans__lapse_time
Field label Lapse time
Description The conversion time in seconds
Field type metric
Data type int.number.value
trans__network_fee
Field label Network fee
Description Network fee of the transactions
Field type metric
Data type float.currency.value

TRANSACTIONS

pub__pending_no
Field label Pending transactions
Description Number of pending transactions
Field type metric
Data type int.number.value
pub__pending_value
Field label Pending value
Description Value of pending transactions
Field type metric
Data type float.currency.value
pub__pending_comm
Field label Pending commission
Description Commission of the pending transactions
Field type metric
Data type float.currency.value
pub__confirmed_no
Field label Confirmed transactions
Description Number of confirmed transactions
Field type metric
Data type int.number.value
pub__confirmed_value
Field label Confirmed value
Description Value of confirmed transactions
Field type metric
Data type float.currency.value
pub__confirmed_comm
Field label Confirmed commission
Description Commission of the confirmed transactions
Field type metric
Data type float.currency.value
pub__bonus_no
Field label Bonus transactions
Description Number of bonus transactions
Field type metric
Data type int.number.value
pub__bonus_value
Field label Bonus value
Description Value of the bonus transactions
Field type metric
Data type float.currency.value
pub__bonus_comm
Field label Bonus commission
Description Commission of the bonus transactions
Field type metric
Data type float.currency.value
pub__total_no
Field label Total transactions
Description Total number of transactions
Field type metric
Data type int.number.value
pub__total_value
Field label Total value
Description Total value of transactions
Field type metric
Data type float.currency.value
pub__total_comm
Field label Total commission
Description Commission of the all transactions
Field type metric
Data type float.currency.value
pub__declined_no
Field label Declined transactions
Description Number of declined transactions
Field type metric
Data type int.number.value
pub__declined_value
Field label Declined value
Description Value of the declined transactions
Field type metric
Data type float.currency.value
pub__declined_comm
Field label Declined commission
Description Commission of the declined transactions
Field type metric
Data type float.currency.value
pub_dwh__pending_no
Field label Pending transactions
Description Number of pending transactions
Field type metric
Data type int.number.value
pub_dwh__pending_value
Field label Pending value
Description Value of pending transactions
Field type metric
Data type float.currency.value
pub_dwh__pending_comm
Field label Pending commission
Description Commission of the pending transactions
Field type metric
Data type float.currency.value
pub_dwh__confirmed_no
Field label Confirmed transactions
Description Number of confirmed transactions
Field type metric
Data type int.number.value
pub_dwh__confirmed_value
Field label Confirmed value
Description Value of confirmed transactions
Field type metric
Data type float.currency.value
pub_dwh__confirmed_comm
Field label Confirmed commission
Description Commission of the confirmed transactions
Field type metric
Data type float.currency.value
pub_dwh__bonus_no
Field label Bonus transactions
Description Number of bonus transactions
Field type metric
Data type int.number.value
pub_dwh__bonus_value
Field label Bonus value
Description Value of the bonus transactions
Field type metric
Data type float.currency.value
pub_dwh__bonus_comm
Field label Bonus commission
Description Commission of the bonus transactions
Field type metric
Data type float.currency.value
pub_dwh__total_no
Field label Total transactions
Description Total number of transactions
Field type metric
Data type int.number.value
pub_dwh__total_value
Field label Total value
Description Total value of transactions
Field type metric
Data type float.currency.value
pub_dwh__total_comm
Field label Total commission
Description Commission of the all transactions
Field type metric
Data type float.currency.value
pub_dwh__declined_no
Field label Declined transactions
Description Number of declined transactions
Field type metric
Data type int.number.value
pub_dwh__declined_value
Field label Declined value
Description Value of the declined transactions
Field type metric
Data type float.currency.value
pub_dwh__declined_comm
Field label Declined commission
Description Commission of the declined transactions
Field type metric
Data type float.currency.value
crea__pending_no
Field label Pending transactions
Description Number of pending transactions
Field type metric
Data type int.number.value
crea__pending_value
Field label Pending value
Description Value of pending transactions
Field type metric
Data type float.currency.value
crea__pending_comm
Field label Pending commission
Description Commission of the pending transactions
Field type metric
Data type float.currency.value
crea__confirmed_no
Field label Confirmed transactions
Description Number of confirmed transactions
Field type metric
Data type int.number.value
crea__confirmed_value
Field label Confirmed value
Description Value of confirmed transactions
Field type metric
Data type float.currency.value
crea__confirmed_comm
Field label Confirmed commission
Description Commission of the confirmed transactions
Field type metric
Data type float.currency.value
crea__bonus_no
Field label Bonus transactions
Description Number of bonus transactions
Field type metric
Data type int.number.value
crea__bonus_value
Field label Bonus value
Description Value of the bonus transactions
Field type metric
Data type float.currency.value
crea__bonus_comm
Field label Bonus commission
Description Commission of the bonus transactions
Field type metric
Data type float.currency.value
crea__total_no
Field label Total transactions
Description Total number of transactions
Field type metric
Data type int.number.value
crea__total_value
Field label Total value
Description Total value of transactions
Field type metric
Data type float.currency.value
crea__total_comm
Field label Total commission
Description Commission of the all transactions
Field type metric
Data type float.currency.value
crea__declined_no
Field label Declined transactions
Description Number of declined transactions
Field type metric
Data type int.number.value
crea__declined_value
Field label Declined value
Description Value of the declined transactions
Field type metric
Data type float.currency.value
crea__declined_comm
Field label Declined commission
Description Commission of the declined transactions
Field type metric
Data type float.currency.value
crea_dwh__pending_no
Field label Pending transactions
Description Number of pending transactions
Field type metric
Data type int.number.value
crea_dwh__pending_value
Field label Pending value
Description Value of pending transactions
Field type metric
Data type float.currency.value
crea_dwh__pending_comm
Field label Pending commission
Description Commission of the pending transactions
Field type metric
Data type float.currency.value
crea_dwh__confirmed_no
Field label Confirmed transactions
Description Number of confirmed transactions
Field type metric
Data type int.number.value
crea_dwh__confirmed_value
Field label Confirmed value
Description Value of confirmed transactions
Field type metric
Data type float.currency.value
crea_dwh__confirmed_comm
Field label Confirmed commission
Description Commission of the confirmed transactions
Field type metric
Data type float.currency.value
crea_dwh__bonus_no
Field label Bonus transactions
Description Number of bonus transactions
Field type metric
Data type int.number.value
crea_dwh__bonus_value
Field label Bonus value
Description Value of the bonus transactions
Field type metric
Data type float.currency.value
crea_dwh__bonus_comm
Field label Bonus commission
Description Commission of the bonus transactions
Field type metric
Data type float.currency.value
crea_dwh__total_no
Field label Total transactions
Description Total number of transactions
Field type metric
Data type int.number.value
crea_dwh__total_value
Field label Total value
Description Total value of transactions
Field type metric
Data type float.currency.value
crea_dwh__total_comm
Field label Total commission
Description Commission of the all transactions
Field type metric
Data type float.currency.value
crea_dwh__declined_no
Field label Declined transactions
Description Number of declined transactions
Field type metric
Data type int.number.value
crea_dwh__declined_value
Field label Declined value
Description Value of the declined transactions
Field type metric
Data type float.currency.value
crea_dwh__declined_comm
Field label Declined commission
Description Commission of the declined transactions
Field type metric
Data type float.currency.value