# One Report for Affiliates and Loyalty

> Puts last month's AffiliateWP and RewardsWP numbers side by side, compares them with the month before and names one change for each program.

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

## The prompt

```text
Give me one report for my affiliate and loyalty programs for last month, compared with the month before. From AffiliateWP: referrals, earnings, unpaid earnings, visits and my top 5 affiliates. From RewardsWP: new and active members, points earned and redeemed, orders that used a reward and their revenue, and completed referrals. Then tell me in plain words what is working, what looks off and one change to test in each program.
```

## What happens when you paste it

You: Give me one report for my affiliate and loyalty programs for last month, compared with the month before…

Assistant: AffiliateWP: 212 referrals and $6,380 earned, up 18%, with $2,140 unpaid. RewardsWP: 340 new members, 28% of points redeemed and $9,120 from orders that used a reward. Calling: `affiliatewp/get-program-summary`, `affiliatewp/list-top-affiliates`, `rewardswp/get-program-report`.

Assistant: Affiliates are growing and loyalty is flat. Pay the $2,140 owed before month end, and test a bigger friend reward in RewardsWP.

## Abilities this recipe calls

- **Get affiliate program totals** (`affiliatewp/get-program-summary`, read only, from AffiliateWP): Totals for affiliates and referrals by status, paid and unpaid earnings, and visits, for any date range.
- **Rank top affiliates** (`affiliatewp/list-top-affiliates`, read only, from AffiliateWP): Ranks affiliates by earnings for a date range, with their referrals and visits.
- **Get program report** (`rewardswp/get-program-report`, read only, from RewardsWP): Members, points, redemption rate, rewards revenue, referrals and VIP moves for a period, with the change from before.

## Variations

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

- Write it as a 5 line summary I can paste into Slack.
- Cover the last 90 days instead.

## Related recipes

- [Get a Plain-English Weekly Sales Recap](https://storeagent.ai/mcp-recipes/weekly-recap.md): Revenue, orders, best sellers and anything weird, compared to last week, in five bullet points.
- [Did My Emails Sell Anything This Month?](https://storeagent.ai/mcp-recipes/mail-mint-monthly-email-report.md): Your Mail Mint numbers for the last 30 days next to your WooCommerce orders, with the campaigns that worked and the ones that did not.
- [Do Overseas Orders Cover Their Costs?](https://storeagent.ai/mcp-recipes/extra-fees-international-check.md): Compares what overseas customers pay for shipping with a suggested country handling fee, so you can decide if a fee is fair.

---

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/