Growth Pipeline Tracker

An independent consultant who has maintained an active network for five years - attends events, nurtures LinkedIn presence, stays in contact with former clients. New clients continue to arrive at the same rate they did in year one. She believes the issue is volume ('I need more contacts') but has never measured where contacts drop off in her actual funnel.

Frame the AARRR framework as a diagnosis before a prescription. 'Before we talk about what to do more of, let's see where the funnel is actually narrowing.' Expect resistance grounded in activity: 'I'm already doing a lot.' Don't contest the activity. 'The question isn't whether you're doing enough - it's which activities are generating which results, and where the funnel is losing people.' That framing makes the tracker a measurement tool rather than a judgment.

Watch the conversion rate fields. Clients who have been operating by feel often cannot populate conversion rates because they've never tracked them. Blank rate fields are not failure - they're data: she doesn't have the measurement infrastructure to know where her funnel is working. Watch also the Referral row specifically: consultants who rely on word-of-mouth typically have high Acquisition but low or unmeasured Activation - they get in the door but don't systematically convert conversations to proposals.

Start with wherever she has numbers and wherever the fields are blank. 'What do you actually know, and what are you estimating?' Then narrow to the largest gap: 'Between which two stages are you losing the most people?' The question that creates movement: 'If you could measure one thing in your business that you're currently guessing at, and it would change your decisions, what would it be?' That question usually identifies the missing measurement that would unlock the funnel diagnosis.

A SaaS founder, 18 months post-launch, who measures growth by new signups weekly and celebrates acquisition wins. His churn rate is high but he hasn't connected it to his growth strategy. He is investing heavily in top-of-funnel content and paid acquisition while his retention stage is entirely unmanaged.

Frame the AARRR model as a full-system view. 'Acquisition is one of five. We're going to look at all five and see what the actual growth picture is.' Founders who are acquisition-focused often resist looking at retention because the numbers aren't flattering. Name the math: 'You can't grow your way out of a retention problem - the more you acquire, the faster you lose ground.' That statement usually creates enough discomfort to generate engagement with the other rows.

Watch the Revenue and Retention rows. If he fills Acquisition in detail and leaves Retention blank or with vague entries ('users stay for a while'), the avoidance is visible. Also watch the conversion rate between Activation and Retention specifically - the moment a new user decides to stay or leave is usually the most neglected stage in early-stage SaaS, and the tracker will surface that gap if he actually attempts to populate the rate.

Start with Acquisition and Retention side by side. 'You're bringing in X new users weekly. How many are still active at 90 days?' If he doesn't know: 'What would you need to check to find that number?' Don't let the data gap become the end of the conversation. Then: 'If your retention rate doubled without any change to acquisition, what would your current user base look like?' The question that creates movement: 'What would you be doing differently in weeks two through four of a user's experience if you prioritized retention as much as acquisition?'

A boutique firm owner with 15 active clients. He tracks monthly revenue reliably but has no visibility into which clients are growing, which are static, and which are consuming disproportionate service time. He is resource-constrained and needs to make decisions about where to invest account management attention but has no data to guide that.

Frame the tracker as a client portfolio lens rather than a growth-channel lens. 'Most AARRR applications look at new client acquisition. We're going to apply the same framework to your existing client base - which clients are in Acquisition (new, still proving), which are in Retention (stable, renewing), and which have reached Revenue expansion (growing accounts).' That framing makes the AARRR rows client-category labels rather than funnel stages, which fits his reality better.

Watch the Revenue and Referral rows. In professional services, existing client revenue expansion and referral generation are often more significant growth drivers than top-of-funnel acquisition. If he has no referral tracking at all, that's a gap. Also watch the Retention row for how he characterizes 'stable' clients - if stability means they're renewing but not growing, that's different from clients who are deeply embedded in his services.

Start by asking him to name his top three revenue clients and which AARRR stage each one is in. Then: 'Where is your account management time going relative to where your revenue is concentrated?' If he's spending disproportionate time on acquisition clients while large accounts are unmanaged, that's the reallocation conversation. The question that creates movement: 'If you moved one hour per week from acquiring new clients to deepening one existing account, which account would you pick and why?'