Website conversion and revenue model calculators
Use our conversion and revenue model spreadsheet to create a budget to give you more confidence in your lead or sales forecasts
How will this website conversion and revenue model calculators spreadsheet help me and my business?
This spreadsheet includes a worksheet for startup businesses to develop their revenue model based on Cost-per-click (CPC, cost-per-thousand (CPM) or affiliate advertising models and it can be applied to Ecommerce, B2B lead generation and media sites.
It also has three other worksheets for calculating the increase in leads and sales you can get from investing in conversion rate optimization (AB testing) and other digital initiatives.
The spreadsheet shows you how to:
- Forecast leads, sales and profit to create business plans for startups
- Forecast predicted target leads and sales to make the business case for investment in digital for existing businesses
- Automatically calculate expected returns for best and worst case scenarios
Who is this spreadsheet for?
This spreadsheet is aimed at helping:
- Owners and founders of startups looking to estimate their revenue potential
- Marketers creating digital marketing plans who want to forecast sales improvements
- Marketers responsible for getting better results from their website who want to estimate improvements in leads and sales
How is the spreadsheet structured?
The template includes four separate worksheets:
- 1. Basic conversion model for B2B or B2C sites
- 2. Multichannel conversion model for sites with phone or in-store sales
- 3. Online business startup revenue model calculators
- 4. Conversion optimization business case model – determine lead or sales increase
Resource Details
- Author: Dr. Dave Chaffey
- Format: Excel 2003 template (.xls works in new and old versions of Excel)
About the author
Dr. Dave Chaffey
Dave is co-founder of Smart Insights and creator of the Smart Insights RACE Planning Framework. He has consulted and trained for many businesses including large international B2B and B2C brands including 3M, BP, Barclaycard, Dell, Confused.com, HSBC, Mercedes-Benz, Microsoft, M&G Investment, Rentokil Initial, O2, Royal Canin (Mars Group) plus many smaller businesses. For his full profile, or to connect on LinkedIn or other social networks, see the About Dave Chaffey profile page on Smart Insights. Dave is author of 5 bestselling books on digital marketing including Digital Marketing Excellence and Digital Marketing: Strategy, Implementation and Practice. He has been recognized by the Chartered Institute of Marketing as one of 50 marketing ‘gurus’ worldwide who have helped shape the future of marketing.