Cisco Cisco StadiumVision Mobile Streamer Maintenance Manual
© 2011 Cisco Systems, Inc. All rights reserved. This document is Cisco Internal Information.
Page 17 of 28
Table 8.
KORE CSV File Data
Data
Description
Content
File name of the content.
State Start
Timestamp for when the event state started.
Device Count
Number of DMPs on which the content was played.
Zone
Zone which the DMP is a member of.
Action
Commands to the DMP attached display (reserved).
Time Played
How long the content played.
Airtime
Actual time that the ad played out.
Region
Region of the screen template where the content played.
SeqNum
Sequence number beginning at event start increment by ad play.
Event Date
Date of event.
Script Name
Name of event script that played.
Group
Group which the DMP is a member of.
State Name
Name of the event state that was active when the content was displayed.
Playlist Name
Name of the content playlist.
Content Tags_PoP
Tags assigned to the content.
Receive
Interpolated airtime timestamp by using received time (obsolete).
PlaylistNum
Item number in the playlist.
Processing KORE CSV Files
The KORE CSV file is the result of post processing the main proof of play file
and condensing it by collapsing multiple entries with the same time played
stamp into a single record or row. Once the data set is in this format, it is
much more manageable (around 5-10 MB for the average event) and can be
further manipulated in Microsoft Excel.
and condensing it by collapsing multiple entries with the same time played
stamp into a single record or row. Once the data set is in this format, it is
much more manageable (around 5-10 MB for the average event) and can be
further manipulated in Microsoft Excel.
The advantage of using desktop software like Microsoft Excel is that it
provides the ability to share, modify and distribute the information to others
depending on their needs. By leveraging the inherent functionality of the
Pivot Table feature in Excel, many views into the KORE CSV data can be
accomplished. For example you can set filters to view:
provides the ability to share, modify and distribute the information to others
depending on their needs. By leveraging the inherent functionality of the
Pivot Table feature in Excel, many views into the KORE CSV data can be
accomplished. For example you can set filters to view:
•
Only the game states that represent the time period of interest.
•
When and where content played by content file name and any included
tags.
•
The total number of plays for a piece of content throughout the venue.
•
The total number of plays for a piece of content by specific Group or Zone
association.
•
The cumulative time a piece of content was displayed throughout the
venue.