Visits - Unique visitors
Visits - Unique Visitor Days
A log of of all past user days.
Column | Description |
|---|---|
date | The calendar date when the user visited the platform. |
agentid | The ID of the visiting user. |
The email address of the visiting user. | |
displayname | The name of the visiting user. |
Visits - Unique Visitors - All Time List
A list of all users that have visited the platform. It includes a count of total number of return days per user.
Column | Description |
|---|---|
agentid | ID of the visiting user. |
The email address of the visiting user. | |
displayname | The name of the visiting user. |
active_days | The count of days user was active on the platform. |
Visits - Unique Visitors - Daily
A daily summary showing number of users that visited the platform.
Column | Description |
|---|---|
date | The calendar date being summarized. |
unique_visitors | Number of users that visited the platform. |
Visits - Unique Visitors - Monthly
A monthly summary showing number of users that visited the platform.
Column | Description |
|---|---|
month | The calendar month being summarized. |
unique_visitors | Number of users that visited the platform. |
Visits - Unique Visitors - Quarterly
A quarterly summary showing number of users that visited the platform.
Column | Description |
|---|---|
quarter | The quarter being summarized. |
unique_visitors | Number of users that visited the platform. |
Visits - Unique Visitors - To Date
Total number of users that have visited the platform.
Column | Description |
|---|---|
count | Total number of users that have visited the platform. |
Visits - Unique Visitors - Weekly
A weekly summary showing number of users that visited the platform.
Column | Description |
|---|---|
week | The calendar week being summarized. |
unique_visitors | Number of distinct users that visited the platform. |
Useful queries
The number of unique visitors that accessed the application. The results are grouped by week, for the past year.
Note
How are unique visitors counted?
Say you have Bob, Jane, and Sarah in your organization and in the past week, Bob was active for 2 days, Jane was active for 3 days, Sarah was not active, the count of unique visitors for the week is 2 as only 2 unique visitors were active for the week.
Sample query
SELECT * FROM visits_unique_visitors_weekly WHERE week >= date_add(now()::date, -1, 'year')