# Monthly Coupon Performance Report

> Shows which coupons actually brought in orders last month, how much they cost you in discounts, and which ones nobody used.

- Job: [Reporting & insights](https://storeagent.ai/mcp-recipes/job/reporting/)
- 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) + Advanced Coupons
- Works in: Claude, ChatGPT, Cursor and any MCP client connected to the store through StoreAgent MCP
- Web page: https://storeagent.ai/mcp-recipes/coupon-performance-report/

## The prompt

```text
Give me a coupon performance report for last month. Show the total coupons used, total amount discounted, number of discounted orders and the revenue from those orders. Compare each number with the month before. Then list the top coupons by usage with the discount each one gave away. For the top 3, open the coupon and tell me its type, amount, usage limit and expiry. Finish with active coupons that had no uses at all, and give me one sentence on what you would change.
```

## What happens when you paste it

You: Give me a coupon performance report for last month…

Assistant: September: 214 coupon uses, $3,870 discounted across 198 orders, $21,640 in discounted order revenue. August had 171 uses and $16,200 revenue. Calling: `advanced-coupons/get-coupons-summary`, `advanced-coupons/list-coupons`, `advanced-coupons/get-coupon`.

Assistant: WELCOME10 led with 96 uses and $1,120 off. FREESHIP had 61 uses. 9 active coupons had zero uses, 4 of them from old campaigns. I would retire those 4 and give WELCOME10 a usage limit.

## Abilities this recipe calls

- **Get coupon performance** (`advanced-coupons/get-coupons-summary`, read only, from Advanced Coupons): Totals coupon usage, discounts given and discounted order revenue for a date range.
- **List coupons** (`advanced-coupons/list-coupons`, read only, from Advanced Coupons): Lists your coupons with type, amount, usage count and expiry date, with filters.
- **Get coupon details** (`advanced-coupons/get-coupon`, read only, from Advanced Coupons): Shows every setting on one coupon, including cart conditions, schedule and URL settings.

## Variations

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

- Only include BOGO coupons in the report.
- Use the last 90 days instead of last month and compare with the 90 days before.
- Show the discount given as a percentage of the discounted order revenue for each top coupon.

## 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.
- [See What Shoppers Asked Your Chat Assistant This Week](https://storeagent.ai/mcp-recipes/chat-questions-digest.md): Reads every shopper chat from the last 7 days and tells you what people keep asking, and where the assistant came up short.
- [Audit Your Whole Wholesale Pricing Setup](https://storeagent.ai/mcp-recipes/wholesale-pricing-audit.md): Counts every wholesale pricing rule by level and spot-checks real prices for a customer in each role, so you know what is actually live.

---

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/