Troubleshooting Salesforce
This troubleshooting guide is designed to help you with common questions or issues you may encounter when using Salesforce as a data source.
For further assistance, please send an email to our Support team at help@ortto.com or lodge a support ticket from your account:
- In the left-hand navigation drawer of your Ortto account, click Support.
- On the How can we help? page:
- Under Quick links, click Submit a support ticket.
- Populate the Submit a support ticket form and click Submit ticket when you are done.
Disconnect and delete the data source
You must disconnect and archive a data source before you can delete it.
Disconnecting a data source from Ortto will stop new data from the data source merging with the CDP.
Learn about disconnecting, archiving and deleting a data source under Managing data sources.
Data source already connected
Disconnect, archive, and delete the existing Salesforce connection before attempting to connect again; the existing data source must be deleted.
Connect more than one Salesforce account
Ortto can connect to more than one Salesforce account at a time. You may wish to do so if you have 2 Salesforce accounts, for example, with a contact named John Smith in both Salesforce accounts. By connecting both of your Salesforce accounts with your Ortto account, Ortto will store John Smith as 1 person (contact) in your CDP. This will help you see John Smith’s activity all in once place, as you can view John Smith’s profile and see activity from both of your Salesforce accounts.
To connect to another Salesforce account, log in to the Salesforce account you wish to connect, then repeat the steps outlined in Connect from Ortto.
Salesforce data source still displays as 'syncing' after x minutes/hours
Depending on the amount of records in your Salesforce account the initial sync may take up to several hours in some cases.
How do I backfill Salesforce field data?
If you select a new/additional Salesforce field to sync to Ortto (under Data sources > Salesforce > Salesforce fields), the field will only be populated with data from new (future) updates.
If you wish to backfill the field data, you can select Backfill Salesforce fields, which will populate data for the newly-added Salesforce fields against existing contacts (people) in your CDP. You can access the backfill feature two ways:
- On the Data sources page, by clicking the more icon next to your Salesforce account, then Backfill Salesforce fields.
- In the Salesforce data source view, under Actions > Backfill Salesforce fields.
For example, say you have contact ID data populated in your Salesforce account but you did not set up your Salesforce integration in Ortto to capture contact ID field data. You can add the contact ID field in Data sources > Salesforce > Salesforce fields. Once you have done so, in the Salesforce view, select Actions > Backfill Salesforce fields to backfill the contact ID data for your existing contacts.
NOTE:
- The Backfill Salesforce fields feature only populates data for contact fields.
- Backfilling Salesforce fields will put the Salesforce data source into a dual Connected and Updating status. This means the backfill is happening in the background and won’t affect your ability to use Salesforce in Ortto.
My Salesforce selective sync is missing updates for contacts or leads
If you configured your Salesforce data integration to selectively sync Salesforce data using filter conditions to capture only contacts, the sync will filter out leads (and vice versa). As such, you will not be able to find data on leads in your CDP, for example, because leads do not have contact fields in Salesforce.
If you wish to capture both contacts and leads, your filter conditions will need to be configured to capture both record types, using an OR operator. For example, the filter conditions Primary object name is Contact OR Primary object name is Lead, and group those conditions with any additional contact or lead field conditions as required.
Learn more about grouping conditions and AND/OR operators in Working with filters.
How do I send data from Ortto to Salesforce?
There are two ways in which you can send data from Ortto to Salesforce:
- Create a journey with Action shapes that update object records, such as an action to change a campaign’s status. Learn more about Salesforce actions.
- Select up to 20 activities to sync to Salesforce. This creates custom objects in your Salesforce account with the same names as the activities selected in Ortto.
Learn more about syncing Ortto activities to Salesforce.
Associating Salesforce opportunities in Ortto
Salesforce opportunities must have a contact assigned to the primary contact role in order for the opportunity (and related activities) to be successfully associated with the contact in Ortto. Even if an opportunity has one or more contacts, you need to make one contact the primary contact.
This means that for opportunities with multiple contacts, only the contact assigned to the primary contact role will be associated with the opportunity in Ortto.
Assign a primary contact in an existing opportunity
To assign a contact to the primary contact role for a Salesforce opportunity:
- In Salesforce, view the opportunity you want to add a primary contact to.
- In Contact Roles section, at the relevant contact, click the drop-down arrow then Edit.
- In the Edit Opportunity Contact Role modal, select the Primary checkbox then Save.
Create a new opportunity with a primary contact
To create a new Salesforce opportunity with a primary contact:
- In Salesforce, at Opportunities, click New.
- Populate the opportunity fields as required then click Save.
- On the new opportunity view, in the Contact Roles section, click the drop-down arrow then Add Contact Roles.In the Primary Contact field at the top of the Add Contact Roles modal, select the contact then Save.
How do I sync scores to Salesforce?
To send your scores to Salesforce, you need to:
- Install the latest Ortto package using the link in the note at Syncing Ortto activities to Salesforce.
- Check the remote site settings related to the Ortto package in Salesforce.
Install the latest Ortto package
To enable contact scores to sync to contact-related record pages in Salesforce, you need to click the link in the note at Syncing Ortto activities to Salesforce:
- During the installation, select Install for all users and click acknowledgement checkbox, then click Install.
- You’ll see an Approve Third-Party Access pop-up alerting you that 3 remote sites are included in the package (this is to accommodate each of the regions in which Ortto can host data). Select the checkbox to grant access to the sites then click Continue.
- When the installation is complete, click Done to return to Salesforce.
- You then need to check the 3 remote sites are active.
Check the remote site settings
When you installed the Ortto package for Salesforce (using the link at Syncing Ortto activities to Salesforce), it automatically added 3 remote sites to your Salesforce account.
When the remote sites were installed, they may not be active, so you will need to check this in Salesforce:
- In Salesforce, at Setup, choose from the left-hand panel Security Remote site settings.
- On the All Remote Sites page, click Edit at each of the Ortto remote sites:
- Ortto_AU: https://salesforce-integration-api.au.autopilotapp.com,
- Ortto_EU: https://salesforce-integration-api.eu.autopilotapp.com, and
- Ortto_US: https://salesforce-integration-api.autopilotapp.com.
- Select Active if not already selected to enable each remote site. There is no need to alter other settings.
- Click Save to finish.
Add the Ortto Scores component to Salesforce records
To add Ortto Scores, on a record page (e.g. lead record or contact record):
- Click the Setup cog, then Edit page.
- In the page builder, in the left-hand Components panel, locate the Ortto Scores page component.
- Click and drag Ortto Scores onto the record page view.
- When you are finished setting up the record page, click Save.
- When prompted, Activate the page so it is visible to all users in your Salesforce account.
- Once the record page setup is complete, you can return to a lead or contact record to see the Ortto Scores section. The section will be populated with scores when the sync occurs.
Needs attention: Couldn’t connect Salesforce
If your Salesforce data source has a status of Needs attention and you get an error message saying Couldn’t connect data source it may mean that you need to:
- In Salesforce, review your Refresh Token Policy. We recommend having this set to Refresh token is valid until revoked under OAuth Policies. This can be updated by managing your Salesforce authorization.
- Reset your Salesforce security token.
- Reset your Salesforce password.
- Once the token and password are updated, try again in Ortto to connect to Salesforce.If you are asked to login to Salesforce from Ortto during the reconnection, populate the Password field with your Salesforce password followed by your Salesforce security token. For example, if your password is "mypassword" and your security token is "XXXXXX", enter "mypasswordXXXXXX".
Reauthenticate Salesforce
Reauthenticating allows you to generate a new authentication token for our app to use with Salesforce. You don’t need to make changes if the original user who connected the data source is unavailable, but re-authenticating can be helpful if you have taken steps to reset your Salesforce security token.
Reauthenticating helps keep your data source active, preventing it from entering a syncing stage.
Navigate to CDP > Data sources > Salesforce > Actions > Reauthenticate.
Salesforce account connection interrupted
If Salesforce has an outage due to maintenance or an update release, it can disrupt the data source connection with Ortto.
If this occurs, we will notify you by email that campaigns with Salesforce-related actions and/or activities synced from Ortto to Salesforce need attention. For example, an email like this:
If this occurs, you need to perform the following in Ortto:
- Reconnect the Salesforce data source. You can do this from the Data sources page, click the … more icon > Reconnect. Or from the Salesforce data source view under Actions > Reconnect.
- Turn on any campaigns that were turned off (if required). The email we send to you will list the campaigns that have been affected by the connection disruption so that you can click the link to view the specific campaign, or click View campaigns to access your campaigns list.
- Reconfigure activities to sync from Ortto to Salesforce (if required). If your Ortto > Salesforce activity sync was interrupted, you will need to reconfigure it in Ortto. In the email we send you, click View data source to access the Salesforce data source view and re-add the activities. Advice regarding this issue is available in an earlier section of this page.
Salesforce field mapping can't be edited
Sometimes the "Salesforce fields" section cannot be edited (the "Edit" link is disabled). This generally occurs when the Data source is currently updating, and as such the field mapping cannot be updated until the update is complete. This is to avoid missing field data.