CASE STUDY

National canine registry unlocks donor insights with a unified data platform on Google Cloud

 

KEY RESULTS

case-study-checkmarkSecure, scalable foundation for future cloud analytics

case-study-checkmarkCentralized all marketing data

case-study-checkmarkImproved donor targeting with data


 

Customer overview

The not-for-profit customer is a recognized and trusted expert in breed, health, and training information for all dogs. The organization actively advocates for responsible dog ownership and is dedicated to advancing dog sports.

CDW acted as the primary system integrator, data consultant, GCP design lead, and GCP reseller and support arm post-implementation.

 

The challenge

As a non-profit, the organization was seeking insights to better target donors for their cause. The goal was to streamline marketing and outreach campaigns, ensuring return on marketing budgets. The customer identified their GA4 (Google Analytics 4) dataset and two other disparate datasets as the source data for a BigQuery pilot to production to address this challenge.

 

The solution

CDW set up the customer's GCP project and established a foundational landing zone. A BigQuery dataset was created by exporting data from MS SQL to BigQuery using Dataflow / Datastream, and defining a reference data lake with two zones using the Dataplex service. Once complete, CDW established IAM and proper access policies to the GA4 dataset now in BigQuery.

 

The result

The non-profit is now able to search against and capture insights and trends from their GA4 dataset. In addition, they have a secure Google Cloud foundation integrated with their identity provider. This allows for expanded usage of the Google Cloud Platform and knowledge transfer on how to use various Google Cloud Services.

Knowledge transfer and upskilling of the customer's IT team was established through the delivery of this project. The foundation is in place for both the customers first workload, but also expanded usage of the Google Cloud Platform.

CDW is the innovation expert for YOUR team.

 

Embarking on a cloud journey is the first stride towards innovation for your enterprise. Our dedicated team of change management experts accompanies you every step of the way, ensuring user adoption and maximizing ROI through tailored strategic planning and customized training services.