Skip to content

Overnight X-Post Baseline — 2026-05-25 05:09 UTC

Captured immediately before Devin's "Third time's the charm" relaunch X post (post 1).

Supabase snapshot (project nldbaojmdtiutfgxhevj)

Metric Value
auth.users total 25
Latest signup 2026-05-24 23:23:50 UTC
Signups in prior 12h 1
public.subscriptions tier=pro 5
Baseline captured at 2026-05-25 05:09:30 UTC

How to use this file (any future session)

To compute overnight delta:

-- new signups since baseline
SELECT email, created_at
FROM auth.users
WHERE created_at > '2026-05-25 05:09:30+00'
ORDER BY created_at;

-- new pro upgrades since baseline (FIRST100 redemptions show as source/stripe rows)
SELECT *
FROM public.subscriptions
WHERE created_at > '2026-05-25 05:09:30+00';

-- totals to compare
SELECT
  (SELECT COUNT(*) FROM auth.users) AS total_users,           -- baseline 25
  (SELECT COUNT(*) FROM public.subscriptions WHERE tier='pro') AS pro_subs; -- baseline 5

Scheduled wake-up

Cron f9b61cb8 set to fire 2026-05-25 07:13 AM CT (one-shot, session-only — may not survive session restart). If it fires, it will: 1. Run the queries above 2. Write FounderOS/deliverables/OPS-overnight_post_report_2026-05-25.md 3. PushNotification with summary

If the cron dies (likely if Claude Code session was closed): any new session can manually run the queries against this baseline and produce the same report.

Diagnostic context

  • Analytics blind: CF token dead (401), PostHog wired on /app.html only — landing-page impressions invisible. Auth.users delta is the only reliable signal.
  • Post 1 hashtags: #PEExam #FEExam #NCEES #EIT (all direct-intent, no general-reach tag — Grok recommended adding #engineering for reach; deferred for post 1, candidate swap for post 3)
  • Coupon: FIRST100 live in Stripe per Devin
  • Pricing: $29/mo · $100/4mo

Decision triggers for post 2 timing

  • If new signups cluster in a single hour → post 2 at the same hour tomorrow (ride the impression peak)
  • If >5 new signups overnight → tag mix worked; reuse for post 2
  • If 0–2 new signups → swap tags; try #PEExam #engineering #civilengineering for broader reach on post 2