Active users for specific months

[alehandrof]

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.

[alehandrof]

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

[Mittineague]

My guess is not “dumb” but that the weekend happened.

Have you seen this post?

What cool data explorer queries have you come up with?

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 AND t.archetype …

[HAWK]

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.

[alehandrof]

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]

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