Let’s face it your customer database isn’t clean !

In all our years of working with simPRO users we’ve noticed them all. There’s just way too many to list here but I’ll try to make a list, think of what ticks off for you.:

You could have

  • duplicates,duplicates,duplicates,
  • misspelligns
  • wrong email addresses @gamil.com
  • Incorrect CaPItalisATIONS
  • incor rect Spaci n g s
  • Not having the full address (34, Sydney
  • Suburb not entered in the Suburb field
  • Entire Address entered in the street address area
  • Post Code missing
  • Phone number not entered in correct place
  • Phone / mobile not entered in the correct format (Critical for SMS and other phone / Voip services)
  • Mobile entered as phone number and viceversa
  • Two emails entered in the single email address column (John@gmail.com, Lisa@gmail.com)
  • Customer Profile not entered / Not segmented
  • Customer Group not entered / Not segmented
  • And heaps more like this For example companies named differently School, Limited, Ltd etc.

Is this is something that gives you jitters every time you want to run a marketing campaign or send a mass mail out to customers ? Imagine that you have some jobs coming up in a certain area of town and you want to pitch your customers in that area of town to get more work well having a clean database can help with that.

What about an announcement or a special promotion that you want to announce.

Let’s look at a little known export / import feature in simPRO and how you can use it to clean up your simPRO database in the all powerful MS Excel !

To do the same individually in simPRO would take days if not weeks.

So instead of spending hours before every big marketing push here’s how you can clean up your database efficiently in a matter of minutes and hours not days and weeks.

Step 1) Export the simPRO customer list to EXCEL

So instead of spending hours before every big marketing push here’s how you can clean up your database efficiently in a matter of minutes and hours not days and weeks.

Step 2) Edit the list in Excel like a super ninja !

Cleanup the list like shown in this video: Become an excel super ninja !

Step 2) Upload this cleaned up csv file back into simPRO !

You have done a great job, Give yourself a pat on your back and grab that double cream frappuchino or Gin and Tonic, whatever’s your poison ! You deserve it after all this hard work.

If you need help doing this or have special requirements reach out to us, we can do this and lots of other API black magic with simPRO  🙂

Related Posts

ZOHO One Suite

ZOHO ONE As ZOHO Partners and as an Australian ZOHOLics run business, we love the convenience of having a suite of 40 + very well integrated fully functional apps. We will be giving you a window into our business and doing a deep dive into how we at...

ZOHO CRM Plus : A full Customer engagement solution

Here's a clearer picture update on everything that the ZOHO CRM Plus account gives you. It's a single subscription that gives you access to ZOHO CRM, plus 8 additional business apps. ZOHO Calls it the Customer Engagement Suite. It is the one power tool...

Introducing 30 Minute rounding in simPRO

30 Minute customizable Rounding in simPRO. This setting now available for all customers in SyncEzy allows you to bill your clients in 30 minute blocks in simPRO while maintaining per minute tracking in TSheets. When the time goes in to simPRO you have the...

Let us Automate your business!

Fill in the details below and we'll get back to you in 24 hrs.