How to get these dimensions and metrics in your workspace?	What do you need?
Go to Data > Connect. Click + Connect data source. Search for CJ Affiliate in the search bar, then select it from the search results.	All plans. You also need a CJ personal access token (API key) and your CJ Advertiser ID (CID).

Funnel gets one row per commission for your advertiser account from CJ Affiliate. All monetary values are in USD.

Dimensions

Date: The event date of the commission, in the time zone set for your data source. Same as Event Date.
Event Date: The date of the commission event. Also maps to Date.
Posting Date: The date CJ posted the commission.
Click Date: Click date for the commission.
Commission ID: The commission identification number.
Order ID: The order ID of the commission.
Action Tracker ID: The unique identifier of an advertiser’s defined action associated with the particular commission record.
Action Tracker Name: The name of the action (as specified by the advertiser) associated with the particular commission record.
Action Type: The associated action type for the item.
Advertiser ID: The associated CID of the joined advertiser or publisher.
Advertiser Name: The name of the advertiser.
Publisher ID: The associated CID of the joined advertiser or publisher.
Publisher Name: The name of the publisher.
Website: The name of the publisher website.
Website ID: The ID of the publisher website.
Ad ID: The ID of the ad.
Click Referring URL: Click referring URL for the commission.
Country: The country of the commission.
Brand: The brand of the item(s) purchased. CJ only fills in this field for certain verticals, such as travel and hotels. For other advertisers it's empty. CJ sends brand names URL-encoded, so values look like The+Shelborne+By+Proper instead of The Shelborne By Proper.
Brand ID: The identifier of the brand of the item booked. CJ only fills in this field for certain verticals, such as travel and hotels. For other advertisers it's empty.
Currency: The currency of the monetary metrics. Always USD.

Metrics

Sales and leads

Sales: The number of sale events tracked.
Cancelled Sales: The number of sale events tracked that were cancelled.
Total Sales: The number of sale events tracked including events later cancelled.
Leads: The number of leads events tracked.
Total Leads: The number of leads events tracked including events later cancelled.
Bonus Events: The number of bonus events tracked.

Amounts

Sale Amount: The sale amount for events that weren't cancelled.
Cancelled Sale Amount: The sale amount for cancelled events.
Total Sale Amount: The associated publisher sale amount including sales later cancelled.
Sales Amount Raw: The sales amount that is returned from the API.
Publisher Commission: The associated publisher commission amount.
Cancelled Publisher Commission: The associated cancelled publisher commission amount.
Total Publisher Commission: The associated publisher commission amount including commissions later cancelled.
Publisher Commission Raw: The publisher commission that is returned from the API.
Order Discount: The order discount for events that weren't cancelled.
Cancelled Order Discount: The associated publisher order discount for cancelled events.
Total Order Discount: The associated publisher order discount including discounts for events later cancelled.
Order Discount Raw: The order discount amount that is returned from the API.
CJ Fee: The fee CJ adds on commissions.

Note: CJ returns cancelled events as negative amounts. The Raw metrics show the amounts as CJ returns them. The other amount metrics split them into positive amounts for events that weren't cancelled and for cancelled events.

API documentation

For full field definitions and updates, see the CJ Commission Detail API reference.

Change history

Added Brand and Brand ID

From 12 Oct, 2026, the Brand and Brand ID dimensions are available. CJ only fills them in for certain verticals, such as travel and hotels.

CJ Affiliate: Dimensions and metrics