I’m trying to find two pieces of data: How many active users* did my community have in the month of April 2016 and how many in September 2016. * Active user = posted at least 1 topic or reply within the time period. More details: I have Google Analytics hooked up. My community is private so all users are logged in. I’ve read several forum posts here, as well as on the FeverBee forum, which indicate that this is possible, but I can’t figure out how.

My guess is not “dumb” but that the weekend happened. Have you seen this post? [תמונה] Posts created for period Data & reporting Posts created for period Got what I need (thanks @meglio) so updating this for future posterity. -- [params] -- date :date_from -- date :date_to -- int :min_posts = 1 WITH user_activity AS ( SELECT p.user_id, count (p.id) as posts_count FROM posts p LEFT JOIN topics t ON t.id = p.topic_id WHERE p.created_at::date BETWEEN :date_from::date AND :date_to::date AND t.deleted_at IS NULL AND t.visible = TRUE AND t.closed = FALSE AND t.archived = FALSE…

Has no one answered because my question is dumb :flushed: or because there is not way to find out this data :imp:?

[תמונה] alehandrof: I’ve read several forum posts here, as well as on the FeverBee forum, which indicate that this is possible, but I can’t figure out how. The query Mittineague references does the job perfectly. I use it for my monthly reporting.

That answer my question perfectly. Thanks to both @Mittineague & @HAWK! Edit: you should really put a big bow on that post. This is super useful stuff!

No problem. FWIW I’ve updated the topic on FeverBee to reflect this – things shouldn’t be that hard to find (apologies).

משתמשים פעילים עבור חודשים ספציפיים

קהילה נתונים ודיווח

HAWK (Hawk) 17 באוקטובר,‏ 2016,‏ 4:58pm 4

The query Mittineague references does the job perfectly. I use it for my monthly reporting.

נושא		תגובות	צפיות
How to find the most active users over the last month Data & reporting	5	835	4 במרץ,‏ 2024
How many active users last month? Data & reporting	13	4983	14 בדצמבר,‏ 2020
Users who’ve become active Data & reporting sql-query	0	181	12 ביולי,‏ 2019
Posts created for period Data & reporting sql-query	0	234	14 בספטמבר,‏ 2016
Retrospectively pulling number of users each calendar month Data & reporting	9	463	12 בנובמבר,‏ 2024

משתמשים פעילים עבור חודשים ספציפיים

נושאים קשורים