Update Import Fields for Salesforce/HubSpot Templates

Section header image mobile

ℹ️ NOTE: For templates using other data sources, please refer here.

 

Coefficient Templates use a pre-defined selection of data fields and filters to power your dashboard. However, in many cases, you may prefer to use your company’s custom fields instead.

Here is a simple guide to help you update the default fields with your own when connecting with Salesforce or HubSpot CRM templates.

In this example: Let’s say you are replacing the field "Churn Date" with your custom field called "Contract End Date" in our HubSpot MRR Template.


1. Launch Coefficient on your copy of a template spreadsheet by going to the Extensions menu and selecting Coefficient: Salesforce, Hubspot Data Connector.

Untitled (18).png

2. In the right sidebar, select the import which contains the fields you need to replace. (Example: " HubSpot Import")

Screenshot 2023-08-10 at 11.56.22 PM.png

3. Scroll down and click on + Add fields.

Screenshot 2023-08-10 at 11.57.32 PM.png

4. Select the field(s) you would like to add. (Example: Add "Contract End Date")

Screenshot 2023-08-10 at 11.59.05 PM.png

5. Uncheck the field(s) you are replacing, so that your new field takes the same position in the list order. (Example: We unchecked Churn Date to remove it from our list, Contract End Date.)

ℹ️ NOTE: If you are replacing a field that is not at the bottom of the list, you will need to drag your new field to the position immediately below the one you are replacing, BEFORE unchecking/removing the original field. This ensures that the new field lands in the same column as the original field.

Screenshot 2023-08-11 at 12.00.55 AM.png

6. Repeat the above steps for any other fields you would like to replace with custom fields. Once done, click on “Save and Run” to update your import and refresh your dashboard.

Screenshot 2023-08-11 at 12.01.50 AM.png

Was this article helpful? 0 out of 0 found this helpful