Retail | Data Analytics, AI / ML

Midwest grocer turns shopper data into satisfied customers

Schnucks, a leading Midwest supermarket retailer headquartered in St. Louis, Missouri was looking to capitalize on robust customer data insights to drive stronger decision making.

CS-Midwest-grocer-turns-shopper-data-into-satisfied-customers_C_Banner-1-2024
    

Customer

Industry

Retail

Location

St. Louis, MO

Solution

Data Analytics, AI / ML, Managed Services

Technology

Google BigQuery, Cloud SQL, GKE, GCE


    

Overview

Schnucks, a leading Midwest supermarket retailer headquartered in St. Louis, Missouri was looking to capitalize on robust customer data insights to drive stronger decision making. Google Cloud Platform (GCP) anchors their efforts, along with data strategy, architecture support and ongoing guidance from Pythian. Since implementing Google Workspace, Chrome Enterprise, and several Google Cloud services over the years, Schnucks has relied on Pythian as a Google Cloud Managed Service provider with broad expertise.

To launch their analytics initiative, Schnucks needed to:

  • Organize their data. While the grocer had robust customer and purchasing data, to make it usable they needed to inventory, segment and store this information efficiently. They also needed to adopt formal data governance protocols.
  • Understand staffing requirements. Leadership knew emphasizing analytics would require different competencies in the internal Data & Analytics group, as well as outside expertise.
  • Start strong. Quick wins are key for high-visibility initiatives. A proof of concept would show stakeholders the potential within company data and create an appetite for ongoing insights.
    

What we did

Working together, Pythian helped the grocer to:

  • Set the right incentive strategy. Pythian’s data scientists helped Schnucks develop a machine-learning model to predict shopper likelihood to buy certain products. These insights drove other campaign parameters.
  • Launch in the cloud. The modern, scalable GCP platform gave Schnucks computing power and ease-of-use. It offered far more flexibility than creating a custom, on-premise solution.
  • Test and learn. The 12-week proof of concept gave the Schnucks team the opportunity to learn the platform and absorb Pythian’s analytic approach in a collaborative environment.

With the subject in place, Pythian and Schnucks worked quickly to launch the proof of concept. This included:

  • Building an algorithmic, machine learning model in GCP. The model predicts the likelihood a customer will buy certain products, based on their individual shopping history.
  • Identifying Own Brand products to recommend to each customer, based on their unique results in the model.
  • Distributing coupons, special offers and other promotions to the test group during each week of the 12-week campaign, via Schnucks Rewards, the company’s loyalty program. (The control group received no recommendations or incentives.)
    

Technologies used

  • Anthos
  • App Engine
  • Apigee
  • BigQuery
  • Cloud Logging
  • Cloud Run
  • Cloud SQL
  • Composer
  • DataFlow
  • DNS
  • Google Cloud Storage (GCS)
  • Google Compute Engine (GCE)
  • Google Kubernetes Engine (GKE)
  • IAM
  • Natural Language API
  • Pub/Sub 
  • Vertex AI
  • VPC
        

Key Outcomes

Pythian helped Schnucks jumpstart their analytics efforts with:

  • Increased demand. The 12-week proof of concept clearly demonstrated the potential of data-driven programs. It generated a measurable boost in Own Brand sales and reactivated 1,200 lapsed Customers.
  • Improved competitive position. With GCP’s agility, scalability and robust features, Schnucks now has a platform to close the tech gap with larger grocery chains. They’re also armed with data insights to show their own customers new ways to eat well and save money.
  • Roadmap for the future. Going forward, Schnucks has a strategic partner in Pythian, as well as a clear plan for where to leverage this outside expertise and where to hire and train in-house talent.

The pilot quickly proved a success on multiple fronts. First and foremost, it generated a tangible improvement in Own Brand sales.

The project showed the power of targeted communications. Not only did more customers try Own Brand products, the promotions also increased the frequency of shopper visits to the store.

For Henry, even the small-scale results of the proof of concept exceeded his expectations with the caliber of information available to tailor their marketing programs and spending.

“From day one, Pythian was an extension of my team,” Henry said. “They weren’t a third-party; they were a group of teammates just as intent on project success as the Schnucks employees.”
Tom Henry

Chief Data & Deputy Chief Information Officer, Schnucks

Explore our Google Cloud Services

No matter your business, no matter the challenge: Pythian’s solutions drive results.
Related resources

Expand your data analytics knowledge

Find out more about how Pythian's Google Cloud analytics services can help you do more with your data. Check out our resources below:

Next-Gen Supply Chain Solutions Provider Improves Search Accuracy Using GenAI

Next-Gen Supply Chain Solutions Provider Improves Search Accuracy Using GenAI

Mar 28, 2024 3:14:06 PM 1 min read
Data-enabled retail: Stand Out For Good leverages BigQuery to improve marketing and customer experience

Data-enabled retail: Stand Out For Good leverages BigQuery to improve marketing and customer experience

Aug 25, 2023 9:38:27 AM 1 min read
How Retailers Can Personalize the Customer Experience Using Google BigQuery

How Retailers Can Personalize the Customer Experience Using Google BigQuery

Aug 11, 2023 12:00:00 AM 3 min read