No history yet

Defining Analytical Frameworks

From Vague Questions to Clear Plans

A common starting point in analytics isn't a clean dataset, but a vague question from a business leader: "Why is customer engagement down?" or "How can we improve sales in the next quarter?" The real work begins before you open a single spreadsheet. It starts with translating that ambiguity into a concrete, measurable analytical problem. This is the core of a 'Structured Problem Solving' framework. It's the process of building a blueprint before you start building the house.

The first step is always to refine the business problem. This means sitting down with the people who asked the question, a process called , to understand what they really need to know. What decision will the answer drive? Who will be impacted by this decision? For example, a request to "improve user retention" is too broad. A better-defined problem is: "Identify the key factors causing users who subscribed in the last six months to cancel their accounts within 90 days." This version is specific, time-bound, and points toward a clear analysis.

Choosing Your Metrics Wisely

With a clear problem defined, you need to select the right measures of success. The most important one is the Primary Metric. This is the single number that best represents the outcome you are trying to influence. For our user retention problem, the primary metric would likely be the '90-day churn rate'.

But focusing only on a primary metric can be dangerous. Imagine the team decides to reduce churn by making the 'cancel subscription' button nearly impossible to find. Churn rate might go down, but customer frustration would soar. This is why you must also define —numbers that you monitor to ensure your solution isn't causing unintended harm elsewhere. For the churn project, good counter-metrics would be 'customer satisfaction scores' and 'number of support tickets related to cancellations'.

This structured approach is part of an 'Analytic Plan'. This simple document outlines the business problem, the key stakeholders, and the primary and counter-metrics. It acts as a contract, preventing scope creep and ensuring everyone is aligned on the goals before the deep-dive analysis begins.

Picking the Right Analytical Lens

The type of question you're asking determines the type of analysis you'll perform. A hypothesis-first approach helps guide this choice. Instead of just exploring data aimlessly, you form a testable statement. For instance: "We believe the 90-day churn rate has increased because new users are not completing the onboarding tutorial." This hypothesis immediately tells you which analytical framework to start with. There are four main types of analytics, each building on the last.

TypeQuestion It AnswersExample (Churn Problem)
DescriptiveWhat happened?"Our 90-day churn rate for new users is 15%, up from 10% last quarter."
DiagnosticWhy did it happen?"Users who skip the onboarding tutorial have a 30% churn rate, compared to 5% for those who complete it."
PredictiveWhat is likely to happen?"Based on current trends, we predict next quarter's churn rate will be 18% if no changes are made."
PrescriptiveWhat should we do about it?"We should implement an email campaign encouraging users who skip the tutorial to revisit it, which could reduce churn by 5%."

You almost always start with descriptive analytics to understand the landscape. From there, you move to diagnostic to find the root causes. Only then can you build predictive models and recommend prescriptive actions. This progression turns raw data into a clear, actionable story for a non-technical audience.

Time for a quick check-in.

Quiz Questions 1/5

What is the primary purpose of defining Counter-Metrics in an Analytic Plan?

Quiz Questions 2/5

A business leader asks: "How can we improve sales in the next quarter?" According to the structured problem-solving framework, what is the most effective first step?

By translating vague business needs into structured problems with clear metrics and a chosen analytical approach, you create a solid foundation. This ensures your final insights are not just interesting, but directly useful and ready for action.