All Collections
Integrations
Salesforce
Setting up the Salesforce integration
Setting up the Salesforce integration

An overview of Planhat's Salesforce integration, and step-by-step guidance to set it up

Carly Hammond avatar
Written by Carly Hammond
Updated over a week ago

Summary

  • Data you can sync

    • CRM data: standard and custom objects (see data mapping table below)

  • Sync direction

    • Managed at object/model and field level

    • Choose between:

      • Bidirectional

      • Receive from Salesforce

      • Send to Salesforce

      • Receive from Salesforce

  • Sync frequency

    • Automatic sync

      • Salesforce to Planhat: standard sync is up to 10 minutes

      • Planhat to Salesforce: near instant

    • Manual: on demand

  • Data mapping

    • See table below

Who is this article for?

  • All Planhat users

  • It's particularly relevant to those setting up the Salesforce integration

Series

We have a series of articles on the Salesforce integration:


Article contents

This article covers a lot, so use the links below to jump to the relevant section if you would like to look up something specific!


Introduction

Planhat's bidirectional Salesforce integration enables you to bring your CRM data into Planhat quickly and easily. Within Planhat, all your different data (from a variety of sources) is consolidated, meaning you get a full 360 degree view of your customers. You can analyse your data in Planhat in lots of advanced ways without requiring your developers, display your data clearly for greater insights, and automatically take action in response to data for maximum efficiency and productivity. With Planhat's unlimited user model, it's not just Customer Success teams who can benefit from all the features - Sales, Marketing and Product etc. can use it too.

In addition, you can push data from Planhat to Salesforce, so if you do have colleagues still using Salesforce, you can ensure everyone is the same page with up-to-date customer information. For example, you could sync Planhat customer analysis such as Health Scores into Salesforce to help your Sales team identify potential expansion opportunities or references. Or, since Planhat can create End User (Contact) records from various connected systems, you could consider syncing End Users (Contacts) to Salesforce if your Marketing team is working there.

πŸ“ In this article, we will give an overview of what's synced (data mapping), sync frequency, the basic principles of the integration (sync direction, filtering, and custom field mapping), and then take you through the steps of connecting the integration and configuring each model/object section.


Data mapping overview

Some of the data mapping is predefined (e.g. the Salesforce Account object is always mapped to the Planhat Company model), but there is also a great deal of flexibility possible.

Here's an overview of the model/object pairings in the Salesforce integration.

Planhat model

Sync direction

Salesforce object

Company

Bidirectional (or one-way)

Account

End User

Bidirectional (or one-way)

Contact

Task

Bidirectional (or one-way)

Task

Conversation - type "note"

Bidirectional (or one-way)

Note or ContentNote

Conversation - type "ticket"

From Salesforce to Planhat

Case

License, Sale (NRR), Opportunity, Asset, Project, Churn, Invoice, Campaign, Objective or Workspace

Bidirectional (or one-way)

Your choice of object (pick for each model)

Planhat model already mapped (see note below)

Bidirectional (or one-way)

Your choice of additional Salesforce object

Further details:

  • Within these model/object pairings, not all fields are automatically synced, only a subset (learn more here); you can add custom field mapping for your choice of fields (detailed here)

  • Salesforce objects need to have a relationship to the Account (as in Planhat, other models are connected to the Company)

  • For all model/object combinations other than Salesforce Case, the sync can be bidirectional, but if you only want it to be one way (e.g. from Salesforce to Planhat), you can set it to that

  • You can set sync direction on the field level in addition to the model/object level - we discuss this in further detail within this article

  • You choose a single Salesforce object to be synced to both the License and the Sale (NRR) models

  • The bottom row in the table describes an "extension object"

    • If you'd like to learn more about extension objects, check out our deep-dive technical article here

    • Extension objects aren't applicable for the Planhat License or Sale (NRR) models

  • Not all Planhat models are available in all contracts - speak to your CSM if you would like to add a model


Sync frequency overview

The Salesforce integration syncs your data automatically, making it simple to keep both Planhat and Salesforce up to date, without requiring extra manual effort from you.

You can also manually sync, on demand - either all models/objects, a specific model/object, or data related to a particular Company.

Quick summary of the main, default automatic sync:

  • Planhat to Salesforce: New/updated records in Planhat are sent to Salesforce near instantly

  • Salesforce to Planhat: New/updated records in Salesforce are synced to Planhat by a job that runs every 10 minutes. (Occasionally the gap between sync job runs could be slightly longer than 10 minutes)

Technical deep-dive article

For technical details of the different automatic syncs, as well as the different ways you can manually sync, check out our deep-dive article here.


Principles of the Salesforce integration

Before we deep-dive into the details of configuring the Salesforce integration, let's go through the main principles.

Once you've connected the integration to your Salesforce account, you'll see a series of sections, each corresponding to a Planhat model mapping to a Salesforce object. The main parts of these sections are:

We'll go through each of these here.

Sync direction

Here, we're referring to the main sync direction for each model/object section. The Planhat Salesforce integration is bidirectional, meaning you can choose to push data to, and pull data from, each system.

You set the sync direction independently for each model/object pairing, offering a great deal of flexibility.

The default is "Not Syncing", so you select another direction to enable the sync of that model/object.

For all objects other than Case, which is a one-way sync from Salesforce to Planhat (so only "Receive from Salesforce" is possible), you can choose from "Send to Salesforce", "Receive from Salesforce", or "Both Directions".

It's possible to change the sync direction later on - e.g. you could initially select "Receive from Salesforce" when you're setting up your Planhat tenant, and then change it to "Both Directions" later on.

When you set up custom field mapping, you can also choose the sync direction for each field - we'll discuss this when we talk about field mapping later in this article.

πŸ“Œ Important to note

For data security reasons, regardless of direction, the integration does not delete records (e.g. if you manually delete an End User in Planhat, the integration won't delete the corresponding Contact in Salesforce), but records can be updated.

Record filtering

For most model/object sections, you have the ability to apply a filter to specify which records are included in the sync from Salesforce.

A common use case is in the Company/Account section, to specify that you only want to sync in Salesforce Accounts with an "Account Type" of "Customer" - that is, they sync in when they become paying customers, rather than prospects. Here is an example of how that might look:

As you can see, the basic principle is:

  • Select the field on the Salesforce object to use for filtering

  • Select which values of the field to include - records with these will be synced, and others won't be included

πŸ“Œ Important to note

If a record is created in Planhat from Salesforce, and then ceases to match the filter for the Salesforce integration, the Salesforce record will receive updates from Planhat, but updates will not flow the other way.

πŸ“Œ Important to note

The Account/Company acts as a kind of filter itself: in the Planhat data structure, Company is at the top, and (almost) all other models have to link to a Company.

This means that, for example, only Contacts (End Users) belonging to an Account (Company) synced to Planhat are synced in, as Planhat doesn't support End Users not connected to a Company.

Custom field mapping

For most model/object sections, you can set up custom field mapping: link up specific Planhat fields with specific Salesforce fields. (Note that the integration does not create fields, only syncing data between them, so you would need to create the fields first before selecting them in the integration.)

There are a small number of standard/default fields included in the sync - for example, Account (Company) name, and first name / last name for Contacts (End Users) - but in addition to that, you can configure which Salesforce fields you would like to map to which Planhat fields.

Technical deep-dive article

If you'd like to learn all about which fields are synced (or populated) as default by the integration, you can read our guide here.

You don't need to sync every single field that exists in your Salesforce org; think about which fields contains relevant data for your team working in Planhat. Similarly, if you still have colleagues working in Salesforce, consider which Planhat data in particular you may like to sync back.

For the main objects at the top (Account and Contact etc.), the field mapping section will look something like this:

For each set of fields you want to match, click "map another field" to add a new row for you to complete.

From left to right, the columns are:

  1. Use the dropdown to select whether the Planhat field you want to map is:

    • "Attribute" - a standard/default field (available "out of the box")

    • "Custom" - a custom field created just in your Planhat tenant

    • For Account/Company only: "Metrics" - a Company calculated metric created in your Planhat tenant

  2. Specify the Planhat field name:

    • For "Attribute", you can select the Planhat field from a dropdown list

    • For "Custom", you should copy and paste the field name (or you can type it in, but it needs to match the field name exactly)

    • For "Metrics", select your chosen calculated metric from the dropdown list

  3. Select what the field type is - "String", "Number", "Date", and so on

  4. Select your chosen Salesforce field name from the dropdown menu

  5. Choose the sync direction for the field

    • You will typically set this to the same as the main object sync, but it is possible to set it to something different

    • For Account/Company only, the field sync direction can supersede the object sync direction

      • This means you can set the object to "Receive from Salesforce", if you don't want Planhat to sync Companies into Salesforce as new Accounts, but you can set individual fields to "Send to Salesforce", which can be particularly useful for sharing Planhat Company information (such as metrics) with colleagues working in Salesforce

    • For all other models/objects, the sync direction on the object level is the limiting factor, so you'd need to enable the model to sync to Salesforce if you want one of its fields to sync to Salesforce. It's still possible to have different sync options, along as the field isn't syncing in a way the object can't - see example screenshot below

When setting up custom field mapping within the optional model/object sections at the bottom of integration, the field mapping is simplified:

  • You select the Planhat custom field from a single dropdown, regardless of whether it's a standard or custom field

  • You don't need to select the field type - it's automatically detected for you

Here's an example of what this can look like:

πŸ“Œ Important to note

When mapping list/multipicklist fields, it's important that the values (possible options) in those fields are identical in both systems. For this, Planhat's values need to match the internal Salesforce API names, rather than the label names.

πŸ“Œ Important to note

If you add new field mapping at a later date, click "Fetch Data from SFDC" for the relevant object/model section, so the new custom match field is enabled/synced.

πŸ“Œ Important to note

If you can't see the custom model/object mapping sections at the bottom of the integration (where you can add sections and choose your own model/object pairs) but you would like to add this functionality to your subscription, reach out to your CSM.

Now you understand the principles, let's go through the practical steps of configuring the Salesforce integration in Planhat. Firstly, we'll start with connecting the two platforms.


Connecting Planhat to Salesforce

The first step in setting up the Salesforce integration in Planhat is to connect it to your Salesforce account. This is very simple - just follow these steps.

Technical deep-dive article

For details of the minimum permissions needed for the Salesforce User who's connecting the integration, you can check out our guide here.

  1. Navigate to Planhat's Operations Module (icon at the bottom in the black left-hand bar), ensure the "INTEGRATE" tab is selected, and click on "Salesforce"

    πŸš€ Tip: Find the Salesforce integration more quickly by typing in the search box, or clicking into the "CRM" section, both shown below.

  2. Click the blue "Connect Salesforce" button

  3. A new browser tab will appear, displaying the login page to Salesforce if you are not currently logged in
    ​

  4. Salesforce will ask for your permission to allow the connection with Planhat. Click "Allow". You will see a "Success!" message

  5. Refresh the Planhat Salesforce integration, and you will now see the object sections to configure

πŸ“Œ Important to note

If you are on a very basic Salesforce plan, you may see an error as follows:
​


This error is due to a Salesforce limitation: it means you do not have the relevant Salesforce API as part of your plan, so will need to upgrade with Salesforce before syncing data to Planhat. ​

Now you've connected Salesforce to Planhat, you can start configuring the sections for each of the object/model pairings.

As we've already gone through the basic principles of sync direction, filtering and field mapping earlier in this article, we're not going to cover that again in detail for each object/model pair we describe, but instead we will focus on where there are different elements within the section.

Firstly though, let's start with the "Team" section at the top of the page.


Team (Users)

At the top of the integration, you will see the "Team" section. This is for syncing details of Salesforce Users and Planhat Team Members (Users) - i.e. you and your colleagues using Salesforce and Planhat. (Note that we are not talking about End Users / Contacts here.)

Be aware that this section of the integration does not create Users in either Salesforce or Planhat. Instead, it fetches Salesforce User details and save them into the integration settings.

This information is then used when you have field mapping between Salesforce User fields and Planhat Team Member (User) fields - e.g. syncing the Account Owner of an Account/Company. For this kind of field mapping, the integration checks the list of Users saved here in the integration settings, rather than checking the Salesforce org. It looks at the Salesforce User ID referenced in Salesforce User fields, and identifies their email address, so they can be matched up to the equivalent Planhat User. An advantage of the integration being designed in this way (saving the Salesforce User details within the integration) is that it allows the sync to be faster.

πŸ“Œ Important to note

  • You need to create the Users (you and your relevant colleagues) in Planhat. You can add Users manually, including via a spreadsheet import. Speak to your TAM (or our Support team) if you need further help with this

  • The Planhat Salesforce integration matches Salesforce Users and Planhat Users via their email addresses, so they need to have the same email address in both systems to be identified as the same person

To set up the "Team" part of the integration:

  1. Use the dropdown to select a Salesforce User field and associated field value(s) if you would only like to sync the details of a subset of Users into the integration

    • For example, you could select "Active" equals "Yes"

  2. Click "Save" to save your selection

  3. Click the "Fetch SF Users" to fetch the details of the Salesforce Users matching the filter, and save them into the integration

  4. Optionally, click "Show Owners" to see a list of Account Owners in Salesforce, and whether they are currently a Planhat User or not

    • You can use this as a check/reminder to see if there are any additional Users you should (separately) create in Planhat

πŸ“Œ Important to note

The Team section is included in the automatic sync from Salesforce to Planhat. This can detect when a new User is added in Salesforce, for example.

However, if a User's email is changed in Salesforce, that wouldn't be automatically detected by the integration, so you can use the "Fetch SF Users" button to manually sync in that change.

Also, if you update the Team filter here, you could use this manual sync to update the Users list right away rather than waiting for the next automatic sync job.


Now let's get started mapping the model/object pairs! In this article we'll go through each one, giving you step-by-step instructions as well as important notes and tips.

We'll list them in the order they are shown in the integration UI, but you don't necessarily need to set them up in this order.

Company - Account

  1. Choose the overall sync direction for the object/model

  2. Set the filter, so only specific Salesforce Accounts sync into Planhat

    • The "Account Type" field is commonly used for this, as many people only want paying customers to sync into Salesforce

  3. Optionally, choose a default phase to be applied in Planhat to all Companies/Accounts syncing in from Salesforce

    • For example, if Companies sync in as soon as they become paying customers, you may want them to initially be given the phase "Onboarding". You can change a phase for a Company in Planhat later on, as they progress through the lifecycle

    • In general, when you are first setting up the integration, you'll want to leave this as blank, as you'll be syncing in Companies from a range of phases, rather than just new ones

  4. Choose whether you would like to use the default Account Owner sync from Salesforce

    • Note: this sync is not bidirectional: it will it only sync Account Owners from Salesforce to Planhat. If you would like to sync the Account Owner bidirectionally, use the field mapping section instead - see tip box below

  5. Configure the field mapping section

    • Remember that for Account/Company, you can choose from Planhat metrics, as well as system/default fields ("Attributes") and custom fields

    • A typical use case for syncing field data back to Salesforce would be to share Planhat data (such as a Company Health Score) with colleagues working in Salesforce

    • See the tip boxes below for more ideas!

  6. Finally, make sure you press the green "Save" button to ensure your configuration is saved

πŸš€ Tip

If you would like to sync the Company/Account Owner bidirectionally, you should map the Planhat "Owner" field (which is of type "Team Member") to the Salesforce "Owner ID" field, with the "User" field type selected:

πŸš€ Tip

What if you want to sync Planhat Company Owners to Salesforce, but some of them are Team Members (Users) in Planhat but not in Salesforce? In this case, you can sync the Planhat Company Owner to a custom picklist field in Salesforce (e.g. called "Planhat Owner"). You should set up your picklist as follows:

  • Picklist item value: user name in Planhat

  • Picklist item API name: email address in Planhat

When you set up the field mapping in the integration, you would then select "String" as the field type.

πŸš€ Tip

If you later want to import Company custom metrics (time-series data) into Planhat, you will need to refer to Companies by their "external ID". If you have an external ID field in Salesforce, include it in your field mapping to sync it into Planhat.

(The Salesforce record ID will be automatically synced into Planhat as "source ID". In Planhat, you could potentially copy this source ID into the "external ID" field, but more commonly the external ID will be a different value, and represent the ID you use in your own system/database/product.)

Speak to your TAM if you would like to learn more about source IDs and external IDs.

πŸš€ Tip

To sync Company/Account group structures (parent/child), set up field mapping between:

  • the Planhat field called "Parent Org" (a default/system field - "Attribute") and

  • the Salesforce field called "Parent Account ID" (a default/system field), or otherwise a custom field containing the ID of the parent Account

This can potentially be either a string or an Account lookup field.

For more information, see this article.


Ticket - Case

Salesforce Cases sync into Planhat on the Conversation model, type "ticket".

The Case section of the integration is unique in that it can only be a one-way sync, from Salesforce to Planhat.

  1. Change the sync direction to "Receive from Salesforce" if you would like to sync in Cases to Planhat tickets

  2. Use the dropdown to choose whether, in Planhat, to link tickets to Companies via Account ID or email domain

  3. Optionally, select a Case field and field values if you would like to filter which Cases are synced in (e.g. "Case Type" is "Product A")

  4. Select the initial date for syncing the Cases - this determines how far back the sync goes. Cases created before this date are not included

  5. Use the toggle switch to choose whether to include internal Cases in the sync

    • An internal Case is defined as one without a Contact assigned

    • Internal Cases may occur if you create a Case on behalf of your customers

  6. Optionally, configure custom field mapping

  7. Press the "Save" button to save your configuration


End User - Contact

  1. Choose the overall sync direction for the object/model

  2. Optionally, choose if you would like to configure a filter so only selected Contacts sync in from Salesforce

    • Note that the Company/Account object acts as a kind of build-in filter, as only Contacts (End Users) belonging to an Account (Company) synced to Planhat are synced in

  3. Choose whether to sync all Contacts in as "featured", a property/field in Planhat. In most case, you'll want to leave this toggle switch turned off

  4. Configure custom field mapping, as required

  5. Press the "Save" button to save your configuration


Note - Note

πŸ“Œ Important to note

  • The object on the Salesforce side can be either Note or ContentNote (your choice)

  • The model on the Planhat side is technically the Conversation model. Notes from Salesforce sync into Planhat as Conversations with type "note". Conversations of some other types can also sync to Salesforce via the "Note" part of the integration

  • The "Note" part of the integration is designed so that it only syncs under certain circumstances - e.g. it doesn't sync all new/updated Notes

Technical deep-dive article

To learn more about Notes in Planhat and Salesforce, including different terminology, what is synced and when, and the relationship between "planned activities" (Tasks) and "logged activities" (Conversations/Notes) in Planhat, check out our deep-dive article here.

It's optional to turn on this section of the integration. If you don't want to activate this sync, simply leave the section on "Not Syncing".

  1. Choose the sync direction

  2. Choose which Salesforce object to sync to Planhat Notes: "Legacy Notes" or "Note Taking Tool"

    • Legacy Notes:

      • These are "old notes"; this is the Note object in Salesforce

      • They are displayed in the Section "Notes & Attachments" in Salesforce

      • They are simple text

      • These notes do not have a "Text Preview" field

    • Note Taking Tool

      • These are "new notes"; this is the ContentNote object in Salesforce

      • They are displayed in the "Note" section

      • They support HTML format

      • They have the "Text Preview" field

  3. Use the toggle switch to select whether to sync Contacts and Users for the Notes

    • This is specific to the ContentNote object ("Note Taking Tool")

    • For further details, you can refer to our article on default fields synced by the integration

  4. Click "Check User" to see if the permissions have been enabled in Salesforce to allow Planhat to map the User of the Note

    • If the User creating the Note in Planhat has an email address that matches a User's email in Salesforce, the Note will be saved in Salesforce associated with that User. Doing this requires a specific permission in your Salesforce account. (If the User creating a Note in Planhat has an email address that does not match any User in Salesforce, the Note will be saved using the name of the User who connected the Salesforce integration in Planhat)

    • You can watch the video below to see what to enable in Salesforce:


Task - Task

Technical deep-dive article

If you'd like to learn all about syncing Tasks to and from Salesforce, you can refer to our separate article, where we go over what Tasks look like in Planhat and Salesforce, how they relate to Planhat Notes (Conversations - "logged activities"), how to sync Task types, and more.

It's optional to sync Tasks. If you don't want to include them in the sync, simply leave this section on "Not Syncing".

  1. Choose the sync direction

  2. Use the checkboxes to filter Tasks from Salesforce by Profile. If no Profiles are selected, Planhat will fetch all Tasks

  3. Optionally, configure custom field mapping

  4. Press the "Save" button to save your configuration


License & NRR (Sale) - your choice of object (e.g. Opportunity)

πŸ“Œ Important to note

In Planhat, recurring (subscription) revenue is stored on the License model, and non-recurring revenue is stored on the Sale (NRR) object. This section of the integration is special, as you have one model in Salesforce syncing to (potentially) these two different models.

  1. Choose the sync direction

  2. Choose which Salesforce object (standard or custom) to sync

    • Many people store their revenue data on the Opportunity object in Salesforce, but if you use a different object (e.g. Subscription), you can select that here instead

    • This object needs to have at least one field that relates to the Account object (e.g. Account ID)

  3. Specify the field on that object that relates to Account (e.g. Account ID)

  4. Choose the field to filter the object on in Salesforce, and the field values specifying which records to sync. For example, this could be "Stage" equals "Closed Won"

  5. There are a series of dropdowns for standard revenue data. Select the field in Salesforce that corresponds to the relevant property in Planhat

    • The integration will not sync Licenses with no start date, but it will sync those with no end date (i.e. open-ended Licenses)

  6. Complete the "Default options for licenses" section. Like the one above, this consists of a series of dropdowns for you to select from

    • "Sync Licenses with zero values?"

      • It is possible to sync revenue records from Salesforce that have a 0 as a contract value (or MRR/ARR) but also negative values (e.g. credit notes) - if that's your case, simply set the option to "Yes"

      • Note that empty values in Salesforce are not considered as 0, and these records are always excluded from the sync

    • "Notice Unit" and "Notice Period"

      • Select Day/Week/Month and then a number, e.g. 30 days

      • This only impacts settings you are using our auto-renewal function

    • "Currency"

      • You can select any currency as the default

      • BUT if you have activated multi-currency in Salesforce, then instead of the option to select a default currency, a message will display saying: "Salesforce Account with Multicurrency ON". Your Licenses will then be mapped based on the currencies used in Salesforce

      • πŸ“Œ Note: You need to add these currencies to Planhat first, in the tenant settings

  7. Optionally, configure custom field mapping

  8. Press the "Save" button to save your configuration

πŸ“Œ Important to note

You need to complete "Start Date", "Notice Unit" and "Notice Period" as a minimum, in order to have the option to save.


Asset - your choice of object

πŸš€ Tip

Planhat Assets can be used in a variety of ways, but typical use cases are to represent products or departments. Time-series data can be associated with Assets. If you would like to learn more about Assets, see here, or speak to your TAM or CSM.

πŸ“Œ Important to note

If you don't currently have the Asset model available as part of your subscription, and would like to add it, reach out to your CSM.

  1. Choose the sync direction

  2. Choose which Salesforce object (standard or custom) to sync to Planhat Assets

  3. Specify the field on that object that relates to Account (e.g. Account ID)

  4. Optionally, choose a field to filter the object on, and field value(s) corresponding to the records that you would like to include in the sync

  5. Use the dropdown to select/confirm which field on the Salesforce object should map to the "Name" field on the Planhat Asset

  6. Optionally, configure custom field mapping

  7. Press the "Save" button to save your configuration


Project - your choice of object

πŸš€ Tip

Projects are initiatives that have a clear start and end date, such as competitions, courses or conferences. Time-series data can be associated with Assets. If you would like to learn more about Projects, see here, or speak to your TAM or CSM.

πŸ“Œ Important to note

If you don't currently have the Project model available as part of your subscription, and would like to add it, reach out to your CSM.

  1. Choose the sync direction

  2. Choose which Salesforce object (standard or custom) to sync to Planhat Projects

  3. Specify the field on that object that relates to Account (e.g. Account ID)

  4. Optionally, choose a field to filter the object on, and field value(s) corresponding to the records that you would like to include in the sync

  5. Use the dropdowns to select/confirm which field on the Salesforce object should map to particular fields on the Planhat Project:

    • "Name"

    • "Start Date"

    • "Mrr"

  6. Under "Default options for Projects", you'll see "Currency", like you saw in the License section

    • Either select a currency ...

    • Or if you have activated multi-currency in Salesforce, then instead of the option to select a default currency, a message will display saying: "Salesforce Account with Multicurrency ON"

  7. Optionally, configure custom field mapping

  8. Press the "Save" button to save your configuration


Custom (extended mapping) sections

In addition to the main, pre-configured sections, you can also add additional model/object sections at the bottom of the integration. You can use this to map to new Planhat models (i.e. that you haven't mapped yet), such as Opportunity, Invoice or Campaign; or to map an additional Salesforce object to a Planhat model you have already mapped.

πŸ“Œ Note

If you can't see the custom model/object mapping sections at the bottom but you would like to add this functionality to your subscription, reach out to your CSM.

Opportunity - Opportunity

While commonly you may map the Salesforce Opportunity object ("Closed Won" records only) to the Planhat License model, you may also want to sync open Opportunities in Salesforce to/from the Planhat Opportunity model. For example, if you are focusing on CSQLs (Customer Success Qualified Leads) you may want your CS team to identify the Opportunity, create it in Planhat and sync it to Salesforce, or you may just want full visibility for teams in both systems.

  1. Click the blue "Add New Section" button at the bottom

  2. Select "Opportunity" as both the Planhat model and Salesforce object

  3. Choose the sync direction

  4. Specify the field on the Salesforce Opportunity that relates to Account (e.g. Account ID)

  5. Choose the field to filter the object on in Salesforce, and the field values specifying which records to sync. For example, this could be "Stage" equals all options other than "Closed Won" and "Closed Lost"

  6. Optionally, configure custom field mapping

    • As discussed earlier in this article, in these optional custom sections, the field mapping section is actually even easier than in the default sections - you simply select the Planhat and Salesforce fields from dropdowns, and select the desired sync direction

  7. In these optional custom sections, there isn't a "Save" button, as the configuration is saved automatically

πŸ“Œ Note

The Salesforce Opportunity object has a required field "CloseDate", which is defined as "Date when the opportunity is expected to close", so you need to set up custom field mapping for this if you are syncing from Planhat to the Salesforce Opportunity object. Note, however, that the Planhat "closeDate" field is the actual close date, so isn't populated for open Opportunities in Planhat. You can map a custom date field instead.

Extension objects

You can use a custom section at the bottom of the integration to map extra Salesforce objects to an already mapped Planhat model - e.g. map a custom Salesforce object called "Account Extension" to the Planhat Company model, in addition to the Salesforce Account object already syncing to Company.

Technical deep-dive article

For a full discussion of extension object use cases, specifications and how to set this up, please see our separate article here.


Further reading

Did this answer your question?