Selected work

E-COMMERCE BEAUTY BRAND · CHECKOUT AND ATTRIBUTION

Finding the coupon leak at checkout

From a checkout that invited full-price buyers to go looking for a discount, to one that offered it only to people who already had a code.

Problem

Coupon-attributed revenue kept climbing, and redemptions far outran anything the actual distribution of codes could explain. The brand was giving away margin on sales that would have happened without a discount.

Strategy

My hypothesis was that the open promo code field at checkout was sending customers off to find a code for a purchase they'd already decided to make. A hunch is hard to prove from a single number, so I set out to test it against several independent sources before taking it to the client. The measures that would confirm it afterward were coupon-attributed revenue and total revenue read together, since a drop in the first with the second holding steady would show the discounts hadn't been producing the sales.

Execution

I compared code redemptions against how widely each code had been distributed, looked at the share of orders credited to coupon and deal sites in the affiliate program, traced sessions that left checkout and returned through a coupon site referral to buy with a code, and checked for codes turning up outside the audiences they were meant for. With all of the evidence pointing the same way, I made the case to the client. Their team collapsed the promo code field behind a text link, leaving it available to anyone holding a code while removing the empty box that had been prompting everyone else to go looking for one.

Results

Coupon-attributed revenue dropped and total revenue didn't.

Checkout before and after the promo code field was collapsed, a re-creationRecreated checkout, before and after. Before, the order summary has an open promo code field, with an empty input and an Apply button, above the total. After, the field is replaced by an underlined “Have a promo code?” link, and the rest of the checkout is unchanged.Before: open promo code fieldOrder summaryCleansing oil$28.00Moisturizer$46.00Subtotal$74.00Promo codeEnter codeApplyTotal$74.00Place orderAfter: collapsed behind a linkOrder summaryCleansing oil$28.00Moisturizer$46.00Subtotal$74.00Have a promo code?Total$74.00Place orderThe open field that was collapsedRe-creation for illustration, not the original checkout
Re-creation; the original checkout is no longer live
How an open promo code field leaked discounts, before and after the changeDiagram in two lanes. Before, a customer at checkout sees an empty promo code field, leaves to search, gets a code from a coupon site, and returns to buy at a discount, with each step labelled by the data source that revealed it. After, the same customer sees no empty field and pays full price, while a customer who already has a code clicks the text link and enters it.Before: open promo code fieldFull cart,at checkoutSees emptycode boxLeaves tosearchGets code oncoupon siteReturns, paysdiscountedExit-and-returnsession pathsAffiliatecredit shareRedemptions vsdistributionCodes outsidetheir audienceThe leakData that caught itData that confirmed itAfter: field collapsed behind a linkFull cart,at checkoutNo emptybox to fillNo code,pays in fullHas a code,clicks linkEnters codeas beforeCoupon-attributedrevenue fellTotal revenueheld steady