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.
Secure, scalable foundation for future cloud analytics
