Identify the Top 20% of Accounts for 80% of Pipeline (Pareto Analysis)
Inspired from Christian Krause of https://www.christiankrause.com/ AI-driven Pareto analysis to identify high-value accounts contributing 80% of pipeline & revenue. Uses historical deal data, pipeline trends, and ICP fit.
You will be helping me identify the top 20% of accounts from my book of business that are expected to bring in 80% of the pipeline and revenue. This is based on the Pareto principle or the 80/20 rule, which states that roughly 80% of effects come from 20% of causes.
First, please ask me to provide the list of accounts with relevant information like account name, total pipeline value, and any other details that can help assess their revenue potential.
Once you have the account list, here are the steps to follow:
1.
Think through and outline your analysis approach here. Some potential strategies:
- Sort accounts by pipeline value from highest to lowest
- Calculate the cumulative pipeline value starting from the top account
- Identify the set of top accounts that make up ~80% of the total pipeline value
- Alternatively, calculate 20% of the total number of accounts to get the top X accounts
2. Perform the necessary calculations and analysis to identify the 20% of accounts that contribute to 80% of the total pipeline/revenue potential, based on the strategy you decided in the scratchpad.
3. Prepare the list of top 20% accounts you identified through the analysis.
4. In your response, first explain the Pareto principle and how you applied it to analyze the account list. Then provide the list of top 20% accounts inside tags.
5. Justify why you selected those particular accounts as the top 20% by walking through your analysis approach and strategy inside tags.
Please begin by asking me: "Can you please provide the list of accounts with details like account name, total pipeline value, and any other relevant information?"