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!

特定月份的活跃用户数

社区数据与报告

HAWK (Hawk) 2016 年10 月 17 日 21:45 6

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

话题		回复	浏览量
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 日

特定月份的活跃用户数

相关话题