Households

[Nsantana]

What would be the best way to create households?

I have a list of customer ids and addresses but the addresses can vary a bit. 

How can I group customers with almost identical addresses into a household?

[Luke_C]

Hi @Nsantana 

Addresses are tricky, can you share an example?

[Nsantana]

Please see attached. The HH column would be the desired output. 

[Luke_C]

So there's probably a bunch of roundabout ways to go about this using text parsing formulas, but I've recently been using the google maps API which is very helpful assuming the addresses data quality is somewhat decent. You'd just have to register for an API key, update it in the text input, and test it. Google credits the first $200 of usage every month which is good for almost 10,000 records. 

[Nsantana]

Unfortunately i can't register for anything like that