How To Write a Marketing Plan with a Simple, Three-Tabbed Spreadsheet

Updated: October 29, 2010

The first tab is the most important, as it represents a roll-up of how leads generated convert to sales opportunities and closed business each month or quarter. If you already know what your lead-to-opportunity and opportunity-to-close conversion rates are, you should be able to plug in the expected sales figures each month or quarter, and the formulas will work back to 1) the required size of sales pipeline at the beginning of the month/quarter, and 2) the required number of leads to achieve that pipeline. Relatively simple napkin math.

The second tab breaks down, by month and by channel, where those leads are coming from. It demonstrates explicitly which marketing channels you will lean on, and with what expected lead volume, to contribute to the required overall figure to fuel the sales model on tab one.

The third tab demonstrates how you are able to achieve certain lead volume by month and channel. For example, if you're counting on email marketing, it will demonstrate how many emails need to be sent in a given month, with what expected response and conversion rate, to hit that number of leads. Same for required search impressions and click rates, same for expected event or Webinar registration and/or attendance, etc.

Featured Research
  • The New 2017 Phone Systems Comparison Guide

    It was a painstaking process, but to help B2B companies start 2017 off on the right foot, we recently compiled a comparative list of the top 34 business phone vendors in the world. In one, easy-to-reference location, we’ve neatly outlined the information you need. more

  • Best Practices for Contact Center Quality Assurance

    A contact center often brings about a prospect’s first real-time interaction with your company. As such, if it’s not a positive one, they’ll likely look elsewhere for help. With 69% of Americans more inclined to recommend a company to friends and family after a positive customer service experience, you’ll need to exceed expectations on the following fronts. more

  • How to Make Your Contact Center More Efficient

    There’s a very good chance that your contact center is underperforming. With consumer preferences continuously changing, strategies that were once effective now result in too many unsatisfied customers. Fixing this problem involves reviewing your current procedures and optimizing them to drive better results. more

  • 8 Common Pain Points UC Eliminates

    Many businesses rely on a collection of communication tools that they adopt to address specific needs as they arise. This strategy may seem to work in the beginning, but eventually will lead to a system that is cumbersome to use, difficult to explain to new hires, expensive, and effective in some areas, but full of gaps. more

  • Your Guide to Social Customer Service

    Did you know that 67% of online consumers have used social media for customer service purposes?Unfortunately, many businesses ignore social mentions because they don’t know how to handle them appropriately. This is a problem because managing and responding to these mentions can make or break your brand. more