# Active users for specific months
**URL:** https://meta.discourse.org/t/active-users-for-specific-months/51495
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [October 13, 2016, 10:15am UTC](https://meta.discourse.org/t/active-users-for-specific-months/51495 "2016-10-13T10:15:05Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@alehandrof](https://meta.discourse.org/u/alehandrof)
#### Post date: [October 13, 2016, 10:15am UTC](https://meta.discourse.org/t/active-users-for-specific-months/51495/1 "2016-10-13T10:15:06Z")
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.
---
### Author:  [@alehandrof](https://meta.discourse.org/u/alehandrof)
#### Post date: [October 17, 2016, 4:50pm UTC](https://meta.discourse.org/t/active-users-for-specific-months/51495/2 "2016-10-17T16:50:59Z")
Has no one answered because my question is dumb 😳 or because there is not way to find out this data 👿?
---
### Author:  [@Mittineague](https://meta.discourse.org/u/Mittineague)
#### Post date: [October 17, 2016, 4:56pm UTC](https://meta.discourse.org/t/active-users-for-specific-months/51495/3 "2016-10-17T16:56:06Z")
My guess is not “dumb” but that the weekend happened.
Have you seen this post?
> [@Posts created for period](https://meta.discourse.org/t/posts-created-for-period/275138):
>
> Posts created for period 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…
---
### Author:  [@HAWK](https://meta.discourse.org/u/HAWK)
#### Post date: [October 17, 2016, 4:58pm UTC](https://meta.discourse.org/t/active-users-for-specific-months/51495/4 "2016-10-17T16:58:46Z")
> [@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.
---
### Author:  [@alehandrof](https://meta.discourse.org/u/alehandrof)
#### Post date: [October 17, 2016, 5:04pm UTC](https://meta.discourse.org/t/active-users-for-specific-months/51495/5 "2016-10-17T17:04:37Z")
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!
---
### Author:  [@HAWK](https://meta.discourse.org/u/HAWK)
#### Post date: [October 17, 2016, 9:45pm UTC](https://meta.discourse.org/t/active-users-for-specific-months/51495/6 "2016-10-17T21:45:03Z")
No problem. FWIW I’ve updated the topic on FeverBee to reflect this – things shouldn’t be that hard to find (apologies).
---
### Author:  [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [June 8, 2024, 12:45pm UTC](https://meta.discourse.org/t/active-users-for-specific-months/51495/7 "2024-06-08T12:45:14Z")
This topic was automatically closed after 2795 days. New replies are no longer allowed.