We used the query provided in the post above and have the following questions:
- Is
user_metricsfrom theuser_statstable the correct source for this information? Given thatuser_statsis 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). - 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_enteredposts_read_countdays_visited
Could you clarify if there’s a better way to retrieve time-bound user metrics?