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.

    Note

    How are active user days calculated? Say you have Bob, Jane, and Sarah in your organization and Bob logged in for 5 days and had only 4 interactions each day with the application, where are, Jane and Sarah logged in for 5 days and had more than 11 interactions each day, the active user days for that week will be 10.

    Sample query

    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
In this section: