| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | CONVERTED TRAFFIC GOAL: | 15,000 | CONFIRMED BY SOURCE...👍 | (to make your own copy of this spreadsheet that you can edit, go to "File" → "Make a Copy") | |||
2 | TOTAL POTENTIAL CONVERTED TRAFFIC: | 1,000 | |||||
3 | REMAINING: | 14,000 | |||||
4 | PERCENT COMPLETE: | 6.67% | |||||
5 | SOURCE | TOTAL AUDIENCE SIZE | REACH RATE (Playlist: How many go to the Playlist when you're on it, Site: How many see the content when it's posted) | AUDIENCE REACHED | CONVERSION RATE | POTENTIAL CONVERTED TRAFFIC | SOURCE CONFIRMED? |
6 | Playlist X | 50,000 | 10.00% | 5,000 | 12.00% | 600 | Yes! |
7 | Instagrammer X | 100,000 | 4.00% | 4,000 | 10.00% | 400 | Yes! |
8 | TikToker X | 80,000 | 3.00% | 2,400 | 10.00% | 240 | Not Yet |
9 | Email List X | 350,000 | 20.00% | 70,000 | 25.00% | 17,500 | Not Yet |
10 | Blog X | 30,000 | 11.00% | 3,300 | 15.00% | 495 | Rejected |
11 | (for a blog ⬆, the audience size could be calculated from their social reach or monthly unique visitors) |