RevOps Co-op Weekly #52 - Beyond KPIs: The Art of Storytelling With Data
A good data analyst knows how to check and double check their work. A great analyst knows how to tell a story and suggest improvements.
RevOps Co-op provides resources, content and community for those who ❤️ revenue operations. This weekly newsletter features collected tweets, posts and thoughts on a variety of RevOps topics. We also have a private Slack community with > 2,800 RevOps pro’s from companies like Slack, Lyft, Clari, Miro and more 👉🏻 click here to join.
Beyond KPIs: The Art of Storytelling With Data
I remember one of the first times I was allowed to present data to a bunch of executives like it was yesterday. I put a slide covered in charts from my deck up on the wall and sat in silence. Instead of staring at the slide and absorbing the data, everyone but the CFO stared back at me, waiting.
My boss at the time liked to teach me by throwing me in the deep end, but a heads up would have been helpful.
The big piece of advice I was missing?
The executive team didn’t have time to tease out what the patterns from the charts told them on the screen. They wanted the highlight reel, not the full game tape played back in real time. And not only did they want the highlight reel, they wanted the color commentary that goes along with it.
It wasn’t enough to show them patterns and proof that there was an issue. They weren’t familiar enough with the day-to-day stats I watched like a hawk to know why the charts on the screen should matter to them.
After some stammering, I caught onto the problem and ran ahead with the presentation, standing up and pointing to the data points that mattered, listing off the factors that fed into the trends, and where I thought we should dig deeper.
The experience wasn’t great. But I learned that one of the reasons things weren’t changing was because I wasn’t adequately communicating with my leadership team. I would send them a deck, and unless they had follow up questions, that was it.
After that day, I started writing up my findings. Then I learned that executives don’t read novels and bullet points are best. The emails helped, but I got better results once I started pulling together leadership team meetings and walking through a narrative.
It turns out that even data is absorbed better with an interesting backstory. But there’s groundwork that needs to happen first.
You Can’t Win Without Infrastructure
You can’t tell a story without the proper tools.
Even the most talented analysts can’t dig up cause and effect if they’re spending all of their time trying to merge data sources and fix a data hygiene problem.
Invest in CRM deduplication and merging tools. Enrich the data you can passively to eliminate human error. Buy tools that make data entry as simple as possible for salespeople and advocate for simple processes with the minimum required fields possible.
Recognize Salesforce’s (or any CRM’s) reporting limitations. In order to answer difficult questions, you will need to have a data warehouse or analytics tool that can merge your data sources and allow for ad hoc analysis.
I know people who have avoided learning T-SQL, and this is a big mistake. We have an excess of data available to us, and analysis isn’t getting any easier. Understanding data structure and logic will only become more desirable in the future.
Get the right tools, invest in education, and embrace a thorough understanding of how the data flows from one system to the next, and you’ll have the information necessary for a good narrative.
A Good Analyst vs. an Excellent Analyst
Put a chart in front of five different people, and you’ll get five different interpretations. Some will pick up on some patterns but not know the business context. Others will shove the chart away because it’s just a jumble of numbers and shapes.
A good analyst will spot problems.
An excellent analyst will try to understand where the data is coming from, who or what populates it, and the factors that drive success and failure.
For example, we know that opportunities have stages with correlating percentages that are supposed to reflect the probability of a deal closing. And there’s a close date and an amount associated with products. For short-cycle sales, a seller will have an idea of how many deals they can close in a given time period, but they don’t know the exact mix of accounts that will make up that number.
For longer-cycle sales, the salesperson will know that some deals are shaky and some will definitely close, and it’s their job to figure out how to close enough to make up the gap.
Sales managers understand that their team members will each favor a forecasting strategy. Some like to under promise and over deliver (the “sandbaggers”), some are wildly optimistic, and a few are spot on target nearly every month. A manager sees the amount each sales rep is projecting and uses their gut to temper that number when it gets to their manager, and their manager does the same.
When analyzing forecasts, analysts can draw some conclusions about how accurate a salesperson’s forecast will be based on prior performance. They will also see how much they tend to push their close dates and how many deals they refuse to close that clearly aren’t going to close. An excellent analyst will also look at leading indicators and be able to flag that a lack of SFDC logins, pipeline build, and activities is a strong predictor of attrition.
Once an analyst learns to look at leading and lagging indicators, they’re on their way to telling a story instead of flagging outliers.
An Example of the Deep Dive
Let’s say your sales VP has let the executive team know that he doesn’t see a clear path to reaching their number for the quarter. With fifteen days left, it looks like his team will only produce 80% of goal.
The executive team wants to know what went wrong (and is on call to leverage any connections in order to close deals).
A good analyst will point out that bookings aren’t on track. A great analyst will work backwards to figure out the backstory.
Start at the point sale and look for points of failure:
What was the forecast at the beginning of the quarter?
How accurate have they been historically?
How much pipeline did they begin the quarter with?
Historically, would this have been enough?
What is the percentage of opportunities that typically close in quarter? Has this quarter’s pipeline generation been anemic?
Where are the deals falling off (at what stage)? Is this normal? Are people running into a consistent stall point?
Talk to the management team and place a few (anonymous feedback) calls to key sellers.
Sometimes it takes a few salespeople to trust you to figure out what’s wrong. At one company, a few phone calls uncovered that we had made a key competitor’s radar and they had an initiative to price us out of any deal where we went head-to-head. At other times the feedback was that the product had a key shortcoming that sabotaged a proof of concept or contract terms were causing larger corporations to balk and redline.
If the issue appears to stem from a department not supported by your organization, we would advise working with their analysts instead of escalating directly to the executive team. It will give them an opportunity to figure out their own narrative and encourage an open line of communication. Unfortunately, finger pointing is a common symptom of a bad quarter. It’s best to let teams know they’ll be under scrutiny before it’s too late.
…Read the full Blog post here 👉 Beyond KPIs: The Art of Storytelling With Data
🗣 From the Community
#04_revops-questions
9/25/21: Hi Everyone, 4 questions from a Rev Ops Leader perspective:
How to maintain authentic data sanctity, especially the data that sales reps/BDRs/Account Managers fill?
Which tools do you use to enrich the customer and prospect data?
What processes do you follow to collect and maintain market and competitor intelligence?
Is there a good resource to refer to while building Rev Ops tech stack (Commissions tool, Ticketing, Enrichment Tools are a few I have found worth paying for, wondering what else can be good ROI). Read 5 Responses.
10/01/21: I have a general question around how compensation is set for bdr/sales/CS teams in your org. I’m particularly interested in understanding the boundaries of what role do your finance team, revops team, and sales leaders play. Kind of like a bit of a RACI matrix for compensation planning and management. Read 2 Responses.
#08_tools-and-software
9/27/21: Any recommendations or pointers to pull real time data across multiple systems like salesforce, marketo, gainsight etc with minimal effort and cost? Read 6 Responses.
9/30/21: Hi all! Happy end of quarter to those of you living that wonderful energy today! Question on integrations between JIRA and Salesforce:
do any of you have a bi-directional integration you are loving?
if so - was it home grown (API work) or a plug in?
We are working to replace ServiceRocket, as it just doesn’t have the feature set we need for the various use cases of sharing data across the two systems. Read 7 Responses.
💬 Access the RevOps Co-op Slack group here to contribute to the conversation!
🐦 This week in #RevOps Twitter
I mean….🤷♀️
Just do it! ✔️
Ah, if only! 🪄
📅 Upcoming Events
RevOps Hangout! Virtual Networking - Thursday, October 7 at 11am PT (2pm ET)
Come and meet other folks from the RevOps Co-op. Share your ideas, get some great tips, and make new friends.
This week's Hangout will take place on Gatheround.
Hangout Topic: Operationalizing Insights: Do More with the Data you Have
📚 Your curated #RevOps reading list
12 People to Follow on LinkedIn for Practical RevOps Advice | Everstage (a RevOps Co-op community partner)
There’s no guidebook out there that can solve every Ops issue we come across. This is why we need trailblazers who solve problems and share their experiences and learnings with people in the same boat. As cliche as it sounds, the learning never stops and we need to sponge a lot of insights, data and meaningful advice everyday to win RevOps. I am an absolute sucker for actionable content and when I am doing my reading, that’s exactly what I am looking for.
Whenever I’ve checked out the people listed in my RevOps 12, I’ve never been disappointed. Hit that follow button on each one of them and subscribe to sky-high quality RevOps knowledge.
The Ultimate Guide To SEO For B2B Tech | Tortoise and Hare Software
Search Engine Optimization (SEO) is one of the most important ways to attract new business for mid-market B2B tech companies. If you look at B2B tech companies that have achieved any sort of meaningful scale and grown to the 10MM ARR mark and beyond, you will almost always see a significant portion of their growth came from organic traffic on search engines. There are of course numerous challenges and many factors involved in growing to that level, not related to sales and marketing, and many of them are more difficult than solving the marketing problem. However, marketing is the first step, and if you don’t have the pipeline, you don’t have the chance to tackle any of the other problems that come next.
Marketing vs. Operations: The Battle for a Small Business' Attention | Hubspot
When an organization officially opens its doors for business, marketing-related activities tend to be the primary focus. And it makes sense. After all, if no one knows about your product or service, you won't be in business long. Those activities can include sales strategies, P.R. and social media campaigns, and digital ads that catalyze advancement from the startup to the growth stage of business.
Eventually, if you have a great product or service that customers want, you'll see a return on investment for those marketing activities. At this point, as an organization advances from the growth stage to the emerging and scaling stages of business, the need for Operations becomes paramount.
🚒 Weekly RevOps Meme
🔥 A few HOT #RevOps Jobs
Director Revenue Operations | Instructure
Director, Revenue Operation Strategy and Planning | Paycor
Director Global Marketing Intelligence & Analytics (Rev Ops) | Instructure
Sr. Manager Revenue Operations, Marketing Automation | Instructure
Revenue Operations Manager | LeanIX
SDR Leader | MaestroQA
Salesforce Administrator | Nacelle
Gainsight Administrator | Comparably
Salesforce Business Analyst | Cobalt.io
Funnel IQ is an operating system for your GTM team that provides end-to-end, full funnel analytics and insights that keep marketing, sales and customer success teams aligned and working seamlessly together to drive more revenue growth for your business.