# Joining Google Analytics data with Hubspot Contact Table

**URL:** <https://community.hubspot.com/t/joining-google-analytics-data-with-hubspot-contact-table/66910>\
**Category:** Reporting & Analytics\
**Created:** [October 12, 2022, 4:09am UTC](https://community.hubspot.com/t/joining-google-analytics-data-with-hubspot-contact-table/66910 "2022-10-12T04:09:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![VVergis5](https://avatars.discourse-cdn.com/v4/letter/v/59ef9b/32.png) [@VVergis5](https://community.hubspot.com/u/VVergis5)\
**Post date:** [October 12, 2022, 4:09am UTC](https://community.hubspot.com/t/joining-google-analytics-data-with-hubspot-contact-table/66910/1 "2022-10-12T04:09:15Z")

</div>

Hi There,

Has anyone here undertaken a BI project where the objective was to create a funnel from visitors to leads and all the way to SQLs an Opps. We should then be able to filter this by geo, ad groups, landing pages etc. While trying this, the first problem was finding a primary key to join the two data source tables (GA and Hubspot).

Anyone who has tried something similar? Would be interested to know different thought process on this.

---

<div class="post-metadata">

**Author:** ![PamCotton](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/pamcotton/32/47916_2.png) [@PamCotton](https://community.hubspot.com/u/PamCotton)\
**Post date:** [October 12, 2022, 10:00pm UTC](https://community.hubspot.com/t/joining-google-analytics-data-with-hubspot-contact-table/66910/2 "2022-10-12T22:00:49Z")

</div>

Hello @VVergis5, thank you for posting in our Community!

I would like to add our top experts to this conversation @NicoleSengers @Jnix284@DavidDennison any suggestions for @VVergis5 matter?

Thank you,

Pam

---

<div class="post-metadata">

**Author:** ![AHeni](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/aheni/32/34033_2.png) [@AHeni](https://community.hubspot.com/u/AHeni)\
**Post date:** [October 14, 2022, 7:03am UTC](https://community.hubspot.com/t/joining-google-analytics-data-with-hubspot-contact-table/66910/3 "2022-10-14T07:03:58Z")

</div>

Hey, there is this how to guide to connect google analytics and hubspot.

> **[How to connect Google Analytics to your CRM system in less than 5 minutes?](https://windsor.ai/how-to-connect-google-analytics-to-your-crm/)**
>
> Connect Google Analytics to your CRM system to understand your entire customer journey. You will need to configure Google Tag Manager to store a hashed user identifier.

[![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/1/c/1c6f3036f86d0ae171959148ad51ad88e7b52a99.jpeg "Connecting Google Analytics and CRM data") ](https://www.youtube.com/watch?v=gebnNpTpbNE)