Is there a way to see how many posts in a topic in a particular month?

data & reporting
1

I am curious about topic growth over time - is there a way to see posts within a topic in a particular timeframe for reporting?

2

If you have Data Explorer plug-in installed, I think this will work:

-- [params]
-- date :date_from = 
-- date :date_to = 
-- int  :topic_id = 

SELECT COUNT(p.id) as posts_count
FROM posts p
WHERE p.created_at::date BETWEEN :date_from::date AND :date_to::date
    AND p.topic_id = :topic_id
    AND p.deleted_at IS NULL

The query counts the number of posts in the specified topic that were created within the date range and have not been deleted, so you can use any period of time. Date format is YYYY-MM-DD and topic id can be seen in the topic’s URL.

2 Likes
3

I’m not sure I’m 100% following what the requirement is? Are you looking for post count per month for a specific topic?