Skip to main content

Visits - Daily Adoption

A daily summary of number of users who used the platform with proportion which were new users.

Table 1.  

Column

Description

date

Calendar date being summarized.

user_days

Members of the account that are unique visitors that day (at least 1 pageview event).

return_days

Members of the account that are unique return visitors that day (at least 1 pageview event) and this is not their first day (e.g. creation day).

new_days

count of users visiting within their first calendar day.

percent_new

new_days / user_days * 100

rads

count of Real Active Days.

percent_rad

rads / user_days * 100



Useful queries

Find the number of active user days by week, for the past year. An active user day is counted when a user has had 11 or more interactions with the application in one calendar day. active user day.

SELECT DATE_TRUNC(date, 'week') AS week,
       SUM(user_days) AS weekly_user_days
FROM visits_adoption_daily
WHERE date >= DATE_ADD(NOW()::DATE, -1, 'year')
GROUP BY week