Expand my Community achievements bar.

Join us for Adobe Campaign Community Q&A Coffee Break on Thursday, March 7th at 8am PT with Eric Perrin, Gael Mouello, Chakravarthy Kalva, Bruce Swann and Sandra Hausmann.
SOLVED

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

Avatar

Level 4

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 4

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.