Has anyone done this? It’s not an easy thing to do with any degree of accuracy.
I’ve been working off my own homegrown financial models, based on a number of KPIs, namely:
- “Organic” Visitors (predicted)
- PPC traffic based on Google Adwords Estimator
- Average Order value (estimated on market knowdlege)
- Average conversion rate (based on data from here)
- Unit shipping costs
- Amortised Returns Factor (A % of gross order intake)
- Card processor margins
- Staff rates etc
Does anyone have any good models built, or some spreadsheets with a better starting point? Would be much appreciated.
Cheers,
Matt