Identify the Top 20% of Accounts for 80% of Pipeline (Pareto Analysis)
AnalyzeSales
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.
The prompt
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. <scratchpad> 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 </scratchpad> 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 <top_accounts></top_accounts> tags. 5. Justify why you selected those particular accounts as the top 20% by walking through your analysis approach and strategy inside <justification></justification> 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?"
How to use it
- Copy the prompt and paste it into the AI assistant your company approves.
- Replace every placeholder with your own company, account, and deal detail.
- Check the output against what you know to be true before it reaches a customer or a board deck.
Need the full process rather than one prompt? See the Skills library.
Common questions
- What does the Identify the Top 20% of Accounts for 80% of Pipeline (Pareto Analysis) prompt do?
- 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.
- Who uses this prompt?
- Sales. Category: Analyze.
- How do I use it?
- Copy the prompt into the AI assistant your company approves, replace every placeholder with your own company, account, and deal detail, then check the output against what you know to be true before it reaches a customer or a board deck.
- Is it free to use?
- Yes. Every prompt in the library is free to copy and adapt.