Hi everyone, has anyone here setup/been using Hubspot <> Looker Studio for reporting/analytics? We're setting this up and I'm looking for answers to a couple of questions! Would love to connect if you have had this experience. Appreciate any help here π
hubspot to looker studio setups usually work well for top level reporting but get nuanced fast once you move beyond standard objects. the connector often handles basic contact deal and campaign data cleanly, yet calculated lifecycle metrics and multi touch attribution can behave differently depending on how data freshness and custom properties are synced, which is why mapping exactly which objects and fields will drive decisions upfront tends to prevent rework later. the sync layer isnβt fully deterministic under higher data volumes, so expectations on latency matter.
add sql in between, for calculated fields, attribution logic and deduplication. looker studio is for viz. hubspot is your data source, to control and manage data you need additional layer here (bigquery, for example)