Boosting Sales: How Salesforce-ChatGPT integration increased RevOps effectiveness by 100%
Our client, operating in the UK market as a publisher with multiple classes of media assets had a critical RevOps problem. Their media@company.com email was used by legacy advertisers and by the partner channels for sending in inquiries about the prices and availability of media assets. With increasing interest in the market to advertise on assets owned by our client, the volume of queries coming into this inbox increased dramatically over a period of time. Also, since the partner channels were also forwarding on queries they received, there were different types of email queries coming into the inbox. The increase in volume of email queries and the proliferation of types of interest created a volume and a data problem for the client. The client’s RevOps team used to handle the emails coming into the inbox manually, at a time when the volume was still manageable. As the business grew, so did the team size and it soon became obvious that deploying people to tackle the inbox not only compounded the problems but also created new problems. Firstly, the RevOps team had to jump from window to window to check the emails and then to move the deals on in Salesforce. Next, they had to ensure the data is rekeyed correctly before processing. Then there was the problem of classifying the various types of queries to ensure correct analysis and continuous improvement. The solution of having more people handle the volume did help to an extent; however, the problems continued to exist and cause pain to the team. We intervened technologically by deploying ChatGPT which is a very simple application of the AI tool’s capability. The solution design was straightforward: as soon as an email lands in the client’s inbox, it gets forwarded to a Salesforce or email generated by the relevant Email Services. The Email Services will receive this email, parse it and hand it over to the next step in the flow which is to structure the email as part of a GPT prompt. The prompt itself was created as a custom metatag to ensure iteration and improvement is easily executed. We did not go down the Prompt Library route (as such we’re eagerly waiting to get our hands on SalesforceGPT templates/ libraries) since the use case didn’t demand an array of prompts but rather to solve just this one scenario: structuring the unstructured email query. Once the email and the prompt are packaged, we opened a session with ChatGPT through REST API connections and supplied the prompt. ChatGPT typically responded within a few milliseconds for standard length prompts and took a little while longer for complex, multi-forwarded emails. The prompt was structured to ensure various scenarios (forwards of forwards; direct; wrongly addressed emails etc.) to be covered. Also, ChatGPT was prompted to return the response in a jquery format with necessary field names for easy processing. Image 1: ChatGPT prompt as a Custom Metadata Type Record This ChatGPT response is processed by the Apex in Salesforce org. The response is parsed and a new record created with necessary lookups and field populations. Though we had the option of creating a lead directly, the use case involved a human to process to record before lead creation (to control the quality further). Hence, we created what we called a pre-lead record that could be converted to a lead by a simple click thus, populating all the critical lead information automatically. As an aid to the user processing the pre-lead, the original email chain was attached to the record so they can peruse this information without leaving Salesforce and opening the inbox. Image 2: a record created from ChatGPT structured data output Image 3: Conversion of the interstitial record to a Lead In the first month of the launch, the team were able to handle 100s of emails coming into the company as inquiries and orders without leaving Salesforce leading hours of saved time and increase in revenue from this channel. The accuracy of data collection improved dramatically leading to better analysis and right deployment of resources. The team continues to use this on a daily basis now.
Amplifying i-media’s Digital OOH Efficiency
In the UK’s Motorway Services Area (MSA) sector, i-media stands out with its transformation in out-of-home advertising. Moving from static displays to dynamic digital screens, they’ve made significant strides in the OOH space, powered by strategic technological partnerships. According to a survey by MAGNA and Rapport, digital roadside billboards continue to dominate the OOH sector. i-media, having screens across the UK’s MSA network, is a testimony to this trend, given the rapid growth of its digital assets. However, scaling from 50 full-motion D48 screens to an inventory of 650 screens within a short span brought its own set of challenges. Managing campaigns on spreadsheets became a mammoth task, prompting the shift to the Broadsign platform for better automation. The challenge then arose: how to integrate i-media’s CRM, Salesforce, with Broadsign seamlessly? Enter Brysa. Recognized for our expertise in system integration, we were approached to bridge the gap. Tapping into Broadsign’s API, we integrated Salesforce with i-media’s campaign management workflow. This move eliminated the need for manual scheduling, and campaigns created in Salesforce reflected instantaneously in Broadsign. This integration reduced the operational workload significantly, leading to a 40% increase in i-media’s operational efficiency. More than just the automation, the integration empowered the sales team with real-time insights into inventory availability. This transparency bolstered trust and reduced response times to advertisers and agencies, enhancing overall client relationships. Our collaboration with i-media is a testament to Brysa’s commitment to providing tailored solutions in the OOH landscape. We pride ourselves on understanding and addressing specific challenges, offering solutions that not only solve immediate concerns but also add long-term value. As i-media continues to expand in the digital OOH sector, they can rely on a robust technology stack that evolves with their needs. With partners like i-media, we look forward to more such opportunities to drive efficiency and growth in the industry. A version of this case study appeared as an article posted at broadsign.com published on 18-Oct-2023
