TransWikia.com

Convert User ID to Name with AMPScript

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

One Answer

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

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP