用户页面指标

数据与报告
2

你好 @srinivas.chilukuri，

可以通过 Data Explorer 使用 directory_items 表来检索 /u 用户页面的统计信息。

用户目录页面指标

-- [params]
-- int :period
-- 时间段选项：
-- 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

该表使用 period_type 字段进行筛选，而不是使用典型的 start_date 和 end_date 参数。以下值对应于目录页面上可用的不同时间段：

  • 1：全部时间
  • 2：每年
  • 3：每月
  • 4：每周
  • 5：每日
  • 6：每季度

此报告的示例结果如下所示：

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
… … .. … … … … … … …
3 个赞