AWS CloudData Pipelines
HubSpot to BigQuery: A Complete CRM History With SCD Type 2 Deal Tracking
Madhumita Giribabu
A leading dental-industry media company runs its sales and marketing on HubSpot. More than 200,000 activity records sat across contacts, companies, deals, calls, emails, meetings, tasks, notes and SMS, with no automated way to bring them together for analysis. The team also had no way to analyze how deals moved through the pipeline over time.
NeenOpal built ingestion pipelines across every major HubSpot object, linked them with 15 association tables and added SCD Type 2 tracking so deal stage history is preserved in Google BigQuery. The pipelines refresh weekly with no manual intervention.
Read case study