Conversion Funnel Analysis – Unaware to Lead to Prospect to Customer to Fan


A conversion funnel analysis is part of an overall examination of the sales organization; it examines how efficiently a business turns leads into its best customers.

There are a series of “levels” that a customer passes through on their way to becoming a raving fan. These levels can be pictured as a funnel. Only a certain percentage moves on to the next level.

As an investor, a Sales Conversion Analysis is helpful because it helps you understand how well a company is taking advantage of the leads it has. The more leads it can move along in the funnel, the greater the likelihood of sales growth and hitting sales targets.

This post is part of a series on the analysis of the sales organization.

This series was inspired by Point 4 from Philip Fisher’s book on investing – Common Stocks and Uncommon Profits.

Converting leads to repeat customers

Any business that sells has a conversion funnel. The narrowing down of a Serviceable Available Market (SAM) to actual customers.

The company you’re analyzing loses a certain percentage of potential customers as they pass through the funnel.

A Sales Conversion Analysis looks at a business’ funnel. The point is to determine where those potential customers are being lost. What percentage of customers are being lost? Can they be regained? What does the competitions’ funnel look like?

The Sales Conversion Analysis is part of the evaluation of the effectiveness of the company’s sales organization. Along with the Sales Growth Analysis, Sales Target Analysis, and the Sales Opportunity Analysis (Unique Selling Proposition).

As an investor, the goal is to make an educated guess on how many customers a company is converting from level to level. When compared to the competition, we can then make judgments. What we learn can be combined with other sales organization analyses to move toward an opinion on the worthiness of the investment.

What is a sales funnel?

A sales funnel is a visualization of how potential customers become actual customers. Beyond that, how they become repeat customers or referrers.

Most of what’s written about sales funnels is for the entrepreneurial community. Which makes sense. They are hungry for revenue and, usually, hungry to be educated. If you are interested in entrepreneurship, check out my other site SpreadsheetsForBusiness.com.

This site is about investing though. So we are going to look at this concept from outside the organization. Not inside.

Each industry (and company, for that matter) has its own unique sales conversion funnel. So, feel free to tweak this as you see necessary. I’ll be using Facebook as an example again. Just as I have for my other Sales Analysis posts.

My funnel will be simplistic to illustrate the topic at hand. It will only consist of four levels.

The number of customers that convert from one level to the next will vary. It depends on the nature of the business you’re analyzing. In some industries, many leads might turn into repeat customers. In others, almost none.

sales conversion funnel illustration
Credit: pinterest.com

Level 1 – leads

At this level, a business is just seeking awareness. They’re targeting people in their Serviceable Available Market (SAM). These are the people (or businesses) that fit the demographic profile of potential customers. The goal is to make those in the SAM aware that the company exists.

This is done through marketing, of course. Whatever means work best. Breadth is more important than depth.

Level 2 – prospects

Here, a business is looking for customers that are not only aware but actually interested in what they have to offer. The business is trying to sort out which people in the SAM are actually interested in buying their product/service. One way they might do this is by focusing their Unique Selling Proposition (USP).

The depth of the marketing message becomes more important than the breadth. A company that is authentic in its marketing message will sort those who are serious about buying from those who are not. This is why a USP is helpful in distinguishing one business from another.

Level 3 – customers

The funnel has narrowed to those who are willing to take the leap. Those who feel that all their want and need “boxes” have been checked. Those who are prepared to spend money.

To land a customer, a business must remove as many obstacles as possible. Sometimes the obstacles only exist in a customer’s mind. This is where an “above-average sales organization” pulls its weight. To convince unsure prospects that their business is the best to suit their needs.

Level 4 – repeat and referring customers

Obtaining a one-time customer isn’t the ultimate goal for most businesses. The best business models self-perpetuate. Landing a customer can be difficult and costly. That’s why it’s ideal for a business to convert as many customers as possible into repeat customers. Or, if the nature of the business isn’t conducive to that, customers who will refer others.

This is the bottom of the funnel. It has narrowed to a business’ best customers. Those who can be upsold, keep coming back, and/or refer others to the business.

Facebook Sales Conversion Analysis example

As has been done with previous sales organization posts, I’ll be using Facebook, Inc. (FB) as an example.

I’ll admit, maybe Facebook isn’t the best company to illustrate this type of analysis. Facebook has a SAM that includes a large part of the population. And, they’ve converted a large portion of that SAM into repeat customers. Facebook might have the preeminent business model.

However, I had to decide between picking a company that might have better illustrated the topic or staying consistent. I opted for the latter. I thought that by using the same company for all sales organization analyses, it would show how they all linked together.

Facebook’s leads

Facebook, as we know, is worldwide. The world’s population currently stands at about 7.7 billion people.

Of those 7.7 billion, 25.45% are age 14 or under (Source). 14 is what I’ll use as the de facto “minimum” age for Facebook. I know that’s not strictly enforced, but it’s a good approximation. So, that leaves us with about 5.7 billion people over the age of 14.

Currently, 57% of the world’s population has internet access (Source). Obviously, this is a bare minimum for being a Facebook user. 57% of 5.7 billion is 3.2 billion.

This is what we’ll use for the first level of the funnel. The SOM. We’ll say that Facebook has 3.2 billion leads.

Facebook’s prospects

So, how many of those 3.2 billion are prospects? How many would move on to Level 2?

In my last post, I gave my opinion on Facebook’s Unique Selling Proposition (USP). I thought it was something like “To keep family and friends connected.”

Earlier, I said that a company’s USP gives us insight into what separates prospects from leads. That might be the case. But, everyone has friends and/or family, right?

Turns out not everybody has a great relationship with their family. 19% of people, we’ll approximate, have no contact with at least some of their family (Source). So, if keeping friends and family is Facebook’s USP, then we might assume that 19% of the “leads” would not translate into “prospects.”

This leaves approximately 2.6 billion people.

Facebook’s customers

How many of those prospects are “customers?” This question might be a little easier to answer.

Think back to the Sales Growth Analysis. In that, Daily Active Users (DAU) were referenced in the analysis of “units.” Beyond that, Facebook also reports Monthly Active Users (MAU) on a quarterly basis.

MAU are people that use Facebook. But, only sparingly. At least compared to their daily counterparts.

As you can see below, MAU equals approximately 2.4 billion as of June 2019. These are what we will consider Facebook’s “customers.”

monthly active user chart Facebook
Credit: sec.gov

Facebook’s best customers

If MAU are “customers,” then DAU are the “repeat and referral customers.” These are the Facebook power-users who are their bread and butter. They keep coming back and drive advertising revenue. They are the ones who talk up Facebook to their friends and family – inspiring them to create accounts.

We can assume that Facebook’s ultimate goal (like most businesses) is to convert as many “customers” as possible into “repeat and referral customers.” As of June 2019, these types of customers numbered 1.6 billion.

daily active user chart Facebook
Credit: sec.gov

There you go. We narrowed down Facebook’s sales conversion funnel. Of course, if you wanted to get more detailed, you could. Breakdowns could have been made by geographic region, for instance. Plus, other criteria could have been used as a filter throughout the funnel. Improvements can always be made moving forward.

Here’s a visualization of the funnel, along with the conversion percentage at every level.

facebook sales conversion funnel illustration

Additionally, you might consider doing something similar for the competition. As was the case for the USP, looking at the competition might help to provide some perspective.

Conversion funnel analysis

So, why go through this exercise? Again, it looks at a company’s revenue from yet another perspective. It complements the other sales organization analyses. When combined, you get an idea of what the future holds for a company’s revenue. Revenue is the driving force behind growth stocks. So, the better grasp you have on a company’s revenue forecast, the better investment decisions you should make.

Do you have any thoughts on my Facebook conversion funnel analysis? Would you have attacked it differently?

Talk to me on Twitter!

Recent Posts