How do I sync URLs to Campaign Monitor

In Salesforce, you can build hyperlink formulas that create clickable links in Salesforce. These are encoded to display your label text and work within Salesforce UX. Therefore, you can't use these formulas to populate custom contact fields in Emma. When merged into emails, the link won't display correctly. 

Instead, you can either:

• Create a text formula that constructs the URL just as a text string, see below
• Build the formula in the email editor using text from synced custom fields. 

Creating the right formula:
Build your mapped formula field to return the URL's HTML. Don't use the HYPERLINK function.

Formula example- use the URL in the link-builder in the Campaign Monitor email editor:
https://jumpshare.com/embed/N1D3b7SwDW04mPgdcd3j

Returned data to include in your import mapping:
https://jumpshare.com/embed/enMRjd5xZFcSgkalC9d2

How to use the formula in the Campaign Monitor campaign builder:

• In your List in Campaign Monitor, copy the merge tag for the contact field that holds the mapped formula.
  
  
• Use the shortcut name as the URL in the link component. 

Formula example - for merging the URL directly into the email
A second option is to build an HTML statement with a Salesforce formula (text). You returned text, mapped to a custom contact field and then merged into the email body would look like this: Click here

Building the formula in the email editor

<a href="https://www.yourwebsite.com/login.php?user=[id,fallback=]">Login to your account</a>