I'm a freelance artist who markets my work to editors and art buyers at a large variety of organizations through various means. In the past I had a scattershot approach to all these things and loosely tried tracking who I talked to when through making notes in my Address Book or spreadsheets.
I'm trying to get more organized about this and that approach is not working. Ideally I'm looking for some kind of solution that will let me:
-keep my client info in one central place
-let me sort/refine that info and export to other places (Mailchimp for email newsletters, my label printer for addressing postcards)
-track all of my contact with every individual at each organization
-let me search by useful information or keep running Smart List type queries ("which editors in the SF area have I not had any contact with in the last 30 days?" or "who in New York responded to my last email promo?" etc.)
A few years ago I interned at an agency that did this using an unwieldy custom Filemaker Pro database that they had hired someone to make. Surely there are more elegant solutions than that? I was looking at HighRise
but was wondering how other people solve this problem.