Skip to main content

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.

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

Steven Hartov: On Shocking Truths in Historical Fiction

Steven Hartov: On Shocking Truths in Historical Fiction

New York Times bestselling author Steven Hartov discusses the surprising truths he discovered when writing his new historical fiction novel, The Last of the Seven.

Larry Beinhart: On Rejection Leading to Mystery

Larry Beinhart: On Rejection Leading to Mystery

Award-winning author Larry Beinhart discusses what he learned in the process of writing his new mystery novel, The Deal Goes Down.

writer's digest wd presents

WD Presents: A Competition Announcement, 6 WDU Courses, and More!

This week, we're excited to announce our self-published e-book awards, 6 WDU courses, and more!

Leah Franqui: On Killing Our Critical Inner Voices

Leah Franqui: On Killing Our Critical Inner Voices

Award-winning playwright and author Leah Franqui discusses how she examined her life through a fictive lens with her new novel, After the Hurricane.

Pacing Your Fight Scene (FightWrite™)

Pacing Your Fight Scene (FightWrite™)

Trained fighter and author Carla Hoch discusses how to pace your story's fight scene and shares three examples from writers who tackle pacing differently.

Writing Mistakes Writers Make: Rushing the Drafting Process

Writing Mistakes Writers Make: Rushing the Drafting Process

The Writer's Digest team has witnessed many writing mistakes over the years, so this series helps identify them for other writers (along with correction strategies). This week's mistake is rushing the drafting process.

Kwana Jackson: On Finding the Right Home for Your Story

Kwana Jackson: On Finding the Right Home for Your Story

USA Today bestselling author Kwana Jackson discusses writing her new romance novel, Knot Again.

Jaden Terrell Killer Writers Post 2

A Conversation With Jaden Terrell on Writer Expectations, Part 2 (Killer Writers)

Killer Nashville founder Clay Stafford continues his conversation with novelist Jaden Terrell about writer expectations and success.

Plot Twist Story Prompts: Antagonist Reappears

Plot Twist Story Prompts: Antagonist Reappears

Every good story needs a nice (or not so nice) turn or two to keep it interesting. This week, have an antagonist reappear.