Tracking customer response rates to marketing campaigns was a manual process for this large U.S. utility. The utility engaged with millions of customers multiple times per day – to achieve energy savings targets, promote rebates / programs, etc. Understanding which customers responded to individual marketing campaigns required pulling data from six enterprise datastores, including Oracle, an in-house Enterprise Data Warehouse, and more. Connecting to each datastore, blending the data together, and analyzing millions of rows of customers required hours of multiple analysts’ time. The utility needed a quick and easy way to measure customer response rates.
The utility looked to C3.ai Ex Machina to reduce reporting timelines. In a matter of hours, the utility’s analysts collaborated to deploy a C3.ai Ex Machina workflow – depicted below – that reduced the reporting cycle to minutes.
The solution fetches hundreds of thousands of rows of customer and marketing campaign data from the C3 AI Suite and joins the information into a unified dataset. Furthermore, analysts quickly identify the marketing campaigns recently sent to each customer by writing a simple SQL query in C3.ai Ex Machina. After cleaning the unified, joined, filtered dataset, analysts use a pivot operation to summarize customer response rates by campain and visualize the customer response rates in a histogram.
In future versions of the workflow, business analysts may choose to further understand customers by using a machine learning algorithm to perform customer segmentation in C3.ai Ex Machina. An analyst could train a clustering algorithm – such as a K-means algorithm – to group customers with similar demographics. The analyst could then assess which groups, or segments, are more likely to respond to a specific marketing campaign.
Business analysts could then write the segmentation results back to an enterprise CRM system such as Salesforce so that the Marketing team could access real-time data on a customer’s likelihood to respond to a campaign.
See how Con Edison uses C3.ai Ex Machina to rapidly identify and visualize at-risk assets to prevent safety incidents.Learn more
See how the U.S. Air Force uses C3.ai Ex Machina to identify parts that drive maintenance downtime.Learn more
See how a major U.S. energy company uses C3.ai Ex Machina to segment customers and deliver targeted marketing messages.Learn more
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.