Skip to main content

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.



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.

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.



Visits - Unique Visitors - Daily

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.



Visits - Unique Visitors - Monthly

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.



Visits - Unique Visitors - Quarterly

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.



Visits - Unique Visitors - To Date

Total number of users that have visited the platform.

Table 6.  

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.

Table 7.  

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