# Hoe maak ik een aangepast rapport voor dagelijkse gebruikersaanmeldingen?

**URL:** https://meta.discourse.org/t/how-to-create-a-custom-report-for-daily-user-sign-ups/346666
**Category:** Data & reporting
**Created:** [11 januari 2025 om 18:23 UTC](https://meta.discourse.org/t/how-to-create-a-custom-report-for-daily-user-sign-ups/346666 "2025-01-11T18:23:52Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![RoyJack](https://avatars.discourse-cdn.com/v4/letter/r/9fc348/32.png) [@RoyJack](https://meta.discourse.org/u/RoyJack)
#### Post date: [11 januari 2025 om 18:23 UTC](https://meta.discourse.org/t/how-to-create-a-custom-report-for-daily-user-sign-ups/346666/1 "2025-01-11T18:23:52Z")

</div>

Hi all,

I want to generate a custom report that shows daily user sign-ups over time. I noticed the built-in reports don’t provide exactly what I need. Would using the [Data Explorer](https://meta.discourse.org/t/32566?silent=true) plugin be the best option for this? If so, could anyone share a sample SQL query to get started?

Thanks!

---

<div class="post-metadata">

### Author: ![Moin](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/moin/32/554653_2.png) [@Moin](https://meta.discourse.org/u/Moin)
#### Post date: [11 januari 2025 om 18:58 UTC](https://meta.discourse.org/t/how-to-create-a-custom-report-for-daily-user-sign-ups/346666/2 "2025-01-11T18:58:33Z")

</div>

Welcome to Meta 👋

> [@RoyJack](#):
>
> I noticed the built-in reports don’t provide exactly what I need.

What do you need? A [data explorer](https://meta.discourse.org/t/32566?silent=true) query can probably help you get the data. Here is a short example that returns the number of users who signed up per day within a given timespan.

```sql
-- [params]
-- date :start
-- date :end

SELECT DATE(users.created_at) AS signup_date, COUNT(*) AS signups
FROM users
WHERE users.created_at >= :start AND users.created_at <= :end
GROUP BY DATE(users.created_at)
ORDER BY signup_date DESC

```

The result is something like:

 ![Screenshot_20250111_195002_Firefox](https://global.discourse-cdn.com/meta/original/4X/d/8/1/d81eeea55a66db777a30062078fbc7910126a83e.jpeg)

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [10 februari 2025 om 18:59 UTC](https://meta.discourse.org/t/how-to-create-a-custom-report-for-daily-user-sign-ups/346666/3 "2025-02-10T18:59:14Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.