continued from Converting Cards to Cash (part 1 of 3)
Step 2 – Where to store the data and in what format
This stumbling block seems to be a key barrier for that pile of business cards. To make it worse everyone has their opinion on what the best database program is and what format it should take. For the purpose of this blog I will stick to the fundamentals of what a good database should include.
Format
It is important that whatever database you choose that you have the ability to export the information into a format that is standards based, like a .csv file (comma separated value). The reason for this is that most Database Software will recognize this file format and you can migrate the information with ease.
Also you want the ability to sort and query your database. This is simply a way for you to get information from your database that you can segment and draw conclusions from – like who are the 20% of my customers that make up 80% of my revenues.
Information
Your business is unique and your customer database should reflect that. Being able to customize the information you collect is a must. This varies dramatically, but there are several frequently used types of business information:
- Contact details
- Customer preferences
- Communications history
- Sales history
- Actions
- Payments
Then there is specific customer information. For example, family information (spouse, children, pets…), birthdays, anniversaries, hobbies and interests are all key information for developing a relationship with your customers.
Ownership
If your customers are the heart of your business than their information is the soul. Keeping it secure is important. Retaining ownership of your database will ensure your customer information is safe. Ownership means you have exclusive password protected access to your database and can export the information at your convenience. This goes for both hosted database solutions (Software as a Service) and resident database solutions (saved on your hard drive or network).
Step 3 – Getting access to the data
To be continued…
How many separate databases does your business have??? (e.g. one for your accounting system, an excel spreadsheet for sales, one in a marketing tool like a newsletter/e-blast program, one on your phone…) Am I forgetting any?





