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. 

Did this answer your question?