Building Metrics with New Relic Insights

Pairing our fully-functional, free trial, Datazoom account with your New Relic Insights account, you can build a number of metrics to help you understand your users' experience. The examples below provide some simple steps to get you started. Please review and complete our New Relic Insights Connector steps before you begin. Doing so will ensure that you can take advantage of the Datazoom free trial while utilizing New Relic Insights to understand your data.

If you haven't already done so, please review New Relic Insights documentation to familiarize yourself with terminology and NRQL, the query language that you'll be using to build metrics.

Creating the Metrics

Prerequisites

You should have already created a Collector for your video player and have its configuration deployed. 

You should have already created a Connector for New Relic Insights and have it as part of your Data Pipe with at least the following data points selected:
Bitrate
First_Frame
Play_Request
sessionViewId
timeSinceRequested

Create a new dashboard

Refer to the New Relic Insights documentation for more complete instructions on creating and managing dashboards.

1. Login to New Relic and navigate to their Insights product
2. Click the + next to All Dashboards to start with a new dashboard
   
   

Create a metric for the number of minutes watched

1. Copy and paste the following into the Query Builder then click Run

   SELECT sum(timeSinceLastHeartbeat/60000) as 'minutes' from `Datazoom Video` where actionName = 'FLUXDATA' or actionName = 'CONTENT_END' or actionName = 'CONTENT_QUARTILE'

2. Give the metric a Title then click Add to this dashboard
   
   

Create a metric for the number of content requests

1. Copy and paste the following into the Query Builder then click Run
   

   SELECT count(*) as 'requests' FROM `Datazoom Video` where actionName = 'CONTENT_REQUEST'

2. Give the metric a Title then click Add to this dashboard
   
   

Create a metric for the number of content starts

1. Copy and paste the following into the Query Builder then click Run
   

   SELECT count(*) as 'starts' FROM `Datazoom Video` where actionName = 'CONTENT_START'

   
   

2. Give the metric a Title then click Add to this dashboard
   
   

Create a metric for the average bitrate

1. Copy and paste the following into the Query Builder then click Run
   

   SELECT average(contentRenditionBitrate)/1000/1000 as MB FROM `Datazoom Video`

   
   

2. Give the metric a Title then click Add to this dashboard