# Your Weekly Abandoned Cart Report

> How many carts were left, how many came back, what was lost and which products shoppers walk away from most.

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

## The prompt

```text
Give me my weekly abandoned cart report. Show last week's recoverable, recovered and lost carts with their revenue and my recovery rate, and compare them with the week before. Put the recovered revenue next to my total sales from completed and processing orders for the same week. List the 5 products shoppers abandoned most last week with the value left behind. End with the two things most worth fixing this week.
```

## What happens when you paste it

You: Give me my weekly abandoned cart report…

Assistant: Last week: 142 abandoned carts worth $9,860. 31 came back for $2,140, a 21.8% recovery rate, up from 17.4%. That is 9% of your $23,600 in sales. Calling: `wcar/get-dashboard-stats`, `wcar/get-product-stats`, `woocommerce/orders-query`.

Assistant: Fix these first: the Merino Travel Hoodie sits in a quarter of all lost carts, so check its shipping cost at checkout. Then add a second reminder email, since most recoveries came from the first one.

## Abilities this recipe calls

- **Get cart recovery stats** (`wcar/get-dashboard-stats`, read only, from Cart Abandonment Recovery): Shows recoverable, recovered and lost carts with their revenue and your recovery rate for any date range.
- **List most abandoned products** (`wcar/get-product-stats`, read only, from Cart Abandonment Recovery): Lists the products shoppers leave in their carts most often, with the total value left behind.
- **Find orders** (`woocommerce/orders-query`, read only, from WooCommerce): Finds orders by status, customer, email or date, with the items in each order.

## Variations

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

- Compare this month with last month instead.
- Write it as a 5 line summary I can paste into Slack.

## Related recipes

- [Which Payment Methods Lose My Conversions?](https://storeagent.ai/mcp-recipes/payment-gateway-tracking-gaps.md): Finds the payment methods where orders never reach your ad pixels, so you know where ad data leaks.
- [Which Product Options Do Customers Pick?](https://storeagent.ai/mcp-recipes/ppom-popular-options.md): See which add-ons and choices shoppers pick most in last month's orders, and which ones nobody uses.
- [Which Store Popups Actually Get Clicked](https://storeagent.ai/mcp-recipes/notificationx-popup-click-report.md): Views, clicks and click-through rate for every NotificationX popup and bar, set next to last month's orders, with what to keep and what to cut.

---

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/