Populate State by Phone Area Code

[Anonymous]

We have some cases were leads are in our database and we are given phone #s but aren't asking for states. However, our leads get assigned out by territory. So I'd like to make a rule - if state is blank and area code is ..., state = ...

Has anyone done this before? I'm curious if there's already lists of area codes out there in the community for this and also how to deal with data standardization (ie. 904. or (904) or 904-).

Thanks!

PS I found this thread but was curious if there was any more discussion around this (http://community.marketo.com/MarketoDiscussionDetail?id=90650000000PbPqAAK)

[Anonymous · Accepted solution]

A webhook would be the simplest method, taking the area code and reading the response to populate state.

http://www.allareacodes.com/api/

[Anonymous]

Thanks for the reply. I'll have to start looking into webhooks more 🙂