Unlocking the Secrets of Lost Sales Opportunities (via FP&A)
In this week's episode Herman Kastroll (Skip Kastroll), Senior Director, Insights and Analytics at AmPhil.
He gives the inside story on creating and selling a report in conversation with host Glenn Hopper.
It is a practical example of effective FP&A leading to revenue-grabbing opportunities.
Skip says: "I took all of our closed loss opportunities over a period of time, and I wanted to know what is it telling us? What is it telling us about the organization? About the person who made the sale? And what does it say about all the information that is typically cataloged when you have an opportunity in your pipeline."
Structuring the report:
1. Start with a Catchy Title
Skip's example: "Unlocking the Secrets of Lost Sales Opportunities"
2. Add a Memorable Quote
Skip's choice: "Data is the new oil, but we keep losing the map to the oil field."
3. Provide an Executive Summary
Skip says: "I gave a summary right away. The report was nine or 10 pages long, and I gave a summary at the front. Some people want to read the whole report and some people are gonna stop on page two."
4. Distill Key Findings into Main Takeaways
In Skip's words: "I then took the distilled key findings into three main takeaways. So instead of just presenting the data, I provided what my best (3-5 main) interpretation of the data was."
5. Make each takeaway actionable
Link data to potential strategies. "In particular when people are pressed with time, they will al almost always fill their open time with what is practical over what is ideal."
6. Deep Dive with Detailed Analysis
"I then had a bunch of detailed analysis below for each finding. I give context and implications."
7. Tailor Content for Different Audiences
"I tried to tailor different sections to different types of people. So this report went to the CEO, but it also went to individual directors who lead a team. So, I broke out some of the numbers by teams, by groups so that they would have something relevant that they could look at."
"Find the genuine human impact that the data is letting you guide the narrative, that can make it memorable.
8. Create memorable charts and graphs
I recommend Dona Wong, The Wall Street Journal Guide to Information Graphics("whenever I make a chart, I’ll always flip through a couple of pages")
Ensure visuals support your narrative
9. Encourage Discussion
Some of my insights were way off base. But it sparked some thinking. Some executives said we probably couldn’t do exactly what Skip suggested, but we could maybe do something like it."
Also in this episode:
🧳My multidisciplinary journey – studying math, economics, educational leadership and religion (and how it applies to my data insights)
🎓FP&A business partnering at a University Finance team
📈Leading vs lagging indicators
😻My favorite Excel function
🖇Please connect and with Skip and and feel free to ask him questions.