Create a conversion funnel model to optimise your online marketing
About the Excel spreadsheet
- Author: Dave Chaffey
- Last updated: January 2011
- Format: Excel 2003 template (.xls works in new and old versions of Excel)
- Download: Download now
How will this spreadsheet help me?
This Microsoft Excel spreadsheet has been created by Dave Chaffey of Smart Insights to help you improve leads and sales. The spreadsheet will allow you to optimise your investment in search engine marketing, display advertising, affiliate marketing and online PR to maximise leads, sales and profit.
These spreadsheets are included on the CD in Web Analytics 2.0 by Avinash Kaushik, Google’s Web Evangelist.
This spreadsheet features:
What does the template include?
The template includes these features:
- Set your overall budget and adjust the % investment in different media channels
- Channel options available include SEO, Adwords, Ad networks (Cost-per-click), Display (CPM), Sponsorship, Email marketing and owned media
- Automatically calculates response, leads, sales and profit based on media investment
- Allows you to specify different different response rates
- A simpler, single traffic source conversion model of the spreadsheet is available as part of Expert membership
This advice is free to access if you are a Basic-level member
Smart Insights Expert Members also get “at your desk access” to in-depth advice to improve their online marketing skills and capabilities:
- In-depth Ebooks
- Online training
- How to videos
- Marketing templates
- Audit Online Capabilities
Locked
About Smart Insights Templates
What make's our templates different?
The Smart Insights system for digital marketing improvement includes many templates to help you plan and manage your marketing. The templates are Word or Excel checklists to help you review a company's approach to digital marketing or Excel calculators and models to enable you to better plan digital marketing. All our templates are:- Focused on improvement – Each template will support you to review current ways of working and recommend improvements.
- Available in Word or Excel – Supplied in the most commonly used apps, they can be imported into other programmes.
- Provided as an unbranded template – Unlike our guides, these templates are plain, so you can easily modify to add your own company logo
- Field-tested – Dave Chaffey and the authoring team have years of experience in online marketing, we know the questions that need answering, so that's we include
How will the templates help me?
Our templates are designed to be used as "live documents" to help you and your team when planning or managing digital marketing. This is how our guides help:- Company owners and marketing managers - many of templates cover planning and strategy.
- Digital marketing and Ecommerce managers - as well as planning and strategy you can audit specific digital channels like search or social media marketing with our templates.
- Digital marketing specialists - templates are available for each of the main digital channels, so whether you work on Social media marketing, SEO, PPC, email marketing or conversion rate optimisation for the website there is a template to help. If there isn't, get in touch and we can develop one .
- Consultants and agency specialists - review your own techniques and process against the best practice templates to help you provide structured insights and recommendations for clients.
