Cj Affiliate: Most-used fields
The table below gives information about most-used fields that you can import from Cj Affiliate. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
actionStatusDimension
Status of the commission. Possible values include 'closed', 'extended', 'locked', and 'new'.
actionTrackerIdDimension
Unique identifier of an advertiser's defined action associated with the commission.
actionTrackerNameDimension
Name of the action, as specified by the advertiser, for that commission.
actionTypeDimension
Action type for the commission. Examples include 'bonus', 'click', 'imp', 'item_lead', 'item_sale', 'perf_inc', 'sim_lead', and 'sim_sale'.
adOwnerDimension
Displays the company ID (CID) of the advertiser through which the link was clicked. This field only applies to cross-correlated accounts.
advCommissionAmountAdvCurrencyMetric
Advertiser commission amount in the advertiser's currency (Advertiser-only attribute).
advCommissionAmountUsdMetric
Advertiser commission amount in USD (Advertiser-only attribute).
advertiserIdMetric
Company ID (CID) of the advertiser for this commission.
advertiserNameDimension
Name of the advertiser for this commission.
aidDimension
Ad identification number.
cjFeeAdvCurrencyMetric
CJ fee in the advertiser's currency (Advertiser-only attribute).
cjFeeUsdMetric
CJ fee in USD (Advertiser-only attribute).
clickDateDimension
Click date for the commission in UTC time zone (ISO 8601 format).
clickReferringURLDimension
Click referring URL for the commission.
commissionIdDimension
Commission identification number.
concludingBrowserDimension
The associated browser that the transaction concluded in.
concludingDeviceNameDimension
The associated device name that the transaction concluded in.
concludingDeviceTypeDimension
The associated device type that the transaction concluded in.
countryDimension
Country where the transaction occurred.
couponDimension
The coupon or voucher code used in the transaction.
dateDimension
The date when the transaction was recognized and recorded by the advertiser in CJ reports. This represents when the commission becomes visible or processed within the CJ system. Dates are in UTC ISO 8601 format (e.g., '1999-12-31T11:59:59Z').
eventDateDimension
Event date for the commission in UTC time zone (ISO 8601 format).
initiatingBrowserDimension
The associated browser that the transaction initiated in.
initiatingDeviceNameDimension
The associated device name that the transaction initiated in.
initiatingDeviceTypeDimension
The associated device type that the transaction initiated in.
isCrossDeviceDimension
Indicates if a transaction was attributed using cross-device tracking ('true' or 'false').
item_perItemSaleAmountUsdDimension
Per-item sale amount in USD.
item_quantityDimension
Quantity of the item.
item_skuDimension
Advertiser's unique identifier (SKU) for the item.
item_totalCommissionUsdDimension
Total commission for the specified quantity of the item in USD.
orderDiscountAdvCurrencyMetric
Discount associated with the order in the advertiser's currency.
orderDiscountPubCurrencyMetric
Discount associated with the order in the publisher's currency.
orderDiscountUsdMetric
Discount associated with the order in USD.
orderIdDimension
The advertiser-assigned identification number for the entire transaction or order.
originalDimension
Indicates if a transaction is an original ('true' or '1') or a non-original/corrected ('false' or '0') transaction.
postingDateDimension
Date on which the commission is posted in UTC time zone (ISO 8601 format).
pubCommissionAmountPubCurrencyMetric
Publisher commission amount in the publisher's currency.
pubCommissionAmountUsdMetric
Publisher commission amount in USD.
publisherIdDimension
Company ID (CID) of the publisher for this commission.
publisherNameDimension
Name of the publisher for this commission.
saleAmountAdvCurrencyMetric
Sale amount in the advertiser's currency.
saleAmountPubCurrencyMetric
Sale amount in the publisher's currency.
saleAmountUsdMetric
Sale amount in USD.
siteToStoreOfferDimension
Displays the coupon code used, indicating it was a site-to-store offer transaction.
sourceDimension
Source for the transaction.
websiteIdDimension
Publisher website identification number.
websiteNameDimension
Publisher website name.