Cellular Retailer Saves Over $1 Million a Month with Power Apps
One of the nation’s largest cellular retailers needed to simplify the customer’s lead distribution process for field representatives.
Assess and pinpoint top priorities for a custom app to solve customer’s challenges
Design and Build
Create a multi-form Power Apps application for campaign and lead assignment, which included automation
Azure Storage & Security
Data stored in Azure for speed, including up to date notifications and tasks, as well as Azure Active Directory for security
Monthly Savings in Licensing
Number of Users Migrated to Power Apps
< 1 Month
Time It Took to Build and Utilize the Power Apps Solution
One of the nation’s largest cellular retailers, with over 770 stores in 41 states, needed to create a more cost-effective way for its field reps to both receive and follow-up with leads. To operate these locations, they were employing over 5,000 sales representatives, each responsible for following up with dozens of leads a day for phone upgrades.
“The development of this application positioned us to handle the COVID crisis with ease.”
Custom Power App Helps Large Retailer Become More Efficient and Get Massive Cost Savings
3Cloud came on board to help the client’s 5,000+ sales representatives to more effectively receive and follow up with leads.
3Cloud came in as a Microsoft partner to create a multi-form Power Apps application, meaning it would be able to be used on any device or web, to simplify the customer’s lead distribution process. Among the top priorities for this project were the establishment of a custom application for campaign creation and lead assignment, and to provide the field reps or call center an automatically created and updated to-do list daily. As a sale happened, Power Automate would automatically create tasks for the user, specifically follow-ups based on time frames. It also allowed their sales team to load information on their previous sales history, and pinpoint exactly who to target based on last purchase made and needed upgrades since.
Several design considerations came into play with this custom application, including security using Azure Active Directory, core data living in Azure SQL DB, flows being used for user notifications and all data being stored in the cloud. It was imperative that the data be stored in Azure for speed, as the entire application depended on field reps being sent the most up-to-date notifications and tasks each day.
During this engagement, 3Cloud worked to finalize the data model for storage of all leads and activities; built the ETL to load the database; created a campaign builder application; built a to-do application for field reps to generate alerts each day including leads; and trained the internal development staff on how to use the application. The custom campaign dashboard we created not only provided a summary of active campaigns and provided a set of filters to build a campaign, but also allowed a manager to pause a campaign if needed. A stored procedure loaded the campaign and active entities, and users were able to log all new activity in the application.
One of the main benefits of this custom Power Apps application was that it allowed this retailer to dramatically reduce their Salesforce licenses, and therefore costs. The Salesforce Unlimited plan averages $300 per user per month, while the Power Apps Unlimited plan costs $40 per user per month. Licenses for 5,000 field reps went from costing the client $1,500,00 monthly to costing $200,000 monthly – a savings of over $1 million each month.
In addition, our Power Apps solution was built and ready to use in less than a month, unlike a Salesforce, C# or web application which can take months to build and utilize.
After 3Cloud put this Power Apps application for this organization into production, the Covid-19 crisis hit North America and their CEO, who was very pleased with the results they were seeing, said all markets had to use it immediately. As this retailer discovered, one of the most significant benefits of Power Apps is how quickly 3Cloud was able to develop a highly useful, functioning app. Speed, combined with total integration with Office 365, Power Automate, and Microsoft Power BI, made it easy for them to get data into and out of SharePoint, or Excel, and any of the other 365 apps on which their business depends.
Karen RobitoCustomer Story – Cellular Retailer Saves Millions with Power Apps