Visits - Daily Adoption
A daily summary of number of users who used the platform with proportion which were new users.
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