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.