Giving 74 Million Loyalty Members a Single, Intelligent View – With No Code Required
Motivus, in partnership with Google Cloud, deployed a multi-agent generative AI platform that lets their marketing and CRM teams query 74 million customer records in plain language, collapsing campaign planning cycles from weeks to days and putting hyper-personalization in the hands of non-technical users.
Building a Self-Service Intelligence Layer Across the Region’s Prominent Retailer
It is the region’s dominant retailer with 3,200+ stores, 74 million loyalty members, and e-commerce growing 20% year over year. Their marketing and CRM teams had access to one of the richest customer datasets in Latin America, stored in mature BigQuery data models. But the data was effectively locked. Hundreds of tables, complex schemas, and no way for business users to query them independently meant every insight request went through the data team – creating bottlenecks that stretched campaign planning cycles into weeks. Motivus was brought in alongside Google Cloud to change how the business accesses and acts on its own data.
Marketing Teams Couldn’t Move at the Speed Their Data Demanded
With e-commerce growing 20% YoY and competitive pressure intensifying across 6 countries, they needed real-time, self-service access to customer intelligence. Instead, marketing and CRM teams were entirely dependent on data engineers to extract insights, build custom reports, and analyze customer behavior across hundreds of BigQuery tables. Campaign planning took weeks. Hyper-personalization – the capability needed to compete – was out of reach for non-technical users. The data was there. The access wasn’t.
What We Did
Built a Gemini Pro-powered interface that translates plain language business questions into optimized BigQuery SQL - so marketing teams can query 74M customer records across transactions, loyalty, and digital touchpoints without writing a line of code.
Deployed specialized AI agents connected to AI agents connected to the client’s existing customer and CRM data models on GCP - orchestrating query interpretation, semantic metadata resolution, and data retrieval through a governed, reliable pipeline built on the Google Gen AI SDK.
The platform automatically generates charts and trend analysis alongside query results, delivering contextual insights in a React frontend - turning raw data responses into ready-to-use campaign intelligence with no additional analyst effort.
Built a semantic metadata layer that maps business language to complex data schemas - enabling accurate, consistent query interpretation across hundreds of BigQuery tables and making the system reliable enough for non-technical users to trust independently.
100 Users. Weeks Collapsed to Days. Hyper-Personalization Live in Month One
First production release was shipped in December 2025. Within the first month, approximately 100 active users across marketing and the customer office were independently querying 74 million customer records, replacing manual analysis workflows with real-time audience segmentation. By January 2026, this leading retailer had launched hyper-personalized campaigns built directly from platform insights, with uplift measurement now running. Fragmented reporting silos were eliminated in favor of a single source of truth. The platform also established a reusable architecture – the semantic layer and model governance framework are already scoped for expansion into supply chain and operations, and the engagement has strengthened their Google Cloud partnership for future collaboration across the region’s 6-country footprint.
WEEKS TO DAYS
Campaign planning cycles collapsed from weeks to days. 100 active users in marketing and CRM within the first month of launch.
HYPER-PERSONALIZATION LIVE
January 2026: personalized campaigns activated using platform insights across 74M loyalty members. Uplift measurement in progress.
SCALABLE ACROSS 6 COUNTRIES
Reusable semantic layer and governance architecture positioned for expansion to supply chain, operations, and the full regional footprint.
Putting your customer data to work – without waiting on data teams
Motivus helps retailers and consumer brands build AI-powered customer intelligence platforms that put self-service insights directly in the hands of marketing, CRM, and commercial teams.
Build AI-First GCCs With Motivus
AI-powered delivery - Nearshore talent - Strong governance.
To provide you with the best experience, we use technologies like cookies to store and/or access information on your device. Consenting to these technologies will allow us to process data such as your browsing behavior or unique IDs on this site. Not consenting or withdrawing consent may adversely affect certain features and functions.