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
  • Is Your ERP Solution Out of Date?

    Enterprise Resource Planning (ERP) is a modern, large-scale software program designed to help businesses improve the internal flow of important corporate processes and communication. more

  • How Video Conferencing is Transforming Healthcare

    The telemedicine revolution is finally happening. Experts have been discussing the potential for patients and healthcare providers to connect remotely for years, but the market is just now moving to adopt it—in a big way. Data suggests this market will grow over 14% annually through 2020! more

  • How to Update Your Contact Center Software

    If improving customer experience is important to you (it should be), then 2017 may be a good year to reevaluate the software you use for your contact center. With customer preferences shifting, the importance of an efficient contact center has never been higher. You cannot afford to simply focus on keeping costs low. Significant competitive advantages are available to businesses who manage this area effectively. more

  • Leading the IT Revolution

    The status of technology within an organization is rapidly evolving—and so is the role of the CIO. With breakthrough capabilities enabled by new technologies, a growing shortage of available developers, and an increasingly tech-savvy business user, the role of IT—and the CIO in particular—is morphing into one of strategic advisor to the business and driver of innovation within the company. more

  • Leading the IT Revolution

    The status of technology within an organization is rapidly evolving—and so is the role of the CIO. With breakthrough capabilities enabled by new technologies, a growing shortage of available developers, and an increasingly tech-savvy business user, the role of IT—and the CIO in particular—is morphing into one of strategic advisor to the business and driver of innovation within the company. more