@SaraDev can u provide the sql query for metrics available at https://meta.discourse.org/u?cards=no&order=post_count refer image below metrics like received like given topics viewed posts read days visited solutions cheers we are utilizing category moderators hence we are modifying the m…

Hi @srinivas.chilukuri , The /u user page statistics can be retrieved via the Data Explorer by using the directory_items table. User Directory Page Metrics -- [params] -- int :period -- Period Options: -- 1. all -- 2. yearly -- 3. monthly -- 4. weekly -- 5. daily -- 6. quarterly SELECT di.us…

@SaraDev I require the start and end date . is there a workaround for getting the given metrics with start and end date user likes_received likes_given topics_viewed topic_count post_count days_visited posts_read solutions cheers Note : I am getting metrics for a small subset of total users

[image] srinivas chilukuri: I require the start and end date . is there a workaround for getting the given metrics with start and end date user likes_received likes_given topics_viewed topic_count post_count days_visited posts_read solutions cheers If you want to view those metrics for user…

@SaraDev [image] Sara Devlaeminck: User Metrics We used the query provided in the post above and have the following questions: 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 …

PG::UndefinedColumn: ERROR: column uv.topic_id does not exist LINE 38: COUNT(DISTINCT uv.topic_id) AS topics_viewed, -- Cou...

[image] Dashboard Report - Moderator Activity 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…

User Page Metrics

Community Building Data & reporting

srinivas.chilukuri (srinivas chilukuri) October 31, 2024, 11:35pm 3

@SaraDev
I require the start and end date . is there a workaround for getting the given metrics with start and end date

user
likes_received
likes_given
topics_viewed
topic_count
post_count
days_visited
posts_read
solutions
cheers

Note : I am getting metrics for a small subset of total users

Topic		Replies	Views
Daily, weekly, or total stats by user over a specified time range Data & reporting sql-query	0	245	December 31, 2019
Dashboard Report - Moderator Activity Data & reporting sql-query , dashboard-reports , dashboard-sql	5	952	October 30, 2024
PAID Data explorer challenge: chronological list of user topics started, replied and liked Marketplace sql-query	6	3434	August 4, 2016
Complex user activity report requirement Data & reporting sql-query	22	2259	August 5, 2021
Help finding some monthly site stats about topics and user trust levels Data & reporting sql-query	20	5819	December 20, 2018

User Page Metrics

Related topics