SOLVED

How do I map a custom SF field to a Marketo token?

Go to solution
JohnnyVillarini
Level 2

How do I map a custom SF field to a Marketo token?

This is completely new to me but I am searching in Admin - Field Management - Field Management for a new field created in SF that my team is looking to connect with a Marketo token.

When I go to create a new custom field in Marketo, it says that it is already created, but will not show up on the right side when I search for it.

Am I looking in the right place? And if so, why is it not showing?

2 ACCEPTED SOLUTIONS

Accepted Solutions
Katja_Keesom
Level 10 - Community Advisor + Adobe Champion

Re: How do I map a custom SF field to a Marketo token?

Hi Johnny,

 

You had me confused a little with connecting an SF field to a Marketo token. The field actually gets setup in Marketo, so the field maps to the field and of course any lead / company field in Marketo can be used as a token.

That being said, there's a few things to know:

  1. If you want a field in Marketo that's synced with SF, you should NEVER create it in Marketo. The trick is to create it in SFDC and then sync it to Marketo. If you create a field manually in Marketo it will never sync with SFDC.
  2. If you are sure the field has been set up to sync (which by the sound of it is the case, as Marketo tells you the field already exists) you need to be aware that there are several tabs it may have ended up in. Make sure to check the SFDC Lead Fields and SFDC Custom Fields for it.
  3. Still no luck? If the field exists inside a custom object, it will not show as a separate field. Check with your SFDC admin whether this is the case and if so, in which custom object it is set up. These objects are treated quite differently in Marketo. You access them in a  smart list as "Has <custom object name>" and then with constraints you can add criteria for your specific field within the object. If this is the set up you have, it is important to know that you cannot use these fields directly as a token.

I hope this helps in your search.

View solution in original post

SanfordWhiteman
Level 10 - Community Moderator

Re: How do I map a custom SF field to a Marketo token?


Since the token is not populating the URL into our emails, do I have to create a specific smart list for it to work?
 

A {{lead.token}} or {{company.token}} can be used regardless of how the person qualifies to get an email. Smart Lists are totally independent.

 

It would be good if you'd find the Insert Photos link here on the Nation (maybe you're working from a mobile device and can't see it?) and attach your screenshots, because the situation isn't clear without them.

2021-01-22 16_48_12-Reply to Message - Marketing Nation — Mozilla Firefox.png

 

Also note something else about URLs in tokens: if you have a full URL including the protocol (http:// or https://)  in a {{lead.token}}, then the link will not be tracked (though it will still open in the browser). Proper Marketo practice is to include only the hostname + pathname + querystring + hash, then use this structure in your email:

<a href="https://{{lead.someTokenWithAPartialURL}}">

View solution in original post

9 REPLIES 9
Katja_Keesom
Level 10 - Community Advisor + Adobe Champion

Re: How do I map a custom SF field to a Marketo token?

Hi Johnny,

 

You had me confused a little with connecting an SF field to a Marketo token. The field actually gets setup in Marketo, so the field maps to the field and of course any lead / company field in Marketo can be used as a token.

That being said, there's a few things to know:

  1. If you want a field in Marketo that's synced with SF, you should NEVER create it in Marketo. The trick is to create it in SFDC and then sync it to Marketo. If you create a field manually in Marketo it will never sync with SFDC.
  2. If you are sure the field has been set up to sync (which by the sound of it is the case, as Marketo tells you the field already exists) you need to be aware that there are several tabs it may have ended up in. Make sure to check the SFDC Lead Fields and SFDC Custom Fields for it.
  3. Still no luck? If the field exists inside a custom object, it will not show as a separate field. Check with your SFDC admin whether this is the case and if so, in which custom object it is set up. These objects are treated quite differently in Marketo. You access them in a  smart list as "Has <custom object name>" and then with constraints you can add criteria for your specific field within the object. If this is the set up you have, it is important to know that you cannot use these fields directly as a token.

I hope this helps in your search.

JohnnyVillarini
Level 2

Re: How do I map a custom SF field to a Marketo token?

Hi Katja,

Sorry for the confusion! I was able to speak with our SFDC Admin and the token is now showing. The only problem now is that the URL in the SF field that is supposed to show within the token is not populating when I test it. I have a screenshot of the field created below:

 

Update: My apologies for some reason it is not allowing me to add in a screenshot, but our SFDC Admin was able to create the new field and now I can see it in the Field Management section. Since the token is not populating the URL into our emails, do I have to create a specific smart list for it to work?

 
SanfordWhiteman
Level 10 - Community Moderator

Re: How do I map a custom SF field to a Marketo token?


Since the token is not populating the URL into our emails, do I have to create a specific smart list for it to work?
 

A {{lead.token}} or {{company.token}} can be used regardless of how the person qualifies to get an email. Smart Lists are totally independent.

 

It would be good if you'd find the Insert Photos link here on the Nation (maybe you're working from a mobile device and can't see it?) and attach your screenshots, because the situation isn't clear without them.

2021-01-22 16_48_12-Reply to Message - Marketing Nation — Mozilla Firefox.png

 

Also note something else about URLs in tokens: if you have a full URL including the protocol (http:// or https://)  in a {{lead.token}}, then the link will not be tracked (though it will still open in the browser). Proper Marketo practice is to include only the hostname + pathname + querystring + hash, then use this structure in your email:

<a href="https://{{lead.someTokenWithAPartialURL}}">
JohnnyVillarini
Level 2

Re: How do I map a custom SF field to a Marketo token?

sfdc-calendly-link.png

SanfordWhiteman
Level 10 - Community Moderator

Re: How do I map a custom SF field to a Marketo token?

I would change that to a CRM Text / Marketo String and populate it as suggested, without the protocol.

But either way, the {{lead.token}} should be available. If you browse for tokens that start with "{{lead." what do you see when you reach the Ls?
JohnnyVillarini
Level 2

Re: How do I map a custom SF field to a Marketo token?

You are saying to change the type to CRM Text / Marketo String instead of URL right? Sorry for the confusion, but yes that token does come up when I search for it now, but the URL that is supposed to show does not (the calendar URL link). Our SF Admin has that field in SF as "Book Time" with the calendar link hyperlinked to the text though. Since the type is URL, maybe that is why it wouldn't show? 

SanfordWhiteman
Level 10 - Community Moderator

Re: How do I map a custom SF field to a Marketo token?

Definitely [a] that's not valid content for a URL type, if it's wrapped with an anchor and [b] you don't want to include the anchor even with a String field, as you'll lose tracking. The field should be changed to String and only include the protocol-less link.
JohnnyVillarini
Level 2

Re: How do I map a custom SF field to a Marketo token?

Thanks Sanford! I appreciate all the help - I'll speak with our SF Admin tomorrow and see if this fixes the issue

JohnnyVillarini
Level 2

Re: How do I map a custom SF field to a Marketo token?

Hey Sanford!

I have some good news! So we got the token to populate the URL - unfortunately, it is the one that was hyperlinked to "Book Time", so the token would show " <a href="https://www..." target="_blank">Book Time</a>. Our SF Admin was able to update the field it was mapping to with just the URL, but it is still showing the <a href="https://www..." target="_blank">Book Time</a>. 

I have screenshots below of the field in Marketos Field Management and Field Mapping. I know it says URL in the second picture but I am not sure why since I changed it to string in Field Management

marketo-calendar-screenshot.png

marketo-field-mapping.png