Cisco Cisco StadiumVision Mobile Reporter Manual De Mantenimiento
© 2011 Cisco Systems, Inc. All rights reserved. This document is Cisco Internal Information.
Page 18 of 28
•
The cumulative time a piece of content was displayed by a specific Group
or Zone association.
Generating Pivot Table Reports
To extract some meaningful information from the proof of play data, you can
create a PivotTable
create a PivotTable
®
report in Microsoft
®
Excel. A PivotTable is an interactive
table that automatically extracts, organizes, and summarizes your data. You
can control how MS Excel summarizes the data—for example, by sum,
average, or count—without entering a single formula. In a PivotTable report,
you can quickly:
can control how MS Excel summarizes the data—for example, by sum,
average, or count—without entering a single formula. In a PivotTable report,
you can quickly:
•
Add or remove categories of data
•
Rearrange the data
•
View a subset of the data
•
Show the details you want
The following links provide examples of proof of play files that were created
using the PivotTable
using the PivotTable
®
report functionality in Microsoft
®
Excel. These
examples are referenced in the following sections of this guide.
•
example_pivot.xlsx –
•
example_min_pivot.xlsx –
When you open the example_pivot.xlsx file, there are four tabs:
•
Example Data Set tab: Default view which shows the entire proof of play
data set.
•
Total Plays in Venue tab: Displays a basic play count of each ad listed
by content filename and any associated content tags, detailed by group
and zone.
and zone.
•
Summarized Play Time tab: Adds a “Played …” column to each group
and zone. This column takes the number of plays and multiplies it by the
length of time the content played to establish a total amount of time the
content aired per group and zone.
length of time the content played to establish a total amount of time the
content aired per group and zone.
•
Content Time Stamps tab: Lists all the timestamps of proof of play per
content filename.
Applying Filters to PivotTables
You can adjust the proof of play reporting view by applying filters to the
PivotTable as described here. For more details on working with PivotTables,
see Appendix A.
PivotTable as described here. For more details on working with PivotTables,
see Appendix A.