Database creation and using it

Every single day we all deal with people and businesses. Imagine having all the details of those people you come across everyday stored in one central database? Imagine being able to sort that database into areas, types of businesses, suppliers and past clients and being able to generate marketing campaigns to target those specific groups.

If you don’t gather together the following:

1. An invoice from each supplier
2. Invoices to all past customers
3. All business cards you have hanging around
4. Your address book
5. Your email address book
6. Yellow pages/directories of potential desired clients (choose industries and upload info into Excel then sort into cells)

Open an Excel spreadsheet (most database programs allow you to import Excel documents as CSV files when you are ready).

Type in the information you need to store in this order

1. Name
2. Title (director/manager)
3. Company Name
4. Address number and street
5. Suburb
6. Post Code
7. Tel
8. Fax
9. Mobile
10. Email
11. Website
12. How you know them (have a set list of these so you can sort by it later)
13. Birth date or Specific date you want to remember relating to that contact

You can add in columns if you have extra details about the client.

Save the file as an xls. and as a csv. Both are useful later on.

Once you have your database – you can start to use it to do mail outs, email campaigns, telephone campaigns etc. You can also use it to see where your customers live, which will tell you where you should advertise (locality wise).

There are companies who can help you to do this from start to finish. Garnish Marketing offers this service – simply fill in our form and we will provide you with a quote to create your customised database.