BlogsBack to all articles

How to Build a Sales Funnel Spreadsheet [video]

Topics:
B2B Sales
How to Build a Sales Funnel Spreadsheet [video]

Ever wondered how to build a sales funnel spreadsheet? This blog entails a few simple tips about how to build one, and some clever insights into your funnel.

In a nut shell, don’t use a spreadsheet. If you really must however, be sure to follow five important steps.

  • Set up columns to track basic opportunity data including close date and amount
  • Create a stacked bar chart with clever formatting including a hidden field ‘spacer’ to center your bars
  • Add columns for each stage in the buyer’s journey, including ‘leaked’ formatted for date to calculate lag by stage
  • Learn how to analyse for lag and leakage by stage
  • Add fields for sales person and lead source and compare lag and leakage by these new values
funnel-plan-sales-and-marketing-planning-tool
Author –
Hugh Macfarlane

Hugh Macfarlane is founder and CEO of align.me. He's the author of 'The Leaky Funnel', and hundreds of video blogs, papers and ebooks and a handful of research reports on all things alignment.

Let’s create something great together

If you’re ready to get your sales and marketing engine roaring, we’re ready to help you. Get in touch to get things started.

Talk to us

Subscribe to our newsletter

Keep up to date with powerful B2B insights and news

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.