# See Which Affiliate Campaigns Convert

> Compares affiliate campaigns and landing pages so you know what to ask your affiliates to promote.

- Job: [Affiliates & loyalty](https://storeagent.ai/mcp-recipes/job/affiliates/)
- What it does: Read only: looks, never changes anything
- Time saved: ~30 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-campaign-report/

## The prompt

```text
Show me my affiliate campaigns ranked by conversion rate, with visits, unique visits, referrals and earnings. These are lifetime numbers. Then look at affiliate visits from the last 90 days and show the 10 landing pages that get the most visits and how many of those visits converted. Tell me which campaigns and pages work best, which get traffic but no sales, and what I should ask affiliates to promote next.
```

## What happens when you paste it

You: Show me my affiliate campaigns ranked by conversion rate, with visits, unique visits, referrals and earnings…

Assistant: 23 campaigns have visits. "spring-guide" converts at 6.1% lifetime. In the last 90 days the home page got 3x more visits than any other page but converted at 0.9%. Calling: `affiliatewp/list-campaigns`, `affiliatewp/list-visits`, `affiliatewp/list-referrals`.

Assistant: Your gift guide and comparison pages convert best. I would ask affiliates to link to those instead of the home page. The full table is below.

## Abilities this recipe calls

- **List campaigns** (`affiliatewp/list-campaigns`, read only, from AffiliateWP): Lifetime visits, unique visits, referrals, conversion rate and earnings for each campaign and affiliate.
- **List visits** (`affiliatewp/list-visits`, read only, from AffiliateWP): Lists affiliate link visits with landing URL, referrer, campaign and whether they converted. No IP addresses.
- **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.

- Show the results for affiliate [name] only.
- Show the last [number] days for campaign [slug] instead of lifetime numbers.

## 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/