Separate repeat purchase behavior from discount-driven activity
A RUSA case study for retail and e-commerce teams, connecting consented customer records, purchase lines, loyalty transactions, and offer redemptions for retail loyalty and repeat purchase.
Repeat purchase rate (%)
Median time to second purchase (days)
Loyalty offer redemption rate (%)
Repeat customer gross margin (%)
THE CHALLENGE
Loyalty enrollment counts do not show repeat purchase economics
Overlapping offers
Discounts cannot be attributed consistently to a promotion.
Missing cost context
Sales reports omit product cost and funded discounts.
Delayed returns
Returns occur after the promotion reporting window.
Stock constraints
Promotion performance is reviewed without product availability.
THE SOLUTION
Retail Loyalty And Repeat Purchase Review Framework
Controlled identity
Apply explicit rules for overlapping promotions and discount funding.
Margin calculation
Connect net sales, product costs, and allocated discounts.
Return linkage
Attach returned items to the original promotional sale.
Availability context
Review promoted stock and sell through alongside margin.
THE APPROACH
Consented Customer Linking
Assign each sale to active offers using store, product, trading date, and approved overlapping-offer rules.
Discount Funding Allocation
Separate retailer-funded discounts from supplier contributions and document allocation across stacked promotions.
Promotional Cost Matching
Attach effective product costs to promoted order lines before calculating net sales and gross margin.
Late Return Attribution
Attach redeemed benefits to eligible order lines and distinguish concurrent offers from loyalty-funded discounts.
Repeat Purchase Economics
Review second-purchase timing and repeat customer margin after discounts and attributable returns.
Loyalty Intervention Testing
Use mature cohorts to design customer-approved tests without assuming participation caused repeat purchases.
THE IMPACT
Cohort clarity
Repeat rates could be compared over equivalent periods.
Commercial visibility
Loyalty review could include margin after redeemed offers.
Journey context
Second purchase timing could inform follow-up hypotheses.
Responsible use
Customer-level views could remain within agreed consent and access rules.
Controlled review
Authorized teams could review mature cohorts, low-margin redemptions, and identity quality gaps, with source evidence retained beside the review case.
Measurable evaluation
A pilot could establish baseline values for repeat purchase rate (%) and assess changes after approved actions. Loyalty participation would not be presented as the cause of repeat purchasing without an appropriate experiment.
Explore Retail Promotion Profitability
Work with RUSA Analytics to connect sales lines, promotion calendars, product costs, discounts, and returns and create a governed workflow to review loss-making offers, overlapping discounts, and constrained promoted items. Start with a scoped concept or pilot and agreed success measures.
MORE WORK
Explore other case studies