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 percentage investment in different media channels to see the impact on your forecast results
  • Channel options available include SEO, Google Ads, 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 percentage 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.”

About the author

Dr. Dave Chaffey

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

Access this resource now

Individual and Business members get full access to this and 16 other guides in the Digital marketing strategy and planning Toolkit.

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

The Digital marketing planning spreadsheet is included in the

Digital marketing strategy and planning Toolkit

Individual or Business members can access this and 16 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

Why Wait? Start Improving your marketing today

Join as an Individual or Business member to access this toolkit and up to 19 more.

Individual Membership

  • Enhance your marketing skills
  • Keep up to date with all the latest techniques
  • Become more effective in your role and develop your career

Business Membership

  • Improve your (and your clients') results from marketing
  • Upskill and develop your marketing team
  • Get dedicated support on your journey

Trusted by marketers all over the world

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

...plus over 165,000 consultants, agencies, entrepreneurs and SMB's in over 170 countries.

Get better results

Make your job easier

Tenfold improvement

Learn more about Individual or Business membership options
Smart insights logo
CLOSE