Changing the sequence of filters

When you create a segment and apply filters, the sequence of the filters can be changed to retrieve the desired results.

Creating multiple filters using a single data source

Let us see this with an example.

1. Navigate to Profiles > Segments and click Add new segment.
2. Select New and enter a name for the segment.

3. In Step 2, select a profile and click Next.

3. In Step 3, select the headers from the profile and click Next.

4. In Step 4, create a filter with the desired condition. For example, a filter is created to fetch records where "DeviceOS is equal to Android or iOS". You can click + Add more to add more conditions to a filter.

When you click on Check filter, the filter gets executed with the configured condition and the results will be displayed. For the above filter, we have got 2397 records.

5. To add another filter, click on Add filter + and add the condition.

For example, a 2nd filter is created to fetch records where "Gender is equal to male". For this filter, we have got 1417 records.

6. Now add another filter to fetch records where "Age is greater than 35". For this filter, we have got 899 records.

7. To change the filter sequence, drag the 3rd filter header and drop it above the 1st filter.

8. Click Check filter. For this filter, we have 1489 records.

You will notice that based on the sequence of the filters, the record count will change.

Creating filters using multiple data sources

It is possible to create a segment using multiple data sources and create filters on both data sources as desired. When you select multiple data sources you have to specify a relationship between the data sources using the same data type for the selected headers in both the data sources.

1. On the Segments list screen click Add new segment and enter a name for the segment.
2. In Step 2, select 2 data sources and specify a relationship using the same data type for the selected header.

3. In Step 3, select the required headers from both the data sources as shown below.

4. In Step 4, enter a name for the filter and select a data store to apply the required filters. Click Add Filter +, to add a filter on the other data store.

5. Enter a name for the filter and select a data store to apply the required filters. Apply the conditions Exclude, Include, or filter. In the above example, Exclude is selected.
6. Click Check filter to fetch the segment results.