Paid media managers
Check spend and return by campaign every morning.
Review AffiliateWP affiliate earnings, referral conversions and payout history in a read-only data source.
Start free Connect AffiliateWP
Updated November 2026
| Status | Paid earnings | Unpaid earnings |
|---|---|---|
| active | $80.00 | $80.00 |
| Pending | $125.50 | $125.50 |
| Refunded | $42.00 | $42.00 |
Check spend and return by campaign every morning.
See which ads actually bring orders.
Send each client a clear ad report every month, without exporting.
Read affiliates, referrals and payouts using your AffiliateWP Public Key and Token.
Datapipe reads AffiliateWP data for reports. It never changes anything in AffiliateWP.
Commissions and payouts are never modified.
Combine partner referral counts, visit conversion volume and payout totals in one report.
An API key or token from your AffiliateWP account.
Read access only. Datapipe never changes anything in AffiliateWP.
Read-only. Affiliates and referrals are never changed, visits and creatives are not included, and the site must be on public HTTPS.
Affiliates, referrals, and payouts from AffiliateWP.
Read-only reporting access using your AffiliateWP Public Key and Token. Commissions and payouts are never modified.
Read-only. Affiliates and referrals are never changed, visits and creatives are not included, and the site must be on public HTTPS.
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.
Hover or tap a field to see what it means. Custom fields from your own account appear after you connect.
No fields match. Try another search or choose All.
Claude or ChatGPT can read the same numbers. You ask in a normal sentence, and the answer stays with your report.
Summarize AffiliateWP affiliate earnings, unpaid referrals, and recent payouts.
Top 10 active affiliates generated $9,420 across 148 referrals with 100% payouts settled.
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.
Use this template →AffiliateWP referrals dated in the report period with referral ID, affiliate ID, commission amount, currency, status, integration context, order reference, and date.
Use this template →AffiliateWP payouts dated in the report period with payout ID, affiliate ID, amount, payout method, status, and date.
Use this template →Create a project and choose AffiliateWP in Data sources.
Pick where it goes. This one sends the numbers to AWS S3.
Pick where it goes. Choose affiliates, referrals or payouts and a destination.
| Status | Paid earnings | Unpaid earnings | Referrals | Amount | Status | Reference | Date |
|---|---|---|---|---|---|---|---|
| active | $80.00 | $80.00 | 28 | $80.00 | active | 1,240 | Oct 27 |
| Pending | $125.50 | $125.50 | 640 | $125.50 | Pending | 640 | Oct 28 |
| Refunded | $42.00 | $42.00 | 210 | $42.00 | Refunded | 210 | Oct 29 |
Sample numbers, so you can see the shape. Your report uses your accounts.
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.
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 AffiliateWP, send the reports to your destinations and ask an AI assistant about them. Datapipe never changes anything in AffiliateWP. Read-only reporting access using your AffiliateWP Public Key and Token. Commissions and payouts are never modified.
This page lists 24 report fields across 3 datasets. You pick the columns when you build the report.
Affiliates, referrals, and payouts from AffiliateWP. Account permissions and the records available from the provider determine which rows can be read.
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.
Yes. The same numbers can go to a sheet, a chart, a warehouse, or an assistant.
Build the report first, then add AffiliateWP when you are ready.