Skip to main content

Cumulative Unique Users

Distinct users who signed in this month or this calendar year.

The total number of distinct users who have signed in to CanadaLogin over a chosen reporting window: this month or this calendar year.

This metric is useful for understanding the overall reach and adoption of CanadaLogin over time. Note that it will not align with the sum of unique users across individual apps: a user who signs into App A and App B on the same day counts as two unique users at the app level but only one overall.

Calculation

Take the latest value of the cumulative unique-user column for the window of interest. The window is chosen by which column you read, not by a date filter (see the note on reporting timespans):

  • mtd_unique_users for month-to-date
  • ytd_unique_users for year-to-date

These columns are cumulative, so the most recent row holds the current total.

Month-to-date:

SELECT
    mtd_unique_users
FROM ibm_verify_events_transformed.events_auth_total_logins
ORDER BY from_date DESC
LIMIT 1;

Year-to-date:

SELECT
    ytd_unique_users
FROM ibm_verify_events_transformed.events_auth_total_logins
ORDER BY from_date DESC
LIMIT 1;

Month-to-date:

tbl(con, in_schema("ibm_verify_events_transformed", "events_auth_total_logins")) |>
  slice_max(
    from_date,
    n = 1,
    with_ties = FALSE
  ) |>
  pull(mtd_unique_users)

Year-to-date:

tbl(con, in_schema("ibm_verify_events_transformed", "events_auth_total_logins")) |>
  slice_max(
    from_date,
    n = 1,
    with_ties = FALSE
  ) |>
  pull(ytd_unique_users)

Interpretation notes

Each column resets on its own cadence: mtd_unique_users resets at the start of each month and ytd_unique_users at the start of each calendar year. Do not sum these columns across rows; they are already cumulative.

To compare a month in progress with the month before, read both on the same day of the month: the 12th against the 12th. If the earlier month is shorter, use its last day. Never compare a partial month with a finished one; the partial month always looks smaller.

Alternative names

  • month-to-date unique users
  • year-to-date unique users
  • total overall unique users this month / this year
  • overall unique users MTD / YTD
  • distinct people reached on CanadaLogin