Report on number of active users
Learn how to generate a report of the number of library users who sign in to My Account each month.
It is possible to generate a report in your SQL query browser to see how many unique active users log into My Account each month. The report allows your library to see actions performed including:
- renew items
- reserve items
- pay fines
- edit personal information
To generate the report, enter the following string in your query browser:
select count (distinct actor_id), substring (updated, 1.7) month from actor_web_session group by month order by month desc;