Digital marketing planning spreadsheet

An Excel spreadsheet to create an online marketing campaign budget to calculate your ROI

About the Excel spreadsheet

This Microsoft Excel spreadsheet has been created by Dr Dave Chaffey of Smart Insights to help you create a 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 engine marketing, display advertising, affiliate marketing and online PR to achieve target for leads, sales and profit.

These spreadsheets were previously included on the CD in Web Analytics 2.0 by Avinash Kaushik, Google’s Web Evangelist.

What does the template include?

The template includes these features to calculate your annual budget:

  • 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 response rates for different media channels

Available to
Expert members
Learn more

What our members say

I first came across your work when studying for Diploma in Digital Marketing with the Chartered Institute of Marketing, here in Australia. We referred to your Digital Marketing book extensively and I have since become a Smart Insights Expert member. Love the material that you guys publish. Presentation of documents and attention to detail is awesome!

Neil Armstrong, Consultant

We are at the early stages of our digital marketing journey, Smart Insights templates and tutorials help us check and learn as we go.

Stuart Sykes, Digital Marketing Manager

Smart Insights is one of the best digital ‘tools’ on the internet today. It has been a great asset as a channel of advice and insight, helping me to deliver an all-encompassing digital strategy.

Jennifer Law, E-Communications Manager, National Pharmacy Association

Get access to this now by purchasing an Individual or Business Expert membership

Plus access 100+ resources in our Digital Marketing Library to Plan, Manage and Optimize your marketing:

  • In-depth Ebooks
  • Online training
  • How to videos
  • Marketing templates