Designing the Offer Stack: Stand-Alone Value, the Honest Saving, Delivery Cost and Contribution Margin
Lessons in this course
- Mapping a Sales Funnel: Step Conversion, Share of Visitors, Revenue per Step and Revenue per VisitorFree
- Lead Magnets Compared: Opt-in Rate, Cost per Lead, Lead-to-Buyer Rate and Cost per Entry Buyer Locked
- The Entry Offer: Take Rate, Net Revenue after Payment Fees and How Much of the Ad Spend It Covers Locked
- Order Bumps: Take Rate, Bump Revenue per Order, Average Cart Value and the Lift over the Main Price Locked
- Average Cart Value from Order Data: Cart Totals, Mean versus Median, Take Rates with COUNTIF and the Revenue behind the Entry Offer Locked
- Upsell and Downsell: Take Rates with the Right Denominator and Add-on Revenue per Core Buyer Locked
- Earnings per Click of the Funnel: Revenue from All Offers per Click, Margin per Click and an EPC Ranking by Traffic Source Locked
- Break-Even Ad Cost: Contribution per Click, Break-Even CPC, Headroom and a Scale, Hold or Cut Verdict Locked
- Designing the Offer Stack: Stand-Alone Value, the Honest Saving, Delivery Cost and Contribution Margin Locked
- Good, Better, Best: Tier Mix, Revenue per Buyer and Contribution per Buyer of a Three-Tier Core Offer Locked
- Payment Plans: Plan Share, Collected Instalments, Collection Rate and the Real Revenue per Buyer Locked
- Refunds and Net Revenue: Refund Rate per Offer, Revenue after Refunds and Fees, and a Flag for Offers that Need a Review Locked
- Segmenting the Funnel: Orders, Revenue, Average Cart Value and EPC per Traffic Source with COUNTIFS, SUMIFS and AVERAGEIFS Locked
- EPC over Time: Cumulative Revenue of a Click Cohort, Maturing EPC and the Day the Ad Spend Is Recovered Locked
- Testing an Order Bump: Conversion and Revenue per Visitor of Two Checkouts, z Test and p Value Locked
- Pricing the Upsell: Take Rate by Price, Revenue per Offer Shown, the Best Tested Price and a Linear Forecast Locked
- A What-If Grid for the Funnel: Entry Rate against Core Take Rate with Mixed References, a Heat Map and the Break-Even Take Rate Locked
- Scaling the Ad Budget: Average and Marginal CPC, Contribution after Ads and the Spend Level Where Scaling Stops Paying Locked
- Checking Funnel Data: Expected Revenue from Units and Prices, Impossible Rows, a Check Flag and a Highlight Rule Locked
- Final Project: A Quarterly Funnel Dashboard by Traffic Source with Revenue, EPC, CPC, Break-Even CPC, a Verdict and a Chart Locked