Email Automation Flows: Welcome Series, Abandoned Cart, Browse Abandonment, Post-Purchase & Replenishment, Revenue per Recipient, Timing Tests & Flow Share
Measure and improve the automated emails of an online shop, one spreadsheet lab at a time. You will build a flow scorecard with revenue per recipient, then take the five core flows apart: the welcome series by signup source, reach and recovery of the abandoned-cart flow, a keep-or-review rule for browse abandonment, review and repeat rates after the first order and run-out dates for replenishment reminders. You go on to compare flow and campaign share of email revenue, run timing tests on send delays, check entry filters, choose an attribution window, separate incremental from attributed revenue with holdouts, forecast flow revenue from trigger volume, weigh discounts in a what-if grid, decide how long a flow should be, split flows by customer segment, cap email frequency, derive reorder intervals, rank a flow backlog and finish with an annual flow dashboard. 20 hands-on labs, fictional tea-shop data, every cell checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This course teaches the numbers behind automated email flows, lab by lab, in a live spreadsheet. You start with a scorecard of revenue per recipient for five flows of Quillmoor Tea Co., a fictional online tea shop. Then you work through each flow: the welcome series by signup source, the abandoned-cart flow with reach and recovery rates, browse abandonment with unsubscribes, the post-purchase flow with review and repeat rates, and replenishment reminders built on dates. Later labs compare flows with campaigns, test send delays, check entry filters, set an attribution window, measure incremental revenue with holdout groups, forecast flow revenue, model discounts, cap email frequency and rank a backlog of flow ideas. The final project is an annual flow dashboard with a flag rule and a combo chart. Every formula is checked as you type, and a 20-question exam leads to the certificate. All companies, customers and figures in the course are fictional.
Why learn with Tabellab
- Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
- Verifiable certificatePass the final exam and get a certificate with a public verification code.
- Try before you buyLesson 1 is free, with no sign-up or card needed.
- Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint
Lessons
- 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
Learner reviews
Be the first to review this course.