Tabellab

Designing the Offer Stack: Stand-Alone Value, the Honest Saving, Delivery Cost and Contribution Margin

Lesson 9 of 20 Lab 🔒 Locked

Lessons in this course

  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