Start free

AffiliateWP connector · Affiliate program reports

Read & reportRead-only source

See which AffiliateWP partners bring in sales.

Bring AffiliateWP affiliates, referrals and payouts from your WordPress site into your reports and AI assistants, with commissions, earnings and referral counts.

  • Rank affiliates by paid and unpaid earnings
  • Track referrals and commissions by month
  • Ask ChatGPT or Claude which partners stopped sending sales
AffiliateWPSheetsSheetsData StudioData StudioChatGPTChatGPTClaudeClaude

Start free Explore the data

Updated November 2026

AffiliateWP reportSample data
AmountStatusDate
42.00unpaid2026-11-10
18.50paid2026-11-11
36.00unpaid2026-11-12
Refreshes on your schedule in Google Sheets

AffiliateWP reporting for one WordPress site

One WordPress site running AffiliateWP is the data source. Referrals and payouts follow your report dates; affiliates show the full list.

Affiliates

Read every affiliate with status, commission rate and type, paid and unpaid earnings, referral and visit counts, and registration date.

Referrals

See referrals dated in your report dates with commission amount, currency, status, integration and order reference.

Payouts

List payouts dated in your report dates with amount, method and status.

Commission rates

A blank rate means the affiliate uses your site’s default 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.

  • Affiliates
  • Referrals
  • Payouts
What each dataset reports
  • Affiliates

    AffiliateWP affiliates with affiliate ID, user ID, status, custom commission rate and rate type (blank when the site default applies), paid and unpaid earnings, referral and visit counts, and registration date.

  • Referrals

    AffiliateWP referrals dated in the report period with referral ID, affiliate ID, commission amount, currency, status, integration context, order reference, and date.

  • Payouts

    AffiliateWP payouts dated in the report period with payout ID, affiliate ID, amount, payout method, status, and date.

Metrics and dimensions

24 report fields across 3 datasets.

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

Send AffiliateWP data anywhere

Connect AffiliateWP to ChatGPT or Claude for affiliate questions

Use Datapipe’s MCP access as your AffiliateWP AI integration. Ask about top partners, commissions and payouts.

Example

Which affiliates sent referrals last quarter but none this month?

Compare each affiliate’s referrals in the two periods and list those with none in the latest one.

Start with AffiliateWP

What you need

Your WordPress site address and an AffiliateWP Public Key and Token from Affiliates, then Tools, then API Keys.

What to know

Read-only. Visits and creatives aren’t included. Your site must be on public HTTPS. One report reads up to 20,000 rows.

How it works

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

  2. Enter your site address with the AffiliateWP Public Key and Token.

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

Works well with AffiliateWP

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 affiliates with their earnings and rates, referrals with commission amounts, and payouts.

No. AffiliateWP is read-only in Datapipe; affiliates, referrals and payouts stay as they are.

No. Each affiliate shows its visit count, but individual visits aren’t listed.

Yes. Datapipe reads your site over public HTTPS, including sites installed in a subfolder.

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 AffiliateWP 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 program in view.

Start free, add AffiliateWP and bring its referrals into the tools you already use.

Start free See setup requirements