Guides and Templates

Digital marketing planning spreadsheet

An Excel spreadsheet to create an online marketing campaign media budget

How will this template help me and my business?

Many business don't have clear, SMART objectives for their digital marketing. Without experience, it can be difficult to know how to create a more data-driven approach to digital marketing.

This Microsoft Excel spreadsheet has been created to help you create a clearer acquisition plan to improve leads and sales. The spreadsheet will enable you to create a budget for the year ahead to define and then optimise your investment in search marketing, display advertising, affiliate marketing and online PR. Using this spreadsheet will give you confidence that you have defined more realistic targets for leads, sales and profit.

These spreadsheets from Dave Chaffey of Smart Insights were previously included on the CD in the acclaimed book Web Analytics 2.0 by Avinash Kaushik, Google’s highly regarded Digital Marketing Evangelist. They have been fully updated to cover the most important digital marketing channels today from SEO and AdWords through to YouTube and Facebook marketing.

Who is this spreadsheet for?

This 'hands-on' conversion-funnel based spreadsheet is designed for anyone making the case for investment in digital marketing who wants to show with more confidence the results they will get in terms of visits, leads and sales against the channels they invest in. This includes:

  • Digital marketing managers
  • Customer acquisition managers
  • Marketing managers

They require some experience of KPIs for measuring digital marketing campaigns which we explain in the recommended resources.

How is this spreadsheet structured?

The template includes these features to calculate your planned marketing outcomes from annual plans or campaigns where digital marketing is the main investment.

  • Set your overall budget and quickly adjust the % investment in different media channels to see the impact on your forecast results
  • Channel options available include SEO, AdWords,  Ad networks (Cost-per-click), Display (CPM), Social media, Remarketing, Sponsorship, Email marketing and owned media
  • Automatically calculates response, leads, sales and profit based on media investment
  • Allows you to specify different response rates for different media channels

As explained on the ‘Read Me’ worksheet, you have a choice of different tabs/worksheets depending on how much detail you want to go into.  We recommend the detail media mix model which defines conversion models for distinct digital media channels based on a % budget split between channels and costs/responsiveness of media. The details enables the main channels like Programmatic, Social, GDN, Brand, non-brand search and remarketing  to be modelled.

Resource Details

Dave Chaffey explains how these spreadsheets originated:

“I have developed and extended these spreadsheets since 2004 to help marketers plan their returns from digital marketing campaigns more precisely by developing more specific targets. Updated for all the main channels in 2017, you can use them for modelling response and ROI from an individual campaign or on an annual basis.”

About the author

Dave is co-CEO and co-founder of Smart Insights. He is editor of the 100+ templates, ebooks and courses in the digital marketing resource library created by our team of 25+ Digital Marketing experts. Our resources used by our members in more than 100 countries to Plan, Manage and Optimize their digital marketing.

For my 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. In 2004 he was recognised by the Chartered Institute of Marketing as one of 50 marketing ‘gurus’ worldwide who have helped shape the future of marketing.

Individual
Business

Individual or Business members get full access to this and 18 other guides in the Digital Marketing Strategy and Planning Toolkit.

Learn more about membership Already an Individual or Business member?
Login here
Look Inside

The Digital marketing planning spreadsheet is included in the

Digital Marketing Strategy and Planning Toolkit

Individual or Business members can access this and 18 other guides and templates in this toolkit

Learn more about individual or business membership options Already an Individual or Business Member? Login here

...or take a look at the other Guides and Templates in this Toolkit

Trusted by marketers all over the world

Since 2009 our toolkits have helped thousands of marketers in over 100 countries to hit - and exceed - their targets.
Will you be next?

...plus over 150,000 consultants, agencies, entrepreneurs and SMB's in over 100 countries.

Get better results

"A goldmine of digital information on digital marketing that can help you get better results"

Make your job easier

"I'd recommend signing up to Smart Insights for a suite of useful tools
from planning templates to strategy docs and a variety of other guides to make your job easier."

Tenfold improvement

It's my digital marketing go-to Bible Tenfold improvements in digital marketing results."

Learn more about Individual or business membership options
CLOSE