Knowledgebase

Sort by:
Summary Marketo-only records must be manually synced, become a member of a default-program, encounter a Salesforce flow step in order to sync with Salesforce. Issue Records are in the Marketo database but are not syncing over to Salesforce automatically like I thought they would. Solution The sync between Marketo and Salesforce is bi-directional. However, in order for a record to be synced, one of the following conditions must be met: The record becomes a member of a program which is synced to a Salesforce campaign. This occurs when the background sync is used to keep members of a Salesforce campaign in sync with a Marketo Program status. This can easily be verified by navigating to the program and looking at the summary view. More information on this feature can be found here: https://docs.marketo.com/display/public/DOCS/Sync+an+SFDC+Campaign+with+a+Program https://docs.marketo.com/display/public/DOCS/SFDC+Sync%3A+Campaign+Sync The record encounters an SFDC flow step. Any time a record encounters a Salesforce related flow step in a smart campaign, this will cause the record to sync with Salesforce. Some of these flow steps have other implied actions, which you can read about here: https://docs.marketo.com/display/public/DOCS/Implied+Salesforce+Actions The record is manually synced to Salesforce through a single-flow action. This is an intentional user action. It can only occur when you find the record in your database or in the people tab of a smart list and select the option from the 'Person Actions' menu. More on how to do this can be found in this document: https://docs.marketo.com/display/public/DOCS/Run+a+Single+Flow+Step+from+a+Smart+List Root Cause Records had not encountered SFDC flow steps, become members of a program synced with a Salesforce campaign and hat not been manually synced to Salesforce. Environment Marketo with the built-in integration with Salesforce
View full article
Marketo has the ability to see and pull data from Salesforce Formula fields, there is however a catch which will be explained in this article.   Everytime the Marketo Sync connects to Salesforce, it will scan records and look at the " SytemModStamp " (salesforce system field) for each one of them. It will compare this value with the stored value, which was pulled at the last scheduled sync. If the values match, Marketo will move on to the next record. If the values are different (new value later date than previous value) , then Marketo will do a compare and contrast of all fields on that record in both systems and update the information as needed.   When a normal non-formula field is updated and changed on a Lead/Contact record in SFDC, the SytemModStamp value is updated. This is how on next sync Marketo knows to do a compare/contrast check and pull updates. Formula fields do not behave the same way. A formula field is calculated based on data in fields called upon in the formula; this means that the formula field calculation itself will not update the SytemModStamp in Salesforce.   Chances are you already have existing records in SFDC and Marketo. If you were to create a formula field today in your instance of SFDC and have it sync down into Marketo, the data calculated for the formula field in SFDC will not come into Marketo right away. The reason for this is, the formula field has created data based on already existing data, this does not result in a SytemModStamp change.   Typically formula fields will be a calculation of data from fields which are somehow related to the lead/contact record. This means that moving forward, any change in the normal field, will result in a SytemModStamp change as well as a recalculation of the formula field. In this case, Marketo will see the updated SytemModStamp due to the normal field change. Marketo will do the compare/contrast excercise and find that the formula field also needs updating.   If you create a formula field in SFDC and would like to have all the historical data for the formula field to come into Marketo, you can force an update on the records in SFDC to update the SytemModStamp. This way, on next sync, Marketo will see the formula data and pull it in. Alternatively, you can simply allow for natural SytemModStamp updates in SFDC to occur which should result in a slow trickle of historical data from SFDC into Marketo for the newly created formula field.   You can only use data from a formula field in Marketo to segment data and filter. If you try to do a change data value, Marketo will accept the change, tries to sync it to Salesforce and fails to update there. Eventually the Salesforce calculated value will come back into Marketo.  
View full article
Issue Description: Salesforce refreshed your sandbox and it no longer syncs with Marketo Issue Resolution: As a safety precaution, once an instance of Salesforce is synced up with Marketo, we no longer allow the user to sync this particular instance of Marketo with any other instance of Salesforce. When Salesforce does a “refresh” of your sandbox, they are actually canceling your old sandbox account and creating a new account and pulling fresh data from your production. This means the refreshed sandbox is actually a different account and has a new OrgID. Marketo Support can assist by unlocking your Marketo sandbox to be synced up with a refreshed Salesforce sandbox. If you run into this scenario, please create a support ticket requesting that we enable the reset of the OrgID for your SFDC sandbox.
View full article
Issue Sometimes you may get this error when trying to sync a Marketo Program to an SFDC Campaign -  "Not allowed: Salesforce campaign contains incompatible statuses", even though the statuses match in the Marketo program and SFDC campaign.   Solution Check for the statuses in the Marketo program channel and SFDC campaign - you will see the same statuses. This error occurs if there is any case-sensitive error in the statuses. For example, if your Marketo program has the following statuses: Attended, Registered, Unable to Attend and the SFDC campaign has Attended, Registered, Unable to attend. Then you will encounter the above error. You have to change the status in Marketo as "Unable to attend" or change the status in SFDC Campaign as "Unable to Attend"  in order to fix this.    
View full article
Included in this article Overview Do you need to create fields in Salesforce and have them connect to specific fields in Marketo like for Lead Score or Acquisition Program? If so, this document will take you right to the instructions on how to get that done! Step by Step Directions for all Salesforce Editions Adding Custom Marketo Fields to Salesforce Video Overview Here's a video tutorial of the entire process that should make it easy to follow along: Salesforce Connector Setup​ Enjoy!
View full article
Marketo has the ability to see and pull data from Salesforce Formula fields, there is however a catch which will be explained in this article.   Everytime the Marketo Sync connects to Salesforce it will scan records and look at the " SytemModStamp " (salesforce system field) for each one of them. It will compare this value with the stored value, which was pulled at the last scheduled sync. If the values match, Marketo will move on to the next record. If the values are different (new value later date than previous value) , then Marketo will do a compare and contrast of all fields on that record in both systems and update the information as needed.   When a normal non-formula field is updated and changed on a Lead/Contact record in SFDC, the SytemModStamp value is updated. This is how on next sync Marketo knows to do a compare/contrast check and pull updates. Formula fields do not behave the same way. A formula field is calculated based on data in fields called upon in the formula; this means that the formula field calculation itself will not update the SytemModStamp in Salesforce.   Chances are you already have existing records in SFDC and Marketo. If you were to create a formula field today in your instance of SFDC and have it sync down into Marketo, the data calculated for the formula field in SFDC will not come into Marketo right away. The reason for this is, the formula field has created data based on already existing data, this does not result in a SytemModStamp change.   Typically formula fields will be a calculation of data from fields which are somehow related to the lead/contact record. This means that moving forward, any change in the normal field, will result in a SytemModStamp change as well as a recalculation of the formula field. In this case, Marketo will see the updated SytemModStamp due to the normal field change. Marketo will do the compare/contrast excercise and find that the formula field also needs updating.   If you create a formula field in SFDC and would like to have all the historical data for the formula field to come into Marketo, you can force an update on the records in SFDC to update the SytemModStamp. This way, on next sync, Marketo will see the formula data and pull it in. Alternatively, you can simply allow for natural SytemModStamp updates in SFDC to occur which should result in a slow trickle of historical data from SFDC into Marketo for the newly created formula field.   You can only use data from a formula field in Marketo to segment data and filter. If you try to do a change data value, Marketo will accept the change, tries to sync it to Salesforce and fails to update there. Eventually the Salesforce calculated value will come back into Marketo. Is this article helpful ? YesNo
View full article
Issue New program status created in CRM did not sync to Marketo.  Environment Program status did not sync to Marketo New Program status is missing in Marketo Solution Create the corresponding status in Marketo by navigating to Admin > Tags > Channel > Select the corresponding channel > Add new status > Save.  Create a Program Channel | Adobe Marketo Root Cause This is an expected behaviour as program statuses created in CRM do not sync to Marketo. 
View full article
This is working as expected. The Parent Company Name field gets its value set from a different process and not via the SFDC Synch. SFDC and Marketo Engage both have a Parent Account ID field in the Account Object (Company Object in Marketo). If there is a parent account ID in that field, then the value of that field is automatically populated via a reference to the other Account Record. Since Company in Marketo is mapped to Name (SFDC Account) whenever that value is updated it will be reflected in Marketo. Example: Account ID 1 has a Parent Account ID of 2. They both have records in the same Account table. If the Name is changed of the Parent Account it is automatically reflected in any child accounts as the Parent Account Name is just a reference.
View full article
Issue If a record which is in a Marketo Campaign Wait Step and is merged into another record, does the winner of the merge continue through the flow?    Solution Winner of the merge will continue through the Campaign flow and complete the remaining steps. To prevent this behavior, remove the record from Campaign using the 'Remove From Flow' step. Environment Records merged in Marketo  Records merged in SFDC
View full article
Issue Does applying a permission set to the Marketo Sync User in Salesforce suffice for limiting the number of fields to sync from Salesforce to Marketo? or will the profile need to be updated directly? Solution In order to limit the visibility of fields for the Marketo Sync User in Salesforce, the profile will need to be directly edited (example: Add an Existing Salesforce Field to the Marketo Sync - Marketo Docs - Product Documentation) Root Cause Since the profile has access to a field, the Marketo Sync User will still have access to the field even though a permission set applied to the profile does not have access to the same field. Environment Salesforce Sync Marketo Sync User Permission Set SFDC
View full article
The fields and records that will sync from Salesforce are defined by the permissions of the Marketo sync user. Therefore, if you want to prevent specific records or fields from syncing with Marketo, change the permissions of the sync user so they do not have access to the records and fields you do want to sync. Alternatively, you can work with Marketo Support to set up a Custom Sync Filter that will prevent records from syncing based on the value in a specified field. Restricting Leads from Syncing to SFDC With Sync Filters 
View full article
Once your Marketo instance is integrated with a CRM, either Salesforce or MS Dynamics, that integration cannot be switched.  You cannot switch from one CRM to another, and you also cannot switch from one instance of your CRM to another instance.  If you need to switch CRMs, or if you need to connect Marketo with a different instance of your CRM, you will need to contact your Customer Success Manager to have a new Marketo instance provisioned.
View full article
Here's how you can use tokens and URL parameters to automatically assign leads to Salesforce campaigns after filling out a form.  These tokens work in all of the Salesforce campaign flow steps:   Add to Salesforce Campaign Change Status in Salesforce Campaign Remove from Salesforce campaign   Get the Salesforce campaign ID and status   You need two things to begin this process -- the name or ID of the Salesforce campaign you want to sync to and a valid status in that campaign.  You can get the ID for the campaign by opening that campaign in Salesforce and copying the last 15 characters from the URL.  Here's an example campaign URL; the ID is highlighted:   https://naX.salesforce.com/ 701F00230001Z9z   To get the valid statuses, click on "Advanced Setup" on the campaign's page     The status should be listed there:     Create new fields   First, you need to create two new fields -- "SFDC Campaign ID" and "SFDC Campaign Status" -- both of type "string".  You can create these on your lead and contact records in Salesforce, or contact Marketo support to add those custom fields in your Marketo account.   Create or edit the form   After you create those fields, the next step is to incorporate them into your forms.  Create a new form or edit an existing form, then drag those two fields into your form.  Make them both hidden fields and set them to populate from a URL.  If you're unfamiliar with them, this article on hidden fields has details on how they work. Making a Field Hidden on a Form When setting the values for those fields, use a real Salesforce campaign ID and status as the default value.  Here's how you might edit the settings for those fields:   SFDC Campaign ID: Default Value: [a real Salesforce campaign ID or name] Populate from: URL Parameter Parameter name: campaignID   SFDC Campaign Status: Default Value: [a real Salesforce campaign status for the campaign you chose] Populate from: URL Parameter Parameter name: status   And here's what your form might look like when done:   Now you have a form that automatically add leads to the default Salesforce campaign you selected and that you can override with URL parameters.   Create a Smart Campaign   Next, you need to create a campaign that will add these leads to the selected (or default) Salesforce campaign.  We'll trigger this campaign to launch whenever someone fills out your form: In the flow, first you need to sync the lead to Salesforce so that you can add it to a campaign.   Then you can add it to the Salesforce campaign using the values in the SFDC Campaign ID and SFDC Campaign Status fields.  To do this, use the tokens for those fields in your flow step:  {{Lead.SFDC Campaign ID}} for the campaign name and {{Lead.SFDC Campaign Status}} for the status.  If you type "{{" in the fields, the auto-suggest will help you enter that text correctly:     Your finished flow should look like this:     Finally, in the schedule tab set this campaign to run every time and activate it.     Launch your landing page   If you modified a form already in use, you can now go to that landing page, fill out the form, and watch as your lead gets synced to the Salesforce campaign you chose.  If this is a new form, create and approve a new landing page which uses that form.  After filling out the form, you should see the lead added to the default Salesforce campaign specified in your form:     Use URL parameters to override the default campaign and status.  For our forms, the campaign is set by the "campaignID" URL parameter and the status by the "status" URL parameter.  For example, this URL:   http://offers.marketo.com/offers.html? campaignID=701A00000009K3l&status=Responded will assign the lead to the Salesforce campaign "701A00000009K3l" (the Salesforce internal ID) with the status "Responded."  If either value has spaces or special characters, make sure that you URL encode them before adding them to your URL.   Using tokens in other Salesforce campaign flow steps   These tokens work in all of the Salesforce campaign flow steps -- Add, Remove, and Change Status in SFDC campaign.  Follow the same directions as above but substitute the appropriate flow step in place of the Add to SFDC Campaign step.   Diagnosing errors   If your leads are not syncing to your Salesforce campaigns, first go to the Activity Log for that lead and double click the line that has the failed flow step. The information that appears will help you figure out what the problem might be. The most common errors you'll encounter are: Spelling errors in your tokens -- use the autosuggest to help Using an SFDC campaign ID or name that doesn't exist -- check the spelling of the campaign or ID The lead doesn't exist in salesforce -- sync the lead to Salesforce before adding him/her to your campaign Using a status that doesn't exist for that campaign -- change the status to one that does exist for the campaign, or add a new status to the campaign in Salesforce
View full article
Problem/Issue: When you view a lead’s activity history, you noticed a failed sync activity type with the following example: Reason/Cause: This message is very general and can be caused by a number of sync related errors. In order to get more information, you will need to double-click the error message and a separate pop-up window will appear. Search for the section labeled: “SFDC Error:” like the following example:     Fix/Solution: Depending what the error message is, Salesforce provides a website that lists all Core Data Types used in API calls.   You can access it by clicking here .
View full article
Issue: You have Opportunities in Salesforce but they are not showing in Marketo.    Solution: 1) Check Opportunity permissions in Salesforce - Your first line of troubleshooting this issue is to ensure that the Salesforce profile being used by your Marketo sync user has the Create/ReadEdit/Delete access on the Opportunities object in Salesforce.     2) Check the "Contact Roles" Related List - Ensure that the "Contact Roles" Related List in Salesforce under the Opportunity's detail page is populated     3) Ensure that the Marketo sync user has visibility in Salesforce to see the Opportunity - Log in to Salesforce with the Marketo sync user and ensure that the missing Opportunity in Marketo is visible to this Marketo sync user. If the Marketo sync user can't see the Opportunity then the Opportunity will not sync to Marketo.   4) Check to see the time that the Opportunity was created in Salesforce - Often times you have all the correct Opportunities permissions in Salesforce but the Opportunities are still not showing in Marketo because the Opportunity was recently created and you have not allowed enough time for that Opportunity to sync to Marketo. In this scenario, the only thing you can to is wait. If your sync is busy processing other items, you usually need to wait for these pending items to sync before the newly created Opportunity will sync to Marketo.
View full article
Question: How do I add a link to my lead/contact's Salesforce detail page when sending an alert from Marketo?   Answer: If the lead or contact is in both Marketo and Salesforce at the time when the alert email is sent, then the link to the Salesforce detail page will be automatically appended to the alert email sent by Marketo.   Note You will need to use the "Send Alert Info" token within your Alert email while designing your email in the Design Studio of Marketo.     Below is what the generated alert looks like once it is sent from Marketo (note the link to the Salesforce detail page is automatically inserted):     Note if the lead or contact is not in Salesforce then there is no link to the Salesforce detail page:  
View full article
Question: Is it possible to assign a lead owner during a list import?   Answer: No. The reason for this is because lead ownership is a Salesforce functionality and should be first done from within Salesforce. Here is one of the easiest options available to you within Marketo, if you are not able to do the assignment in Salesforce:   1) Upload yours leads into Marketo's Lead Database without lead owner information. i.e. your import CSV will not have any lead owner columns in it. More information on import leads at Import a List of Leads from a Spreadsheet into Marketo (Import List) .   2) Once the list import is successfully completed and your leads are in Marketo, you can use the "Sync Person to SFDC" flow action to assign lead ownership. More information on the "Sync Person to SFDC" flow action at Sync Person to SFDC .
View full article
When you ask Marketo to add a Salesforce contact to a lead queue, Marketo creates a duplicate lead in Salesforce and adds that to the queue instead. The reason why Marketo creates a duplicate is because Salesforce queues can only have leads in them, not contacts.  If you try to add a contact to a queue, Marketo can either do nothing or create a duplicate lead and add that to the queue.  We opted for the duplicate.   If you want to prevent this behavior in your campaigns, use a filter on "SFDC Type is Lead" to limit the action to only leads    
View full article
My Salesforce activities are not showing up in Marketo and when I go to the Admin section I see the following sync error:   soqlBatchQuery failed - INVALID_FIELD: CreatedDate, Description, Id, IsAllDayEvent, IsDeleted, OwnerId ^ ERROR at Row:1:Column:70 No such column 'IsAllDayEvent' on entity 'Event'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names. This is due to lack of permissions for the Marketo Sync User on the Salesforce side. Please have your Salesforce Administrator log into your instance of Salesforce and carry out the following steps:   Log into Salesforce with Admin rights Click on your name drop-down and click on Setup In the left hand column, under App Setup, click on Customize Then click on Activities and then Event Fields Click on the All Day Event Field Label then "Set Field-Level Security" Here make sure to check the box under the Visible column for the Profile that the Marketo Sync User is associated to Click Save Once the above changes have been made on next sync we will begin pulling your Salesforce activities and once the next sync is over, the error message in the Marketo Admin section should go away.    
View full article
  Market Support is here to help you with your issues in the quickest and most effective manner possible.  In order for us to do that, there are a few things we really need from you before you click the submit button to create a support case with us.   First, have you searched the community for a solution? The best kind of support case is the one you don't have to submit.  The Marketing Nation Community is an expansive site with a lot of content.  Have you checked Product Docs or Support Solutions for a resolution to your problem?  Have you checked to see if there is a community discussion thread that covers your question?  The Marketing Nation community is a 24 x 7 customer resource and a quick search for a keyword and phrase maybe all that separates you from a solution to your problems.   Second, what's the best way to reach Marketo Support? Marketo Support offers a variety of ways to reach our support team.  Depending on your issue, some of the support channels might be better suited than others.   Please be aware that only contacts from your company/organization that have been identified as an authorized support contacts or authorized support administrators can submit cases to Marketo Support.       Marketo Support (Support) The Marketing Nation Support area features a case submission application that allows you to select your case priority and also select what the Case Issue and Sub-Issue is.  These selections allow our automated case routing system to assign the case to the available support engineer that can best assist you.   Spark customers can submit cases through the support portal only
View full article