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.
Sample query
SELECT * FROM visits_unique_visitors_weekly WHERE week >= date_add(now()::date, -1, 'year')