User Page Metrics

Data & reporting
5

@SaraDev

We used the query provided in the post above and have the following questions:

  1. Is user_metrics from the user_stats table the correct source for this information? Given that user_stats is a static table summarizing a user’s metrics since they joined Discourse, it may not be ideal for filtering metrics within a specific time range (e.g., from a start date to an end date).
  2. Time-Series Comparison (T/S C/O)
    For a given set of users, we compared the available time-period data on the user page and noticed significant discrepancies.

Key Discrepancies:

  • topics_entered
  • posts_read_count
  • days_visited

Could you clarify if there’s a better way to retrieve time-bound user metrics?

2 Likes