What happens during the "Data Clean Up" process?
Gazelle is currently the only comprehensive program that is customized for the piano service industry. This means that we can handle a lot of information that other programs struggle to manage. Here is an example of what we do during a data cleanup process.
- Names - simply put we make sure everybody's names are formatted correctly in First, Middle, Last, Company Name configuration. Many programs allow you to format names many different ways and we make sure they will go into Gazelle in the right order. Additionally, we scrub the name fields for "Company" names so that Churches, Schools, and Businesses are properly categorized.
- Addresses: - We verify every address we import with Google. If you have partial addresses 99% of the time Google can find the full address and fill in the missing parts. Many times this is simple, like the case of a missing zip code, but it can also be more complex like 123 Waterbury Street, ???, ??, ????? where we are able to verify that there is only one "123 Waterbury Street" in your service area and filling the missing city, state, and zip. We can also correct for common misspellings and abbreviations.
- Phone Numbers - Phone numbers in Gazelle are validated according to the standards in your country. In the US, we require the (xxx) xxx-xxxx formatting. If your phone numbers are missing the area code or are not formatted properly (xxxxxxx, xxx-xxx-xxxx, xxx xx xxxx, etc...) we can detect this and replace it with the correct formatting. We do the same with whatever standards are common in your country.
- Email Addresses - Email addresses are some of the easiest to detect and format. If you commonly put the email address in any field other than a verified "Email Address" field, we will be able to detect this and pull all your email addresses out of the dataset and assign them to the proper person.
- Piano Information - This is where we shine the most. Most programs don't have a good method for sorting all your piano information. This means that you likely have it scattered all throughout your program. In this case we can search your database for hundreds of common piano makes and models and pull the data together to make a single piano file for your client.
- Last Tuning Date - Like piano information tracking a "Last Tuning Date" is not always easy coming from other programs. Most of the time we can pull all of your past service dates out of a notes field and determine which one should be the "Last Tuning Date"
- Service History Notes - We pull all your old service history notes from whatever program you are using and merge them into Gazelle and match them to the proper piano record.
- Invoices - If you have past invoices that you want imported we can match these to client records via identifying information like street address, phone numbers, email addresses, names, piano serial numbers, and several other fields.
- Misc Information - During every import process any misc information is identified and assigned a meaningful spot in Gazelle. We work really hard to ensure that no data gets dropped into a black hole.
Why do you care so much about data?
Gazelle's mission is to simplify your life. And let's be honest, unless you have an IT Database Managment degree, there is nothing simple about migrating to a new system. We know Gazelle inside and out and our support staff are just a little OCD about making sure that your "Post-Import" data in Gazelle is better than the data we used for your import. It is just our way of saying "Thank You" for entrusting us with your business. We promise to help you at every step of the way.