Juniper Notes sample

Database panel

A query against the app's own Postgres, pinned to its dashboard. This one is a sample result: no database is connected to this page.

SELECT created_at::date AS day, count(*) AS new_accounts
  FROM users
 WHERE created_at >= date '2026-09-01' AND created_at < date '2026-10-01'
 GROUP BY 1
 ORDER BY 1

Panels show the result they last stored, whichever range the dashboard is on, so this one covers the whole sample month.

What the numbers help answer

• Is the app being used more? Visits and visitors per day, and the gap between weekdays and weekends.
• Who is actually signing in? Signed-in users and logins count the app's own accounts, and the table shows who has not been back for a while.
• Where do visits come from, and what do people do? Top pages, referrers and named events such assignup_clicked, sent by the app or by a tag.
• Do clicks become accounts? Over the month, 721 signup_clicked events against 434 new rows in the app's users table — tracked behaviour and the database, side by side.

Track your own app