Solved

Data Cleaning for Name and address formatting

  • 2 May 2023
  • 3 replies
  • 79 views

Does anyone gave a good suggestion for data cleaning in customer.io.  I know services like kickbox will work for emails.  I am looking to correct name and physical address formatting.

icon

Best answer by Elena 3 May 2023, 16:31

View original

3 replies

Badge

Hey there!

Thank you for your question. We’ll be happy to explore options here.

Could you please share examples of the name and physical address name you have now and what you want them to be? It’s be super useful!

 

Thanks!

John doe = John Doe

john doe = John Doe

JOHN DOE = John Doe

 

Badge

Thank you for sharing the examples!

It’s possible to format your attribute values with liguid tags Capitalize or Titlecase.

I’m sharing our documentation:

 

You’d want to create a campaign that is triggered by a segment that contains all this attributes your want to format, and have a sing Create or Update Person action, where you’ll use the liquid tags:

I hope it helps!

 

You can also check our blog posts about liquid:

 

Reply