Screenshot showing Google Sheets page showing conversion rate and sales Remember my break-even calculation? I need to sell 44 backpacks at full price (or 79 with a 30% discount). But as the goal is not just to be break even but to make $1,000 in profit, I need to sell some extra product. With a profit of $53.89 per backpack, I’d need to sell 19 more, making it 63 in total. This means I have to bring 2,100 people to my website. Furthermore, as I planned to do marketing for my store for just 5 weeks*, my daily traffic
goal was set to 60 visitors. *Just 5 weeks out of this 8-week live case-study project. As long as the business exists, I will continue my marketing efforts. Those numbers seemed more than achievable. The next step was to figure out where to get the Telemarketing list traffic from. I created another Google spreadsheet and put in all traffic sources and potential traffic I could think of for this new business. Screenshot showing Google Sheets page filled with data I split the sources into... One-time actions. Weekly actions.
Daily actions. As you can see on the image above, my potential traffic from all sources is 5,375. That’s more than 2.5 times the needed traffic. I was very happy to see this. Especially, as I tried to keep the traffic numbers as pessimistic as possible. Too many people purchase with a discount or anything else happens that does not match with my calculations, I still have a good chance to achieve my goal. But this spreadsheet is not only for traffic calculations.