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.

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