Joining Tables in Queries

In this article

Analyse behaviour down to a user/session/page view level

When writing queries, you may want to join different tables together. Below are a few examples of columns you can use to do this. Each of the following columns populate every event fired into Permutive:

View_ID

The view_id  property is a UUID that is unique to the user's current pageview. 

All events tracked will be given the same view_id, allowing you to track a user's activity down to a Pageview level. 

 User_ID

The user_id  property is a UUID that is unique to a specific user. 

All events tracked will be given the same user_id, allowing you to track a user's activity over all-time (unless cookies are cleared).

Session_ID

The session_id  property is a UUID that is unique to each session

All events tracked will be given the same session_id, allowing you to track a user's activity down to session level. 

If you have any questions, please contact customer support by emailing support@permutive.com or chat to the Customer Operations Team via the LiveChat icon in the bottom right corner of your screen. 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request