---
title: LifeLabs Learning: BigQuery and Mailchimp Case Study
url: https://dataautomation.com/case-studies/lifelabs-learning/
description: LifeLabs Learning increased course enrollment by 35% and reduced missed courses by 40%, while improving client satisfaction.
---

[← All case studies](https://dataautomation.com/case-studies/) LifeLabs Learning

# 35% more course enrollment. 40% fewer missed courses.

LifeLabs Learning increased course enrollment by 35% and reduced missed courses by 40%, while improving client satisfaction. The event-driven communication workflow connected learning-operation data with the audiences and messages needed to support participation. LifeLabs Learning connected BigQuery, Google Sheets and Mailchimp to turn operational events into audience selection, message delivery and reporting workflows.

Data integration Event-driven workflows Campaign automation Reporting pipelines

**+35%** course enrollment

**40% fewer** missed courses

**Improved** client satisfaction

## Client

LifeLabs Learning

## Engagement

Data-driven customer communication

## Systems and workflows

- BigQuery
- Google Sheets
- Mailchimp

Learning and membership events -> Audience and message preparation -> Campaign delivery and reporting

## The challenge

LifeLabs Learning's communication needs depended on events held in its data warehouse: missed membership events, deregistrations, upcoming team registrations and invitations. Moving that information into an email platform required more than exporting a contact list.

The workflow needed to choose the right message for the event, prepare the audience, send through the existing platform and update the operational records so the process could be tracked.

## The implementation

### Select the events and the appropriate message

DataAutomation built a workflow that queries unqueued records in BigQuery across the relevant event categories. A template table in Google Sheets provides the message configuration, and client-specific transformation logic selects the appropriate template and campaign data.

### Automate the campaign workflow

The integration updates contact tags, creates campaigns and sends through Mailchimp, then performs configured cleanup and updates the source records. A companion configuration brings Mailchimp reports back into BigQuery.

### Connect delivery to source records and reporting

The implementation connects operational data, message selection, delivery and reporting in a defined sequence. It gives the business a repeatable way to act on warehouse events through its established communication platform.

## What changed

LifeLabs Learning increased course enrollment by 35% and reduced missed courses by 40%, while improving client satisfaction. The event-driven communication workflow connected learning-operation data with the audiences and messages needed to support participation.

The integration connected the action back to the data: source records were updated as the workflow progressed, and reporting information could return to BigQuery. Operational data became something the team could act on through its existing communication platform.

## The scope of the engagement

Data engineering that connects warehouse information to a practical customer-facing action.

Business outcomes and timelines reported by DataAutomation.

[PreviousNelbud](https://dataautomation.com/case-studies/nelbud/) [All case studies](https://dataautomation.com/case-studies/) [NextClinuvel](https://dataautomation.com/case-studies/clinuvel/)

## Audited every year.

Deloitte and Amazon SP-API audits in 2026. PwC and Amazon SP-API in 2025. Shadow AI was involved in 43% of the breaches [IBM studied for its 2026 report](https://www.ibm.com/reports/data-breach); we keep your data out of it. And if something we run goes wrong, we own the fix.

[See the latest AI incidents](https://dataautomation.com/ai-security/) [See our audits](https://dataautomation.com/audits/)

## Bring us the complicated part.

[See what changed for our clients ->](https://dataautomation.com/case-studies/)

[Book a free call](https://meet.dataautomation.com/meet-with-dataautomation) [Describe your setup](https://dataautomation.com/#describe)
