| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Compact Growth Model Sheet by Farid Asadi | |||||||||||||||||
2 | ACTIVATION — ORGANIC | Delta vs. Baseline 2024 Forecast | ||||||||||||||||
3 | All Programs & Segments | 1/1/2024 | 2/1/2024 | 3/1/2024 | 4/1/2024 | 5/1/2024 | 6/1/2024 | 7/1/2024 | 8/1/2024 | 9/1/2024 | 10/1/2024 | 11/1/2024 | 12/1/2024 | TOTAL | ||||
4 | Segment A | Lead Conversion Rate | Segment A, Desktop | 0.00% | 0.00% | 0.00% | 0.00% | 0.64% | 2.60% | 0.60% | 2.87% | 2.26% | 0.70% | 3.02% | 3.04% | |||
5 | — Desktop | 18.00% | Segment A, Mobile | 0.00% | 0.00% | 0.00% | 0.00% | 0.44% | 2.72% | 7.47% | 7.99% | 1.86% | 9.90% | 6.47% | 1.90% | |||
6 | — Mobile | 83.00% | Segment B, Desktop | 0.00% | 0.00% | 0.00% | 0.00% | 0.34% | 0.32% | 0.94% | 0.45% | 2.34% | 2.64% | 1.92% | 2.76% | |||
7 | Segment B | Lead Conversion Rate | Segment B, Mobile | 0.00% | 0.00% | 0.00% | 0.00% | 0.28% | 0.62% | 1.09% | 0.83% | 1.38% | 3.54% | 4.61% | 1.36% | |||
8 | — Desktop | 20.00% | Segment C, Desktop | 0.00% | 0.00% | 0.00% | 0.00% | 0.62% | 0.53% | 2.20% | 1.58% | 2.73% | 2.36% | 2.66% | 2.88% | |||
9 | — Mobile | 33.00% | Segment C, Mobile | 0.00% | 0.00% | 0.00% | 0.00% | 0.53% | 1.72% | 1.56% | 2.44% | 0.60% | 2.35% | 2.74% | 2.34% | |||
10 | Segment C | Lead Conversion Rate | Segment D, Desktop | 0.00% | 0.00% | 0.00% | 0.00% | 0.65% | 0.64% | 0.75% | 0.37% | 0.65% | 0.45% | 0.32% | 2.28% | |||
11 | — Desktop | 33.00% | Segment D, AMP | 0.00% | 0.00% | 0.00% | 0.39% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.91% | 0.32% | |||
12 | — Mobile | 22.00% | Segment E, Desktop | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.93% | 0.77% | 1.22% | 1.78% | 1.87% | |||
13 | Segment D | Lead Conversion Rate | Segment E, Mobile | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.19% | 0.72% | 1.91% | 1.70% | 2.85% | |||
14 | — Desktop | 10.00% | Segment A, Desktop | 0.00% | 0.00% | 0.00% | 0.00% | 0.13% | 1.73% | 1.49% | 1.72% | 1.67% | 2.07% | 0.90% | 0.35% | |||
15 | — AMP | 21.00% | Segment A, Mobile | 0.00% | 0.00% | 0.00% | 0.00% | 0.98% | 0.57% | 0.33% | 0.57% | 0.91% | 2.07% | 1.53% | 0.54% | |||
16 | Segment E | Lead Conversion Rate | Segment B, Desktop | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1.31% | 2.83% | 0.35% | 1.46% | 1.91% | |||
17 | — Desktop | 20.00% | Segment B, Mobile | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1.30% | 0.65% | 0.67% | 2.88% | 1.38% | |||
18 | — Mobile | 20.00% | Segment E, Desktop | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.16% | 0.77% | 1.39% | 1.91% | 1.30% | 0.38% | 0.63% | |||
19 | G Loops | — Desktop | 15.00% | Segment E, Mobile | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.41% | 0.47% | 1.00% | 0.53% | 0.88% | 0.89% | 0.20% | ||
20 | ACTIVATION — PAID SEARCH | Segment F, Desktop | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.66% | 0.37% | 0.36% | 0.55% | 0.63% | 0.55% | 0.69% | ||||
21 | All Segments | Segment F, Mobile | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1.51% | 0.74% | 2.50% | 2.29% | 1.09% | 2.33% | 2.63% | ||||
22 | Segment A | Lead Conversion Rate | Total Extra Revenue | $0 | $0 | $0 | $65,552 | $710,333 | $2,223,470 | $2,742,248 | $4,869,097 | $4,172,574 | $4,680,810 | $5,027,088 | $4,277,624 | $28,768,795 | ||
23 | — Desktop | 22.00% | Total Annualized Extra Potential Revenue (Final Delta*12) | $51,331,484 | ||||||||||||||
24 | — Mobile | 22.00% | Alternate 2024 Forecast, Lead CVR | |||||||||||||||
25 | Segment B | Lead Conversion Rate | 1/1/2024 | 2/1/2024 | 3/1/2024 | 4/1/2024 | 5/1/2024 | 6/1/2024 | 7/1/2024 | 8/1/2024 | 9/1/2024 | 10/1/2024 | 11/1/2024 | 12/1/2024 | TOTAL | |||
26 | — Desktop | 30.00% | Segment A, Desktop | 4.13% | 6.81% | 2.03% | 3.07% | 7.71% | 9.87% | 2.27% | 10.92% | 8.60% | 2.67% | 11.49% | 11.56% | |||
27 | — Mobile | 38.00% | Segment A, Mobile | 8.63% | 5.54% | 5.51% | 2.44% | 5.29% | 5.18% | 14.23% | 15.22% | 3.54% | 18.86% | 12.33% | 3.62% | |||
28 | Segment E | Lead Conversion Rate | Segment B, Desktop | 2.34% | 1.16% | 5.25% | 8.27% | 2.58% | 2.43% | 7.22% | 4.93% | 8.49% | 9.58% | 6.97% | 10.01% | |||
29 | — Desktop | 22.00% | Segment B, Mobile | 3.11% | 7.25% | 5.29% | 2.86% | 2.17% | 4.78% | 8.37% | 5.85% | 3.98% | 10.22% | 13.32% | 3.93% | |||
30 | — Mobile | 12.00% | Segment C, Desktop | 8.36% | 5.44% | 9.76% | 3.47% | 4.77% | 3.72% | 8.67% | 6.23% | 10.76% | 9.30% | 10.50% | 11.35% | |||
31 | Segment F | Lead Conversion Rate | Segment C, Mobile | 1.48% | 1.87% | 8.42% | 3.51% | 4.03% | 9.56% | 5.42% | 8.50% | 2.08% | 8.17% | 9.53% | 8.15% | |||
32 | — Desktop | 10.00% | Segment D, Desktop | 7.77% | 3.65% | 7.90% | 1.72% | 5.00% | 4.88% | 5.78% | 2.84% | 4.97% | 3.47% | 6.72% | 10.87% | |||
33 | — Mobile | 30.00% | Segment D, AMP | 8.19% | 3.55% | 3.74% | 3.00% | 8.13% | 2.94% | 6.69% | 8.74% | 2.86% | 9.25% | 9.54% | 1.85% | |||
34 | *Important; Revenue Lever | Segment E, Desktop | 4.74% | 8.27% | 6.31% | 6.58% | 8.52% | 5.95% | 1.70% | 10.21% | 4.61% | 7.34% | 10.68% | 6.80% | ||||
35 | Segment E, Mobile | 7.36% | 9.18% | 1.03% | 4.13% | 6.39% | 7.88% | 2.40% | 2.08% | 4.31% | 11.44% | 10.22% | 10.34% | |||||
36 | Segment A, Desktop | 2.17% | 1.23% | 8.32% | 5.02% | 1.35% | 9.59% | 8.27% | 9.55% | 9.26% | 11.47% | 4.99% | 1.95% | |||||
37 | Segment A, Mobile | 2.11% | 1.40% | 5.38% | 8.60% | 9.93% | 3.16% | 1.81% | 3.14% | 5.06% | 11.50% | 8.50% | 3.01% | |||||
38 | Segment B, Desktop | 7.96% | 1.58% | 4.54% | 8.69% | 8.53% | 5.04% | 6.90% | 10.06% | 12.27% | 1.53% | 6.33% | 8.27% | |||||
39 | Segment B, Mobile | 6.24% | 8.20% | 7.81% | 8.77% | 8.46% | 3.21% | 5.29% | 8.12% | 2.83% | 2.89% | 12.48% | 5.97% | |||||
40 | Segment E, Desktop | 7.85% | 1.53% | 8.27% | 8.89% | 6.85% | 1.65% | 4.27% | 7.72% | 10.58% | 7.19% | 2.11% | 3.49% | |||||
41 | Segment E, Mobile | 6.70% | 1.30% | 5.48% | 1.15% | 3.27% | 7.16% | 4.35% | 9.35% | 4.96% | 8.21% | 8.27% | 1.85% | |||||
42 | Segment F, Desktop | 7.91% | 2.83% | 2.60% | 4.29% | 5.36% | 7.30% | 4.03% | 4.00% | 6.03% | 6.96% | 6.03% | 7.58% | |||||
43 | Segment F, Mobile | 7.34% | 1.43% | 6.65% | 1.28% | 5.44% | 6.53% | 3.22% | 10.82% | 9.92% | 4.71% | 10.11% | 11.39% | |||||
44 | Total Revenue | $19,153,553 | $10,004,260 | $15,203,670 | $11,068,076 | $16,006,125 | $16,023,824 | $15,254,259 | $23,090,201 | $20,131,315 | $19,262,062 | $22,575,148 | $18,198,837 | $205,971,331 | ||||
45 | ||||||||||||||||||
46 | Baseline 2024 Forecast, Lead CVR | |||||||||||||||||
47 | 1/1/2024 | 2/1/2024 | 3/1/2024 | 4/1/2024 | 5/1/2024 | 6/1/2024 | 7/1/2024 | 8/1/2024 | 9/1/2024 | 10/1/2024 | 11/1/2024 | 12/1/2024 | TOTAL | |||||
48 | Segment A, Desktop | 4.13% | 6.81% | 2.03% | 3.07% | 7.07% | 7.27% | 1.67% | 8.05% | 6.34% | 1.97% | 8.47% | 8.52% | |||||
49 | Segment A, Mobile | 8.63% | 5.54% | 5.51% | 2.44% | 4.85% | 2.46% | 6.76% | 7.23% | 1.68% | 8.96% | 5.86% | 1.72% | |||||
50 | Segment B, Desktop | 2.34% | 1.16% | 5.25% | 8.27% | 2.24% | 2.11% | 6.28% | 4.48% | 6.15% | 6.94% | 5.05% | 7.25% | |||||
51 | Segment B, Mobile | 3.11% | 7.25% | 5.29% | 2.86% | 1.89% | 4.16% | 7.28% | 5.02% | 2.60% | 6.68% | 8.71% | 2.57% | |||||
52 | Segment C, Desktop | 8.36% | 5.44% | 9.76% | 3.47% | 4.15% | 3.19% | 6.47% | 4.65% | 8.03% | 6.94% | 7.84% | 8.47% | |||||
53 | Segment C, Mobile | 1.48% | 1.87% | 8.42% | 3.51% | 3.50% | 7.84% | 3.86% | 6.06% | 1.48% | 5.82% | 6.79% | 5.81% | |||||
54 | Segment D, Desktop | 7.77% | 3.65% | 7.90% | 1.72% | 4.35% | 4.24% | 5.03% | 2.47% | 4.32% | 3.02% | 6.40% | 8.59% | |||||
55 | Segment D, AMP | 8.19% | 3.55% | 3.74% | 2.61% | 8.13% | 2.94% | 6.69% | 8.74% | 2.86% | 9.25% | 8.63% | 1.53% | |||||
56 | Segment E, Desktop | 4.74% | 8.27% | 6.31% | 6.58% | 8.52% | 5.95% | 1.70% | 9.28% | 3.84% | 6.12% | 8.90% | 4.93% | |||||
57 | Segment E, Mobile | 7.36% | 9.18% | 1.03% | 4.13% | 6.39% | 7.88% | 2.40% | 1.89% | 3.59% | 9.53% | 8.52% | 7.49% | |||||
58 | Segment A, Desktop | 2.17% | 1.23% | 8.32% | 5.02% | 1.22% | 7.86% | 6.78% | 7.83% | 7.59% | 9.40% | 4.09% | 1.60% | |||||
59 | Segment A, Mobile | 2.11% | 1.40% | 5.38% | 8.60% | 8.95% | 2.59% | 1.48% | 2.57% | 4.15% | 9.43% | 6.97% | 2.47% | |||||
60 | Segment B, Desktop | 7.96% | 1.58% | 4.54% | 8.69% | 8.53% | 5.04% | 6.90% | 8.75% | 9.44% | 1.18% | 4.87% | 6.36% | |||||
61 | Segment B, Mobile | 6.24% | 8.20% | 7.81% | 8.77% | 8.46% | 3.21% | 5.29% | 6.82% | 2.18% | 2.22% | 9.60% | 4.59% | |||||
62 | Segment E, Desktop | 7.85% | 1.53% | 8.27% | 8.89% | 6.85% | 1.49% | 3.50% | 6.33% | 8.67% | 5.89% | 1.73% | 2.86% | |||||
63 | Segment E, Mobile | 6.70% | 1.30% | 5.48% | 1.15% | 3.27% | 6.75% | 3.88% | 8.35% | 4.43% | 7.33% | 7.38% | 1.65% | |||||
64 | Segment F, Desktop | 7.91% | 2.83% | 2.60% | 4.29% | 5.36% | 6.64% | 3.66% | 3.64% | 5.48% | 6.33% | 5.48% | 6.89% | |||||
65 | Segment F, Mobile | 7.34% | 1.43% | 6.65% | 1.28% | 5.44% | 5.02% | 2.48% | 8.32% | 7.63% | 3.62% | 7.78% | 8.76% | |||||
66 | Total Revenue | $19,153,553 | $10,004,260 | $15,203,670 | $11,002,525 | $15,295,792 | $13,800,354 | $12,512,011 | $18,221,104 | $15,958,741 | $14,581,253 | $17,548,060 | $13,921,214 | $177,202,536 | ||||
67 | Potential Organic Lead Value* | $100 | *Slightly adjusted to reflect the actual potential revenune | |||||||||||||||
68 | Potential Paid Lead Value* | $150 | ||||||||||||||||