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.