Tabellab
Marketing Analytics Intermediate

Sales Funnels & Offer Design: Lead Magnets, Entry Offers, Order Bumps, Upsells, Cart Value, Funnel EPC & Break-Even Ad Cost

Take a sales funnel apart and price it in 20 hands-on labs. You will map every step of a four-offer funnel, compare lead magnets by cost per buyer, check how much of the ad spend an entry offer covers, measure order bumps, upsells and downsells by take rate, build the average cart value from raw orders and roll everything into the funnel's earnings per click and a break-even cost per click. Then you design an offer stack with an honest saving, compare price tiers and payment plans, take refunds and fees off, segment by traffic source, follow a click cohort until it pays back, test an order bump and an upsell price, build a what-if grid, find the budget where scaling stops paying, check the data and finish with a quarterly funnel dashboard. 20 hands-on labs, fictional Emberloaf Baking School data, no income 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 arithmetic behind sales funnels and offer stacks in 20 interactive spreadsheet labs. You work with the data of Emberloaf Baking School, a fictional online sourdough school, and build each part of its funnel yourself: step conversions and revenue per visitor, lead magnets compared by cost per buyer, an entry offer that covers part of the ad spend, order bumps, upsells and downsells with their take rates, and the average cart value from raw order data. From there you calculate the earnings per click of the whole funnel and the break-even cost per click, design an offer stack, compare price tiers and payment plans, deduct refunds and fees, segment by traffic source, follow a click cohort over 90 days, evaluate a split test and a price test, and finish with a what-if grid, a budget scaling analysis, data checks and a quarterly dashboard. Every formula is checked as you type. The course makes no income promises; all companies, offers and numbers are fictional.

Lessons

  1. Mapping a Sales Funnel: Step Conversion, Share of Visitors, Revenue per Step and Revenue per VisitorLabFree
  2. Lead Magnets Compared: Opt-in Rate, Cost per Lead, Lead-to-Buyer Rate and Cost per Entry BuyerLab Locked
  3. The Entry Offer: Take Rate, Net Revenue after Payment Fees and How Much of the Ad Spend It CoversLab Locked
  4. Order Bumps: Take Rate, Bump Revenue per Order, Average Cart Value and the Lift over the Main PriceLab Locked
  5. Average Cart Value from Order Data: Cart Totals, Mean versus Median, Take Rates with COUNTIF and the Revenue behind the Entry OfferLab Locked
  6. Upsell and Downsell: Take Rates with the Right Denominator and Add-on Revenue per Core BuyerLab Locked
  7. Earnings per Click of the Funnel: Revenue from All Offers per Click, Margin per Click and an EPC Ranking by Traffic SourceLab Locked
  8. Break-Even Ad Cost: Contribution per Click, Break-Even CPC, Headroom and a Scale, Hold or Cut VerdictLab Locked
  9. Designing the Offer Stack: Stand-Alone Value, the Honest Saving, Delivery Cost and Contribution MarginLab Locked
  10. Good, Better, Best: Tier Mix, Revenue per Buyer and Contribution per Buyer of a Three-Tier Core OfferLab Locked
  11. Payment Plans: Plan Share, Collected Instalments, Collection Rate and the Real Revenue per BuyerLab Locked
  12. Refunds and Net Revenue: Refund Rate per Offer, Revenue after Refunds and Fees, and a Flag for Offers that Need a ReviewLab Locked
  13. Segmenting the Funnel: Orders, Revenue, Average Cart Value and EPC per Traffic Source with COUNTIFS, SUMIFS and AVERAGEIFSLab Locked
  14. EPC over Time: Cumulative Revenue of a Click Cohort, Maturing EPC and the Day the Ad Spend Is RecoveredLab Locked
  15. Testing an Order Bump: Conversion and Revenue per Visitor of Two Checkouts, z Test and p ValueLab Locked
  16. Pricing the Upsell: Take Rate by Price, Revenue per Offer Shown, the Best Tested Price and a Linear ForecastLab Locked
  17. A What-If Grid for the Funnel: Entry Rate against Core Take Rate with Mixed References, a Heat Map and the Break-Even Take RateLab Locked
  18. Scaling the Ad Budget: Average and Marginal CPC, Contribution after Ads and the Spend Level Where Scaling Stops PayingLab Locked
  19. Checking Funnel Data: Expected Revenue from Units and Prices, Impossible Rows, a Check Flag and a Highlight RuleLab Locked
  20. Final Project: A Quarterly Funnel Dashboard by Traffic Source with Revenue, EPC, CPC, Break-Even CPC, a Verdict and a 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