Tabellab
Marketing Analytics Intermediate

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.

20 lessons 20 labs Certificate

  • 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

  1. Revenue per Recipient by Flow: Email-Level RPR, Placed-Order Rate and a Five-Flow Scorecard with SUMIFSLabFree
  2. The Welcome Series: First Orders per Email, Subscriber-to-Customer Rate and Revenue per Subscriber by Signup SourceLab Locked
  3. The Abandoned-Cart Flow: Reach Rate, Recovery Rate and Margin per Recipient After the DiscountLab Locked
  4. Browse Abandonment: RPR by Category, an Index Against the Flow Average and a Keep-or-Review Rule with UnsubscribesLab Locked
  5. The Post-Purchase Flow: Review Rate, 60-Day Repeat Rate, a Target per Product Type with XLOOKUP and a Status with IFSLab Locked
  6. Replenishment Reminders: Days of Supply, Run-Out Date, Reminder Date and a Send-Now Status with Date ArithmeticLab Locked
  7. Flow vs Campaign Share: Flow Share of Email Revenue, Email Share of Store Revenue and the RPR Gap in a Stacked ChartLab Locked
  8. Timing Tests: RPR per Send Delay, Lift Against the Current Timing with SUMIFS and the Winning Variant per FlowLab Locked
  9. Flow Entry Filters: Consent, Already Purchased, Cool-Down and Minimum Cart Value in One Send-or-Skip RuleLab Locked
  10. Time to Convert: Daily and Cumulative Share of Flow Orders and the Attribution Window That Covers 90%Lab Locked
  11. Is the Flow Revenue Incremental? Holdout Groups, Incremental RPR, Incremental Revenue and the Share That Would Have Come AnywayLab Locked
  12. Forecasting Flow Revenue from Trigger Volume: Revenue per New Subscriber, SLOPE, FORECAST.LINEAR and R²Lab Locked
  13. What-If Grid: Margin per 1,000 Cart-Flow Recipients for Every Discount and Recovery Rate, a Heat Map and the Break-Even RateLab Locked
  14. How Long Should a Flow Be? Net Value per Email After Unsubscribes, a Keep-or-Cut Rule and the Cumulative Revenue CurveLab Locked
  15. Flows by Customer Segment: an RPR Matrix with Two-Criteria SUMIFS, the Repeat-to-Prospect Ratio and Each Segment's Share of RecipientsLab Locked
  16. Discounts in Flows: Margin per Recipient With and Without a Code, the Gain per Email and the Emails Where the Code Loses MoneyLab Locked
  17. When Flows Collide: Emails per Subscriber in 7 Days, a Frequency Cap, the Share Over the Cap and the Emails to Hold BackLab Locked
  18. Replenishment Intervals from Real Reorder Gaps: Average vs Median per Product, the Reminder Day and Who Reorders Before ItLab Locked
  19. Prioritising the Flow Backlog: Incremental Revenue per Build Hour, a Rank, Cumulative Hours and a Build-or-Later DecisionLab Locked
  20. Final Project: the Annual Flow Dashboard with Revenue, RPR and Share per Flow, Flow Share of Email Revenue, a Flag Rule and a Combo ChartLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy