Publish date:

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

NaNoWriMo: Making the Most of Community

NaNoWriMo: Making the Most of Community

Books, much like children, sometimes take a village. Let managing editor and fellow WriMo participant Moriah Richard give you tips for engaging with your online and in-person NaNoWriMo community.

From Script

Film and TV Show Reviews and Writing What You Know (From Script)

In this week’s round up brought to us by Script magazine, Script contributor Tom Stempel reviews the latest in film and television show releases, an exclusive interview with Lamb screenwriter Sjón, and much more!

Why We Should Read Middle Grade Fiction as Adults

Why We Should Read Middle Grade Fiction as Adults

Young Adult fiction has surpassed its own demographic by being acceptable to read at any age. Why have we left middle grade fiction out of that equation? Here’s why we should be reading middle grade fiction as adults and as writers.

What Are the 6 Different Types of Editing?

What Are the 6 Different Types of Editing?

When you reach the editing phase of your manuscript, it's important to know what kind of editing you're looking for in particular. Author Tiffany Yates breaks down the 6 different types of editing.

WD Poetic Form Challenge

WD Poetic Form Challenge: Imayo Winner

Learn the winner and Top 10 list for the Writer’s Digest Poetic Form Challenge for the imayo.

Writer's Digest 90th Annual Competition Print or Online Article First Place Winner: "Surfacing an Aquatic Diaspora"

Writer's Digest 90th Annual Competition Print or Online Article First Place Winner: "Surfacing an Aquatic Diaspora"

Congratulations to Elaine Howley, first place winner in the Print or Online Article category of the 90th Annual Writer's Digest Writing Competition. Here's her winning article, "Surfacing an Aquatic Diaspora."

Writer's Digest 90th Annual Competition Script (Stage Play or TV/Movie) First Place Winner: "Jaguar Woman"

Writer's Digest 90th Annual Competition Script (Stage Play or TV/Movie) First Place Winner: "Jaguar Woman"

Congratulations to Olga El, first place winner in the Script (Stage Play or TV/Movie) category of the 90th Annual Writer's Digest Writing Competition. Here's her winning TV Pilot script, "Jaguar Woman."

Writer's Digest 90th Annual Competition Non-Rhyming Poetry First Place Winner: "won't you celebrate with me"

Writer's Digest 90th Annual Competition Non-Rhyming Poetry First Place Winner: "won't you celebrate with me"

Congratulations to Nicole Adabunu, first place winner in the Non-Rhyming Poetry category of the 90th Annual Writer's Digest Writing Competition. Here's her winning poem, "won't you celebrate with me."

Writer's Digest 90th Annual Competition Rhyming Poetry First Place Winner: "She Lives in Underbridge World"

Writer's Digest 90th Annual Competition Rhyming Poetry First Place Winner: "She Lives in Underbridge World"

Congratulations to MF Slattery, first place winner in the Rhyming Poetry category of the 90th Annual Writer's Digest Writing Competition. Here's the winning poem, "She Lives in Underbridge World"