Note: For templates using Salesforce or HubSpot, 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 own custom fields instead.

This simple guide will help you update the default fields with your own when connecting to your data source.

In this example: Let’s say you are replacing the field Quantity with your custom field called Current Quantity on our Shopify Sales template.

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

1. In the right sidebar, click on the import which contains the fields you need to replace. (Example: ⚡ Line Items)

1. Scroll down and click on Edit fields.

1. Find and select the Current Quantity field. It will be added as the right-most column in your preview.

1. Drag and drop the new field (Current Quantity) so that it is immediately next to the ****field you are replacing (Quantity).

1. Uncheck/remove the field from those listed on the left of the Preview to exclude that field from your import. Repeat steps 3-5 for any additional fields you would like to replace. Then click Done when finished.