Visits - Unique visitors

Visits - Unique Visitor Days

A log of of all past user days.

Table 1.

Column	Description
date	The calendar date when the user visited the platform.
agentid	The ID of the visiting user.
email	The email address of the visiting user.
displayname	The name of the visiting user.

A list of all users that have visited the platform. It includes a count of total number of return days per user.

Table 2.

Column	Description
agentid	ID of the visiting user.
email	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.

A daily summary showing number of users that visited the platform.

Table 3.

Column	Description
date	The calendar date being summarized.
unique_visitors	Number of users that visited the platform.

A monthly summary showing number of users that visited the platform.

Table 4.

Column	Description
month	The calendar month being summarized.
unique_visitors	Number of users that visited the platform.

A quarterly summary showing number of users that visited the platform.

Table 5.

Column	Description
quarter	The quarter being summarized.
unique_visitors	Number of users that visited the platform.

Total number of users that have visited the platform.

Table 6.

Column	Description
count	Total number of users that have visited the platform.

A weekly summary showing number of users that visited the platform.

Table 7.

Column	Description
week	The calendar week being summarized.
unique_visitors	Number of distinct users that visited the platform.

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')

In this section: