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. 

  • Retail
  • Data and AI
  • Generative AI
  • Google Cloud / Gemini Pro
  • Customer Intelligence
  • 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

    Ask in Plain English, Get Optimized SQL

    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. 

    Multi-Agent System on Google Cloud

    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. 

    Charts and Insights, Instantly Generated

    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. 

    Accurate Interpretation at Scale

    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.

    Read more