--- title: How I Audited My Coupon Profitability in 2 Minutes (With One Conversation) canonical_url: https://lolacore.com/how-i-audited-my-coupon-profitability-in-2-minutes-with-one-conversation/ last_updated: 2026-05-09T16:10:31+00:00 plugin_version: 1.2.1 --- # How I Audited My Coupon Profitability in 2 Minutes (With One Conversation) A few weeks ago I wrote about [how discount coupons silently destroy your margins](https://file+.vscode-resource.vscode-cdn.net/blog/your-coupons-are-destroying-your-margins). Store owners responded with the same problem: checking it manually takes forever. Pulling WooCommerce order data, filtering by coupon, calculating per-coupon AOV, and cross-referencing repeat purchase rates takes an hour of spreadsheet work. Nobody does it weekly. Most people never do it at all. So I did it through a conversation with Lola instead. The whole thing took about two minutes. ## The conversation I opened my WordPress admin, clicked the Lola chat widget, and typed: > **Me:** Which of my active coupons are actually profitable? I want to know which ones are bringing in good customers and which ones I should kill. > **Lola:** You have 6 active coupons. Let me pull the numbers on each. > > Here's what I found: > > **WELCOME10** (10% off, first order only): 84 uses, average order $94. 31% of users came back and purchased again at full price within 60 days. This coupon is working. It's an acquisition tool with positive ROI. > > **SPRING20** (20% off, no minimum): 47 uses, average order $62. 8% repeat rate. Most orders are near the minimum cart size. You're discounting full-margin products for one-time buyers. > > **LOYALTY15** (15% off for returning customers): 23 uses, average order $118. 100% repeat customers by definition, but their AOV before using this coupon was $125. They were already buying at full price. This coupon is rewarding behavior that was already happening. > > **FLASH50** (50% off, 48-hour sale): 112 uses, average order $43. 2% repeat rate. This is your worst-performing coupon by every metric. Average margin after discount is approximately $1.20 per order before shipping costs. You likely lost money on most of these transactions. > > **FRIEND25** (25% off, referral code): 9 uses, average order $87. Too small a sample to draw conclusions, but early signs are decent. > > **BUNDLE10** (10% off orders over $150): 34 uses, average order $178. 22% repeat rate. Strong performance. The minimum threshold is protecting your margin and attracting higher-intent buyers. I already suspected FLASH50 was a problem. But seeing "$1.20 per order before shipping" made it real. Then I pushed further: > **Me:** What would you do with FLASH50? > **Lola:** I'd kill it. 112 orders at an average margin of $1.20 generated about $134 in gross profit total. Your shipping and payment processing costs on those orders were almost certainly higher than that. This coupon cost you money. > > If you want to run flash sales, a 25% discount with a $100 minimum order would keep your average margin above $15 per order. That's still aggressive enough to feel like a deal without subsidizing your cheapest products at a loss. > > Want me to deactivate FLASH50 and create a replacement with those parameters? > **Me:** Yes, do it. > **Lola:** Done. FLASH50 is deactivated. I've created FLASH25 with 25% off on orders over $100, limited to 1 use per customer, valid for 48 hours. Want me to set the start date or leave it as a draft? ## What just happened Three things happened in that conversation that wouldn't happen with a dashboard or a report: First, Lola didn't just show me the numbers. She interpreted them. "This coupon is rewarding behavior that was already happening" about LOYALTY15 is the kind of insight that takes a human analyst 30 minutes to articulate after looking at the raw data. It reframed a coupon I thought was working into one that was unnecessary. Second, Lola told me to kill a coupon. She didn't say "consider reducing" or "you might want to review." She said "I'd kill it" and showed me the math. FLASH50 generated $134 in total gross profit across 112 orders. That's a number that makes the decision obvious. Most tools show you usage counts and revenue — metrics that make bad coupons look successful. Lola showed me margin, which made the same coupon look like what it was: a loss. Third, the fix was immediate. In the same conversation where I diagnosed the problem, I also solved it. Deactivate the bad coupon, create a better one with specific parameters, done. No switching between WooCommerce screens, no navigating to Marketing → Coupons → Add New, no filling out form fields. One conversation, one outcome. ## The LOYALTY15 surprise The coupon that surprised me most wasn't FLASH50. I already had a bad feeling about that one. It was LOYALTY15. I created that coupon thinking I was rewarding my best customers. Turns out I was discounting orders that would have happened anyway at full price. Those 23 customers had an average order of $125 before the coupon existed. With the coupon, their average dropped to $118. I wasn't generating loyalty. I was giving away $7 per order to people who were already loyal. That's the kind of insight you only get when someone looks at your data with an opinion, not just a chart. A dashboard would have shown me "LOYALTY15: 23 uses, $118 AOV" and I would have thought it was fine. Lola told me it was wasteful because she compared it to what those same customers were spending without the coupon. ## What this changes The traditional workflow for coupon analysis looks like this: export orders, open spreadsheet, build pivot tables, calculate AOV per coupon, manually check repeat rates, make a decision, go back to WooCommerce, execute the change. Two to three hours if you're efficient. Most store owners do it quarterly, if ever. The conversation above took two minutes. You can do this every week without it feeling like a chore. Ask Lola, get the answer, act on it, move on. That's what changes when your store admin can actually talk back to you. --- *This is the fourth post in a series about running a WooCommerce store without the busywork. Previously: [Your Discount Coupons Are Destroying Your Margins](https://file+.vscode-resource.vscode-cdn.net/blog/your-coupons-are-destroying-your-margins). Next: what happens when you replace 8 plugins with code snippets generated by a single conversation.*