How can I view/calculate how many new unique users visited in a particular month?
סיכום מבוסס בינה מלאכותית
The discussion revolves around tracking new users who visited a Discourse site in a given month. Pratham_Nawal asks how to calculate total new unique user visits, including both logged-in and anonymous users. osioke suggests using the admin dashboard’s Signups report for basic data but acknowledges it doesn’t cover anonymous visits. They recommend using the Data Explorer plugin for more detailed analysis via SQL queries and also suggests setting up Google Analytics for broader tracking, including sign-ups. osioke further points to community-written SQL queries for additional insights.
This should show up in your admin dashboard /admin under the Signups report, are you not seeing this there? You can adjust the date range to show for a month.
You can also go to the direct Signups report to focus in on just that report: /admin/reports/signups.
Does this work for you? There are other ways but I’d suggest starting with this, the simplest step first.
Hi @osioke Unfortunately, this doesn’t help. I’m looking for something like
-
Total new user visits
-
new Logged in user visits (Signups)
-
new Anonymous user visits
Oh, okay. Then you can use the Discourse Data Explorer to get more detail, I’ll suggest also setting up Google Analytics (also see this discussion: Track sign-ups on Google Analytics) to help here too.
With Data Explorer, you can get more detailed statistics using SQL queries, here are some community written SQL queries: discourse-data-explorer/querys.md at queries · SidVal/discourse-data-explorer · GitHub.