Filters

 

Main Filters

Trends provides you to apply filters using single click instant filters or apply filters using Filter Builder (with basic and advance filtering options).

Filter Builder (based on Dimensions)

Easily visualize side-by-side comparisons based on advanced filter settings, in the dimension tables with links to Trends.

Click New Trends: Build and Compare Filters GIF to watch an example on building a filter.

After zoom, select and dimension filters, you can create the filters to see the specific data. Along with the single click filters you can create dimension filters based on equals and contains filter options.

For example, create a dimension filter for asset analysis that does not contain video trailers.

Trends allows you to create a complex filter with conditions easily. Also, you can filter the unknowns and compare the between Basic and Advance modes using the toggle.

The Advanced option allows you to easily see the conditions applied and modify the filters. This advance mode allows you to change the condition equals and not equals on the fly.

For example, set the advance filter for specific device groups while filtering out irrelevant assets to the performance analysis, such as trailers, older players, and viewers from less relevant geographies.

Note:  When you add data from the same dimension table, it creates a logical OR, and when you add data from different dimension tables, it creates a logical AND during the filter creation.

Filtering Unknowns

You can create one click instant filter on the unknown dimension values and drill down to the discover the details of the dimension values.

Standalone Compare

Trends provides a new instant compare mode, allowing you to easily compare in basic and advanced modes.

1. Select Old Compare from the drop-down.

   

2. Select the dimensions within or across the dimension table.

Compare In Trends

Trends offers instant comparison of filters for the top dimension entities or across a custom dimension filters. You can add up to 20 filters to compare the data.

For more information on Compare Integrated in Trends, see Compare.

Annotate in Diagnostics and Compare dashboard

You can also annotate on the Diagnostics and the Compare dashboards.

Annotate in Diagnostics

• Click Annotate on the diagnostics view of the desired metric.

• Click on the timeline to see the annotations popup page.

Annotate in Compare

• Click Annotate on the compare page.

• Click on the timeline to see the annotations popup page.

  

  You can export the annotation data along with comments from the page export option in action bar.

  Note: c3.[accountname] is mentioned in the exported file.

  For more information on adding custom text to the metric widgets, see Annotations.

  Search in customize drop-down

  Enhanced the customize drop-down in viewer sessions with the search facility to search the desired dimensions.

  

Using Secondary Filters

To create the secondary filters:

• Click Distribution on the metric widget.

  

• Select the distribution bucket (bars).

  

• This creates a metric filter and filters the data in all the other metric widgets, displaying the primary filter (blue) and the secondary (black) trends in the time series.

  

The metrics which support distribution and metric filters are:

• Audience and Engagement: Average % Complete, Ended Play Duration

• Startup Experience: Video Start Time, Video Start Failure, Video Start Failure Business, Video Start Failure Technical, Exit Before Video Starts, Starting Bitrate, Exit During Pre-Roll

• Playback Experience: Video Playback Failures, Video Playback Failures Business, Video Playback Failures Technical, Rebuffering Ratio, Connection Induced Rebuffering Ratio, Connection Induced Interrupted Plays, Video Restart Time, Avg. Peak Bitrate, Average Framerate, Avg. Average Bitrate, Bitrate Switches, Paused Ratio, Paused Time, CIR Related Exits, Exit During Pre-Roll

Log Scale

1. Apply a secondary filter.

2. Click the Focus button.

   

3. Click the Log Scale toggle button to see the bar graph view of the metric.

   

Secondary and Companion Metrics

For each filtered metric, a secondary metric along with the Unique Devices companion metric display for additional comparative analysis.

• Secondary metric for different comparisons across startup and playback experience.

• Companion metric for comparison based on unique devices.

Startup Experience Metrics	Secondary Metric (Y axis in distribution)
VSF, VSF-B, VSF-T, EBVS, Exit During Pre-Roll, Abandonment	Attempts
Starting Bitrate	Ended Plays
Video Start Time, High Start Time	Plays

 

Playback Experience Metrics	Secondary Metric (Y axis in distribution)
VPF, VPF-B, VPF-T, VRT, Connection Induced Interrupted Plays, Paused Time, Paused Ratio, Avg. Average Bitrate, Average Peak Bitrate, Bitrate Switches	Ended Plays
Rebuffering Ratio, CIRR, Average Framerate	Plays

For example, for VPF the secondary metric displays the number and percent of related ended plays impacted by the playback failures. The Unique Devices companion metric displays as the Unique Devices, devices related to the ended plays, and Impacted Unique Devices, devices related to the ended plays but also including devices from early exits and start failures. These device metrics help you analyze and compare the number and percent of devices impacted by the metric across all sessions versus the filtered sessions.

Note: You can switch between viewing the metrics as a numerical value or a percentage by using the toggle button.

In this example of metric filtering on VPF, secondary metric is Ended Plays and companion metric is Unique devices and Impacted Unique Devices with number and percent values.

Column	Description
Ended Plays	The number of Ended Plays (from the Ended Plays metric widget) during the selected time period as the secondary metric. Compare with the metric filter version to determine the number of impacted ended plays.
[SF] Ended Plays	The number of Ended Plays (based on the metric filter) during the selected time period for the filtered sessions as the filtered version of the secondary metric. Compare with the metric widget version to determine the number of impacted ended plays.
[SF] Ended Plays%	The percentage of the impacted Ended Plays during the selected time period for the filtered sessions, enhancing the filtered version of the secondary metric. Shows the percent of the ended plays as [MF] ended plays. The Ended Plays secondary metric value for the selected time period is 115K. The number of ended plays impacted with the metric filter of VPF< 4 seconds is 22K Play, which accounts for 19.2% of the total Ended Plays.
Unique Devices	The number of unique devices (based on ended plays) during the selected time period (matching the Unique Devices metric widget) as the companion metric. Compare with the metric filter version to determine the number of impacted unique devices.
[SF] Unique Devices	The number of Unique Devices (based on the metric filter) during the selected time period for the filtered sessions as the filtered version of the secondary metric. Impacted unique devices includes devices for the ended plays along with early exits and startup failures.
[SF] Unique Devices%	The percentage of the impacted Unique Devices (based on the metric filter) during the selected time period for the filtered sessions, enhancing the filtered version of the companion metric. Impacted unique devices includes devices for the ended plays along with early exits and startup failures. The devices shown in the example indicate the Apple iPhone is a high impacted device with the metric filter setting for less than 4 seconds of VPF. The Unique Devices companion metric shows the values of 46.2K total unique devices with ended plays, and 10.4K devices as impacted unique devices, which accounts for 22.6% of the total unique devices.

Based on the metric filter settings, the Apple iPhone experiences a considerable amount of playback failures that could impact a large number of unique devices. Hence, it may be wise to closely monitor this device as you work to address the issue, as its users are heavily impacted.

 

Improved VSF/VPF Error Code Diagnostics with Analysis Across Impacted Devices and Sessions

Previous error code diagnostics was limited to only device analysis, so if an error occurred on 80% of Roku devices, Roku devices appeared associated with the cause of the error. Applying a Secondary Filter (SF), for example VPF-T > 4 seconds, displays the percentage of errors by ended plays for both sessions and devices. The difference in error distribution across devices and sessions indicates how much of the error is associated with the device. In this case, 80% of the Roku sessions and 80% of the Roku devices were impacted, a balanced occurrence across devices and traffic.

However with iOS, the error rate was 7.99% of the sessions and 14.7% of SF unique devices, indicating an association of the device with increased VPF-T error rates.

 

 

 

Quick Error Filtering

To provide a better error code analysis, Quick Error Filtering in Trends allows applying a single-click secondary filter for one or more error codes. This functionality enhances the impact measurement and facilitates a quick understanding of the dimension with a higher value for a given error. For instance, it allows users to easily identify the impacted unique devices affected by a specific error.

To apply error filtering,

• Select the VSF or VPF metric (Tech and Business)

• Click one or more error codes on Technical Error Code dimension data.

  

  A secondary filter is applied and the secondary Unique Devices metric is displayed.

  

  The dimension data is updated based on the filter applied.

  

• Click the Old Error diagnostics icon to see the error diagnostics dashboard.

  

• Check the details to analyze the data on the error diagnostics dashboard.

  

Quick Boolean Filter

In order to obtain the number of unique devices that have VSF-T or VPF-T for a specific device, geo, or any other metadata cohort, trends enable you to apply a single click secondary filter on all VSF-T/VPF-T and automatically include the [SF] Unique Devices column in the Dimension table, along with the corresponding percentage column.

To apply the Boolean filter

• Click the Error filter icon on the metric widget.

  

  Secondary Boolean filter is applied for the metric.

  

  [SF] Unique Devices column is added in the dimension table.

  

You can do the error code diagnostics within Trends which is more flexible.

 

Filtering Filters Filtering Filters Filtering Filters Secondary Filters Secondary Filters Secondary Filters Compare Filtering