Pull Domain Out of Email Address

Jay_Jiang
Level 10

Re: Pull Domain Out of Email Address

It doesn't look like you can write/change the field "Website". You'll need to create a custom field e.g. Domain

SanfordWhiteman
Level 10 - Community Moderator

Re: Pull Domain Out of Email Address

You certainly can change Website via a webhook. It's a standard data enrichment target.

Make sure it's not set to block field updates from webhooks.

Note Website is a Company field, not a Person/Lead field, so the standard expectations apply.

Jerry_Cooper1
Level 2

Re: Pull Domain Out of Email Address

Domain worked perfectly. The formatter is a great help for us. Thank you all.

Jerry Cooper
SanfordWhiteman
Level 10 - Community Moderator

Re: Pull Domain Out of Email Address

You didn't need to create a new field for this, though I suppose it's harmless if you did already.

Jerry_Cooper1
Level 2

Re: Pull Domain Out of Email Address

Was there one of these PHP's suggested  to format phone numbers?

Jerry Cooper
SanfordWhiteman
Level 10 - Community Moderator

Re: Pull Domain Out of Email Address

Use Twilio's Lookup API Validation and Formatting endpoint for that. Follow the same directions as in Calling the Twilio Lookup API as a Marketo webhook.

Or you can embed Google's libphonenumber SDK in any supported language.

Jay_Jiang
Level 10

Re: Pull Domain Out of Email Address

I've personally written one for Australian phone numbers but not sure if that's any use to you. Global numbers are too hard to manage so paying for service might the way to go if you handle data from various countries. The logic and code is a lot more full on for a phone number formatter than separating domains though...

SanfordWhiteman
Level 10 - Community Moderator

Re: Pull Domain Out of Email Address

The logic and code is a lot more full on for a phone number formatter than separating domains though...

Yep, that's why there's a whole library for it (Twilio themselves uses libphonenumber, since they didn't feel like they could do better in-house).