Start free
Read & reportRead-only source

See your CJ Affiliate numbers in ChatGPT.

Track commission events, merchant order values, and approval statuses across affiliate partnerships.

  • Publisher commissions, order sales amounts and action statuses in one automated partnership report
  • Audit affiliate partner performance and commission payouts without logging into CJ Affiliate portal
  • Report affiliate revenue alongside Google Ads, Facebook Ads and direct store sales in one project
CJ AffiliateChatGPTChatGPT

Start free Connect CJ Affiliate

Updated November 2026

CJ Affiliate reportSample data
Posting dateAdvertiser nameAction status
2026-10-281,240Paid
Oct 28640Pending
Oct 29210Refunded
Refreshes on your schedule in ChatGPT

Who uses Datapipe with CJ Affiliate

Affiliate Marketing Managers

Track publisher commissions, conversion rates and top-performing partners across every product category.

Ecommerce Directors

Evaluate return on affiliate ad spend (ROAS) and validate sales numbers before monthly publisher payouts.

Agency Partner Leads

Send each retail client a transparent affiliate performance report without manual exports.

What you can do with CJ Affiliate

Read and report

Read attributed commissions, order discounts, and action statuses using your CJ Personal Access Token.

  • Affiliate commissions
  • Performance summary
  • Attributed merchant orders

Explore metrics and dimensions

Read-only source

Datapipe reads CJ Affiliate data for reports. It never changes anything in CJ Affiliate.

Full read details

Currency amounts retain transaction values.

Examples for your team

Read & report

Track affiliate commissions and approval statuses

Refresh approved, pending, and locked commission events alongside transaction dates.

  1. Scheduled refresh
  2. Latest CJ Affiliate data
  3. Updated report
Read & report

Analyze merchant order performance

Review attributed sale values, order discounts, and country distributions across retail merchants.

  1. Scheduled refresh
  2. Latest CJ Affiliate data
  3. Updated report

Before you connect

What you need

An API key or token from your CJ Affiliate account.

Read-only

Read access only. Datapipe never changes anything in CJ Affiliate.

Limits and exclusions

Read-only.

Full details and limits

Publisher commissions, order values, merchant details, and approval statuses from CJ Commission Junction.

Reporting reads commissions, orders, and performance. CJ Affiliate integration is strictly read-only for affiliate earnings tracking.

Read-only. Open commissions can still change before they lock.

Reports you can build

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

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.

Hover or tap a field to see what it means. Custom fields from your own account appear after you connect.

Send CJ Affiliate data anywhere

Ask AI about your data

Claude or ChatGPT can read the same numbers. You ask in a normal sentence, and the answer stays with your report.

Which advertisers paid us the most commission in CJ this month?

Outdoor Gear Co. led with $1,240 in commission on $15,500 of sales, ahead of Travel Pack ($610) and Home Basics ($420).

Better than exporting by hand

Start from a goal

How it works

  1. Create a project and choose CJ Affiliate in Data sources.

  2. Pick where it goes. This one sends the numbers to ChatGPT.

  3. Pick where it goes. Choose commissions and a destination.

Sample report

CJ Affiliate reportSample data
Posting dateAdvertiser nameAction statusPublisher commissionSale amount
2026-10-281,240Paid1,240$425.00
Oct 28640Pending640$125.50
Oct 29210Refunded210$42.00

Sample numbers, so you can see the shape. Your report uses your accounts.

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

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.

No. Name a project, add a data source, then choose a report and destination.

OAuth means you sign in with the service and grant access, without pasting an API key. Datapipe works with multiple partners to provide that sign-in. Some partners already provide it. Some integrations are API-only at present, so you paste a key or token. OAuth is coming soon for some. Some partners do not provide OAuth at all. The setup steps on each integration page say how that source connects. Signing in is only how the connection is made. It is not permission to change records. Where a source supports changes, those writes stay off until the workspace owner turns specific actions on and approves each one. We do not promise OAuth on every source, and we do not share dates.

This integration is read-only in Datapipe. You can report on CJ Affiliate, send the reports to your destinations and ask an AI assistant about them. Datapipe never changes anything in CJ Affiliate. Reporting reads commissions, orders, and performance. CJ Affiliate integration is strictly read-only for affiliate earnings tracking.

This page lists 3 metrics and 6 ways to split them. You pick the columns when you build the report.

Publisher commissions, order values, merchant details, and approval statuses from CJ Commission Junction. Account permissions and the records available from the provider determine which rows can be read.

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.

Yes. The same numbers can go to a sheet, a chart, a warehouse, or an assistant.

Try CJ Affiliate with sample data first

Build the report first, then add CJ Affiliate when you are ready.

Start free Add data source