For this project, I was asked to help identify our company’s ideal customer profile. Our company, Balto, sold an AI tool for contact centers that gave agents real-time suggestions of what to say on every call.
There were three specific areas that I was asked to focus on:
I collected data from a variety of sources. The main one was Salesforce, but a lot of data came from Google Sheets, Pendo, or even individual contracts.
I compiled data on all of our current as well as churned customers.
Some of the most important data points to consider were the following:
I performed all the analysis in Google Sheets, with different sheets for the industry, tier, and integration analysis for both current and churned customers, as well as some sheets for direct comparison between the two.
Here is a link to the dataset, as well as all the analyses. I have restricted the access to invitation-only at Balto's request to protect proprietary interests. Additionally, all columns that show customer counts or raw ARR figures have been hidden- all customer and ARR statistics use percentages. All company names and softphone brands have been changed, and many other aspects of the dataset have been changed as well.
Here is a slide deck with a summary of key takeaways, which I presented to executive stakeholders upon finishing the analysis. Its access is also restricted.
A more in-depth look at results by industry can be found within this sheet of the analysis.