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.
- Navigate to Profiles > Segments and click Add new segment.
- Select New and enter a name for the segment.
- In Step 2, select a profile and click Next.
- In Step 3, select the headers from the profile and click Next.
- In Step 4, create a filter with the desired condition. For example, filter1 is created to fetch records where "Age is greater than 40 and less than 60 ". You can click + Add conditions 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 9215 records.
- To add another filter, click on *Add filter and add the condition.
For example, a filter2 is created to fetch records where "DEVICE_OS equal to Android". For this filter, we have 14570 records.
- Now add filter3 to fetch records where "SALARY is greater than 40000". For this filter, we have got 11345 records.
- To change the filter sequence, drag the 3rd filter header and drop it above the 1st filter.
- Click Update final count of all filters. For this filter, we have 1345 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.
- On the Segments list screen click Add new segment and enter a name for the segment.
- In Step 2, select 2 data sources and specify a relationship using the same data type for the selected header.
- In Step 3, select the required headers from both the data sources as shown below.
- 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.
- 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.
- Click Check filter to fetch the segment results.
Updated 4 months ago