Daily product metrics snapshot
Run read-only SQL on your Supabase database each morning and email your key numbers.
Every morning, pull my key product metrics from Supabase with read-only SQL and send me a short snapshot so I start the day knowing the numbers. Query the database for these, each as "yesterday vs the day before" with the change: - New signups (rows in the users/profiles table created yesterday). - Total users. - <add your own — e.g. new paid subscriptions, active users, orders, revenue>. Figure out the right tables and columns from the schema. Use read-only queries only. Present it as a tidy list with the number, the day-over-day change, and an arrow (↑/↓). Add a one-line read on how the day looked. If a query can't be built confidently, say which metric and why instead of guessing.
Product snapshot — 30 Jun 2026 (vs 29 Jun) • New signups: 143 ↑ (+18%) • Total users: 28,410 • New paid subs: 12 ↑ (+2) • Active users (24h): 4,905 ↓ (−3%) • Revenue (new MRR): $348 ↑ Read: solid signup day; activity dipped slightly — worth a glance if it continues.
The numbers that tell you how the product is doing already live in your Supabase database — you just have to remember to look. This routine runs the queries for you every morning and emails a clean snapshot with day-over-day changes, so the pulse of the product is the first thing in your inbox.
How it works
- It uses Supabase to run read-only SQL for the metrics you name and compares day over day.
- One short snapshot lands in your inbox each morning, with an arrow on every number.
- It's read-only — the routine queries your data, it never writes to the database.
Make it yours
- Swap in the metrics that matter to you — retention, orders, churn, whatever you track.
- Change the comparison window to week-over-week, or add a simple 7-day trend.
- Pair it with Slack to post the snapshot into a team channel instead of email.
Run “Daily product metrics snapshot” on autopilot
Copy it to your account, tweak the details, and it runs every day at 7:00 am.
Use this routine →More Monitoring templates
Every Monday, run a set of buyer-intent searches and tally which tools show up when people research your space — a weekly Share-of-Voice report, emailed.
Every weekday, run an Apify scraper you choose, pull the fresh results, and email a summarized digest of what's new.
Every morning, get the X/Twitter mentions worth replying to, grouped by sentiment.
Get an email the moment a competitor changes their pricing page — plans, prices, or limits.