All Writing
๐Ÿ“Š Data & DecisionsDeep DiveJune 20264 min read

I Set Up Product Analytics at Sonic Linker in 48 Hours. No Data Engineer, No Budget.

When you're shipping an AI product in 3 months, you don't have time for a perfect data stack. I learned to get 80% of what enterprise analytics gives you with none of the overhead. Here's exactly how I did it.

At Sonic Linker, we were three months away from launch when I realized we had no way to actually know if our AI linking feature was working. Not "working" like the model ran without errors. Working like users kept coming back to use it.

We had no data engineer. No budget for Amplitude or Mixpanel's enterprise plans. And honestly, no time to debate the perfect event taxonomy while we were still trying to ship V1.

But here's what I figured out: you don't need perfect analytics. You need just enough visibility to answer three questions every week: Are people using the core feature? Are they coming back? Where are they dropping off?

I got that visibility in 48 hours. And it cost us $0 for the first six months.

Start with Product, Not Infrastructure

Most guides tell you to "set up your data warehouse first" or "define your event taxonomy." That's great if you have a data team. I didn't.

I started with PostHog's free tier. Self-hosted, open source, and shockingly good for early-stage products. The setup was literally: add one script tag to our app, define five core events, and start tracking.

Those five events were: - User signed up - User created their first link (our core action) - User shared a link - User returned to dashboard (D1, D7, D30) - User upgraded to paid

That's it. No "button_clicked_header_cta_v2" nonsense. Just the actions that directly tied to our thesis: if users create and share links, they'll come back.

Within two days, I had a retention curve. Rough, but real. I could see that 40% of users who created one link never came back. That single insight changed our onboarding flow.

Make Every Event Answer a Decision

At Finvestfx, I inherited an analytics setup with 80+ events. Half of them were never queried. The other half had names like "action_completed_step_3" that nobody understood six months later.

I learned this the hard way: if an event doesn't directly answer a question you're asking right now, don't track it yet.

When I was trying to improve activation at Sonic Linker, I asked: "What's the smallest action that predicts someone will stick around?" Turned out it was creating two links in the first session, not just one. So I added an event for "second_link_created" and started optimizing for that.

That's it. One new event, tracked because I had a specific hypothesis to test.

Compare that to the alternative: spending two weeks defining a "complete event schema" that covers every possible future question. By the time you're done, your product has probably pivoted.

Use Google Sheets as Your First Dashboard

This sounds ridiculous, but hear me out.

PostHog has an API. So does Segment, Plausible, or whatever free tool you pick. You can pull basic metrics (signups, DAU, core action completion) into a Google Sheet with a simple script.

I did this at Sonic Linker because our CEO didn't want to log into "another tool." Fair. So every Monday, I had a sheet that auto-updated with: - Weekly signups - WAU (weekly active users) - Links created per user - Week-over-week retention

It took me two hours to set up using Google Apps Script. And honestly? It forced me to think about what metrics actually mattered, because I could only fit so much on one sheet.

The cleaner your sheet, the clearer your strategy.

Automate the Stuff That Doesn't Need a Human

You know what's annoying? Manually checking if power users are hitting errors. Or if signup volume suddenly drops on a Saturday.

I set up two Slack alerts at Sonic Linker: 1. If daily signups dropped below 50% of the 7-day average, ping me. 2. If error rate on "link_created" spiked above 5%, ping the eng team.

That's it. Two alerts. They caught issues before users even complained.

I used Zapier for this (free tier), connected to PostHog webhooks. Took 20 minutes. Saved me from obsessively refreshing dashboards every morning.

You'll Outgrow This. That's Fine.

Eventually, Sonic Linker needed more. We wanted cohort analysis, feature flags, proper funnel tracking. At that point, we paid for PostHog's cloud tier and brought in a part-time data analyst.

But here's the thing: we didn't need that on Day 1. Or even Month 3.

What we needed was enough data to make decisions faster than our competitors. And I got that in 48 hours with free tools and a scrappy mindset.

If you're a solo PM or early founding team, stop waiting for the "right" analytics stack. Pick a tool (PostHog, Plausible, June, whatever), track five events that matter, and start learning.

You can always upgrade the stack later. But you can't get back the three months you spent debating it.