Freelance Writing: How to Track Magazine Query Letters (& Follow Ups)

For a freelance writer who doesn’t have a query tracking system—or has the organizational skills of a bowling ball, like me—here is a simple spreadsheet to help you keep track.
Author:
Publish date:

Q: What's the most efficient way to track magazine queries when freelance writing? I've been doing it by date on a single sheet of paper, but that seems haphazard. —Ellen Ryan

Grammar Rules

A: There isn’t a “right” way to track queries. You could create a database on your computer. You could write them on napkins and stuff them in a cookie jar. Any method can work as long as you understand how to use it. If you’re sending out submissions by the busload, all that really matters is that you’re organized.

For a writer who doesn’t have a system—or has the organizational skills of a bowling ball—it’s a good idea to set up a spreadsheet to track your submissions. There are six major categories that belong in your chart: the article idea, the magazine you’ve sent it to, the editor’s name/submissions address of said magazine, the date you submitted it, the date by which you should get a response and the date you plan to follow up in the event that your query goes unanswered. It should look something like this:

Article Idea

Magazine Submitted To

Editor name/ submissions e-mail address

Date Submitted

Date Submitted

Date Magazine should reply by

Follow up on

It’s these elements you need to remember. And for any magazine that doesn’t give a response within the time it states in its guidelines, give the editor at least one month before checking in.

You can add in extra boxes, of course, such as article accepted/rejected, contract signed, payment received and so on. You could always highlight accepted queries or draw happy faces next to them. Whatever works best for you. Just stay organized.

Thanks for visiting The Writer's Dig blog. For more great writing advice, click here.

brian-klems-2013

Brian A. Klems is the editor of this blog, online editor of Writer's Digest and author of the popular gift bookOh Boy, You're Having a Girl: A Dad's Survival Guide to Raising Daughters.

Follow Brian on Twitter: @BrianKlems
Sign up for Brian's free Writer's Digest eNewsletter: WD Newsletter
Listen to Brian on: The Writer's Market Podcast

Nicole Galland: On Returning to Familiar Characters

Nicole Galland: On Returning to Familiar Characters

Bestselling author Nicole Galland explains what it was like to dive into writing a series and how speculative fiction allows her to explore her interests.

6 Tools for Writing Nonfiction That Breathes

6 Tools for Writing Nonfiction That Breathes

Nonfiction author Liz Heinecke gives her top 6 tips for crafting a nonfiction book that will really capture your subject.

Flash Fiction Challenge

2021 February Flash Fiction Challenge: Day 27

Write a piece of flash fiction each day of February with the February Flash Fiction Challenge, led by editor Moriah Richard. Each day, receive a prompt, example story, and write your own. Today's prompt is to write something that makes you laugh.

Poetic Forms

Ars Poetica: Poetic Forms

Poetic Form Fridays are made to share various poetic forms. This week, we look at ars poetica and the art of writing poems about poems.

Flash Fiction Challenge

2021 February Flash Fiction Challenge: Day 26

Write a piece of flash fiction each day of February with the February Flash Fiction Challenge, led by editor Moriah Richard. Each day, receive a prompt, example story, and write your own. Today's prompt is to write about an article of clothing.

Authors Share Tips on Writing Mystery and Thriller Novels That Readers Love

23 Authors Share Tips on Writing Mystery and Thriller Novels That Readers Love

23 authors share tips on writing mystery and thriller novels that readers love, covering topics related to building suspense, inserting humor, crafting incredible villains, and figuring out the time of death.

Jaclyn Goldis: From Personal History to Historical Fiction

Jaclyn Goldis: From Personal History to Historical Fiction

Debut author Jaclyn Goldis explains how her novel When We Were Young was inspired by her real-life grandmothers and how many times she rewrote her first chapter.

Plot Twist Story Prompts: Forced Decision

Plot Twist Story Prompts: Forced Decision

Every good story needs a nice (or not so nice) turn or two to keep it interesting. This week, force a character to make a decision.

Flash Fiction Challenge

2021 February Flash Fiction Challenge: Day 25

Write a piece of flash fiction each day of February with the February Flash Fiction Challenge, led by editor Moriah Richard. Each day, receive a prompt, example story, and write your own. Today's prompt is to write about a cryptid.