How to get the domain name from Recipient table email address column?

My target dimension is Recipient table and the filtering dimension I am using a custom schema.

I am trying to get the domain name from the custom schema which is linked with recipient schema as below in adding additional data > Output columns

Substring(@email,'@',-1)

Substring([recipient/@email],'@',-1)

However, I am getting an error. Please suggest

Thank you in advance.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by ParthaSarathy

Hi @rvnth ,

You can use GetEmailDomain() function in Query / enrichment expression to get the domain of email, and use it to map.

Example, GetEmailDomain([@email])

And also, in nms:recipient schema you can find OOTB attribute called email domain which will be using the same expression.

rvnthAuthor

Level 5

I found this. Please correct me if I am wrong.

I am targeting only gmail here.

Right(@email,9 )

Accepted solution

Community Advisor

You can use GetEmailDomain() function in Query / enrichment expression to get the domain of email, and use it to map.

Example, GetEmailDomain([@email])

And also, in nms:recipient schema you can find OOTB attribute called email domain which will be using the same expression.

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups

Sign up