AI-Powered Customer Engagement Analytics: 22% Conversion Increase & 15% Churn Reduction
A major e-commerce company had rich transactional data and a mature Power BI implementation - but all insights were backward-looking, and marketing teams were creating campaigns manually. Numlytics built an AI-powered customer engagement analytics platform combining Azure Machine Learning for churn prediction Power BI integration and OpenAI GPT for automated personalised content - delivering a 22% conversion increase and 15% churn reduction.
The Challenge: Descriptive Analytics, Manual Campaigns
Despite mature Power BI reporting, the client's analytics capability was entirely retrospective. There was no personalised marketing automation Power BI layer, no predictive churn model, and no mechanism to personalise content at scale. Every campaign was produced manually.
- No predictive capability: Power BI dashboards showed past behaviour only - no purchase intent prediction, no churn prediction Power BI Azure ML model existed.
- Manual campaign creation: Marketing teams hand-crafted product recommendations and email campaigns - slow, generic, and ineffective at individual-level personalisation.
- No personalisation at scale: Customer segmentation existed but was too broad for meaningful personalisation - the same message sent to millions of customers.
- Reactive churn management: Customers were only flagged as at-risk after they had already disengaged - too late for effective intervention.
The Numlytics Solution: Power BI OpenAI Integration
Numlytics built a six-component architecture connecting Power BI's visualisation strengths with Azure ML's predictive capability and OpenAI GPT's GPT marketing content generation - creating a system that both predicts customer behaviour and automatically acts on those predictions.
-
01Power BI Customer Data Layer
Purchase history, web traffic, and engagement data ingested from CRM, Shopify, and Google Analytics. Custom DAX metrics for customer segmentation, lifetime value, and purchase patterns - the data foundation for all AI-powered customer engagement analytics.
-
02Azure Synapse Data Integration
ETL pipelines extracting data from all systems into structured format. Azure Data Lake handling both structured and unstructured data at scale - feeding both Power BI and Azure ML models.
-
03Azure ML Predictive Models
Purchase intent and churn prediction Power BI Azure ML models built on historical customer data. Models integrated directly into Power BI - predictive scores visible alongside existing behaviour analytics in the same dashboard.
-
04Power BI OpenAI GPT Integration
Numlytics built a Power BI OpenAI integration connecting customer segments from Power BI to OpenAI GPT via custom API - enabling GPT to generate personalised product recommendations, email subject lines, and marketing copy at scale.
-
05Azure Cognitive Search Enrichment
Customer data indexed for improved search and categorisation - improving the relevance of GPT marketing content generation by linking it to product catalogues and individual purchase history.
-
06Azure Logic Apps Automation
Content distribution automated: GPT-generated campaigns sent via Mailchimp and Salesforce without manual intervention - enabling personalised marketing automation Power BI at scale.
The Results
- Power BI showed past behaviour only
- No predictive churn or intent models
- Campaigns hand-crafted manually
- One generic message to all customers
- Azure ML churn & intent scores in Power BI
- GPT-generated personalised content at scale
- 22% conversion, 15% churn reduction
- Campaigns automated via Logic Apps