Timing Tests: RPR per Send Delay, Lift Against the Current Timing with SUMIFS and the Winning Variant per Flow
Lessons in this course
- Revenue per Recipient by Flow: Email-Level RPR, Placed-Order Rate and a Five-Flow Scorecard with SUMIFSFree
- The Welcome Series: First Orders per Email, Subscriber-to-Customer Rate and Revenue per Subscriber by Signup Source Locked
- The Abandoned-Cart Flow: Reach Rate, Recovery Rate and Margin per Recipient After the Discount Locked
- Browse Abandonment: RPR by Category, an Index Against the Flow Average and a Keep-or-Review Rule with Unsubscribes Locked
- The Post-Purchase Flow: Review Rate, 60-Day Repeat Rate, a Target per Product Type with XLOOKUP and a Status with IFS Locked
- Replenishment Reminders: Days of Supply, Run-Out Date, Reminder Date and a Send-Now Status with Date Arithmetic Locked
- Flow vs Campaign Share: Flow Share of Email Revenue, Email Share of Store Revenue and the RPR Gap in a Stacked Chart Locked
- Timing Tests: RPR per Send Delay, Lift Against the Current Timing with SUMIFS and the Winning Variant per Flow Locked
- Flow Entry Filters: Consent, Already Purchased, Cool-Down and Minimum Cart Value in One Send-or-Skip Rule Locked
- Time to Convert: Daily and Cumulative Share of Flow Orders and the Attribution Window That Covers 90% Locked
- Is the Flow Revenue Incremental? Holdout Groups, Incremental RPR, Incremental Revenue and the Share That Would Have Come Anyway Locked
- Forecasting Flow Revenue from Trigger Volume: Revenue per New Subscriber, SLOPE, FORECAST.LINEAR and R² Locked
- What-If Grid: Margin per 1,000 Cart-Flow Recipients for Every Discount and Recovery Rate, a Heat Map and the Break-Even Rate Locked
- How Long Should a Flow Be? Net Value per Email After Unsubscribes, a Keep-or-Cut Rule and the Cumulative Revenue Curve Locked
- Flows by Customer Segment: an RPR Matrix with Two-Criteria SUMIFS, the Repeat-to-Prospect Ratio and Each Segment's Share of Recipients Locked
- Discounts in Flows: Margin per Recipient With and Without a Code, the Gain per Email and the Emails Where the Code Loses Money Locked
- When Flows Collide: Emails per Subscriber in 7 Days, a Frequency Cap, the Share Over the Cap and the Emails to Hold Back Locked
- Replenishment Intervals from Real Reorder Gaps: Average vs Median per Product, the Reminder Day and Who Reorders Before It Locked
- Prioritising the Flow Backlog: Incremental Revenue per Build Hour, a Rank, Cumulative Hours and a Build-or-Later Decision Locked
- Final Project: the Annual Flow Dashboard with Revenue, RPR and Share per Flow, Flow Share of Email Revenue, a Flag Rule and a Combo Chart Locked