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
  • Are You Using These 5 VoIP Features?

    In large part, the success of your business depends on the strength and reliability of your team’s many communication networks—this includes your Voice over Internet Protocol system (VoIP). more

  • Video Conferencing Best Practices

    Video conferencing is quickly becoming one of the most important communication channels for both small and big businesses. As more businesses turn to this technology, expectations about the experience are also rising. It’s not enough to just offer video conferencing as a communication method. You also need to meet minimum audio and visual standards, and there’s even proper etiquette to consider. more

  • 10 Contact Center Myths Busted

    For most forward-thinking companies, the use of contact center software is on the rise. That said, in spite of contact center software’s sudden rise in popularity, a number of myths have begun to take shape. more

  • Go Mobile and Increase Employee Productivity

    The Bring Your Own Device (BYOD) and Voice over Internet Protocol (VoIP) tech trends now allow people to work whenever, wherever, and however they want—mobility makes it happen. more

  • [Infographic] How to Select a Phone System in 10 Steps

    Choosing the perfect phone system for your business is no small task …. Depending on the size of your company, the industry in which you work, and the specific needs your phone system will be required to meet, any number of solutions could get the job done. more