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.