Start free

Awin connector · Publisher commission reports

Read & reportRead-only source

See your Awin commissions in one report.

Bring Awin transactions into your reports and AI assistants, with advertiser, commission, sale amount, status and validation date.

  • Track commissions and sales by advertiser
  • See which transactions are pending, approved or declined
  • Ask ChatGPT or Claude which programs pay best
AwinSheetsSheetsData StudioData StudioChatGPTChatGPTClaudeClaude

Start free Explore the data

Updated November 2026

Awin reportSample data
AdvertiserStatusCommission
Northwind Outdoorapproved£14.20
Harbor Homepending£8.75
Bluebird Booksdeclined£3.10
Refreshes on your schedule in Google Sheets

Awin reporting for one publisher account

One Awin publisher account is the data source. Transactions are picked by transaction date.

Transactions

Read each transaction’s date, advertiser, sale amount and currency.

Commissions

See the commission amount and its status: pending, approved or declined.

Validation

Keep the validation date and any decline reason beside each transaction.

Countries

See the customer’s country for each transaction.

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 transactions
  • Publisher earnings summary
  • Advertiser reports
What each dataset reports
  • Affiliate transactions

    Tracked sales, commission approval statuses, validation dates, and decline reasons.

  • Publisher earnings summary

    Commission and sale totals by transaction date, advertiser, status and currency.

  • Advertiser reports

    Commission validation timelines, payment currencies, and decline reasons.

Metrics and dimensions

2 metrics and 7 ways to split them.

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

Send Awin data anywhere

Connect Awin to ChatGPT or Claude for commission questions

Use Datapipe’s MCP access as your Awin AI integration. Ask which advertisers earn most and what’s still pending.

Example

Which advertisers paid the most approved commission last quarter, and how much is still pending?

Total approved commission by advertiser for the quarter, then sum pending commission by currency.

Start with Awin

What you need

An Awin API token and your publisher ID.

What to know

Amounts stay in each transaction’s currency. Pending commissions can still be approved or declined.

How it works

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

  2. Paste your Awin API token and publisher ID. Add your other affiliate networks to compare earnings.

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

Works well with Awin

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 your transactions with date, advertiser, commission, sale amount, currency, status, validation date, decline reason and customer country.

No. Each amount stays in its transaction’s currency, so group by currency when you total them.

No. Awin is read-only in Datapipe.

Yes. Add CJ Affiliate 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 Awin 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 Awin and bring your commissions into the tools you already use.

Start free See setup requirements