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
  • Business Meeting Showdown

    It is no secret that communication and collaboration are at the heart of success and longevity for any business. However, as businesses become more global and more employees work remotely, video conferencing is being increasingly used as an alternative to face-to-face interactions. There are pros to both business travel and video conferencing such as personal connection and ease of use. However, there are cons as well ranging from travel delays to being technologically reliant. more

  • Mobile Communication Showdown

    It's no secret that businesses are becoming agiler and employees are spending more time away from their desks. The question isn't should we get rid of our landlines, but how quickly can we replace them?However, staying connected with your colleagues, clients, and customers is absolutely essential for cultivating long-term, lucrative relationships that will help your company achieve success. more

  • Signs you are Ready for Mobile BI

    With workforces moving more and more mobile on a daily basis, it is essential to ensure that your company is able to arm your employees with the analytics that they need to succeed. 89% of business leaders believe that Big Data will revolutionize business operations in the same way that the internet did. These numbers show the trend towards investing in a BI system. more

  • 15 Ways to Optimize Your Contact Center

    We live in a time where customer experience is seen as an important competitive differentiator. Given this, wouldn't you like to make sure that your contact center is fully optimized to meet your business needs? Deciding to upgrade and optimize your contact center is a big step, and one that shouldn't be done without due diligence and plenty of research. more

  • Stress-Free Video Conferencing

    It should shock no one that video conferencing technology is an amazing tool to connect and engage with business contacts in a more personal and effective way. In fact, only 7% of how we communicate is through words, whereas a whopping 93% is through tone of voice and body language. To further the strength of video conferencing, 99% of professionals feel that by improving communication and collaboration, productivity will be positively impacted. more