Download PDF
International CPG Brand Leverages Sigma to Drive Growth
Technology Category
- Analytics & Modeling - Big Data Analytics
- Functional Applications - Enterprise Resource Planning Systems (ERP)
- Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries
- Consumer Goods
Applicable Functions
- Business Operation
- Sales & Marketing
Services
- Data Science Services
- System Integration
The Challenge
The BI team of a major international CPG brand faced scale limitations with Tableau, which often caused analyses to fail. This prevented the team from providing the necessary data to create customer profiles and a functional customer database. As a result, data had to be extracted from Snowflake via SQL queries for analysis in Excel, but these datasets were constrained due to Excel's scale limitations. The marketing team lacked insight into email campaign performance and could not develop accurate customer profiles or a searchable customer database. Customers were opting out of email communication because the emails were not relevant, leading to lost revenue opportunities from upsells, cross-sells, and repeat business.
About The Customer
A major international consumer packaged goods (CPG) brand with more than $6 billion in revenue relies on customer data provided during product registration to engage with customers and drive growth through repeat business. The brand aimed to analyze its 300 million row dataset by product information and customer cohorts to enable the marketing team to target customers with personalized email campaigns. They also wanted to identify which campaigns drove the most business and which led customers to opt out, limiting the brand's ability to grow through its existing customer base.
The Solution
With Sigma, the marketing team now has a comprehensive customer database that they can rapidly filter to create customer cohorts and highly targeted, personalized campaigns that drive revenue for the brand. Sigma was purpose-built for Snowflake and cloud data warehouses, providing the marketing team with direct access to live data in Snowflake. This ensures that everyone is always working with the same current data, eliminating stale extracts, data sprawl, and conflicting insights. Sigma's cloud-native solution delivers unlimited scale at cloud speed, allowing the marketing team to easily analyze and filter billions of rows of customer data without rendering or latency delays. Sigma's spreadsheet interface makes iterative data exploration accessible to anyone, especially those accustomed to analyzing data in spreadsheets. The marketing team can now analyze data and create pivot tables in Sigma, enabling them to quickly create customized campaigns that convert to sales.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Improving Vending Machine Profitability with the Internet of Things (IoT)
The vending industry is undergoing a sea change, taking advantage of new technologies to go beyond just delivering snacks to creating a new retail location. Intelligent vending machines can be found in many public locations as well as company facilities, selling different types of goods and services, including even computer accessories, gold bars, tickets, and office supplies. With increasing sophistication, they may also provide time- and location-based data pertaining to sales, inventory, and customer preferences. But at the end of the day, vending machine operators know greater profitability is driven by higher sales and lower operating costs.
Case Study
Series Production with Lot-size-1 Flexibility
Nobilia manufactures customized fitted kitchens with a lot size of 1. They require maximum transparency of tracking design data and individual processing steps so that they can locate a particular piece of kitchen furniture in the sequence of processes.
Case Study
American Eagle Achieves LEED with GE LED Lighting Fixtures
American Eagle Outfitters (AEO) was in the process of building a new distribution center. The AEO facility management team decided to look at alternate options for lighting layout that could provide energy and maintenance savings. AEO would need a full-time maintenance employee just to replace burned-out fluorescent tubes.
Case Study
Revolutionizing Rodent Control
From pet- and child-safe traps, to touch-free and live-catch rodent control solutions, Victor continues to stay committed to producing superior products that meet the varying needs of today’s pest control professionals. And, with a long standing history supporting customers in the food processing, service, and retail settings, Victor knew that strict regulations were costing organizations thousands of dollars in excess overhead trying to manage their rodent-control solutions. Trap inspections in these environments are often difficult and time consuming, requiring personnel to manually check a trap’s status multiple times per day, amounting to over six hours of manual labor. Victor is looking for an innovative way to increase operational efficiencies with the use of technology.