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
  • 2017 Contact Center Software Trends

    Did you know that, according to Forbes, 86 percent of customers will pay more for a better customer experience? Customer satisfaction is always a worthy business pursuit, but to identify customer preferences and exceed expectations, you must keep pace with innovations in the technology your customers are using. more

  • The Social Intranet: A guide to getting better business results

    This whitepaper describes why the shift from a traditional to a social intranet is imperative to staying competitive, and analyzes the costs and benefits associated with implementing one. You will also find useful KPIs to measure performance and further leverage your intranet's success, raising employee engagement and boosting your competitive advantage. more

  • How to Select Contact Center Software in 9 Steps

    Your choice of contact center software will affect the future success of your business. Don’t leave this important decision to chance. This guide provides nine actionable steps for the selection process. more

  • [Infographic] 15 Questions to Ask When Selecting a VoIP Provider

    Deciding which phone system is right for your business can be difficult. With our VoIP technology blueprint, discover the top 15 questions you should ask VoIP vendors before you make a buying decision. more

  • 2017 Business VoIP Buyer's Guide

    In 2017, more business will transition to a VoIP phone system. If you are among them—or if you’ll be upgrading an existing VoIP system—you need to learn about the latest technologies and market trends. more