A template for estimating leads, opportunities and sales


Share on LinkedIn

Most marketing plans, once you’ve outlined clearly what measurable goals and outcomes look like, should start with a spreadsheet. That spreadsheet should outline and/or predict what the business can expect in revenue and/or customer growth, from what initiatives, and at what volume/cost per initiative or channel.

Here’s a short summary of what this three-tabbed spreadsheet could look like.

The first tab is the most important, and doesn’t have to take long at all to complete. Below is a sample template you can use to either build a sales projection based on a set number of leads generated, or (with some formula adjustments) how many qualified leads are required to hit a particular sales expectation.

You’ll see this template assumes two different products (at different average price points), as well as an expected cost per qualified lead. This way you not only have broken down leads, new opportunities and sales required (or expected) per quarter or month, but you can also see how much it will likely cost to generate those leads.

Of course, you can make this model far more complicated. But might be a good place to start, at minimum to stress-test your current plan and assumptions.

Republished with author's permission from original post.

Matt Heinz
Prolific author and nationally recognized, award-winning blogger, Matt Heinz is President and Founder of Heinz Marketing with 20 years of marketing, business development and sales experience from a variety of organizations and industries. He is a dynamic speaker, memorable not only for his keen insight and humor, but his actionable and motivating takeaways.Matt’s career focuses on consistently delivering measurable results with greater sales, revenue growth, product success and customer loyalty.


Please use comments to add value to the discussion. Maximum one link to an educational blog post or article. We will NOT PUBLISH brief comments like "good post," comments that mainly promote links, or comments with links to companies, products, or services.

Please enter your comment!
Please enter your name here