Skip to main content
Skip table of contents

Data Exports

This page gives a high-level, generic overview of regular data exports. All export fields for all operators are listed below. Data in either .csv or parquet file format is currently exported every 24 hours into general purpose Amazon S3 buckets in Prod accounts.

Details of data exports are only available on agreement with Nagravision.

Exact locations of S3 buckets are operator-specific and therefore not shown on this page. Please contact a Nagra representative for further details.

Additionally, certain data export fields may not be available depending on data reported by end user devices in different deployment contexts.

Data Exports

Data Export

Description

device

Device information extracted from the playback metrics. Describes the type of device on which content is watched e.g. STB, Handheld.

event_error

Error events (extracted from the playback_event table).

playback_event

Events as they are collected by the agent. Typical events are play, stop, playing, stalled, error, etc.

playback_metric

Metrics are produced at regular intervals (defined by the sampling interval configuration parameter of the agent, typically set to 30 seconds) and contain aggregated values of what happened in the player during the interval like, for example, the number of seconds during which a content was played.

N.B For the OPF solution, the data point frequency will be once every 5 minutes or significant change, a significant change being something other than a timestamp, offset or progress change. 

replay_session

Replay sessions are created when a subscriber watches replays of live content.

programme_session

Programme sessions are created by matching the channel sessions and the EPG.

vod_session

VOD sessions are created when a subscriber watches on-demand content.

channel_session

Channel sessions are created when a subscriber watches a live TV channel.

channel

Name of channel, available for Live or Replay

programme

Export Events which are starting on day of the event.

e.g. for export date = 2023-06-25 .

event start date from 2023-06-25 00:00:00 till 2023-06-25 23:59:59.

Specific Details

device

Name

Type

Description

id

STRING

Unique device identifier

device_type

STRING

Type of device, like stb or handheld

manufacturer

STRING

The device manufacturer

model

STRING

The device model

os_type

STRING

The kind of OS running on the device as reported by the agent like ios, android, linux, etc.

os_version

STRING

The version of the OS running on the device

application_name

STRING

The name of the player application

application_version

STRING

The version of the player application

user_id

STRING

The user identifier as specified in the agent configuration

account_id

STRING

The account identifier as specified in the agent configuration

event_error

Name

Type

Description

session_id

STRING

Unique playback session identifier

device_id

STRING

Unique device identifier

error_code

STRING

Code of the error

. timestamp

TIMESTAMP

Date and time of when the error occured. Format is ISO and timezone is UTC.

error_message

STRING

Message of the error

playback_event

Name

Type

Description

session_id

STRING

Unique playback session identifier

timestamp

BIGINT

Timestamp of the event. Format is ISO and timezone is UTC.

device_id

STRING

Unique device identifier

device_type

STRING

Type of device, like stb or handheld

playback_timezone

STRING

Timezone of the device. Format is ISO.

name

STRING

Name of the event

properties_error_code

STRING

Error code, available when the name is "error"

properties_error_message

STRING

Error message, available when the name is "error"

properties_time_to_video_start

INT

Time to video start, available when the name is "timeToVideoStart"

properties_selected_bitrate

INT

Bitrate value, available when the name is "selectedBitrateChanged"

properties_all

STRING

All of the event's properties serialized as a JSON string

playback_metric

Name

Type

Description

session_id

STRING

Unique playback session identifier

timestamp

BIGINT

Timestamp at which the metric was produced. Format is ISO and timezone is UTC.

viewing_seconds

INT

Number of seconds during which a content was viewed

buffering_seconds

INT

Number of seconds during which a spinning wheel was displayed

frame_drops

INT

Number of frames dropped

average_bitrate

INT

Average content bitrate

bitrate_switches

INT

Number of time the bitrate changed

bitrate_downgrades

INT

Number of time the bitrate changed to a lower value

bitrates

ARRAY

List of available bitrates

offset_from_live

INT

Number of seconds behind the live stream, available for LIVE

content_type

STRING

Type of content like LIVE, VOD, CU, DVR, etc

channel_id

STRING

Channel identifier, available for live or replay

channel_name

STRING

Name of the channel, available for live or replay

content_id

STRING

Content identifier, available for VOD

content_name

STRING

Name of the content, available for VOD

event_id

STRING

Program identifier, available for replay

event_name

STRING

Name of the program, available for replay

duration

INT

Content duration in seconds, available for VOD and replay

content_completion_percent

INT

Percentage of the content that was viewed, available for VOD and replay

content_completion_minutes

INT

Number of minutes viewed, available for VOD and replay

content_quality

STRING

Quality of the content, like HD, SD, HDTV or UHD

content_uri

STRING

URI loaded by the player to start the playback

device_id

STRING

Unique device identifier

device_type

STRING

Type of device, like stb or handheld

hardware_manufacturer

STRING

The device manufacturer

hardware_model

STRING

The device model

os_type

STRING

The kind of OS running on the device as reported by the agent like ios, android, linux, etc.

os_version

STRING

The version of the OS running on the device

application_name

STRING

The name of the player application

application_version

STRING

The version of the player application

playback_timezone

STRING

Timezone of the device. Format is ISO.

network_connection

STRING

The kind of network connection of the device like wifi, ethernet, etc.

user_id

STRING

The user identifier as specified in the agent configuration

account_id

STRING

The account identifier as specified in the agent configuration

account_corp

STRING

The account CORP value

account_node

STRING

The account NODE value

replay_session

Name

Type

Description

session_id

STRING

Unique playback session identifier

device_id

STRING

Unique device identifier

start_ts

TIMESTAMP

Timestamp at which the session started (ie. timestamp of the first metric). Format is ISO and timezone is UTC.

end_ts

TIMESTAMP

Timestamp at which the session ended (ie. timestamp of the last metric). Format is ISO and timezone is UTC.

duration

INT

Duration of the session in seconds

channel_id

STRING

Live channel identifier

programme_id

STRING

Programme identifier

replay_type

STRING

Type of replay like CU or DVR

completion_percent

INT

Percentage of the content that was viewed, available for VOD and replay

total_viewing_seconds

INT

Amount of seconds during which a content was playing

total_viewing_seconds_bad

INT

Amount of seconds during which a content was playing and the QoE was bad

total_viewing_seconds_acceptable

INT

Amount of seconds during which a content was playing and the QoE was acceptable

total_viewing_seconds_good

INT

Amount of seconds during which a content was playing and the QoE was good

total_viewing_seconds_unknown

INT

Amount of seconds during which a content was playing and the QoE was unknown

total_buffering_seconds

INT

Amount of seconds during which a spinning wheel was displayed to the user

buffering_ratio

DOUBLE

Ratio between the buffering seconds and the duration of the session

buffering_rate

DOUBLE

Average count of stalled events per minute

avg_time_to_start

DOUBLE

Number of milliseconds between when the user pressed play and when the first frame was rendered

sum_framedrops

INT

Number of frames dropped during the session

sum_bitrate_switches

INT

Number of bitrate changes during the session

sum_bitrate_downgrades

INT

Number of time the bitrate changed to a lower value during the session

avg_bitrate

DOUBLE

Average bitrate for the session

bitrates

STRING

List of available bitrates

count_stalled_events

INT

Number of stalled events that occurred during the session

count_bitrate_switch_events

INT

Number of selectedBitrateChanged events that occurred during the session

count_error_events

INT

Number of error events that occurred during the session

application_name

STRING

The name of the player application

application_version

STRING

The version of the player application

valid

BOOLEAN

Whether the session is considered valid by our backend

valid = False if playback session for which the sum of viewing seconds + buffering seconds is 0

programme_session

Name

Type

Description

session_id

STRING

Unique playback session identifier

device_id

STRING

Unique device identifier

start_ts

TIMESTAMP

Timestamp at which the session started (ie. timestamp of the first metric). Format is ISO and timezone is UTC.

end_ts

TIMESTAMP

Timestamp at which the session ended (ie. timestamp of the last metric). Format is ISO and timezone is UTC.

duration

INT

Duration of the session in seconds

channel_id

STRING

Live channel identifier

programme_id

STRING

Programme identifier

completion_percent

INT

Percentage of the content that was viewed, available for VOD and replay

offset_from_start

INT

Number of seconds, from the program start, after which the session starts

offset_from_end

INT

Number of seconds left in the program when the session ends

total_viewing_seconds

INT

Amount of seconds during which a content was playing

total_viewing_seconds_bad

INT

Amount of seconds during which a content was playing and the QoE was bad

total_viewing_seconds_acceptable

INT

Amount of seconds during which a content was playing and the QoE was acceptable

total_viewing_seconds_good

INT

Amount of seconds during which a content was playing and the QoE was good

total_viewing_seconds_unknown

INT

Amount of seconds during which a content was playing and the QoE was unknown

total_buffering_seconds

INT

Amount of seconds during which a spinning wheel was displayed to the user

buffering_ratio

DOUBLE

Ratio between the buffering seconds and the duration of the session

buffering_rate

DOUBLE

Average count of stalled events per minute

avg_time_to_start

DOUBLE

Number of milliseconds between when the user pressed play and when the first frame was rendered

sum_framedrops

INT

Number of frames dropped during the session

sum_bitrate_switches

INT

Number of bitrate changes during the session

sum_bitrate_downgrades

INT

Number of time the bitrate changed to a lower value during the session

avg_bitrate

DOUBLE

Average bitrate for the session

count_stalled_events

INT

Number of stalled events that occurred during the session

count_bitrate_switch_events

INT

Number of selectedBitrateChanged events that occurred during the session

count_error_events

INT

Number of error events that occurred during the session

vod_session

Name

Type

Description

session_id

STRING

Unique playback session identifier

start_ts

TIMESTAMP

Timestamp at which the session started (ie. timestamp of the first metric). Format is ISO and timezone is UTC.

end_ts

TIMESTAMP

Timestamp at which the session ended (ie. timestamp of the last metric). Format is ISO and timezone is UTC.

duration

INT

Duration of the session in seconds

device_id

STRING

Unique device identifier

content_vod_id

STRING

On-demand content identifier

completion_percent

INT

Percentage of the content that was viewed, available for VOD and replay

total_viewing_seconds

INT

Amount of seconds during which a content was playing

total_viewing_seconds_bad

INT

Amount of seconds during which a content was playing and the QoE was bad

total_viewing_seconds_acceptable

INT

Amount of seconds during which a content was playing and the QoE was acceptable

total_viewing_seconds_good

INT

Amount of seconds during which a content was playing and the QoE was good

total_viewing_seconds_unknown

INT

Amount of seconds during which a content was playing and the QoE was unknown

total_buffering_seconds

INT

Amount of seconds during which a spinning wheel was displayed to the user

buffering_ratio

DOUBLE

Ratio between the buffering seconds and the duration of the session

buffering_rate

DOUBLE

Average count of stalled events per minute

avg_time_to_start

DOUBLE

Number of milliseconds between when the user pressed play and when the first frame was rendered

sum_framedrops

INT

Number of frames dropped during the session

sum_bitrate_switches

INT

Number of bitrate changes during the session

sum_bitrate_downgrades

INT

Number of time the bitrate changed to a lower value during the session

avg_bitrate

DOUBLE

Average bitrate for the session

bitrates

STRING

List of available bitrates

count_stalled_events

INT

Number of stalled events that occurred during the session

count_bitrate_switch_events

INT

Number of selectedBitrateChanged events that occurred during the session

count_error_events

INT

Number of error events that occurred during the session

application_name

STRING

The name of the player application

application_version

STRING

The version of the player application

valid

BOOLEAN

valid = False if playback session for which the sum of viewing seconds + buffering seconds is 0

Whether the session is considered valid by our backend

channel_session

Name

Type

Description

session_id

STRING

Unique playback session identifier

device_id

STRING

Unique device identifier

start_ts

TIMESTAMP

Timestamp at which the session started (ie. timestamp of the first metric). Format is ISO and timezone is UTC.

end_ts

TIMESTAMP

Timestamp at which the session ended (ie. timestamp of the last metric). Format is ISO and timezone is UTC.

duration

INT

Duration of the session in seconds

channel_id

STRING

Live channel identifier

total_viewing_seconds

INT

Amount of seconds during which a content was playing

total_viewing_seconds_bad

INT

Amount of seconds during which a content was playing and the QoE was bad

total_viewing_seconds_acceptable

INT

Amount of seconds during which a content was playing and the QoE was acceptable

total_viewing_seconds_good

INT

Amount of seconds during which a content was playing and the QoE was good

total_viewing_seconds_unknown

INT

Amount of seconds during which a content was playing and the QoE was unknown

total_buffering_seconds

INT

Amount of seconds during which a spinning wheel was displayed to the user

buffering_ratio

DOUBLE

Ratio between the buffering seconds and the duration of the session

buffering_rate

DOUBLE

Average count of stalled events per minute

avg_time_to_start

DOUBLE

Number of milliseconds between when the user pressed play and when the first frame was rendered

sum_framedrops

INT

Number of frames dropped during the session

sum_bitrate_switches

INT

Number of bitrate changes during the session

sum_bitrate_downgrades

INT

Number of times the bitrate changed to a lower value during the session

avg_bitrate

DOUBLE

Average bitrate for the session

bitrates

STRING

List of available bitrates

count_stalled_events

INT

Number of stalled events that occured during the session

count_bitrate_switch_events

INT

Number of selectedBitrateChanged events that occured during the session

count_error_events

INT

Number of error events that occured during the session

application_name

STRING

The name of the player application

application_version

STRING

The version of the player application

valid

BOOLEAN

Whether the session is considered valid by our backend

valid = False if playback session for which the sum of viewing seconds + buffering seconds is 0

channel

Name

Type

Description

channel_name

STRING

Name of channel, available for live or replay

 corrupted

BOOLEAN

Hardcoded to False. Reserved for future usage.

 id

STRING

Unique device identifier

 local_id

STRING

Unique locality identifier

programme

Name

Type

Description

 id

STRING

Unique programme identifier

 content_id

STRING

Unique content identifier

 channel_id

STRING

Unique channel identifier

 name

STRING

Programme name

 start_ts

INT

Start time of event

 end_ts

INT

End time of event

 start_date

STRING

  • start_date is calculated form the start_ts. The timestamp is interpreted in the time zone of the customer (America/Bogota for Claro) and formatted as « yyyyMMdd »

  • The same logic applies to start_time, the value is the number of minutes since midnight (i.e. hour * 60 + minutes)

  • We use those columns as foreign keys to days and minutes dimensions, allowing to store calendar data.

 duration

INT

Session duration in seconds

Detailed information on export script-based validation, comparisons, analyses, redshift queries, bug fixes and sanity checks may be obtained from Nagra support.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.