9 Replies Latest reply on Oct 8, 2018 9:30 PM by Brian Law

    how to sync lookup field to Marketo?

    Teresa Hsu

      I want to create a lookup field in Lead object in SFDC.  The field will pull campaign name to the lead.

      I've read some articles in the community and understood that I need to create a formula field, but not sure what the formula should be for the campaign name?  any idea?

       

      Thanks!

      Teresa

        • Re: how to sync lookup field to Marketo?
          Grégoire Michel

          Hi Teresa,

           

          Yes, the formula should bring back the campaign name. The lookup field it self will carry the campaign SFDC ID, although on SFDC user interface it displays the name.

           

          -Greg

          • Re: how to sync lookup field to Marketo?
            Robert Solis

            Hi Teresa,

             

            Just a side comment, when it comes to Salesforce Formula and Lookup fields, the values displayed in these types of fields will not automatically sync down to Marketo when the displayed value changes.  The reason for this is due to the fact these two types of fields do not update the Salesforce systemmodstamp field on a record when the displayed value changes.  Marketo's integration relies on the timestamp for the systemmodstamp to change in order for it to review a record to see what values have changed.  The fields can still be synced with Marketo and utilized but understand that their value changes will not sync down until some other field on the record is updated, resulting in the systemmodstamp also updating.

            1 of 1 people found this helpful
            • Re: how to sync lookup field to Marketo?
              Veronica Holmes

              Teresa - Since a Lead can be associated to multiple campaigns what exactly does the formula need to do? Original campaign source? Most recent campaign? What are you looking to accomplish exactly?

                • Re: how to sync lookup field to Marketo?
                  Teresa Hsu

                  To make it more clear -- I want to be able to capture the latest and most relevant Campaign before we can set up a meeting with a lead.

                  Meeting Set is one of our Lead Status.  Inside Sales are calling down the campaign list and setting up meetings.  However, we don't have visibility as to which campaign actually converts lead to meeting.

                   

                  What I'm doing now is to capture the latest "Most Recent Campaign" as the meeting source campaign.  I'm able to capture the "text" of the campaign name.  However, I want to be able to click on the campaign name and go to the campaign itself in SFDC.  Eventually, I'm building a related list in Campaign object to show how many meetings we were able to get thru this specific campaign.

                  I'm stuck with making the Campaign name in SFDC Lead Object linkable. 

                   

                  I've created a text field in SFDC to show SFDC Campaign ID.  However, I'm not sure if there's a token in Marketo to populate the SFDC Campaign ID?

                    • Re: how to sync lookup field to Marketo?
                      Veronica Holmes

                      Hi Teresa - if what you are looking for is literally to stamp a lookup field (hence give you a link and a related list) then you don't need a bunch of Marketo experts here, you need a Salesforce expert! Fortunately I have 10 of them working in my office .

                       

                      What you would need here is an apex trigger that takes the last campaign value assigned to the lead and stamps it to that lookup field whenever they are added to a new campaign. You could also do this with Salesforce process builder, but I have it on good advice that this would start hitting Salesforce limits if you have a lot of campaigns that people are being added to, so the trigger would be the best way to go and much more reliable.