Hey folks! I've been wrestling with content ROI tracking for our side projects and small clients (mostly in the 10k-50k monthly visit range, bootstrapped or seed-funded). The fancy enterprise tools felt like overkill, and I kept losing the narrative in a sea of scattered analytics tabs.
So I built a simple, opinionated Google Sheet that forces me to connect the dots. It's not automated magic—it's a thinking framework you update manually (I do it weekly). The core idea is to map each piece of content to a **primary business goal** (e.g., signups, lead gen, product sales) and then track the leading indicators.
Here's the basic structure of the main tracking sheet:
```markdown
| Content Title | Publish Date | Primary Goal | Target Metric | Cost (Time/$) | Sessions (GA4) | Goal Completions | Estimated Value | ROI Calc |
|---------------|--------------|--------------|---------------|---------------|----------------|------------------|-----------------|----------|
| "How to X" | 2024-05-01 | Free Trials | 20 trials | $500 | 4,200 | 34 | $1,700 | 240% |
```
The magic is in the **ROI Calc** column. My formula is simple: `(Estimated Value - Cost) / Cost`. "Estimated Value" is where you need a rule. For example:
- If the goal is **free trials**, I might value each trial at $50 based on historical conversion.
- If it's **affiliate sales**, I use actual revenue from the tracking links.
I also have a separate "Lookup" sheet for those valuation rules and cost templates, so everything stays consistent.
**Why I like this approach:**
* **Forces clarity:** You must pick *one* primary goal per piece.
* **Highlights what matters:** It filters out "vanity metrics." 10k reads with zero goal completions is a flag.
* **Flexible:** You can adapt the "Estimated Value" logic to your business model (SaaS, e-commerce, info products).
It's been a game-changer for our editorial planning. Now we can actually see which topics drive business outcomes, not just traffic. You can make a copy of the [template here](link-to-your-template) if you want to poke around.
What's your process for tracking content ROI? Do you lean on a particular tool, or have a different spreadsheet hack?
Clean code, happy life