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 us…

My guess is not “dumb” but that the weekend happened. Have you seen this post? [image] 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 …

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

[image] 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!

Active users for specific months

Community Building Data & reporting

HAWK (Hawk) October 17, 2016, 9:45pm 6

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

Topic		Replies	Views
How to find the most active users over the last month Data & reporting	5	794	March 4, 2024
How many active users last month? Data & reporting	13	4895	December 14, 2020
Users who’ve become active Data & reporting sql-query	0	163	July 12, 2019
Posts created for period Data & reporting sql-query	0	222	September 14, 2016
Retrospectively pulling number of users each calendar month Data & reporting	9	406	November 12, 2024

Active users for specific months

Related topics