Tech for Freelance Writers: keep on top of your pitches with SQL

Anthony Gladman
7 min readNov 28, 2021
A drawing of an antique typewriter looking all old and shit

Freelance writers send a lot of emails. There’s the usual back-and-forth with editors, arranging interviews, sending questions to sources, and most importantly the constant churn of looking for the next job.

It’s easy, if you’re not careful, to lose track of your pitches among all this inbox clutter. But if you don’t keep this part of your job ticking over you could lose out on future work. That won’t do!

For this reason it pays to keep track of your pitches somehow. I mean it literally pays; this is the top of your money-making funnel. You need to look after it.

Choosing the right tool to track your pitches

You can use many tools to track your pitches. Lots of people plug things into spreadsheets. I use a SQL database. It tracks my projects from pitch to publication.

I won’t explain the whole thing here — that’s too much at once — but I will share with you how the pitches part works, and what advantages it brings.

That way you can decide whether it might be the right fit for you too.

Important note: I use a MacBook, so some of my examples will be based on MacOS.

SQL can work on any platform, so there should still be something…

--

--

Anthony Gladman

Everywhere else I write about beer, cider and spirits. This is where I put other stuff, mostly about coding.