Expand my Community achievements bar.

Adobe Campaign User Groups are live now. Join our Adobe Campaign User Groups and connect with your local leaders!
SOLVED

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

Avatar

Level 5

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.

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.

View solution in original post

2 Replies

Avatar

Level 5

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

 

I am targeting only gmail here.

 

Right(@email,9 )

 

 

Avatar

Correct answer by
Community Advisor

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.