Skip to main content

How do I have Salesforce lead fields autopopulate based in Landing Page?

 

I have successfully capture pass the Landing Page URL into salesforce, but I have hard time with source medium auto appended, etc. 

 

I must get 'Land Page (url)' to auto parse queries into Source Medium Campaign AdSet/AdGroup Keyword Term  Match Type and Device Type:

a.  IF URI {key}={value} value pair is detected AND

b. IF Salesforce {key_field} is {blank-value}

 

1. Salesforce captures the following lead information from website

 

Name (First Name, Last Name)

Phone (555-555-1234)

Email (email@email.com)

Qualifier Question 1: (Yes, No)

Qualifier Question 2: (10,30,50,100,200,500+)

 

Hidden Form Fields

GCLID (AdWords click) - {1234567890ABCDEFabcdef123456Ch0WoASyEAAYAiAAEgJG1fD_BwE}

Landing Page URI (https://www.website.com/lp-path/get-started?matchtype=e&device=c&term=%2Bawesome%20%2Blong%20%2Btail%20%2Bkeyword&gclid=1234567890ABCDEFabcdef123456Ch0WoASyEAAYAiAAEgJG1fD_BwE

 

2. I must strip the following from url and AUTO input into salesforce field:

Match Type = {e=exact,p=phrase,b=broad}

Device Type = {c=desktop,t=tablet,m=mobile}

Term = Term

Keyword = Keyword

Campaign = Campaign

{misc peram} = {misc value}

 

3. Logic

a. if LANDING PAGE contains ((?|&)utm_source={value}) AND SOURCE={blank} then replace SOURCE with return {value} to salesforce field SOURCE

b. if LANDING PAGE contains ((?|&)utm_medium={value}) AND MEDIUM={blank} then replace MEDIUM with return {value} to salesforce field MEDIUM

c. if LANDING PAGE contains ((?|&)device={value}) AND DEVICE={blank} then replace DEVICE with return {value} to salesforce field DEVICE

...etc

 

Workaround solution,

I can create additional <input type="hidden"> fields on the capture form and it will pass desired values, however is a LAST RESORT solution because web dev is already busy on cue, I must find a way to do it within SalesForce. I also export leads, edit excel and reupload lead UPDATE LEADS as upload file. This also is a LAST RESORT solution.

 

OR

 

Does anyone know how to autostrip URI query perams inside of zapier and then inject the uri strip into salesforce from Zapier?

 

OR

 

Can someone send me super easy to follow api/rest/code documentation specific to Strip URI into Salesforce fields that I can pass my developer that would take him less than 10 minutes to implement after I draft the code?

 

Thank you!

0/9000