CJ Affiliate fields

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

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

11 metrics53 dimensions

ACCOUNT

account_id
Field label Account ID
Description Account ID
Field type dimension
Data type string.text.value
account_name
Field label Account name
Description Account name
Field type dimension
Data type string.text.value
company_id
Field label Company ID
Description Company ID
Field type dimension
Data type string.text.value

ACTION

action_name
Field label Action name
Description Name of the action (as specified by the advertiser) for the commission
Field type dimension
Data type string.text.value
action_id
Field label Action ID
Description Unique identifier of an advertiser's defined action associated with the commission
Field type dimension
Data type string.text.value
action_type
Field label Action type
Description Action type for the commission
Field type dimension
Data type string.text.value

ADVERTISER

advertiser_name
Field label Advertiser name
Description Name of the advertiser for the commission
Field type dimension
Data type string.text.value
advertiser_id
Field label Advertiser ID
Description CID of the advertiser for the commission
Field type dimension
Data type string.text.value

COMMISSION

order_id
Field label Order ID
Description Advertiser-assigned identification number for the order
Field type dimension
Data type string.text.value
commission_id
Field label Commission ID
Description Commission identification number
Field type dimension
Data type string.text.value
posting_datetime
Field label Posting datetime
Description Datetime on which the commission is posted
Field type dimension
Data type string.time.datetime
posting_date
Field label Posting date
Description Date on which the commission is posted
Field type dimension
Data type string.time.date
event_datetime
Field label Event datetime
Description Event datetime for the commission in UTC time zone
Field type dimension
Data type string.time.datetime
event_date
Field label Event date
Description Event date for the commission in UTC time zone
Field type dimension
Data type string.time.date
locking_datetime
Field label Locking datetime
Description Datetime on which the commission is locked for extending or correcting
Field type dimension
Data type string.time.datetime
locking_date
Field label Locking date
Description Date on which the commission is locked for extending or correcting
Field type dimension
Data type string.time.date
status
Field label Status
Description Status of the commission
Field type dimension
Data type string.text.value
source
Field label Source
Description Source for the transaction
Field type dimension
Data type string.text.value
coupon
Field label Coupon
Description The coupon/voucher used in the transaction
Field type dimension
Data type string.text.value
new_to_file
Field label New to file
Description Indicates if the customer is new or existing to the advertiser (advertiser defined)
Field type dimension
Data type bool
is_cross_device
Field label Is cross-device
Description Indicates if a transaction was attributed using cross-device tracking
Field type dimension
Data type bool
reviewed_status
Field label Reviewed status
Description Indicates if an advertiser has reviewed a transaction
Field type dimension
Data type string.text.value
original
Field label 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
commissions
Field label Commissions
Description Total number of commissions
Field type metric
Data type int.number.value
sale_amount_usd
Field label Sale amount (USD)
Description Sale amount in USD
Field type metric
Data type float.currency.value
order_discount_usd
Field label Order discount (USD)
Description Discount associated with the order in USD
Field type metric
Data type float.currency.value
advertiser_commission_usd
Field label Advertiser commission (USD)
Description Advertiser commission amount in USD
Field type metric
Data type float.currency.value
publisher_commission_usd
Field label Publisher commission (USD)
Description Publisher commission amount in USD
Field type metric
Data type float.currency.value
cj_fee_usd
Field label CJ fee (USD)
Description CJ fee in USD
Field type metric
Data type float.currency.value
sale_amount_adv_currency
Field label Sale amount (advertiser currency)
Description Sale amount in the advertiser's currency
Field type metric
Data type float.currency.value
order_discount_adv_currency
Field label Order discount (advertiser currency)
Description Discount associated with the order in the advertiser's currency
Field type metric
Data type float.currency.value
advertiser_commission_adv_currency
Field label Advertiser commission (advertiser currency)
Description Advertiser commission amount in the advertiser's currency
Field type metric
Data type float.currency.value
publisher_commission_pub_currency
Field label Publisher commission (publisher currency)
Description Publisher commission amount in the publisher's currency
Field type metric
Data type float.currency.value
cj_fee_adv_currency
Field label CJ fee (advertiser currency)
Description CJ fee in the advertiser's currency
Field type metric
Data type float.currency.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

PUBLISHER

publisher_name
Field label Publisher name
Description Name of the publisher for the commission
Field type dimension
Data type string.text.value
publisher_id
Field label Publisher CID
Description CID of the publisher for the commission
Field type dimension
Data type string.text.value
website_name
Field label Website name
Description Name of the publisher website
Field type dimension
Data type string.text.value
website_id
Field label Website ID
Description ID of the publisher website
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

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
year
Field label Year
Field type dimension
Data type string.time.year
year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Field type dimension
Data type string.time.month
year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
date
Field label Date
Field type dimension
Data type string.time.date
atom
Field label Datetime
Field type dimension
Data type string.time.datetime