A Question For Writers - Keeping Track Of Clients

14 replies
Hi

This is just a question for content writers. How do you keep track of your regular clients, and what they have ordered, delivery times etc?

Do you us a database program, or just a whiteboard on the wall?

My writing business is growing exponentially at the moment, and I'd like to put strategies in place to make sure I keep on top of what needs to be done by when.

Thanks for your suggestions.

Audrey
#clients #keeping #question #track #writers
  • Profile picture of the author smisen
    Personally, I use Google's calendar to keep track of clients. Each client has a color so that I can mark when specific batches are due, and all the writers on my team have their own colors so that I can see who's working on which articles at what time.
    {{ DiscussionBoard.errors[1121755].message }}
  • Profile picture of the author Audrey Harvey
    Thanks for the replies. I'll have a good look at Google calendar. I don't have a team because I stick to the pet niche, and I promote my writing as being written by a vet. I like the idea of different colors for each client though.
    Signature

    Expert content written by an experienced veterinarian and published magazine and newspaper writer.
    Feel free to contact me for details.
    {{ DiscussionBoard.errors[1121793].message }}
    • Profile picture of the author Marya_Miller
      Hi Audrey, I've tried all the recommended systems but honestly, the only thing that has worked for me is to have one of those big desk calendars on a countertop that doesn't get used. Then I write in:

      • Project (e.g. "Autoresponder Sales Letter")
      • Client Name
      I put the entry in the actual due date for the project, then use very transparent, different colored highlighters to block out all the days I think I'll need to finish it.

      Sounds messy and not very detailed, but actually, what it does is keep my schedule crystal-clear in my mind for the whole month. I just need to glance at those colors to know what I'm working on and where I ought to be. (My brain responds well to color coding ;-) )

      My clients always pay up front, but you could add a "Paid?" field to it, if yours don't - and just tick it when they do pay.

      I believe in simplicity! Life is complicated enough, in the 21st century. ;-)
      {{ DiscussionBoard.errors[1121820].message }}
  • Profile picture of the author Craig Fenton
    Hi Audrey:

    Hope all is well and glad your business is growing! Great work.

    In order to prevent learning the hard way (as a professional author/writer/public-speaker) this has happened) please not only organize and save the work once but twice.

    You can set up any system you like such as Microsoft Word/Excel with each client having the information at your fingertips such as name/address/phone/fax/paid and unpaid balances, dates of completed and due assignments, and so on.

    Here is where you want to make sure you never have the information lost forever. Every day back it up by either recording a Data CD and or copy/paste the info into your email account and save as a draft. This way if anything happens to the computer you can always copy/paste the email into a database/Word/Excel File and do the same with the Data CD.

    A Data CD lets you record almost anything on it. Audio/video/files/photos/etc. Best of all the same blank CD's for music are used for Data CD's. Almost every computer these days has recording software that enables you to use the Data feature without spending additional funds. If you don't have the software it is well worth it (normally no more than 30- 50.00 American dollars) for time tested quality releases.

    Keep up the superlative work.
    Signature

    {{ DiscussionBoard.errors[1121840].message }}
  • Profile picture of the author Audrey Harvey
    Marya, thank you. I must admit, I prefer something that's visible on the wall, or at my fingertips.

    Craig, appreciate the reminder :-) Will definitely take your advice.
    Signature

    Expert content written by an experienced veterinarian and published magazine and newspaper writer.
    Feel free to contact me for details.
    {{ DiscussionBoard.errors[1121990].message }}
    • Profile picture of the author Marya_Miller
      Originally Posted by Audrey Harvey View Post

      Marya, thank you. I must admit, I prefer something that's visible on the wall, or at my fingertips.
      LOL! Me too. The moment I close a calendar or spreadsheet on the computer, it doesn't matter how beautifully organized and designed it is - it's "out of sight, out of mind!"
      {{ DiscussionBoard.errors[1127664].message }}
    • Profile picture of the author Craig Fenton
      Hi Audrey:

      I appreciate your thanks and hope the Warriors have given you great advice.

      Have a fantastic weekend!
      Signature

      {{ DiscussionBoard.errors[1128217].message }}
  • Profile picture of the author BigRedNotebook
    I use Google calendar.
    I have 4 B-I-G calendar whiteboards, too.

    I love my whiteboards--both my calendar ones and the blank ones.

    CDB
    {{ DiscussionBoard.errors[1122047].message }}
  • Profile picture of the author Bev Clement
    Spreadsheet with all the relevant data on it. Copies of all emails, and a folder for each client in my documents which are inside a folder for writing projects. Each new projects has a brief written in word, normally a copy of the original email, and then further information as you get it.
    {{ DiscussionBoard.errors[1122817].message }}
  • Profile picture of the author Kevin Regier
    I have been a content writer for a while now and the one thing I use is called Basecamp. The company I work for uses one and then I got my own to keep rack of my own personal projects.
    Project management, collaboration, and task software: Basecamp

    It is the best thing I have seen.
    {{ DiscussionBoard.errors[1122854].message }}
  • Profile picture of the author Mary Gallivan
    Hi Audrey

    I use an excel spreadsheet. The headings include-name, email, WF ID, what's been ordered, when ordered, completion date offered, amount, deposit, final payment, discount, any other info.

    You can also use a year planner for your wall so you have an 'at a glance' record.

    I also keep a folder with all email correspondence.

    Mary
    {{ DiscussionBoard.errors[1122990].message }}

Trending Topics