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
  • 10 Reasons to Invest in Video Conferencing

    Have you been on the fence about implementing a video conferencing solution for your business? Not quite sure if your employees will utilize it or are concerned about the costs being too high? The modern workforce is adapting and evolving with more and more employees working remotely, it is essential that they have the tools to be able to communicate effectively. more

  • Checklist for Setting Up an In-House Contact Center

    As customer service continues to become the most important competitor differentiator, can you honestly state that your business ranks among the best in your industry? 93% of organizations expect that contact volume will either remain constant or increase over the next two years. It is absolutely essential that you have a contact center that has been set up for success. more

  • 2017 Business Intelligence Trends

    It's long been thought that business intelligence (BI) could only be utilized by highly trained analysts and was therefore unattainable for most businesses. However, advancements in BI have made it so that everyone can utilize BI solutions to help shape business decisions and drive companies bottom lines. more

  • Your Phone System and Your Bottom Line

    Businesses have been using phones to drive increases to their bottom lines for almost a century now. Telephony, much like the rest of the business world, has seen drastic changes with the increase in technological advancement. Voice Over Internet Protocol (VoIP), has enabled companies to connect with consumers at levels that have been seen as unheard of before. And trust us when we say this, it is doing wonders for the bottom line. more

  • How to Scale a Contact Center in 2017

    Are you on the fence about scaling your contact center and not sure how or whether or not now is the time? Studies have shown that 93% of executives expect that contact volume will remain constant or increase within the next two years. This means that now more than ever is the time to begin scaling and we are here to help. more