Salesforce Asked by Greg Noble on February 22, 2021
I am trying to populate the name of the contact owner (‘referred to as the retention owner in our organization) in an email subject line in Marketing Cloud using AMP Script.
Based on the code below, I am able to bring over the ID but am wanting to convert the ID to the individual’s name. Below is what I have so far.
%%[
VAR @retentionOwner
SET @retentionOwner = AttributeValue("Retention_Owner__c")
]%%
%%=v(@retentionOwner)=%%
May I have advice and guidance on what I am missing?
Thanks
You need to lookup the name in the synchronised data extension with all the users:
%%[
VAR @retentionOwner
SET @retentionOwner = AttributeValue("Retention_Owner__c")
SET @ownerName = Lookup(User_Salesforce,”Name”,”Id”, @retentionOwner)
]%%
%%=v(@ownerName)=%%
If you are working in a child business unit, you must reference the data extension with ENT in front: ENT. User_Salesforce
Correct answer by Lukas Lunow on February 22, 2021
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP