Marketing Funnel Calculator

Resource Overview

Use this tool to evaluate calculate how many leads you need to generate to hit your revenue target.


Related Resources

Your Problem

You need to optimize your marketing funnel so that you can effectively demonstrate your department´s responsibilities and revenue contribution.

Our Solution

We created the Marketing Funnel Calculator to give you a great, visual representation of your marketing metrics data.  You will need be familiar with you marketing department's annual revenue target, the average sale of your products/services, the percentage of revenue marketing is responsible for, and a few other key marketing and sales metrics.

This tool works by enabling you to first identify your annual revenue target and average selling price. In addition to this, you will be asked to add the revenue that marketing is responsible for, opportunity to close, sales qualified leads, leads accepted, marketing qualified leads and the response rate to the marketing campaigns.

Once you've input your data, your marketing funnel will provide you with key data points, such as deals that must be sourced by marketing and revenue impact, that will help you optimize your company's marketing and sales initiatives.

Key Benefits

  • considers key metrics in the marketing & sales cycles
  • encourages growth through marketing channels
  • provides an example of marketing benefits in the sales cycles
  • offers a great, visual presentation of data points
  • saves 2 hours of writing/formatting


Microsoft Excel Spreadsheet

Estimated Time Required: 2 Hours

Skills Required: Marketing Analysis