Query Tracking



I'm a spreadsheet nerd. I love using spreadsheets to keep information organized! Too bad I can't "spreadsheet" the junk in my house, haha! One of the spreadsheets I use all the time is my query tracking spreadsheet. It lists all the agents I could possibly query and then has columns for what manuscripts I send them, when I sent it, and any responses I've received.

After seeing others frustrated with trying to create their own spreadsheet, I went searching for templates. One template I found which is really nice is from the Sub It Club blog. There is other information about tracking your queries in the post. Check it out: SubItClub.com

Another option to track your queries is using Query Tracker. They have a limited free tracker available, or an upgraded version for a fee. I love that you can see an agent's average response time. But beware, not every agent is listed in their database. Check it out: www.querytracker.net

I also created my own spreadsheet template, which I'm making availble to you here! It is arranged differently than the one from Sub It Club. It is organized by agent and gives multiple places to enter different manuscripts subbed to that agent. It tells the query age and also color-codes based on the query status. I hope you find it helpful. Leave a comment with any suggestions on how to make it better! Check it out: QueryTrackingTemplate
*This link takes you to a view-only Google sheet but you can download a copy for your own use.



*Enter a date in "Date Queried" and the row will turn yellow.
*Enter a date in "Rejection Received" and the row will turn red.
*Enter a date in "Request Received" and the row will turn green.
*The "Query Age" column will automatically calculate the days since "Date Queried" or since "Request Received"
*To close a query that has had no response after a period of time, you can enter the text "No Response" (or any text) in the "Rejection Received" column and the row will turn red. The "Query Age" cell will show an error if you enter anything other than a date.
*If you "sort" the rows, the colors will move with the data.
*You can add columns if you want to track more info for each agent and the color coding and formulas should not be affected.
*Newly added: There is a drop-down menu to record the query type, or you can enter text into the box.


Comments

Popular posts from this blog

Be Brave

The Scrumptious Tale of an Allergic Kid