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.	dimension
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		dimension
eventDate	eventDate	Event date for the commission in UTC time zone (ISO 8601 format).	dimension
event_date	event_date	Event date for the commission in UTC time zone (ISO 8601 format). This field likely refers to ‘eventDate’.	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_commissionItemId	item_commissionItemId	The unique ID of this item record within a commission.	metric
item_discountAdvCurrency	item_discountAdvCurrency	Item discount amount in the advertiser’s currency.	metric
item_discountPubCurrency	item_discountPubCurrency	Item discount amount in the publisher’s currency.	metric
item_discountUsd	item_discountUsd	Item discount amount in USD.	metric
item_itemListId	item_itemListId	Unique ID of the item list which applies to this item record.	metric
item_perItemSaleAmountAdvCurrency	item_perItemSaleAmountAdvCurrency	Per-item sale amount in the advertiser’s currency.	metric
item_perItemSaleAmountPubCurrency	item_perItemSaleAmountPubCurrency	Per-item sale amount in the publisher’s currency.	metric
item_perItemSaleAmountUsd	item_perItemSaleAmountUsd	Per-item sale amount in USD.	metric
item_quantity	item_quantity	Quantity of the item.	metric
item_sku	item_sku	Advertiser’s unique identifier (SKU) for the item.	dimension
item_totalCommissionAdvCurrency	item_totalCommissionAdvCurrency	Total commission for the specified quantity of the item in the advertiser’s currency.	metric
item_totalCommissionPubCurrency	item_totalCommissionPubCurrency	Total commission for the specified quantity of the item in the publisher’s currency.	metric
item_totalCommissionUsd	item_totalCommissionUsd	Total commission for the specified quantity of the item in USD.	metric
lockingDate	lockingDate	Date on which the commission is locked for extending or correcting in UTC time zone (ISO 8601 format).	dimension
newToFile	newToFile	Advertiser-defined flag indicating if the customer is new or existing to the advertiser (Advertiser-only attribute).	dimension
orderDiscountAdvCurrency	orderDiscountAdvCurrency	Discount associated with the order in the advertiser’s currency.	metric
orderDiscountOrigCurrency	orderDiscountOrigCurrency	Discount associated with the order in its original 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	Identification number used for correlation between the original transaction and a corrected transaction.	dimension
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.	dimension
publisherName	publisherName	Name of the publisher for this commission.	dimension
reviewedStatus	reviewedStatus	Indicates if an advertiser has reviewed a transaction.	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