Agency Playbook: Reporting RPR Lift to DTC Clients Monthly
A monthly reporting playbook for retention agencies: how to frame RPR movement, annotate the curve, and use projection math to defend the retainer.
Quick answer
Report RPR on a locked rolling 90-day window comparing the latest month to the prior three, annotate every campaign or flow launch directly on the curve, and close the deck with the calculator's 12-month revenue projection at the new RPR — that is the number that defends the retainer.
Agency RPR reporting playbook
A standardised method for presenting Repeat Purchase Rate movement to retention clients in monthly review meetings.
An agency RPR reporting playbook is the repeatable structure a retention or CRO agency uses to show clients how their Repeat Purchase Rate has moved month over month, what work caused the movement, and what the movement is worth in projected revenue.
It locks the measurement window so numbers stay comparable, annotates the RPR curve with the specific launches the agency shipped, and ends with a forward-looking projection so the conversation moves from 'what did you do' to 'what is this worth next quarter.' The format is what turns a metrics dashboard into a renewal argument.
Most agency decks lose the room on slide three because RPR is shown as a single number with no window definition and no causal context. The client sees 24% and has no idea whether that is good, whether it moved, or whether the agency caused it to move.
The playbook below is what high-retention agencies — the ones renewing 90%+ of retainers — use to remove that ambiguity in under fifteen minutes of meeting time.
Lock the measurement window before the first meeting
Decide once, in the kickoff, which window defines RPR for this client and never change it. The standard is a rolling 90-day window: customers who placed a first order in the trailing 90 days, with a repeat purchase counted if it lands inside the same window.
For Shopify apparel and beauty brands, 90 days catches the natural reorder cycle of consumables and second-season buys. For electronics or furniture, extend to 180 days — but lock it. Switching windows mid-engagement to make a number look better is the fastest way to lose trust when the client's analyst notices.
Never re-baseline silently
If you must change the window — for example, a vertical shift after the client adds a subscription SKU — call it out on its own slide, show both numbers side by side for one report, then transition. Silent re-baselining is the single most cited reason clients churn agencies.
Annotate launches directly on the RPR curve
Show RPR as a line chart over the last 6-12 months, then drop vertical annotations on the exact week each agency-shipped initiative went live: the new post-purchase flow, the win-back segment, the loyalty tier launch, the bundle test.
This is the slide that earns the retainer. The client's eye traces the curve, hits an annotation, and reads 'Win-back flow v2 — launched Mar 14' next to a visible inflection. You are no longer arguing for credit; the chart is arguing for you.
Keep annotations to a maximum of five per chart. More than that and the visual gets noisy and every launch starts to look equally small. If you shipped twelve things, pick the five with the clearest causal link and list the rest in an appendix slide.
Benchmark the movement against vertical norms
Typical RPR ranges by DTC vertical (90-day window)
| Vertical | Bottom quartile | Median | Top quartile | Best in class |
|---|---|---|---|---|
| Beauty & skincare | 18% | 28% | 38% | 48%+ |
| Apparel | 12% | 22% | 32% | 42%+ |
| Supplements & wellness | 25% | 38% | 52% | 65%+ |
| Home & decor | 8% | 15% | 24% | 32%+ |
| Consumer electronics | 6% | 12% | 20% | 28%+ |
| Pet (food & treats) | 30% | 45% | 58% | 70%+ |
Show the client's current RPR against their vertical median and top quartile. A move from 18% to 22% in apparel is the difference between bottom-quartile and median — a much more compelling framing than '+4 points.' The benchmark gives the number scale.
Close with the projection — this is the renewal slide
Open the Repeat Purchase Rate Calculator, drop in the client's customer count, AOV, and the new RPR, and screenshot the 12-month projected repeat revenue. Then run it again at the old RPR. The delta — usually €40k to €400k for brands in the €1M-€15M band — is the slide title.
Format the headline as 'Projected incremental repeat revenue at new RPR: €X over next 12 months.' The retainer line item now sits next to a number that is 8-20x larger than it. That ratio is the renewal conversation in one frame.
What to leave out of the deck
Skip vanity metrics that do not feed the RPR story: open rates, click rates, follower counts. Every slide that is not RPR, contributing inputs, or projected revenue dilutes the renewal argument. The deck should be five slides plus an appendix.
Also skip experiments that lost. List them in a one-line appendix ('3 tests run, 1 winner shipped, 2 learnings logged') — but the body of the deck is for things that moved the metric. Clients do not pay retainers for a transparency report; they pay for repeat revenue.
Agency RPR reporting — frequently asked questions
Extend the window to match the median replenishment cycle. For supplements and pet food, 90 days is right. For furniture or appliances, use 180 or 365 days. Lock it at kickoff and document the choice in the SOW.
Segment the report: show RPR for the cohort acquired before the spike separately from the post-spike cohort. Mixing them masks the true retention signal and makes lift harder to attribute to your work.
Lead with it. Explain the mechanism — usually a paid acquisition push diluting the customer base or a seasonality dip — and show the per-cohort view that isolates the effect. Clients lose trust when bad months are buried, not when they are explained.
Three to five maximum. More than that and the chart gets noisy and individual launches lose visual weight. Pick the launches with the clearest causal link to the curve and list the rest in an appendix.
Yes, but on separate slides. RPR is the leading indicator agencies can move in 30-90 days; LTV is the lagging confirmation that shows up at 6-12 months. Reporting them together helps clients see the causal chain.
Pre-fill it before the meeting with the client's customer count and AOV, then toggle RPR between old and new values live on screen. Watching the projected revenue number change in real time is more persuasive than a screenshot.
Monthly for the formal deck, with a weekly automated dashboard the client can check anytime. Quarterly reports are too slow to course-correct, and weekly decks create noise from normal week-to-week variance.
Hold-out by channel: report RPR for organic and email-acquired customers (your domain) separately from paid-acquired customers. This isolates your contribution without claiming credit for cohorts you did not influence.
Find the closest analogue by purchase frequency and price point. A premium candle brand looks more like home decor than beauty. Document the analogue choice in the report footer so the client understands the comparison.
Reframe the conversation around the projection delta. If your work moved RPR from 22% to 26% and the calculator shows €180k incremental repeat revenue, a €6k/month retainer is a 2.5x ROI on the first year alone — show that ratio explicitly on the renewal slide.
See Metricuno on your data
Bring your stack — Google Analytics, Stripe, a CRM, anything — and we'll walk through the metric tree that turns your funnel into one number.