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,

Relatórios de estatísticas por categoria?

Comunidade Dados e relatórios

cogdog (Alan Levine) Março 11, 2024, 6:02pm 3

Obrigado por isso, é exatamente o que eu precisava (e também me faz investigar mais o que posso consultar). Adicionei à instrução SELECT para obter a contagem de respostas em um tópico

 sum(t.reply_count) replies,

Tópico		Respostas	Visualizações
Content Audit : Report to pull Categories, Topics and Replies Data & reporting sql-query	2	288	31 de Janeiro de 2025
Aggregate dashboard report data by time interval Data & reporting sql-query	4	1233	24 de Setembro de 2022
View total topics per category/sub category Support moderation	9	3176	18 de Novembro de 2015
Category stats Data & reporting	1	142	20 de Março de 2025
About the Data & reporting category Data & reporting	0	1252	10 de Agosto de 2023

Relatórios de estatísticas por categoria?

Tópicos relacionados