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.
- 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
- 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
Learner reviews
Be the first to review this course.