Integrating Commission Junction into Clarisights

Commission Junction (CJ Affiliate) is one of the world's largest affiliate networks. Connecting CJ to Clarisights lets you analyze publisher-level performance, commissions, and transaction-level dimensions side-by-side with your other paid channels and your web / mobile analytics data.

At a glance

Authentication	CJ Personal Access Token (Bearer) + your CJ Advertiser Account ID
Permissions needed	Token must have access to the CJ advertiserCommissions GraphQL API for the advertiser ID you're connecting
Account discovery	Manual — CJ requires the Advertiser Account ID up front; one Clarisights connector = one CJ advertiser
Data freshness	Daily
Lookback window	Rolling lookback on the daily refresh; CJ also resurfaces commissions when their state changes (locked, extended, corrected)
Backfill on connect	Last 30 days
Timezone	UTC (CJ's eventDate is UTC; converted into account timezone on ingest)
Currency	Both advertiser-local currency and USD are pulled per commission; converted to your reporting currency by Clarisights
Levels supported	Account · Publisher · Commission (transaction)
Limited rollout	No

Prerequisites

• An active CJ advertiser account.

• A CJ Personal Access Token from the CJ Developer Portal. The token must belong to a user authorized for the advertiser you want to connect.

• Your CJ Advertiser Account ID from the CJ Members area.

Steps to Connect

Step 1 — Generate a CJ Personal Access Token

Sign in to the CJ Developer Portal and create a Personal Access Token. Copy the full token value.

[TODO: Screenshot of CJ Developer Portal token creation page]

Treat your access token like a password. It grants read access to commission data for every advertiser the underlying CJ user is authorized for.

Step 2 — Find your Advertiser Account ID

In the CJ Members area, open Account → Account Manager (or any account-settings page) and copy the Advertiser ID. If you have multiple CJ advertisers, you'll connect each one separately.

[TODO: Screenshot of CJ Members area showing Advertiser ID]

Step 3 — Add CJ Affiliate in Clarisights

In Clarisights, go to the Integrations page, search for CJ Affiliate, and click Add Account.

Step 4 — Enter credentials

Fill in:

• Account ID — your CJ Advertiser Account ID

• API Access Token — the Personal Access Token from Step 1

Click Connect Source. Clarisights validates the token by issuing a sample advertiserCommissions GraphQL query against your account ID.

⚠ "No authorized advertiser ids were specified in the query" → The token's CJ user is not authorized for the Advertiser ID you entered. Ask your CJ admin to grant access, or use a token from a user who already has access.
⚠ 401 Unauthorized → The token is invalid or expired. Re-issue from the Developer Portal and retry.

Verify the connection

• Go to Integrations → CJ Affiliate. The connected advertiser should show with its Account ID.

• First data appears within ~24 hours. We backfill the last 30 days on connect, then the daily refresh keeps it current.

• Quick start: create a new report, add CJ Affiliate as the data source, and add Account · Publisher · Sale Amount · Commission · Transaction.

Data available

Hierarchy

How CJ's native levels map to the standard Clarisights levels:

Native level (CJ)	Clarisights level
Advertiser	Account
Publisher	Publisher (the primary spend-bearing level; aggregates sit here. In cross-channel reports the Publisher fills the Campaign slot.)
Commission	Commission / Transaction (each row from the advertiserCommissions query becomes a transaction-level row with order, vertical, and event metadata)

Note: CJ does not have native Campaign / Ad Group / Creative / Link-level reporting in this API. Tracking-link metadata flows in via verticalAttributes.campaignName on each commission.

Dimensions

Dimension	Level	Description
Account / Account ID	Account	CJ advertiser name and Advertiser Account ID
Publisher / Publisher ID	Publisher	CJ publisher name and ID
UTM Campaign	Publisher	Used for dereferencing CJ data to your analytics channel (CA / GA)
Commission ID	Commission	Unique ID of the commission event
Order ID	Commission	Advertiser-side order identifier
Action Tracker	Commission	CJ action tracker name (the action the commission is paid against)
Website Name	Commission	Publisher website that drove the commission
Click Referring URL	Commission	The URL that drove the click
Concluding Device Type	Commission	Device used at the moment of conversion
Coupon	Commission	Coupon / promo code on the order
Event Date	Commission	UTC timestamp of the conversion event
Original	Commission	true for the originating commission row, false for adjustments / corrections (used to compute Transaction count)
New To File	Commission	CJ's flag indicating new vs. returning customers
Campaign Name	Commission	From verticalAttributes.campaignName — the advertiser's campaign label on the commission
Category / Brand / Item Type / Item Name	Commission	Vertical / product attributes from verticalAttributes
Promotion / Promotion Type	Commission	Promotion attached to the commission

Metrics

Metric	Description
Sale Amount (Local currency)	Sum of all sales in advertiser's local currency
Sale Amount	Sale amount converted to your Clarisights reporting currency
Commission (Local currency)	Sum of commissions paid to publishers, in local currency
Commission	Commission converted to your Clarisights reporting currency
CJ Fee (Local currency)	CJ network fee, in local currency
CJ Fee	CJ Fee converted to your Clarisights reporting currency
Order Discount (Local currency)	Sum of discounts applied to orders, in local currency
Order Discount	Order discount converted to your Clarisights reporting currency
Transaction	Count of originating commissions (rows where original = true)

Limitations & known constraints

• One advertiser per connector: CJ requires the Advertiser ID up front. To onboard multiple CJ advertisers, add one connector per advertiser.

• 200 calls / 5 minutes: CJ throttles each token to 200 requests per 5 minutes. On rate-limit errors, Clarisights waits 5 minutes plus exponential backoff before retrying.

• No Campaign / Ad Group / Link levels: the advertiserCommissions API exposes Publisher and Commission only. Use Campaign Name from verticalAttributes if you need a campaign breakdown.

• No clicks / impressions: the API used does not expose pre-conversion traffic; only commission / sale data flows in.

• Adjustments resurface: when a commission's state changes (locked, declined, corrected), CJ returns it again with original = false. This is correct behavior; counting Transaction uses only originating rows to avoid double-counting.

Operating notes

• Refresh schedule: daily.

• Lookback: rolling on each refresh; CJ resurfaces locked / corrected commissions automatically and we upsert by commissionId.

• Pagination: CJ uses cursor-based pagination on maxCommissionId; Clarisights walks all pages until payloadComplete is true.

• Currency conversion: CJ exposes both advertiser-local and USD-denominated values per commission. Clarisights stores the local-currency value and converts to your reporting currency.

• Credential rotation: re-issue the Personal Access Token any time and update it in Integrations → CJ Affiliate → Edit Account.

Need help?

When contacting support from the in-app messenger, please include:

• The integration name and CJ Advertiser Account ID

• The exact error message or screenshot

• The step where the issue occurred

• When the issue started