Sales Funnel Analysis Excel Template

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.