Cookie Consent by Free Privacy Policy Generator

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

Go to the Best Of the SEO Community.

Andy Frobisher
Andy Frobisher
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 in Looker Studio 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
Kyle Faber
Feb 4, 2025, 5:57 AM
Never tried but one thought is to blend in date
Nico Brooks
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
Nico Brooks
Feb 4, 2025, 6:20 AM
You can combine up to five properties this way.

Channels

  • agency (3)
  • ai-for-seo (11)
  • ai-llms (24)
  • analytics (13)
  • biz-of-seo (4)
  • career (4)
  • content (15)
  • cro (4)
  • data-viz-reporting (4)
  • datascience (2)
  • ecommerce (3)
  • events (1)
  • freelance (2)
  • general-seo (21)
  • in-house (2)
  • local-seo (12)
  • local-seo,biz-of-seo (1)
  • lounge (1)
  • reading-list-resources (3)
  • search-console (11)
  • shameless-plug (1)
  • technical-seo (37)
  • tools (1)


    • Join The Community

    The SEO Community is a free organization, with private Slack group and events, for those interested in search and AI optimization to learn, discuss, and meet others in the industry.

    Powered by MODX

    Resources

    The Community Story SEO Articles SEO Jobs SEO Conferences Top SEO Discussions Newsletter Free Tools Learn Claude Code

    The SEO Community © 2026

    Shop Merch Code of Conduct Partnerships Sitemap Update cookies preferences Terms of Service Privacy Policy