Keeping Track of Your Freelance Writing Queries

When doing freelance writing work or when submitting your written work to various publications, it becomes very easy to lose track of what was sent where and to whom. Here is an easy way to keep track of all those queries by using Microsoft Excel or a similar spreadsheet.

OPEN YOUR SPREADSHEET and give it a title. I title mine Queries.

CREATE DIFFERENT FOLDERS for different kinds of queries. I use five separate folders titled Contests, Freelance, Magazine, Online and Other. Creating separate folders simply makes tracking your queries that much easier.

DECIDE WHAT IMPORTANT INFORMATION YOU NEED TO KEEP TRACK OF in your Query spreadsheet. I track the following details of a query: Name of publication, Contact information, Type of query (email, phone, or snail mail), date query was sent and Other. The Other column is for any other pertinent information.

TRACK ANSWERS YOU RECEIVE to your queries by highlighting in different colors. For example, you can use yellow for queries that have been sent but have not been answered and green for queries that have been answered and given the green light. You get the idea.

ADD A COLUMN FOR NOTES. This column becomes very useful when talking to an editor on the phone or through email because you can refer back to the dates and times you have spoken with the editor before.

KEEP COPIES OF YOUR QUERY SPREADSHEET so that you can double-check to see if you have submitted to a certain venue before and what their answer was.

UPDATE YOUR SPREADSHEET on at least a weekly basis.

BACK IT UP! Don’t forget to back up your work frequently!

TRACK IT ONLINE. Use an online query tracker like Duotrope to track submissions or try this online Writer’s Tracking Tool.

Want to learn more? Order the Freelance Writer’s Toolkit!

About Karen Y. Hamilton

Karen leads workshops in Creative Writing, Poetry and Journal Therapy, and Memoir Writing. She has studied genealogy and personal histories since 1987, lecturing and leading workshops on Memoir Writing and Journaling to the community since 1998. Karen holds a BA in English and has studied Literature, Business, and Education at the graduate level. She is a former college instructor of English Composition and Reading. In the past, Karen has worked as a high school & middle school teacher. She currently works as a Curriculum Specialist and is an MFA Creative Writing student at Florida Atlantic University.
This entry was posted in Freelancing and tagged , , , , , , , , , , , , , , . Bookmark the permalink.

One Response to Keeping Track of Your Freelance Writing Queries

  1. anu says:

    GetaElance.com has neat and clean layout. All features are listed clearly. I was using this website and really felling good. I just created my account there.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s