按类别统计的报告?

查看 Data Explorer 插件

您可以使用它通过 SQL 查询生成报告,以下是一个查询示例,可以捕获您想要跟踪的部分内容。

-- [params]
-- date :start_date = 2020-04-01
-- date :end_date = 2020-04-29

SELECT c.id category_id, COUNT(DISTINCT(t.id)) topics, COUNT(p.id) posts, sum(p.like_count) likes, sum(p.reads) reads
FROM categories c
INNER JOIN topics t ON (t.category_id = c.id)
INNER JOIN posts p ON (p.topic_id = t.id AND p.post_type = 1)
WHERE p.created_at BETWEEN :start_date AND :end_date
GROUP BY c.id
ORDER BY COUNT(p.id) DESC

您可以通过 Data Explorer 界面与群组共享这些报告:

它将以如下方式显示在群组页面上:

7 个赞