Why Pre-Seed Teams Fail at Dashboards
You're shipping features. Your co-founder asks: "What's our activation rate?" You open a spreadsheet from last week. Or worse—you guess.
The problem isn't data. It's friction. Setting up Amplitude, Segment, or Tableau takes 2-4 weeks and $300+/month. By then, you've lost momentum.
Michael Seibel's advice: "Metrics are for founders, not for investors." Build dashboards for yourself first. This changes decision-making velocity.
The 60-Minute Setup: What You'll Build
You'll create a live dashboard that shows:
- Daily active users (DAU) trend
- Signup conversion rate (daily)
- Feature adoption (% users triggering key event)
- Cohort retention (7-day, 30-day)
- Revenue metrics if applicable
It updates automatically. It's shareable. It costs ₹0.
Step 1: Instrument Your Product (15 mins)
Start with PostHog. It takes 5 minutes to add to your web app.
```
npm install posthog-js
```
Then initialize:
```
import posthog from 'posthog-js'
posthog.init('YOUR_KEY', { api_host: 'https://app.posthog.com' })
posthog.capture('user_signup', { plan: 'free' })
```
Define 5 core events:
1. `page_view`
2. `user_signup`
3. `feature_x_used` (your core feature)
4. `payment_attempted`
5. `session_end`
PostHog's free tier handles 1M events/month. That's 33K daily active users. Plenty for pre-seed.
Why PostHog over Mixpanel? PostHog is open-source. No vendor lock-in. Better retention analytics out-of-the-box.
Step 2: Export to Google Sheets (20 mins)
PostHog has a Sheets export. But here's the faster path:
Use Convex (a serverless backend) to query PostHog every hour and push data to Sheets.
Convex setup (3 minutes):
1. Visit convex.dev. Create account.
2. Run `npm install convex`. Deploy a function:
```
export const syncMetrics = internalAction(async (ctx) => {
const posthog_data = await fetch('https://posthog.com/api/event/', {
headers: { 'Authorization': `Bearer ${process.env.POSTHOG_API_KEY}` }
}).then(r => r.json())
// Push to Sheets via Google Apps Script
await pushToSheets(posthog_data)
})
```
Schedule it via cron:
```
setInterval(() => syncMetrics(), 3600000) // Every hour
```
Alternative (if you're not technical): Use Zapier.
- Connect PostHog → Google Sheets via their native integration.
- Set it to run hourly.
- 5 minutes. ₹0.
Step 3: Build the Dashboard in Sheets (20 mins)
Google Sheets is underestimated. It's collaborative, real-time, and fast.
Create three tabs:
Tab 1: Raw Data
- Columns: Date, DAU, Signups, Feature Adoption %, Retention 7d
- PostHog/Convex populates this daily
- Don't touch this tab manually
Tab 2: Trends
Use Sheets formulas:
```
=QUERY(RawData!A:E, "SELECT A, B, C, D, E WHERE A > DATE('" & TEXT(TODAY()-30, "yyyy-mm-dd") & "')")
```
This pulls last 30 days. Add a chart (Sheets → Insert Chart):
- Type: Combo chart
- X-axis: Date
- Y-axis: DAU, signups
- Shows patterns immediately
Tab 3: Weekly Snapshot
Summary row:
- DAU this week vs. last week (% change)
- Conversion rate (signups ÷ visitors)
- Feature adoption (% of DAU)
- Retention (cohort from 7 days ago still active?)
Use formulas:
```
=IF(INDIRECT("RawData!B" & ROW()-1) > INDIRECT("RawData!B" & ROW()-8), "↑", "↓") & ROUND((INDIRECT("RawData!B" & ROW()-1) / INDIRECT("RawData!B" & ROW()-8) - 1) * 100, 1) & "%"
```
Color-code: Green (up), red (down). Takes 30 seconds to scan.
The Non-Obvious Insight
Dashboards aren't reporting tools. They're decision-forcing tools.
Scott Belsky writes in "The Messy Middle": "Constraints breed creativity." A visible KPI creates constraints. When your DAU is stuck at 150, and it's public, the team shifts behavior.
The danger: Wrong KPIs. Indian founders often track vanity metrics—sign-ups, page views, Twitter followers. Track what matters:
- For SaaS: MRR growth rate (not MRR itself), activation (day 7 return rate), churn
- For marketplace: GMV per supply-side user, match rate
- For B2B: CAC payback period, NRR
Pick 3-5 metrics. Not 50. If you're tracking 20 metrics, you're tracking noise.
When to Upgrade (and When Not To)
Stay with Sheets + PostHog if:
- You're under $50K MRR
- Team size < 10
- You need data within 1 hour (not minutes)
Move to Looker/Tableau when:
- You need sub-10-minute latency
- Multiple teams need custom views
- You're hiring a data analyst (they'll demand it)
Most Y Combinator companies stay with this setup until Series A.
Implementation Checklist
- [ ] PostHog account created, code deployed (10 mins)
- [ ] 5 core events instrumented (10 mins)
- [ ] Convex function syncing to Sheets hourly (10 mins)
- [ ] Google Sheet dashboard built with charts (20 mins)
- [ ] Shared with co-founders, added to weekly standup (5 mins)
Total: 55 minutes.
The Actionable Takeaway
Do this today. Not next sprint. Not next month.
Your co-founder should open this dashboard during every standup. For the next 4 weeks, write down what you learned from it each Friday.
If you're not changing something based on the dashboard, your KPIs are wrong. Pick new ones.
This is how you move fast. Not by building dashboards for investors. By building them for yourselves.