Start free

CJ Affiliate connector · Publisher commission reports

Read & reportRead-only source

See your CJ Affiliate commissions in one report.

Bring CJ Affiliate commissions into your reports and AI assistants, with advertiser, action type, status, sale amount, discount and country.

  • Track commissions and sales by advertiser
  • Follow action status from new to locked
  • Ask ChatGPT or Claude which programs pay best
CJ AffiliateSheetsSheetsData StudioData StudioChatGPTChatGPTClaudeClaude

Start free Explore the data

Updated November 2026

CJ Affiliate reportSample data
AdvertiserStatusCommission
Northwind Outdoorlocked$42.50
Harbor Homenew$18.20
Bluebird Booksclosed$6.40
Refreshes on your schedule in Google Sheets

CJ Affiliate reporting for one publisher company

One CJ publisher company is the data source. Commissions are picked by posting date.

Commissions

Read each commission’s posting date, event date, advertiser and publisher commission.

Orders

See the order ID, sale amount and order discount.

Action status

Keep each action’s type and status beside it.

Countries

See the country for each commission.

Report datasets and details

Reports you can build

3 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.

  • Affiliate commissions
  • Performance summary
  • Attributed merchant orders
What each dataset reports
  • Affiliate commissions

    Attributed commissions, merchant sale values, order IDs, and approval status.

  • Performance summary

    Publisher commission and sale totals by posting date, advertiser and country.

  • Attributed merchant orders

    Orders behind attributed commissions, with sale amounts, discounts and status.

Metrics and dimensions

3 metrics and 6 ways to split them.

Search the available fields. Hover or tap a field to see what it means.

Send CJ Affiliate data anywhere

Connect CJ Affiliate to ChatGPT or Claude for commission questions

Use Datapipe’s MCP access as your CJ Affiliate AI integration. Ask which advertisers earn most and what’s locked.

Example

Which advertisers drove the most commission this month, and how much is locked?

Total this month’s commission by advertiser, then sum the commissions whose status is locked.

Start with CJ Affiliate

What you need

A CJ personal access token and your publisher company ID (CID).

What to know

Amounts follow each transaction’s values. Open commissions can still change before they lock.

How it works

  1. Create your free account, then choose CJ Affiliate in Data sources.

  2. Paste a personal access token from the CJ Developer Portal and your company ID. Add Awin or other networks to compare earnings.

  3. Choose a report and destination: a sheet, Data Studio, ChatGPT or Claude.

Works well with CJ Affiliate

Add both to the same project. Each keeps its own report, so you can check them side by side or ask ChatGPT or Claude a question that needs both.

Questions

Datapipe reads commissions with posting and event dates, order ID, action type and status, advertiser, commission, sale amount, discount and country.

Your CJ company ID (CID), shown in the CJ Account Manager. The token’s user must belong to that company.

No. CJ Affiliate is read-only in Datapipe.

Yes. Add Awin or other networks to the same project and report on them together.

Free to start. Paid plans add more data sources and refresh faster.

Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 data sources.

One for each CJ Affiliate account you add to a project. Adding the same account to another project counts again. Reports and destinations do not use extra data sources.

Keep your affiliate earnings in one place.

Start free, add CJ Affiliate and bring your commissions into the tools you already use.

Start free See setup requirements