Hi folks, wasn’t able to find this discussed previously. Is there a way to generate reports (pageviews, topics, posts) on a per-category basis? We created a new category that’s generating interest from our community, and we’d like to see its growth curve over time as we make people aware it’s ther…

Check out the Data Explorer plugin . You can use this to generate reports from SQL queries, here’s a query that will capture some of what you want to track. -- [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…

Thanks for this, it’s exactly what I needed (and also has me digging more into what I can query). I added to the SELECT statement to get the count of replies in a topic sum(t.reply_count) replies,

按类别统计的报告？

社区数据与报告

cogdog (Alan Levine) 2024 年3 月 11 日 18:02 3

谢谢你，这正是我需要的（也让我更深入地研究了可以查询的内容）。我在 SELECT 语句中添加了以获取主题回复的数量

 sum(t.reply_count) replies,

话题		回复	浏览量
Content Audit : Report to pull Categories, Topics and Replies Data & reporting sql-query	2	288	2025 年1 月 31 日
Aggregate dashboard report data by time interval Data & reporting sql-query	4	1233	2022 年9 月 24 日
View total topics per category/sub category Support moderation	9	3176	2015 年11 月 18 日
Category stats Data & reporting	1	142	2025 年3 月 20 日
About the Data & reporting category Data & reporting	0	1252	2023 年8 月 10 日

按类别统计的报告？

相关话题