These Microsoft Excel spreadsheets have been created by Dr Dave Chaffey of Smart Insights to help you improve leads and sales. They will allow you to set realistic goals based on the volume, cost and quality of traffic that you're driving from search engine marketing, display advertising, affiliate marketing and online PR.
- Simple conversion model - Download Excel spreadsheet
- More advanced conversion model - Download conversion spreadsheet
Dave developed these spreadsheets to help students prepare digital budgets for case study assignments when he was examiner and tutor on the Professional Diploma in Digital Marketing for the Institute of Digital and Direct Marketing between 2004 and 2012. They have been downloaded by tens of thousands of professionals to create annual or campaign budgets and students at universities and other qualifications like the CIM Diploma in Digital Marketing and Google Squared.
Different worksheets cover:
- E-marketing planning and budgeting models spreadsheet
- Ecommerce return on investment
- Multichannel lead generation and sale modelling
- Email marketing modelling
- Revenue potential for online publishers and startup businesses (Expert members)
Basic member can also sign-up to join thousands of subscribers to our free members' Smart Insights Digital marketing Essentials Enewsletter which is designed for busy marketers and digital marketing specialists who don't have time to follow the latest developments via RSS or Twitter. Each Friday you will receive alerts and articles from the Smart Insights Expert Commentators on the most important developments in digital marketing including digital strategy, web analytics plus search, social and email marketing. Plus we also feature the latest stats, tips and tools. You can unsubscribe anytime and we won't share your personal details with other companies.