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

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

Aktive Nutzer für bestimmte Monate

Gemeinschaft Daten & Berichterstattung

HAWK (Hawk) 17. Oktober 2016 um 16:58 4

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

Thema		Antworten	Aufrufe
How to find the most active users over the last month Data & reporting	5	794	4. März 2024
How many active users last month? Data & reporting	13	4895	14. Dezember 2020
Users who’ve become active Data & reporting sql-query	0	163	12. Juli 2019
Posts created for period Data & reporting sql-query	0	222	14. September 2016
Retrospectively pulling number of users each calendar month Data & reporting	9	406	12. November 2024

Aktive Nutzer für bestimmte Monate

Verwandte Themen