Sales Funnel Analysis Excel Template

Tool used to improve the conversion of prospective customers by optimizing the sales funnel.

by Alberto Scappini
Business Analytics Manager, Professor Data Analytics, AuthorFollow 101

10 reviews779 views|Start the discussion!|Bookmark download for free

Description
Models that estimate demand tend to focus on a specific aspect of the sales channel. For example, a pricing model usually defines the choice of customers in front of a set of possible products or services. However, the awareness of the product is not taken into consideration (usually it assumes full awareness to simplify the analysis).

In an ideal world, these pricing models need to be included in a broader framework called the sales funnel. A sales funnel consists of the following:

1) Market: number of potential customers
2) Awareness: people in the market who know the product
3) Consideration: people who know the product and take it into consideration for purchasing
4) Conversion: of the people who consider the product and then those who buy it.

Please refer to the methodology for an example and for more on market awareness, awareness consideration, consideration conversion and optimization.

This Best Practice includes
1 Sales Funnel Analysis Excel Template