Forum Discussion

julienvdc's avatar
julienvdc
Icon for Helper III rankHelper III
4 years ago
Solved

How can I connect multiple Google Analytics tables?

Hey there,   I have 3 Google Analytics tables: - one for sessions by country and date - one for events by country and date - one for searched terms by country and date   I am trying to find a ...
Show and Tell
Tips and Tricks
  • julienvdc's avatar
    julienvdc
    4 years ago

    Hey lbendlin thanks for jumping in. The thing is that I can have multiple events of one kind within one session, so I needed to be able to have some sort of ID per session so I could group these events to the same session.

    BUT I found a solution via this guide: https://www.simoahava.com/analytics/improve-data-collection-with-four-custom-dimensions/#3-session-id

    Basically, I created a new custom dimension (session ID) in GA and generated it using Google Tag Manager. The only issue is that this is in place for new sessions, but it is not retro-active.. but I don't mind it too much.

    I am now linking each of the three tables via the session ID.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

It all depends on how you want to report against your data. For example if you want to see the result by Country and Date then you can use a geo and a calendar dimension table  to control your three fact tables.