January 29, 2019 — OWOX BI Pipeline. Fields ‘visitNumber’ and ‘newVisits’ added to “owoxbi_sessions” tables

Now, the session data tables “owoxbi_sessions” contain fields ‘visitNumber’ and ‘newVisits’. These fields store data about the number of a user’s session and new users in the session accordingly.

In the table data schema, ‘visitNumber’ and ‘newVisits’ follow the ‘sessionId’ field.

visitNumber INTEGER

The user's session number.

If this is the first session, then it's set to 1.

newVisits INTEGER

The total number of new users in the session.

If this is the first visit, the value is 1, otherwise null.

 

The full data schema of the 'owoxbi_sessions' table

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.