# Review One Affiliate's Sales and Payouts

> Shows one affiliate's visits, referrals, conversion rate and earnings against the period before, with their payout history and what is still unpaid.

- Job: [Affiliates & loyalty](https://storeagent.ai/mcp-recipes/job/affiliates/)
- What it does: Read only: looks, never changes anything
- Time saved: ~20 min vs doing it by hand
- Requires: StoreAgent (free plugin, MCP on every plan) + AffiliateWP
- Works in: Claude, ChatGPT, Cursor and any MCP client connected to the store through StoreAgent MCP
- Web page: https://storeagent.ai/mcp-recipes/affiliate-performance-review/

## The prompt

```text
Review the affiliate [name or email]. Show their visits, referrals, conversion rate and earnings for the last 90 days next to the 90 days before. List their payouts this year with date, amount and status, and every referral that is still unpaid. Tell me if they are growing, flat or slipping, and write 3 sentences I can send them.
```

## What happens when you paste it

You: Review the affiliate [name or email]…

Assistant: Sam Reid: 1,240 visits and 38 referrals in the last 90 days, down from 61. Conversion fell from 4.1% to 3.1%. 4 payouts this year, $3,860 in total. $410 is unpaid. Calling: `affiliatewp/get-affiliate`, `affiliatewp/get-affiliate-performance`, `affiliatewp/list-payouts`, `affiliatewp/list-referrals`.

Assistant: Sam is slipping. Here is a short note that thanks him, mentions your new products and asks what would help him promote them.

## Abilities this recipe calls

- **Get an affiliate** (`affiliatewp/get-affiliate`, read only, from AffiliateWP): Finds one affiliate by ID, username or email, with rate, group, notes, lifetime earnings and referral URL.
- **Get one affiliate's performance** (`affiliatewp/get-affiliate-performance`, read only, from AffiliateWP): One affiliate's referrals, paid and unpaid earnings, visits and conversion rate for a date range.
- **List payouts** (`affiliatewp/list-payouts`, read only, from AffiliateWP): Lists payouts with amount, method, status and the referrals each one covered.
- **List referrals** (`affiliatewp/list-referrals`, read only, from AffiliateWP): Lists commissions with amount, status, affiliate, customer and campaign. Filters by affiliate, status or date.

## Variations

Add one of these to the end of the prompt. Swap anything in [brackets] for your own details.

- Compare this year with last year instead.
- Do this for my top 5 affiliates in one table.

## Related recipes

- [Loyalty Program Health Check](https://storeagent.ai/mcp-recipes/loyalty-health-check.md): Tells you if your points program is working: how many points are redeemed, what it costs you and where points come from. Needs Advanced Loyalty Program.
- [Save Loyalty Points Before They Expire](https://storeagent.ai/mcp-recipes/save-expiring-points.md): Finds customers about to lose their points and gives them a small bonus that keeps their account active. Needs Advanced Loyalty Program.
- [Reward Your Top Loyalty Members](https://storeagent.ai/mcp-recipes/reward-top-loyalty-members.md): Ranks your most loyal customers by points earned and gives them a bonus as a thank you. Needs Advanced Loyalty Program.

---

Part of the StoreAgent WooCommerce MCP Recipes directory: https://storeagent.ai/mcp-recipes/ (index for LLMs: https://storeagent.ai/mcp-recipes/llms.txt). Get StoreAgent free: https://app.storeagent.ai/sign-up/