Affiliates
Read every affiliate with status, commission rate and type, paid and unpaid earnings, referral and visit counts, and registration date.
AffiliateWP connector · Affiliate program reports
Bring AffiliateWP affiliates, referrals and payouts from your WordPress site into your reports and AI assistants, with commissions, earnings and referral counts.
Updated November 2026
| Amount | Status | Date |
|---|---|---|
| 42.00 | unpaid | 2026-11-10 |
| 18.50 | paid | 2026-11-11 |
| 36.00 | unpaid | 2026-11-12 |
One WordPress site running AffiliateWP is the data source. Referrals and payouts follow your report dates; affiliates show the full list.
Read every affiliate with status, commission rate and type, paid and unpaid earnings, referral and visit counts, and registration date.
See referrals dated in your report dates with commission amount, currency, status, integration and order reference.
List payouts dated in your report dates with amount, method and status.
A blank rate means the affiliate uses your site’s default commission.
3 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.
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.
AffiliateWP referrals dated in the report period with referral ID, affiliate ID, commission amount, currency, status, integration context, order reference, and date.
AffiliateWP payouts dated in the report period with payout ID, affiliate ID, amount, payout method, status, and date.
24 report fields across 3 datasets.
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 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.
Your WordPress site address and an AffiliateWP Public Key and Token from Affiliates, then Tools, then API Keys.
Read-only. Visits and creatives aren’t included. Your site must be on public HTTPS. One report reads up to 20,000 rows.
Create your free account, then choose AffiliateWP in Data sources.
Enter your site address with the AffiliateWP Public Key and Token.
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 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.
Start free, add AffiliateWP and bring its referrals into the tools you already use.