Filtering your Imports

Section header image mobile

Coefficient imports can pull in a good amount of data from a connected source - putting filters in place on those imports will allow you to keep the imports focused and objective in your analysis.

How to Add a Filter to Your Coefficient Import?

Filtering Logic and Limits

Logic

Limits

Dynamic Filters

Coefficient Filters vs. Google Sheets Filters

Coefficient Filters

Google Sheet Filters

How to Add a Filter to Your Coefficient Import?

Example: Add filter(s) to an existing Salesforce Opportunity import to capture only the Forecast that is in the category “Pipeline”.

1. Open the Coefficient Sidebar and select the import you would like to edit, “Opportunity”.

Screenshot 2023-11-24 at 1.23.25 AM.png

2. Scroll down to “Filters” and select “Add Filter”.

 

Screenshot 2023-12-08 at 12.46.00 AM.png

3. Select the "Forecast Category" field and choose “is one of”. Select "Pipeline" from the list of values, then click “Save & Run”.

Screenshot 2023-12-08 at 12.50.13 AM.png

4. Your Opportunity import will now only reflect “Pipeline” records from Salesforce. 🎉

Screenshot 2023-12-08 at 12.54.47 AM.png

ℹ️ NOTE: Depending on the data type of the field you are using as a filter, you may need to adjust the logic being added to it. In our example, we selected “is one of” since the Stage field is a picklist type of data in Salesforce. You can filter by Number, Text, Date, Boolean, Picklist, and Multi-Picklist.

Filtering Logic and Limits

When incorporating 2 (or more) filters into your import, you now have the flexibility to employ AND/OR logic. It's important to be aware that the data source API might impose restrictions on the number of filters or their application. If you encounter any issues or errors related to the filters during your import, feel free to contact our Support team at support@coefficient.io for assistance. Check out the dedicated integration article for more information on filters/limits. 

Dynamic Filters

Dynamic Filters allow you to point your filter value to a specific cell on your spreadsheet and constantly change the cell value without making any changes to your import settings. This allows for additional flexibility and granularity with your imports. 😎

Example: We will use the same Salesforce Opportunity import and add a dynamic filter to capture only the Opportunities with Amounts≥ $15,000.

1. In a new sheet, add the value 15,000 to cell A1.

d1.png

2. Open the sidebar, select the import “Opportunity” and add a filter. Then, select “Amount” and enter “Filter Sheet”!A1 in the value box. Save and run your import, and the data will filter based on A1.

d2.png

3. Congratulations on creating your first Dynamic Filter using Coefficient. Anytime you want to adjust the value of the import results, update the value in A1 and refresh your import. 🎉

d3.png

Coefficient Filters vs. Google Sheets Filters

Coefficient Filters

Coefficient Filters allow the data that is imported to be focused on what you truly need for analysis and keep your tab/sheet lightweight and dedicated to the goal and purpose. This also keeps the data in the Sheet small to avoid hitting the Google Sheet limitations.

Screenshot 2023-12-08 at 12.48.09 AM.png

Google Sheet Filters

Google Sheets Filters allow you to have more of the data that may be needed but include more data and the potential for larger analysis.

To learn more about Google Sheets filters, click here.Screenshot 2023-12-08 at 1.12.31 AM.png                                                                         

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