Seeking Help with Looker Studio Data Blending: GA4, GSC, and HubSpot Analytics Integration Challenge

The Best Of

Feb 4, 2025, 5:00 AM

Is there anyone here that is handy with Looker Studio? I am looking to blend data from two different domains but every time I try it doesn't work. I'm not even sure if this is possible but if anyone has done this in the past some tips or sign posting would be appreciated.

For context I already have a blend for GA4 and GSC data on one website. The client also has hub spot pages on a sub domain (completely different domain also) and the client wants the analytics from the hub spot pages included in report I have built in looker studio.

Because the matching dimension for GSC and GA4 is the landing page URL, when I try to blend in the sub domain also, it doesn't work as the landing page URLs are obviously not the same.

Any help/advice would be appreciated ????

Forwarded thread from another channel:

Kyle Faber

Feb 4, 2025, 5:57 AM

Never tried but one thought is to blend in date

Nico Brooks

Feb 4, 2025, 6:18 AM

To approximate an SQL union, do a full outer join blend, with Property as the join field. Then add coalesce fields for property, query, clicks, etc to use in your charts. So, for example, the clicks field you use in your chart will be a calculated field that looks like COALESCE(Clicks - left table, Clicks - right table)

Nico Brooks

Feb 4, 2025, 6:20 AM

You can combine up to five properties this way.