| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Labor (1 Day)* | Tweets Per Day | Tweets Per Year | Daily Cost per Tweet | Annual Cost per Tweet | # Followers (True Fans Who Are Likely to Buy) | Clickthrough | Clicks | Conversion Rate | Monthly Sales* | Margin | Monthly Revenue | Annual Net Proceeds | Annual ROI | ||
2 | $50 | 10 | 2500 | $5 | $12,500 | 1,000 | 5% | 50 | 5% | 2.50 | $5 | $13 | -$12,350 | -199% | PhilBaumann.com | |
3 | $50 | 10 | 2500 | $5 | $12,500 | 2,000 | 5% | 100 | 5% | 5.00 | $5 | $25 | -$12,200 | -198% | ||
4 | $50 | 10 | 2500 | $5 | $12,500 | 4,000 | 5% | 200 | 5% | 10.00 | $5 | $50 | -$11,900 | -195% | ||
5 | $50 | 10 | 2500 | $5 | $12,500 | 8,000 | 5% | 400 | 5% | 20.00 | $5 | $100 | -$11,300 | -190% | ||
6 | $50 | 10 | 2500 | $5 | $12,500 | 16,000 | 5% | 800 | 5% | 40.00 | $5 | $200 | -$10,100 | -181% | ||
7 | $50 | 10 | 2500 | $5 | $12,500 | 32,000 | 5% | 1,600 | 5% | 80.00 | $5 | $400 | -$7,700 | -162% | ||
8 | $50 | 10 | 2500 | $5 | $12,500 | 64,000 | 5% | 3,200 | 5% | 160.00 | $5 | $800 | -$2,900 | -123% | ||
9 | $50 | 10 | 2500 | $5 | $12,500 | 128,000 | 5% | 6,400 | 5% | 320.00 | $5 | $1,600 | $6,700 | -46% | ||
10 | $50 | 10 | 2500 | $5 | $12,500 | 256,000 | 5% | 12,800 | 5% | 640.00 | $5 | $3,200 | $25,900 | 107% | ||
11 | $50 | 10 | 2500 | $5 | $12,500 | 512,000 | 5% | 25,600 | 5% | 1,280.00 | $5 | $6,400 | $64,300 | 414% | ||
12 | $50 | 10 | 2500 | $5 | $12,500 | 1,024,000 | 5% | 51,200 | 5% | 2,560.00 | $5 | $12,800 | $141,100 | 1029% | ||
13 | $50 | 10 | 2500 | $5 | $12,500 | 2,048,000 | 5% | 102,400 | 5% | 5,120.00 | $5 | $25,600 | $294,700 | 2258% | ||
14 | $50 | 10 | 2500 | $5 | $12,500 | 4,096,000 | 5% | 204,800 | 5% | 10,240.00 | $5 | $51,200 | $601,900 | 4715% | ||
15 | $50 | 10 | 2500 | $5 | $12,500 | 8,192,000 | 5% | 409,600 | 5% | 20,480.00 | $5 | $102,400 | $1,216,300 | 9630% | ||
16 | $50 | 10 | 2500 | $5 | $12,500 | 16,384,000 | 5% | 819,200 | 5% | 40,960.00 | $5 | $204,800 | $2,445,100 | 19461% | ||
17 | $50 | 10 | 2500 | $5 | $12,500 | 32,768,000 | 5% | 1,638,400 | 5% | 81,920.00 | $5 | $409,600 | $4,902,700 | 39122% | ||
18 | $50 | 10 | 2500 | $5 | $12,500 | 65,536,000 | 5% | 3,276,800 | 5% | 163,840.00 | $5 | $819,200 | $9,817,900 | 78443% | ||
19 | $50 | 10 | 2500 | $5 | $12,500 | 131,072,000 | 5% | 6,553,600 | 5% | 327,680.00 | $5 | $1,638,400 | $19,648,300 | 157086% | ||
20 | $50 | 10 | 2500 | $5 | $12,500 | 262,144,000 | 5% | 13,107,200 | 5% | 655,360.00 | $5 | $3,276,800 | $39,309,100 | 314373% | ||
21 | $50 | 10 | 2500 | $5 | $12,500 | 524,288,000 | 5% | 26,214,400 | 5% | 1,310,720.00 | $5 | $6,553,600 | $78,630,700 | 628946% | ||
22 | $50 | 10 | 2500 | $5 | $12,500 | 1,048,576,000 | 5% | 52,428,800 | 5% | 2,621,440.00 | $5 | $13,107,200 | $157,273,900 | 1258091% | ||
23 | $50 | 10 | 2500 | $5 | $12,500 | 2,097,152,000 | 5% | 104,857,600 | 5% | 5,242,880.00 | $5 | $26,214,400 | $314,560,300 | 2516382% | ||
24 | $50 | 10 | 2500 | $5 | $12,500 | 4,194,304,000 | 5% | 209,715,200 | 5% | 10,485,760.00 | $5 | $52,428,800 | $629,133,100 | 5032965% | ||
25 | $50 | 10 | 2500 | $5 | $12,500 | 8,388,608,000 | 5% | 419,430,400 | 5% | 20,971,520.00 | $5 | $104,857,600 | $1,258,278,700 | 10066130% | ||
26 | $50 | 10 | 2500 | $5 | $12,500 | 16,777,216,000 | 5% | 838,860,800 | 5% | 41,943,040.00 | $5 | $209,715,200 | $2,516,569,900 | 20132459% | ||
27 | $50 | 10 | 2500 | $5 | $12,500 | 33,554,432,000 | 5% | 1,677,721,600 | 5% | 83,886,080.00 | $5 | $419,430,400 | $5,033,152,300 | 40265118% | ||
28 | $50 | 10 | 2500 | $5 | $12,500 | 67,108,864,000 | 5% | 3,355,443,200 | 5% | 167,772,160.00 | $5 | $838,860,800 | $10,066,317,100 | 80530437% | ||
29 | $50 | 10 | 2500 | $5 | $12,500 | 134,217,728,000 | 5% | 6,710,886,400 | 5% | 335,544,320.00 | $5 | $1,677,721,600 | $20,132,646,700 | 161061074% | ||
30 | $50 | 10 | 2500 | $5 | $12,500 | 268,435,456,000 | 5% | 13,421,772,800 | 5% | 671,088,640.00 | $5 | $3,355,443,200 | $40,265,305,900 | 322122347% | ||
31 | ||||||||||||||||
32 | * In practice, the cost of maintaining a Twitter account actually rises because more time is needed to manage increasing follower counts. | |||||||||||||||
33 | * Monthly sales are dived by 30, since each follower will only make one purchase per month. | |||||||||||||||
34 | ||||||||||||||||
35 | ||||||||||||||||
36 | ||||||||||||||||
37 | ||||||||||||||||
38 | ||||||||||||||||
39 | ||||||||||||||||
40 | ||||||||||||||||
41 | ||||||||||||||||
42 | ||||||||||||||||
43 | ||||||||||||||||
44 | ||||||||||||||||
45 | ||||||||||||||||
46 | ||||||||||||||||
47 | ||||||||||||||||
48 | ||||||||||||||||
49 | ||||||||||||||||
50 | ||||||||||||||||
51 | ||||||||||||||||
52 | ||||||||||||||||
53 | ||||||||||||||||
54 | ||||||||||||||||
55 | ||||||||||||||||
56 | ||||||||||||||||
57 | ||||||||||||||||
58 | ||||||||||||||||
59 | ||||||||||||||||
60 | ||||||||||||||||
61 | ||||||||||||||||
62 | ||||||||||||||||
63 | ||||||||||||||||
64 | ||||||||||||||||
65 | ||||||||||||||||
66 | ||||||||||||||||
67 | ||||||||||||||||
68 | ||||||||||||||||
69 | ||||||||||||||||
70 | ||||||||||||||||
71 | ||||||||||||||||
72 | ||||||||||||||||
73 | ||||||||||||||||
74 | ||||||||||||||||
75 | ||||||||||||||||
76 | ||||||||||||||||
77 | ||||||||||||||||
78 | ||||||||||||||||
79 | ||||||||||||||||
80 | ||||||||||||||||
81 | ||||||||||||||||
82 | ||||||||||||||||
83 | ||||||||||||||||
84 | ||||||||||||||||
85 | ||||||||||||||||
86 | ||||||||||||||||
87 | ||||||||||||||||
88 | ||||||||||||||||
89 | ||||||||||||||||
90 | ||||||||||||||||
91 | ||||||||||||||||
92 | ||||||||||||||||
93 | ||||||||||||||||
94 | ||||||||||||||||
95 | ||||||||||||||||
96 | ||||||||||||||||
97 | ||||||||||||||||
98 | ||||||||||||||||
99 | ||||||||||||||||
100 |