Tabellab
Marketing Analytics Intermediate

Checkout & Cart Abandonment Recovery: Checkout Funnels, Device & Payment Analysis, Shipping Thresholds, Recovery Messages & Incremental Revenue

Find out where carts are lost and what recovery messages really add, in 20 hands-on labs. You will build the checkout step funnel, separate cart from checkout abandonment, track weekly rates, split abandonment by device and payment method, value the abandoned carts and study the free-shipping threshold; then measure recovery emails, use holdouts to tell incremental orders from those that would have been bought anyway, time the first reminder from the natural return curve, compare email, SMS and push, price discount codes, test shipping thresholds, check significance, forecast the programme, clean the send list, rank checkout form friction, spot trained abandonment, build a what-if grid, target segments by net value and finish with a quarterly scorecard. 20 hands-on labs, a fictional online shop, no performance promises, 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 analysis behind checkout and cart abandonment in 20 interactive spreadsheet labs. You work with the data of Tidewick Home, a fictional online shop for kitchen and home goods. First you build the checkout step funnel and separate cart abandonment from checkout abandonment, then you split the losses by week, device and payment method, value the abandoned carts and examine the free-shipping threshold. The second half is about recovery: reach and recovery rates of emails, random holdouts that separate incremental orders from orders that would have been placed anyway, send timing, the economics of email, SMS and push, the real cost of discount codes, significance tests, a forecast, a clean and consented send list, checkout form friction, trained abandonment, a what-if grid, segment targeting and a final quarterly scorecard. Every formula is checked as you type. All companies, people and numbers are fictional and benchmarks are illustrative.

Lessons

  1. The Checkout Step Funnel: Step Conversion, Sessions Lost per Step, Cart Abandonment Rate and Checkout Abandonment RateLabFree
  2. Weekly Abandonment Rates: Cart vs Checkout Abandonment, the Quarter Rate from Sums, Weeks Above Target and a Trend LineLab Locked
  3. Abandonment by Device: SUMIFS per Device, Abandoned Carts, Device Rates and Each Device's Share of the Lost CartsLab Locked
  4. Abandonment by Payment Method: Paid Orders, Payment Success Rate, a Ranking, a Review Flag and Success by Method TypeLab Locked
  5. Abandoned Cart Value: Counting and Summing Abandoned Carts, the Average Abandoned Cart, Abandonment by Value and Value Lost at PaymentLab Locked
  6. Shipping-Cost Thresholds: Shipping Charged with IF, the Gap to Free Shipping, Near and Far Bands and Abandonment Below the ThresholdLab Locked
  7. Recovery Emails: Reach Rate, Recovery Rate of Reachable Carts, Recovered Revenue per Cart and the Share of All Abandoned CartsLab Locked
  8. Recovered Revenue vs Incremental Revenue: Holdout Order Rate, Incremental Orders, Would-Have-Bought Share and the True Share of Claimed RevenueLab Locked
  9. Send Timing: the Natural Return Curve, Orders per Interval, the Share Already Back and the First Sensible Hour for a ReminderLab Locked
  10. Email, SMS and Push: Incremental Orders per Touch, Cost per Incremental Order, Net Incremental Margin and the Channel TotalsLab Locked
  11. Discounts in Recovery Messages: Incremental Orders per Offer, Discount Cost on All Orders, Net Incremental Profit and the Discount LeakLab Locked
  12. Testing Free-Shipping Thresholds: Abandonment per Threshold, Profit per Order, Profit per 1,000 Carts and the Most Profitable ThresholdLab Locked
  13. Is the Lift Real? Lift, Pooled Standard Error, z Value, p Value with NORM.S.DIST and a Verdict per Recovery TouchLab Locked
  14. Forecasting the Recovery Programme: Trend with SLOPE, FORECAST.LINEAR for Abandoned Carts, Revenue per Cart and Projected Incremental RevenueLab Locked
  15. Cleaning the Send List: Duplicate Emails, Days Since Abandonment, a Send or Skip Decision with AND and the Size of the Clean ListLab Locked
  16. Checkout Form Friction: Error Rate per Field, Exits After an Error, a Ranking with RANK.EQ and the Share of the Three Worst FieldsLab Locked
  17. Trained Abandonment: Code Share of Orders, a Code-Seeker Pattern with AND, Counting It with SUMPRODUCT and the Discount It AbsorbsLab Locked
  18. A What-If Grid for Recovery Offers: Net Incremental Profit by Lift and Discount with Mixed References, a Heat Map and the Break-Even LiftLab Locked
  19. Who Should Get the Offer? Net Value per Segment, a Send or Hold Decision, the Gain from Leaving Segments Out and a Row HighlightLab Locked
  20. Final Project: Quarterly Recovery Scorecard with Incremental Orders, Incremental Revenue, Programme Cost, ROI on Margin, a Flag 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