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.user_id,
COALESCE(di.likes_received, 0) AS likes_received,
COALESCE(di.likes_given, 0) AS likes_given,
COALESCE(di.topics_entered, 0) AS topics_viewed,
COALESCE(di.topic_count, 0) AS topic_count,
COALESCE(di.post_count, 0) AS post_count,
COALESCE(di.days_visited, 0) AS days_visited,
COALESCE(di.posts_read, 0) AS posts_read,
COALESCE(di.solutions, 0) AS solutions,
COALESCE(di.gamification_score, 0) AS cheers
FROM
directory_items di
WHERE
di.period_type = :period
ORDER BY
di.user_id
Instead of the typical start_date
and end_date
parameters, data from this table can be filtered using the period_type
field, where the following values correspond to the different time periods available on the directory page:
1
: all time2
: yearly3
: monthly4
: weekly5
: daily6
: quarterly
Example Results for this report would look like:
user | likes_received | likes_given | topics_viewed | topic_count | post_count | days_visited | posts_read | solutions | cheers |
---|---|---|---|---|---|---|---|---|---|
Username1 | 4 | 17 | 250 | 69 | 116 | 480 | 217 | 10 | 844100 |
Username2 | 2 | 5 | 47 | 0 | 2 | 43 | 59 | 1 | 112305 |
Username3 | 0 | 4 | 2 | 0 | 0 | 2 | 7 | 0 | 3100 |
… | … | … | … | … | … | … | … | … | … |