Skip to main content
Answer

Custom Report: Annual Unique Users

  • October 10, 2023
  • 4 replies
  • 54 views

jcellitti
Influencer I
Forum|alt.badge.img+1

Is there an easy way to run a report to count annual unique users? I ran a few workaround reports, which still require some computation to get the correct answer.

Best answer by alekwo

@jcellitti To my knowledge, there is nothing out of the box with that specific metric, but I think it’s easy to get what you need using existing reports.

 

I’d do it like this:

New Reports → Create a New Custom Report → User Report - Users

Filters:

All Users

Uncheck - hide deactivated users (so they will be included)

Uncheck - hide expired users (so they will be included)

View Options

check: User Last Access Date

 

Save and download the report.

Use a filter in Excel to count all records where the Last Access Date is in 2023.

4 replies

lrnlab
Hero III
Forum|alt.badge.img+10
  • Hero III
  • October 10, 2023

What do you mean by ‘annual unique users’? Do some of your users have more than 1 account?


jcellitti
Influencer I
Forum|alt.badge.img+1
  • Author
  • Influencer I
  • October 10, 2023

@lrnlab thanks for your reply! no, its something I need to run as part of our renewal analysis process. Basically, I need to know how many users signed in at least 1x throughout FY23.


lrnlab
Hero III
Forum|alt.badge.img+10
  • Hero III
  • October 10, 2023

What if you used the filter for “Last access Date” from the user management screen and the use the export function? 


alekwo
Guide III
Forum|alt.badge.img+1
  • Guide III
  • Answer
  • October 10, 2023

@jcellitti To my knowledge, there is nothing out of the box with that specific metric, but I think it’s easy to get what you need using existing reports.

 

I’d do it like this:

New Reports → Create a New Custom Report → User Report - Users

Filters:

All Users

Uncheck - hide deactivated users (so they will be included)

Uncheck - hide expired users (so they will be included)

View Options

check: User Last Access Date

 

Save and download the report.

Use a filter in Excel to count all records where the Last Access Date is in 2023.