Руководство По Обслуживанию для Cisco Cisco StadiumVision Mobile Streamer
© 2011 Cisco Systems, Inc. All rights reserved. This document is Cisco Internal Information.
Page 19 of 28
Time Stamp Filtering
Since proof of play reporting starts when the event script begins – usually
before the event – and ends well after the event, you may need to make
some adjustments to the data to retrieve an accurate accounting of plays
during the actual event versus the timeframe the event script was running.
You can do this by setting a filter in the PivotTable so that the proof of play
report displays only proof of play data for content that displayed during the
actual event. In the example_pivot.xlsx file, you can set this filter in cell B2.
before the event – and ends well after the event, you may need to make
some adjustments to the data to retrieve an accurate accounting of plays
during the actual event versus the timeframe the event script was running.
You can do this by setting a filter in the PivotTable so that the proof of play
report displays only proof of play data for content that displayed during the
actual event. In the example_pivot.xlsx file, you can set this filter in cell B2.
In Figure 14, the filter is has been adjusted to remove play information
outside the duration of the game. Unchecking the “Daily” part of the event
script activities causes matching proof of play entries to drop from the report.
outside the duration of the game. Unchecking the “Daily” part of the event
script activities causes matching proof of play entries to drop from the report.
Figure 14. Time Stamp Filtering
Content Filtering
In the example_pivot.xlsx file, cell A7 contains a content filter to trim the
entire list of content filenames to just the “what” items you are interested in.
Individual content items can be selected for the report, or a standing pattern
matching filter can be established for the report.
entire list of content filenames to just the “what” items you are interested in.
Individual content items can be selected for the report, or a standing pattern
matching filter can be established for the report.
In this example, the content filenames that start with “R2” detail the region 2
advertising content. By setting up a “Begins With” filter in the “By label:” filter
space with a value of “R2_P”, the report will list only region 2 content. In this
example, the region 2 content is the team’s self-promotion advertisements.
advertising content. By setting up a “Begins With” filter in the “By label:” filter
space with a value of “R2_P”, the report will list only region 2 content. In this
example, the region 2 content is the team’s self-promotion advertisements.