| I | J | K | L | M | N | O | P | Q | |
|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||
2 | Funnel Analysis | ||||||||
3 | |||||||||
4 | |||||||||
5 | |||||||||
7 | |||||||||
8 | 1) Estimate number of new customers generated and target conversion rates | ||||||||
9 | *Only adjust the blue shaded fields | ||||||||
10 | Current | Target | Change | Multiplier | |||||
11 | Visitors / Month | ||||||||
12 | Leads / Month | ||||||||
13 | Customers / Month | ||||||||
14 | Current | Target | |||||||
15 | Visitor-to-Lead Conversion % | ||||||||
16 | Lead-to-Customer Conversion % | ||||||||
17 | |||||||||
18 | 2) Estimate value of marketing and growth investment | ||||||||
19 | |||||||||
20 | How much does your end-customer spend per purchase? | ||||||||
21 | How many times does the customer buy (lifetime)? | ||||||||
22 | Estimated value of a new customer | $0 | |||||||
23 | New customers per month | ||||||||
24 | Customer Lifetime Value (LTV) created per Month | $0 | |||||||
25 | Recommended marketing/growth spend as % of LTV | 20% | Note: generally 10 - 20% | ||||||
26 | Recommended Customer Acquisition Cost (CAC) | $0 | |||||||
27 | Recommended Monthly Growth Investment | $0 | |||||||
28 | |||||||||