Plan one webinar per week — set a different CPL for each week, and see per-webinar, weekly, and monthly revenue including the L2 backend.
Set each week's cost per lead and ad spend — 4 to 12 weeks.
| Week | CPL | Spend | Leads | Show-ups | Sales | L1 revenue | L2 revenue (cash-in)* | Total cash-in | Net cash flow | CAC | Profit / sale |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Month | Webinars | Spend | L1 revenue | L2 revenue (cash-in) | Total revenue | Gross profit | |
|---|---|---|---|---|---|---|---|
Months are 4-week blocks. L2 revenue is placed in the month the cash actually lands, based on your L1 → L2 conversion cycle.
Formulas (from your sheet): Leads = Spend ÷ CPL · Show-ups = Leads × Show-up % · Sales = Show-ups × Conversion % · L1 Revenue = Sales × Ticket · Gross profit = Revenue − Spend · CAC = Spend ÷ Sales · L2 sales = Sales × L2 upgrade % · L2 revenue = L2 sales × L2 ticket, landing after the L1 → L2 conversion cycle. Scenarios are kept in memory for this session.