topic Re: Story time -- Data Standardization in DemandTools

Story time -- Data Standardization

Anonymous — Wed, 01 Feb 2023 13:35:15 GMT

What's the weirdest data standardization problem you had to solve with DemandTools, and how did you do it? I am sure that there are some good ones out there....do share.....this is a judgement free zone!

Re: Story time -- Data Standardization

SummerinGreece — Wed, 01 Feb 2023 13:58:10 GMT

@Anonymous where do I begin... not the weirdest but definitely one of the most complex one is Phone Numbers, it is a global economy and strandardizing phone numbers across regions & countries is a bit of a headache.

Re: Story time -- Data Standardization

Ashley_Validity — Thu, 02 Feb 2023 14:48:44 GMT

@SummerinGreece Yes, phone numbers are always a headache. 😑 I have used the Modify module in DemandTools in the past to add country codes and format numbers in desired formats for different regions. It was beast to set up, but the upkeep after that wasn't bad. Do you have any tips and tricks as to what you've done to standardize phone numbers?

Re: Story time -- Data Standardization

Ashley_Validity — Thu, 02 Feb 2023 14:51:41 GMT

My favorite data clean up jobs were always trying to find and replace the weird values people would put in the first name field as a place holder. Hi Mr. "Don't Know Yet" hoping you are loving our product. 😬 It was always a fun game of trick the system trying to query the different values in either Modify or Tune to track down the culprits.