| A | B | C | D | E | F | G | H | I | J | K | L | M | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Website Marketing Metrics | ||||||||||||
2 | January | February | March | April | May | June | July | August | September | October | November | December | |
3 | Website traffic | 403 | 565 | 2,402 | 2,407 | 2,700 | 3,543 | 4,598 | 4,739 | 6,931 | 6,038 | 8,910 | 9,180 |
4 | Traffic growth rate | #REF! | 40% | 325% | 0% | 12% | 31% | 30% | 3% | 46% | -13% | 48% | 3% |
5 | New email subscribers | 0 | 475 | 55 | 136 | 172 | 174 | 183 | 342 | 283 | 291 | 181 | 182 |
6 | Unsubscribers | 24 | 2 | 18 | 4 | 67 | 3 | 34 | 2 | 33 | 11 | 22 | 12 |
7 | Net new email subscribers | -24 | 473 | 37 | 132 | 105 | 171 | 149 | 340 | 250 | 280 | 159 | 170 |
8 | Total Email Subscribers | -24 | 449 | 486 | 618 | 723 | 894 | 1043 | 1383 | 1633 | 1913 | 2072 | 2242 |
9 | Traffic to email conversion rate | 0% | 84% | 2% | 6% | 6% | 5% | 4% | 7% | 4% | 5% | 2% | 2% |
10 | Email subscriber growth rate | #REF! | -1970.83% | 8.24% | 27.16% | 16.99% | 23.65% | 16.67% | 32.60% | 18.08% | 17.15% | 8.31% | 8.20% |
11 | Email Marketing Metrics | ||||||||||||
12 | January | February | March | April | May | June | July | August | September | October | November | December | |
13 | New subscribers | 0 | 475 | 55 | 136 | 172 | 174 | 183 | 342 | 283 | 291 | 181 | 182 |
14 | Net subscribers | -24 | 473 | 37 | 132 | 105 | 171 | 149 | 340 | 250 | 280 | 159 | 170 |
15 | % Existing Subscribers | #DIV/0! | 100% | 67% | 97% | 61% | 98% | 81% | 99% | 88% | 96% | 88% | 93% |
16 | Churned Subscribers (Unsubscribers) | 24 | 2 | 18 | 4 | 67 | 3 | 34 | 2 | 33 | 11 | 22 | 12 |
17 | Net New Subscribers | -24 | 473 | 37 | 132 | 105 | 171 | 149 | 340 | 250 | 280 | 159 | 170 |
18 | Total Subscribers | -24 | 449 | 486 | 618 | 723 | 894 | 1,043 | 1,383 | 1,633 | 1,913 | 2,072 | 2,242 |
19 | Churn Rate | -100% | 0% | 4% | 1% | 9% | 0% | 3% | 0% | 2% | 1% | 1% | 1% |
20 | Traffic to subscriber conversion rate | 0% | 84% | 2% | 6% | 6% | 5% | 4% | 7% | 4% | 5% | 2% | 2% |
21 | Subscriber growth rate | N/A | -1971% | 8% | 27% | 17% | 24% | 17% | 33% | 18% | 17% | 8% | 8% |
22 | Revenue Metrics | ||||||||||||
23 | January | February | March | April | May | June | July | August | September | October | November | December | |
24 | #1 Revenue Stream | $2,039.00 | $1,928.00 | $4,101.99 | $2,849.00 | $3,810.00 | $2,832.00 | $2,830.00 | $2,838.00 | $1,728.00 | $2,830.00 | $4.00 | $4.00 |
25 | Product % Total Revenue | 47% | 37% | 6% | 31% | 89% | 86% | 84% | 38% | 27% | 82% | 50% | 50% |
26 | #2 Revenue Stream | $2,332.00 | $3,256.00 | $65,856.00 | $6,456.00 | $464.00 | $456.00 | $546.00 | $4,564.00 | $4,564.00 | $626.00 | $4.00 | $4.00 |
27 | % Total Revenue | 53% | 63% | 94% | 69% | 11% | 14% | 16% | 62% | 73% | 18% | 50% | 50% |
28 | Gross Monthly Revenue | $4,371 | $5,184 | $69,958 | $9,305 | $4,274 | $3,288 | $3,376 | $7,402 | $6,292 | $3,456 | $8 | $8 |
29 | Month-to-Month Revenue growth rate | N/A | 19% | 1249% | -87% | -54% | -23% | 3% | 119% | -15% | -45% | -100% | 0% |
30 | Gross Revenue | $4,371 | $9,555 | $79,513 | $88,818 | $93,092 | $96,380 | $99,756 | $107,158 | $113,450 | $116,906 | $116,914 | $116,922 |
31 | Product Metrics | ||||||||||||
32 | January | February | March | April | May | June | July | August | September | October | November | December | |
33 | Product #1 Sold | 23 | 32 | 2 | 34 | 23 | 1 | 11 | 13 | 41 | 13 | 12 | 13 |
34 | % of Total Units Sold | 21% | 36% | 7% | 92% | 30% | 2% | 15% | 52% | 75% | 30% | 17% | 13% |
35 | Product #2 Sold | 43 | 23 | 2 | 1 | 12 | 3 | 5 | 6 | 7 | 23 | 4 | 53 |
36 | % of Total Units Sold | 39% | 26% | 7% | 3% | 16% | 7% | 7% | 24% | 13% | 52% | 6% | 53% |
37 | Product #3 Sold | 45 | 34 | 23 | 2 | 42 | 41 | 56 | 6 | 7 | 8 | 56 | 34 |
38 | % of Total Units Sold | 41% | 38% | 85% | 5% | 55% | 91% | 78% | 24% | 13% | 18% | 78% | 34% |
39 | Total Products Sold | 111 | 89 | 27 | 37 | 77 | 45 | 72 | 25 | 55 | 44 | 72 | 100 |
40 | Month-to-Month Growth Rate | #VALUE! | 80% | 30% | 137% | 208% | 58% | 160% | 35% | 220% | 80% | 164% | 139% |