Here is a great tip for enhancing your marketing database to make it more workable and accessible for you; and to help add more value to your customers.
The tip? CATEGORISE!!!! Well that's what it is called in Outlook. It's Groups in Gmail and Mac Mail. I'll explain these in a moment. But first - what if you're using Excel?
In Excel, thou shalt not sheet. In other words, don't have a different column; or a different worksheet for your variables. By this I mean different sheets for your business by region. Or in one workbook- having one column for customers, a column for prospects, a column for old clients and a column for suppliers.
The right way to do it in Excel is to have one column allocated and called Customer Type (for example). All the different variables are then used within that one column such as customer, old customer, prospect, supplier. What if one person fits several categories? No problem, write them in and separate by a comma.
When you need to see or communicate with a specific type - for example you want to see all the prospects listed, you simply filter the entire list looking for the word prospect and you'll get all your prospects including those that have several categories assigned to them.