Filter App

How to use the filter app?


The Spotzi Filter App allows you to create advanced filters based on your data. This is very convenient if you quickly want to filter out data based on your characteristics. The Filter App is perfect for analyzing high-potential postal code areas or for creating interesting customer profiles of your data.

Below you can find a few step-by-step guides to:

Create a filter based on a numeric field


In this example we will filter a sample of  the US 5-digit ZIP code areas dataset containing total population and the total number of customers in that area. We are going to create a filter based on the number of customers in that area.

1. Open the map.

Numeric Map Filter

2. Now open the Filter App.

Numeric Map Filter

3. Choose the column that you want to use for creating your filter.

Numeric Map Filter

4. Pick a range. In this example I pick the areas where the total number of customers is between 15,000 and 18,322 (maximum number). It is also possible to add multiple ranges to your filter.

Numeric Map Filter

Ranges need to be of numeric data type
Keep in mind that you need a numeric field type in order to create ranges. This is well-documented in our article about data types. Remember that a postal code dataset sometimes contains postal codes of type text (string) . If you want to create a filter based on a specific postal code range you need to change the data type.

5. Press APPLY FILTER.

Numeric Map Filter

6. You have successfully added a filter to your map.

Numeric Map Filter

Create a filter based on a text field


In this example we will filter a sample of the US 5-digit ZIP code areas dataset containing total population and the total number of customers in that area. We are going to create a filter based on multiple area names.

1. Open the map.

Text Map Filter

2. Now open the Filter App.

Text Map Filter

3. Choose the column that you want to use for creating your filter.

Text Map Filter

4. Click SHOW VALUES to open the list with all available values.

Text Map Filter

5. Select the areas you want to show on the map.

Text Map Filter

6. Press APPLY FILTER.

Text Map Filter

7. You have successfully added a filter to your map.

Text Map Filter

Create a filter based on multiple fields


The true power of the filter app is the possibility to add multiple filters to your map. With these advanced filters you can filter and analyze data based on characteristics that are of interest to you. Create customer profiles based on your own custom filtering of the data and find out where your high potential customers are.

In the following example we will create an advanced data filter of our 5-digit ZIP code map with population and customer data. Within this dataset we will create a filter based on the total number of customers and the total population.

1. Open the map.

Multiple Map Filters

2. Now open the Filter App.

Multiple Map Filters

3. Choose the first column that you want to use for your filter.

Multiple Map Filters

4. Pick a range. In this example I pick the areas where the total number of customers is between 15,000 and 18,322 (maximum number). It is also possible to add multiple ranges to your filter.

Multiple Map Filters

5. Press ADD FILTER.

Multiple Map Filters

6. Choose the second column that you want to use for your filter.

Multiple Map Filters

7. Press APPLY FILTER.

Multiple Map Filters

8. You have successfully added a filter to your map.

Multiple Map Filters

Filter data by map layer


The Filter App also has the possiblity to filter data by layer. This allows you to only visualize areas within a certain buffer or only the addresses within a certain postal code area. In this example we will try to filter all the postal code areas that are located within a 60 minutes drive time range. This data is generated with the Drivetime App. To achieve this you have to take the following steps.

1. Open a new map and add the map layer with a drive time range and postal code areas.

Filter by Layer Step 1

2. Open the Filter App.

Filter by Layer Step 2

3. Click the postal code map layer and select the filter by layer option.

Filter by Layer Step 3

4. Select the layer that you will use for the filter.

Filter by Layer Step 4

5. Press APPLY to confirm.

Filter by Layer Step 5

6. You have successfully filtered the data.

Filter by Layer Step 6

Export data based on a filter


 It is also possible to export your filtered selection to CSV, Shapefile, geoJSON, KML or XML. You can use these files to create filtered shapefiles of your data, but it is also possible to add these locations in bulk to your online marketing campaign (e.g. Google AdWords, Facebook Ads).

1. Open the map with your applied filter.

Filter Map Export

2. Now choose the map layer that you want to export.

Filter Map Export

3. Choose the export data option, select the data format and click EXPORT DATA.

Filter Map Export

4. You have successfully exported your data.

Filter Map Export