Showcase your achievements in the Maveryx Community by submitting a Success Story now!
SUBMISSION INSTRUCTIONSIron Mountain is a global leader in records and information management. Their financial planning and analysis team is using location intelligence to identify facility storage capacity and driving storage usage through pipeline demand data from Salesforce. Discover in this use case how Alteryx empowered the Iron Mountain team to create a suite of commercial, financial, and real estate reports that facilitate proactive decision-making across the business. Because of these changes, now 80% of CEOs and regional managing directors and 100% of the regional support actively check the reports each month. The results couldn’t be any different: they are above their sales target at 109%!
Iron Mountain build and rent safe and secure storage warehouses with racking solutions to store and manage the critical assets of their customers, including secure destruction. They need to fill up their warehouses as quickly as possible. Once those spaces start to get full they invest in the metal racking to store the boxes. And when it gets three quarters full, that's when they start to make a profit in a warehouse.
They make large investments up front which take some time to pay off. There is a strong need for analytics to back up those crucial decisions. For commercial, they need to win customers and bring in new boxes, so it’s fundamental to know if salespeople are selling well, if there is a market, if they can improve win rates, etc. In the real estate field, they need to answer questions like how full each warehouse is? And their finance department needs to know what are the most profitable products and countries, they need early indicatiors when something is going wrong or where there is opportunity to do even better.
They need to answer a lot of questions and Salesforce reporting in Excel was no fun. It was showing just a point in time and they coudn’t know what the pipeline was six weeks ago, 12 weeks ago or a year ago. They needed to capture historic pipeline trends and build better reports. Trying to figure out a better solution, Matt Semple downloaded Alteryx trial and he hasn’t looked back since then.
The Salesforce connector in Alteryx Designer was essencial to easily bring in all the data they needed, about 10 millions records. To get the five key sales metrics, they started working with an Alteryx Partner, Interworks ,who helped them build the workflows to get the insights they needed.
COMMERCIAL PERFORMANCE INSIGHTS:
Now for each opportunity on Salesforce they have a track of it through the whole process. So, they have the timeline of each opportunity of each point of the process. This means that they can calculate the likelihood of a close at each stage of the business. Below is the workflow showing how to go from the close rates of each of the salespersons to the aggregate country average rate.
GROUPING DATA BY LOCATION
Iron Mountain has 1,500 storage facilities located throughout the world. They needed to know if they have capacity in the right locations to meet client’s storage requirements and to ensure utilization of all facilities is high, to maximize investment returns. Also, those insights are crucial to determine where to grow or rationalise their real estate portfolio. They used Google Maps API and Alteryx Spatial Tools to group storage facilities based on where they are located in the world.
With their analytics solution now they know their real estate capacity status by facility and market. They know where new commercial opportunities exist and have an algorithmic prediction of how much they are likely to win and when.
When Iron Mountain started publishing their dashboards they had very low expectation that people would actually check them, maybe they would get 50% of participation. But when they mesasure the participation they were staggered. About 80% of CEOs and regional managing directors were logging in each month. To get 100% of the Regional Support team shows that this is now the go-to source for commercial data.
“In terms of our sales performance this year, the dashboards aren't completely driving the sales performer, I can't take credit that we've caused that sales success, but there is a correlation that we've now got tools, everyone's looking at sales performance, everyone's driving sales team to close the deals that are furthest down in the pipeline. We're above 100%, we're 109%,” said David Turley.
Hi there,
Can you share the solution with us?