From income goal to daily actions
Divide your goal by what you keep per sale to get the sales you need. Divide that by your conversion rate to see how many people need to visit your shop or page. A 1% to 3% conversion rate is a common planning range for small shops, though yours may differ.
The formulas behind it
Every result cell is a plain spreadsheet formula, so you can check the math or rebuild it yourself.
| Cell | Result | Formula |
|---|---|---|
| B8 | You keep per sale | =B3*(1-B4%) |
| B9 | Sales per month | =ROUNDUP(B2/B8) |
| B10 | Sales per week | =ROUNDUP(B9/4.33) |
| B11 | Visitors needed per month | =ROUNDUP(B9/B5%) |
