Hello!
Yes, it is possible to join HubSpot Deals and Contacts data in Looker Studio (via Funnel.io), but there’s one critical detail: you should join them using the internal HubSpot ID fields that represent associations, not just record IDs.
I would associate via the following example:
| HubSpot Object | Join Field | Notes |
|---|---|---|
| Deals | associatedVids or contact_id | This is the ID of the associated contact(s) |
| Contacts | hs_object_id or vid | Unique contact ID |
Depending on your Funnel.io export:
-
In the Deals dataset, look for a field named something like:
- associated_contact_ids
- associatedVids
- contact_id
- associations.contactIds (common in HubSpot API exports)
-
In the Contacts dataset, you want the field:
- vid (older field, same as ID)
- or hs_object_id
Then in Looker Studio Data Blend:
-
Use:
- Deals.associated_contact_id = Contacts.vid
If a deal has multiple associated contacts, some exports will return a list or comma-separated string (e.g., 12345,67890). In that case, Looker Studio won’t blend properly unless you explode the list or pre-process the data in Funnel.io.
Let me know if this helps, or if you have any other questions!
Was I able to help answer your question? Help the community by marking it as a solution.
| Brandon Woodruff Senior Software Developer @ PearagonStill have questions? Reach out at brandon@pearagon.com  |
