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? [画像] 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:?

[画像] 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).

Active users for specific months

コミュニティデータとレポート

HAWK (Hawk) 2016 年 10 月 17 日午後 4:58 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	794	2024 年 3 月 4 日
How many active users last month? Data & reporting	13	4895	2020 年 12 月 14 日
Users who’ve become active Data & reporting sql-query	0	163	2019 年 7 月 12 日
Posts created for period Data & reporting sql-query	0	222	2016 年 9 月 14 日
Retrospectively pulling number of users each calendar month Data & reporting	9	406	2024 年 11 月 12 日

Active users for specific months

関連トピック