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	The status of the commissionable action, such as ‘new’, ‘extended’, ‘locked’, ‘cleared’, ‘cancelled’, ‘declined’, or ‘return’.	dimension
actionTrackerId	actionTrackerId	A unique identifier for the advertiser’s defined action that is associated with a specific commission record.	metric
actionTrackerName	actionTrackerName	The name of the action, as defined by the advertiser, associated with the particular commission record.	dimension
actionType	actionType	The type of action that generated the commission, such as ‘sale’, ‘lead’, ‘impression’, or ‘click’.	dimension
adOwner	adOwner	The unique identifier of the advertiser associated with the commission.	metric
advCommissionAmountAdvCurrency	advCommissionAmountAdvCurrency	The commission amount earned by the advertiser, expressed in the advertiser’s functional currency.	metric
advCommissionAmountUsd	advCommissionAmountUsd	The commission amount earned by the advertiser, expressed in US Dollars.	metric
advertiserId	advertiserId	The unique identification number of the advertiser.	metric
advertiserName	advertiserName	The name of the advertiser’s program or company.	dimension
aid	aid	The unique identification number of the ad that led to the commissionable event.	metric
cjFeeAdvCurrency	cjFeeAdvCurrency	The fee charged by CJ Affiliate for the commission, expressed in the advertiser’s functional currency.	metric
cjFeeUsd	cjFeeUsd	The fee charged by CJ Affiliate for the commission, expressed in US Dollars.	metric
clickDate	clickDate	The date and time when the user clicked on the ad or link that initiated the commissionable event.	dimension
clickReferringURL	clickReferringURL	The URL of the page that referred the click leading to the commission.	dimension
commissionId	commissionId	The unique identification number for a specific commission record.	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	The country where the associated transaction or commissionable event occurred.	dimension
coupon	coupon	The coupon code, if any, used by the customer for the transaction.	metric
date	date	The date and time when the commissionable event occurred.	dimension
eventDate	eventDate	The date and time (in UTC timezone) when the commissionable event, such as a sale or lead, actually occurred.	dimension
event_date	event_date	The date and time when the commissionable event, such as a sale or lead, occurred.	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 whether the transaction was attributed using cross-device tracking.	dimension
item_commissionItemId	item_commissionItemId	The unique identification number for a specific item within a commissionable transaction.	metric
item_discountAdvCurrency	item_discountAdvCurrency	The discount amount applied to a specific item within the order, expressed in the advertiser’s functional currency.	metric
item_discountPubCurrency	item_discountPubCurrency	The discount amount applied to a specific item within the order, expressed in the publisher’s functional currency.	metric
item_discountUsd	item_discountUsd	The discount amount applied to a specific item within the order, expressed in US Dollars.	metric
item_itemListId	item_itemListId	The identifier for a specific item within an itemized commission, allowing for granular reporting on products or services.	metric
item_perItemSaleAmountAdvCurrency	item_perItemSaleAmountAdvCurrency	The sale amount for a single item, expressed in the advertiser’s functional currency.	metric
item_perItemSaleAmountPubCurrency	item_perItemSaleAmountPubCurrency	The sale amount for a single item, expressed in the publisher’s functional currency.	metric
item_perItemSaleAmountUsd	item_perItemSaleAmountUsd	The sale amount for a single item, expressed in US Dollars.	metric
item_quantity	item_quantity	The number of units of a specific item purchased in the transaction.	metric
item_situations	item_situations	Additional attributes or specific situations related to a particular item within the commission.	dimension
item_sku	item_sku	The Stock Keeping Unit (SKU) for the purchased item.	dimension
item_totalCommissionAdvCurrency	item_totalCommissionAdvCurrency	The total commission earned for a specific item, expressed in the advertiser’s functional currency.	metric
item_totalCommissionPubCurrency	item_totalCommissionPubCurrency	The total commission earned for a specific item, expressed in the publisher’s functional currency.	metric
item_totalCommissionUsd	item_totalCommissionUsd	The total commission earned for a specific item, expressed in US Dollars.	metric
lockingDate	lockingDate	The date on which the commission is locked, meaning it can no longer be extended or corrected.	dimension
newToFile	newToFile	Advertiser defined, indicates if the customer is new or existing to the advertiser.	dimension
orderDiscountAdvCurrency	orderDiscountAdvCurrency	The total discount amount applied to the entire order, expressed in the advertiser’s functional currency.	metric
orderDiscountOrigCurrency	orderDiscountOrigCurrency	The total discount amount applied to the entire order, expressed in its original transaction currency.	metric
orderDiscountPubCurrency	orderDiscountPubCurrency	The total discount amount applied to the entire order, expressed in the publisher’s functional currency.	metric
orderDiscountUsd	orderDiscountUsd	The total discount amount applied to the entire order, expressed in US Dollars.	metric
orderId	orderId	The advertiser-assigned identification number for the entire transaction or order.	dimension
original	original	Indicates whether the commission record is an original transaction (‘true’ or ‘1’) or a correction/cancellation (‘false’ or ‘0’).	dimension
originalActionId	originalActionId	The identification number used to correlate a corrected or cancelled transaction with its original transaction.	metric
postingDate	postingDate	The date when the commission transaction was posted by CJ Affiliate.	dimension
pubCommissionAmountPubCurrency	pubCommissionAmountPubCurrency	The commission amount earned by the publisher, expressed in the publisher’s functional currency.	metric
pubCommissionAmountUsd	pubCommissionAmountUsd	The commission amount earned by the publisher, expressed in US Dollars.	metric
publisherId	publisherId	The unique identification number of the publisher.	metric
publisherName	publisherName	The name of the publisher.	dimension
reviewedStatus	reviewedStatus	Indicates if an advertiser has reviewed a transaction.	metric
saleAmountAdvCurrency	saleAmountAdvCurrency	The total sale amount of the transaction, expressed in the advertiser’s functional currency.	metric
saleAmountPubCurrency	saleAmountPubCurrency	The total sale amount of the transaction, expressed in the publisher’s functional currency.	metric
saleAmountUsd	saleAmountUsd	The total sale amount of the transaction, expressed in US Dollars.	metric
siteToStoreOffer	siteToStoreOffer	Displays the coupon code used, indicating it was a site to store offer transaction.	dimension
source	source	The source for the transaction.	dimension
websiteId	websiteId	The unique identification number of the publisher’s website through which the commission was generated.	metric
websiteName	websiteName	The name of the publisher’s website.	dimension