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 plugin be the best option for this? If so, could anyone share a sample SQL query to get started?
Thanks!
Welcome to Meta 
What do you need? A data explorer 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.
-- [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:
