Brand Funnel Conversion: Calculate Stage Rates and Find Where a Brand Leaks

There is no single standard funnel. Qualtrics' funnel-reporting help lists six common questions and two default funnels, awareness to consideration to regular use for packaged goods, and the same plus subscription for online services. It recommends three to five levels, ordered from broadest to narrowest (Qualtrics).

The stage names and questions are a design choice, so write down exactly which answers count as "in" each stage. If you change a definition mid-series, the trend breaks.

Qualtrics defines aided brand awareness as "the recognition of your brand name when prompted with a list of brand names or logos" and unaided brand awareness as "unprompted recall of the brand name or product", usually cued by the product category (Qualtrics). The first brand named is top-of-mind awareness; the first and follow-up answers together give total unaided awareness.

Put aided awareness at the top of the funnel, because it is the broadest base and the one every later stage sits inside. Keep unaided recall as a separate line that shows memory strength. Do not divide one by the other and call it conversion: recall is not a step people take after recognition.

Order matters in the questionnaire. Ask the unaided question before any brand list appears, since a list can prompt recall. This is our reasoning, not a rule from the Qualtrics page, which also warns that cue wording changes unaided results: "eat out of your home" may return restaurants, while "eat" may add supermarkets.

Qualtrics' rule: take the number of people who qualify for a level and divide by the number who qualify for the level immediately before it. Funnel level percentages use a different base, the total respondents. Markteffect gives the awareness-to-consideration case as consideration divided by aided awareness, and notes that awareness and consideration can both rise while that conversion rate falls (Markteffect).

Check one thing first. Each stage should be a subset of the one above it. If purchasers exceed people who are aware, the questions were asked or coded inconsistently. Qualtrics notes a lower level can legitimately exceed a higher one in some cases, such as a subscription that bundles a service people do not regularly use, so confirm the logic before treating it as an error.

The numbers are invented to show the method and are not survey results. Brand X is better known; Brand Y is smaller.

Conversion from aided awareness to purchase is 150 ÷ 640 = 23.4% for X and 168 ÷ 420 = 40.0% for Y. Despite far lower awareness, Y has more purchasers (16.8% against 15.0%) and more repeat buyers (12.6% against 9.0%).

Read the leaks. X converts a high share of awareness into familiarity but loses people at consideration (62.5%) and again at purchase (50.0%). Qualtrics says high awareness with a low conversion to consideration may point to "messaging or price", so X's next question is why aware people do not buy. Y's ratios are healthy at every stage and its problem sits at the top: for a brand like this, Qualtrics says more visibility is the lever.

These are survey ratios, not proof of cause. The funnel shows where people drop out, not why; the why needs a follow-up question or an open-ended answer.

Each conversion rate is a proportion on a smaller base, so its margin is wider than the headline's. Using the normal interval, p ± 1.96 × √(p(1 − p) ÷ n) (see NIST), the 95% margins for our example are:

Treating the two brands as independent samples, the margin on the 10-point gap at purchase is about ±8 points (√(0.25 ÷ 300 + 0.24 ÷ 280) × 1.96), so the gap is wider than noise in this invented example. In a real study the same respondents usually rate both brands, so use a test suited to that, as in our significance testing guide. Late-stage rates rest on the fewest people, which is why trackers need large samples to see small changes.

• Awareness to familiarity is low: people know the name but not what it offers. Ask what they believe the brand is for.
• Familiarity to consideration is low: the offer is understood but not wanted. Look at price perception and fit with usage occasions.
• Consideration to purchase is low: intent is not turning into action. Ask about availability and what they bought instead.
• Purchase to loyalty is low: trial is not repeating. Ask about satisfaction and about reasons for switching.

Track the funnel in waves with the same questions, so a change in a ratio can be tied to something you did. Our brand tracking guide covers wave design.

On Hercules, Poseidon selects formulas by question type, and funnel conversion is among them (panel methodology). Whatever tool you use, confirm each stage is a subset of the one above and that the base under each ratio is shown. The Free plan includes 30 responses, enough to test your stage questions on a phone before a full study.