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.
actionStatus Dimension
Status of the commission. Possible values include 'closed', 'extended', 'locked', and 'new'.
actionTrackerId Dimension
Unique identifier of an advertiser's defined action associated with the commission.
actionTrackerName Dimension
Name of the action, as specified by the advertiser, for that commission.
actionType Dimension
Action type for the commission. Examples include 'bonus', 'click', 'imp', 'item_lead', 'item_sale', 'perf_inc', 'sim_lead', and 'sim_sale'.
adOwner Dimension
Displays the company ID (CID) of the advertiser through which the link was clicked. This field only applies to cross-correlated accounts.
advCommissionAmountAdvCurrency Metric
Advertiser commission amount in the advertiser's currency (Advertiser-only attribute).
advCommissionAmountUsd Metric
Advertiser commission amount in USD (Advertiser-only attribute).
advertiserId Metric
Company ID (CID) of the advertiser for this commission.
advertiserName Dimension
Name of the advertiser for this commission.
aid Dimension
Ad identification number.
cjFeeAdvCurrency Metric
CJ fee in the advertiser's currency (Advertiser-only attribute).
cjFeeUsd Metric
CJ fee in USD (Advertiser-only attribute).
clickDate Dimension
Click date for the commission in UTC time zone (ISO 8601 format).
clickReferringURL Dimension
Click referring URL for the commission.
commissionId Dimension
Commission identification number.
concludingBrowser Dimension
The associated browser that the transaction concluded in.
concludingDeviceName Dimension
The associated device name that the transaction concluded in.
concludingDeviceType Dimension
The associated device type that the transaction concluded in.
country Dimension
Country where the transaction occurred.
coupon Dimension
The coupon or voucher code used in the transaction.
date Dimension
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').
eventDate Dimension
Event date for the commission in UTC time zone (ISO 8601 format).
initiatingBrowser Dimension
The associated browser that the transaction initiated in.
initiatingDeviceName Dimension
The associated device name that the transaction initiated in.
initiatingDeviceType Dimension
The associated device type that the transaction initiated in.
isCrossDevice Dimension
Indicates if a transaction was attributed using cross-device tracking ('true' or 'false').
item_perItemSaleAmountUsd Dimension
Per-item sale amount in USD.
item_quantity Dimension
Quantity of the item.
item_sku Dimension
Advertiser's unique identifier (SKU) for the item.
item_totalCommissionUsd Dimension
Total commission for the specified quantity of the item in USD.
orderDiscountAdvCurrency Metric
Discount associated with the order in the advertiser's currency.
orderDiscountPubCurrency Metric
Discount associated with the order in the publisher's currency.
orderDiscountUsd Metric
Discount associated with the order in USD.
orderId Dimension
The advertiser-assigned identification number for the entire transaction or order.
original Dimension
Indicates if a transaction is an original ('true' or '1') or a non-original/corrected ('false' or '0') transaction.
postingDate Dimension
Date on which the commission is posted in UTC time zone (ISO 8601 format).
pubCommissionAmountPubCurrency Metric
Publisher commission amount in the publisher's currency.
pubCommissionAmountUsd Metric
Publisher commission amount in USD.
publisherId Dimension
Company ID (CID) of the publisher for this commission.
publisherName Dimension
Name of the publisher for this commission.
saleAmountAdvCurrency Metric
Sale amount in the advertiser's currency.
saleAmountPubCurrency Metric
Sale amount in the publisher's currency.
saleAmountUsd Metric
Sale amount in USD.
siteToStoreOffer Dimension
Displays the coupon code used, indicating it was a site-to-store offer transaction.
source Dimension
Source for the transaction.
websiteId Dimension
Publisher website identification number.
websiteName Dimension
Publisher website name.