Skip to main content
I am wondering how to do a Vlookup type of function in SalesForce that will clean up data.

 

Example:  Sometimes our Marketing department mistypes a UTM code in their online ads. 

 

UTM = Adwords

 

UTM = Adwordss

 

UTM = Google Ads

 

I would like to create a lookup that translates the multiple names into one.

 

Adwords = Adwords

 

Adwordss = Adwords

 

Google Ads = Adwords

 

Is this possible in SalesForce?
7 respuestas
  1. 21 jun 2013, 14:20
    Thanks for the quick response Bill.  Unfortunately the UTM data is passed through the URL on the Web to Lead page.  The Marketing department enters the UTM in Google Adwords, Facebook Campaigns, and Yahoo/Bing.

     

    There is no way for me to validate the data prior to being entered into SalesForce.

     

    Any other suggestions?
0/9000