LookerStudio Data Blend (Contacs and Deals)

[KirillZh]

Hello,
I'm using funnel.io, I have 2 data sources: HubSpot deals and HubSpot contacts. I need to join the data, so in the final report, I want to see contacts, related to a deal. Do you know - is it possible? If yes, which fields should be used to join? I tried to blend data in Looker Studio, by "Deal to contacts associations" and "RecordId" on contacts, but no luck.

[victoriahcw]

Ah yes, blending Contacts and Deals in LookerStudio can get tricky—especially when it comes to associated records like converted contacts. The problem you’re running into is that LookerStudio’s native blend doesn’t always resolve associations the way HubSpot links them internally. Once the contact becomes associated with a deal, it often ends up only showing up in the context of the deal, and not the contact-level fields in the blend.

One workaround we've had success with is using Coefficient to pull both Contacts and Deals into Google Sheets, with the association logic resolved ahead of time. Coefficient gives you full control over how you join data—either by using HubSpot’s built-in associations or by manually joining via common keys like user_token or contact IDs.

In your case, you could:

Use Coefficient to import all deals and their associated contact IDs.

Pull in contacts (with all the fields you need, even lifecycle ones).

Use Google Sheets to join the two using user_token or contact ID via formulas

Then send the cleaned, flattened dataset into LookerStudio as a single source.

That way, you bypass the limitations of LookerStudio’s data blending and work with a fully enriched table that’s been joined upstream in Sheets.

Let me know if you want a step-by-step on how to do this—it’s a common workaround for cross-object reporting in HubSpot.

[BrandonWoodruff · Accepted solution]

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:

1. In the Deals dataset, look for a field named something like:

   • associated_contact_ids

   • associatedVids

   • contact_id

   • associations.contactIds (common in HubSpot API exports)

2. 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 @ Pearagon Still have questions? Reach out at brandon@pearagon.com

---

[KirillZh]

Hi Brandon,
Thank you for your answer!
 
Unfortunately, there are no such fields. hs_object_id I can see in HS API, but not in data coming from funnel.io.

There is one field called " Deal to contact json associations ", which contains JSON like "[{"toObjectId": 194561522906, "associationTypes": [{"category": "HUBSPOT_DEFINED", "typeId": 4, "label": null}]}]", but It looks like LookerStudio doesn't support JSON (only through RegExp, which I dont think will work with JOIN).