The Freelancer's Notion Project Tracker: Stop Letting Side Projects Die

Here's what actually happens: you've got a full client roster, three billable deadlines this week, and somewhere in a half-finished Notion page sits your SaaS idea, your ebook draft, your productized service that was going to change everything. It's not that you lack motivation. It's that your client work has a system — invoices, briefs, deliverables, deadlines — and your side project has a folder called "Ideas."

The fix isn't discipline. It's structure. Specifically, a Notion project tracker for freelancers that treats your side projects with the same operational rigor you give your clients.

Here's exactly how to build one.

The Database Properties That Actually Matter

Start with a single Notion database. Don't split it into five linked databases right away — you'll never maintain it. One flat database, scoped to your side projects only. Here are the properties worth setting up:

Project Name — Plain text. Keep it short.

Status — Select, with these options:

• Idea — parked, not active
• In Progress — actively worked on
• Paused — deliberately shelved
• Shipped — launched or published
• Killed — explicitly abandoned (don't hide these; killing a project is a decision worth recording)

Next Action — Text field. Not a task list — one sentence describing the very next physical thing to do. "Write intro section." "Record Loom demo." "Post to Product Hunt." If you can't fill this field, the project is stuck, not in progress.

Target Date — Date. Not "someday." A real date. If it keeps slipping, that's signal — either kill it or protect the time.

Category — Select or Multi-select. Examples: Content, Product, Client-Facing, Learning. This pays off when you're reviewing where your time actually went.

Weekly Hours — Number. The hours you're committing per week. Treat this like a retainer for yourself. If your total weekly hours across all active projects exceeds your real available capacity, something comes off the board.

Last Worked — Date. This is the guilt property. You'll update it manually after each work session. Anything that hasn't moved in 14 days is either Paused or Killed — full stop.

Revenue Potential — Select: Low / Medium / High / None. Forces honesty about what you're building and why.

The Views That Make It Functional

Raw databases are just spreadsheets with extra steps. Views are where Notion becomes an actual system.

Active Sprint (Board view) Filter: Status = In Progress. Group by: Status. This is your working board — the thing you open Monday morning. Should have three or fewer items at any time.

Full Pipeline (Table view) No filter. Sort by Target Date ascending. This is your "zoom out" view — run it during your weekly review to see what's active, what's overdue, what's been sitting in Idea forever.

Weekly Focus (Gallery view) Filter: Status = In Progress OR Paused (active consideration only). Shows Next Action and Weekly Hours prominently. Use this to plan your time blocks for the week.

Dead Projects Archive (Table view) Filter: Status = Killed OR Shipped. Hidden by default. Look at this quarterly to notice patterns — what kinds of projects do you start and kill? What did you actually ship?

Common Mistakes (That Kill the System)

Mistake 1: Too many active projects. If you have more than four projects in In Progress at once, nothing moves fast enough to feel like progress. Cap it at three. The fourth waits in Idea or gets Killed.

Mistake 2: Vague "Next Action" fields. "Work on the website" is not a next action. "Write the hero section copy" is. The property should always resolve to a 30-minute task. If it doesn't, break it down before you leave the database.

Mistake 3: Skipping the weekly review. This system requires a 15-minute weekly review minimum. Friday at EOD or Monday morning. Update Last Worked, reset Next Action, archive anything that's actually done. Without this, the database becomes a graveyard.

Mistake 4: Building the tracker instead of the project. Every freelancer I know has spent a full afternoon perfecting their Notion setup and shipped nothing. Build the minimum viable tracker first — five properties, two views — and iterate. The system exists to serve the work, not the other way around.

Mistake 5: Not protecting the time. A side project with 30 minutes a week moves slower than a dead project. If Weekly Hours is 0.5, either bump it or park the project. False commitment is worse than no commitment.

The Payoff: Treated Like Real Work

The moment this clicked for me was when I had a client call on Thursday and a side-project check-in with myself on Friday — same energy, same prep, same accountability. The difference was I had a system for the client and a prayer for everything else.

A notion project tracker for freelancers doesn't add hours to your week. It removes the decision fatigue of "what should I work on today?" Because you already answered that question when you set your Next Action and your Weekly Hours. You just execute.

Side projects die from neglect, not from lack of ideas. Structure is the antidote.