After one series of posts about sales funnels where you can read about the basics of sales funnel, improvements and metrics of the sales funnel, I want to present one template that you can use to plan the sales and marketing activities that will change the metrics of the sales funnel. I make one template that will calculate the results and will give directions for activities that you must accomplish to reach wanted income for the analyzed year. Sales funnel planning template will give you the number of customers that you must have at the end of the sales funnel and the number of prospects that must have at the beginning of the sales funnel.
The input parameters in the template
Following parameters you can input into the form:
- Current year.
- Conversion rate of the sales funnels. This is the percentage of the buyers from prospects that enter the sales funnel.
- Average buying of one buyer. This parameter present average dollar that spent one buyer in your business.
- Planned Income. What income you want to have at the end of each year?
The output parameters
When you finished with input of the parameters you will get following metrics:
- How much customers you must have to realize the planned income?
- How much prospects must enter the sales funnel to that will make an amount of customers that will bring planned income?
Examples
- The year is 2009. Conversion rate of the sales funnels is 3%. Average sales are $500 that will increase annually for $50. Planned income in the first year is $100.000,00 and want to increase 10% on annual level. The results that we will receive from the template are:
- Let’s see what will be the results if we improve the conversion rate from 3% to 5% and improve average buying to increase for $100.00 on annual level.
You can see that with improving the conversion rate for 2% and average spending of money from buyers you will obtain the same income results but with 50% smaller number of entered prospects into the sales funnels.
You can download this template for FREE from here. More FREE templates coming soon!
Popularity: 55% [?]
