Commissions
Read each commission’s posting date, event date, advertiser and publisher commission.
CJ Affiliate connector · Publisher commission reports
Bring CJ Affiliate commissions into your reports and AI assistants, with advertiser, action type, status, sale amount, discount and country.
Updated November 2026
| Advertiser | Status | Commission |
|---|---|---|
| Northwind Outdoor | locked | $42.50 |
| Harbor Home | new | $18.20 |
| Bluebird Books | closed | $6.40 |
One CJ publisher company is the data source. Commissions are picked by posting date.
Read each commission’s posting date, event date, advertiser and publisher commission.
See the order ID, sale amount and order discount.
Keep each action’s type and status beside it.
See the country for each commission.
3 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.
Attributed commissions, merchant sale values, order IDs, and approval status.
Publisher commission and sale totals by posting date, advertiser and country.
Orders behind attributed commissions, with sale amounts, discounts and status.
3 metrics and 6 ways to split them.
Search the available fields. Hover or tap a field to see what it means.
No fields match. Try another search or choose All.
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.
A CJ personal access token and your publisher company ID (CID).
Amounts follow each transaction’s values. Open commissions can still change before they lock.
Create your free account, then choose CJ Affiliate in Data sources.
Paste a personal access token from the CJ Developer Portal and your company ID. Add Awin or other networks to compare earnings.
Choose a report and destination: a sheet, Data Studio, ChatGPT or Claude.
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.
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.
Start free, add CJ Affiliate and bring your commissions into the tools you already use.