Building Metrics with New Relic One

Pairing our fully-functional, free trial, Datazoom account with your New Relic One 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 One Connector steps before you begin. Doing so will ensure that you can take advantage of the Datazoom free trial while utilizing New Relic One to understand your data.

If you haven't already done so, please review Introduction to NRQL 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 One and have it as part of your Data Pipe with at least the following data points selected:
Content Session ID
Media Request
Media Type
Playback Start
Playback Duration - Content
Rendition Video Bitrate

Create a new dashboard

Refer to the Introduction to dashboards for more complete instructions on creating and managing dashboards.

1. Login to New Relic and navigate to Dashboards
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(Content_Minutes) FROM (SELECT max(playback_duration_content_ms)/60000 as 'Content_Minutes'FROM Datazoom FACET content_session_id LIMIT MAX) LIMIT MAX

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 sum(Content_Requests) FROM (SELECT count(*)  AS 'Content_Requests' FROM Datazoom WHERE (actionName = 'media_request' AND media_type = 'content') LIMIT MAX) 

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 sum(Content_Starts) FROM (SELECT count(*)  AS 'Content_Starts' FROM Datazoom WHERE (actionName = 'playback_start' AND media_type = 'content')  LIMIT MAX)

   
   

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(rendition_video_bitrate_kbps) /1000 AS 'Average Bitrate' FROM Datazoom

   
   

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