CJ Affiliate data warehouse table groups

  • Updated on Dec 10, 2025
  • Published on Aug 5, 2025
Prev Next

Table: COMMISSION

account_id
Display name Account ID
Description Account ID
Field type dimension
Data type string.text.value
account_name
Display name Account name
Description Account name
Field type dimension
Data type string.text.value
action_id
Display name Action ID
Description Unique identifier of an advertiser's defined action associated with the commission
Field type dimension
Data type string.text.value
action_name
Display name Action name
Description Name of the action (as specified by the advertiser) for the commission
Field type dimension
Data type string.text.value
action_type
Display name Action type
Description Action type for the commission
Field type dimension
Data type string.text.value
advertiser_commission_adv_currency
Display name Advertiser commission (advertiser currency)
Description Advertiser commission amount in the advertiser's currency
Field type metric
Data type float.currency.value
advertiser_commission_usd
Display name Advertiser commission (USD)
Description Advertiser commission amount in USD
Field type metric
Data type float.currency.value
advertiser_id
Display name Advertiser ID
Description CID of the advertiser for the commission
Field type dimension
Data type string.text.value
advertiser_name
Display name Advertiser name
Description Name of the advertiser for the commission
Field type dimension
Data type string.text.value
cj_fee_adv_currency
Display name CJ fee (advertiser currency)
Description CJ fee in the advertiser's currency
Field type metric
Data type float.currency.value
cj_fee_usd
Display name CJ fee (USD)
Description CJ fee in USD
Field type metric
Data type float.currency.value
commission_id
Display name Commission ID
Description Commission identification number
Field type dimension
Data type string.text.value
commissions
Display name Commissions
Description Total number of commissions
Field type metric
Data type int.number.value
company_id
Display name Company ID
Description Company ID
Field type dimension
Data type string.text.value
coupon
Display name Coupon
Description The coupon/voucher used in 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
date
Display name Date
Field type dimension
Data type string.time.date
event_date
Display name Event date
Description Event date for the commission in UTC time zone
Field type dimension
Data type string.time.date
event_datetime
Display name Event datetime
Description Event datetime for the commission in UTC time zone
Field type dimension
Data type string.time.datetime
is_cross_device
Display name Is cross-device
Description Indicates if a transaction was attributed using cross-device tracking
Field type dimension
Data type bool
locking_date
Display name Locking date
Description Date on which the commission is locked for extending or correcting
Field type dimension
Data type string.time.date
locking_datetime
Display name Locking datetime
Description Datetime on which the commission is locked for extending or correcting
Field type dimension
Data type string.time.datetime
new_to_file
Display name New to file
Description Indicates if the customer is new or existing to the advertiser (advertiser defined)
Field type dimension
Data type bool
order_discount_adv_currency
Display name Order discount (advertiser currency)
Description Discount associated with the order in the advertiser's currency
Field type metric
Data type float.currency.value
order_discount_usd
Display name Order discount (USD)
Description Discount associated with the order in USD
Field type metric
Data type float.currency.value
order_id
Display name Order ID
Description Advertiser-assigned identification number for the order
Field type dimension
Data type string.text.value
original
Display name Original
Description Displays either a '1' indicating an original transaction or a '0' indicating a non-original or corrected transaction
Field type dimension
Data type bool
posting_date
Display name Posting date
Description Date on which the commission is posted
Field type dimension
Data type string.time.date
posting_datetime
Display name Posting datetime
Description Datetime on which the commission is posted
Field type dimension
Data type string.time.datetime
publisher_commission_pub_currency
Display name Publisher commission (publisher currency)
Description Publisher commission amount in the publisher's currency
Field type metric
Data type float.currency.value
publisher_commission_usd
Display name Publisher commission (USD)
Description Publisher commission amount in USD
Field type metric
Data type float.currency.value
publisher_id
Display name Publisher CID
Description CID of the publisher for the commission
Field type dimension
Data type string.text.value
publisher_name
Display name Publisher name
Description Name of the publisher for the commission
Field type dimension
Data type string.text.value
reviewed_status
Display name Reviewed status
Description Indicates if an advertiser has reviewed a transaction
Field type dimension
Data type string.text.value
sale_amount_adv_currency
Display name Sale amount (advertiser currency)
Description Sale amount in the advertiser's currency
Field type metric
Data type float.currency.value
sale_amount_usd
Display name Sale amount (USD)
Description Sale amount in USD
Field type metric
Data type float.currency.value
source
Display name Source
Description Source for the transaction
Field type dimension
Data type string.text.value
status
Display name Status
Description Status of the commission
Field type dimension
Data type string.text.value
website_id
Display name Website ID
Description ID of the publisher website
Field type dimension
Data type string.text.value
website_name
Display name Website name
Description Name of the publisher website
Field type dimension
Data type string.text.value