Carousel Bulletin Impression Reports

Content

Impressions are tracked continuously for bulletins that are set to track. The data is staged each day and then written to an impression report each night. The current day will not be available in the report.

The format of the impression report is shown below.  Each day, each tracked bulletin will generate a line in the downloaded report, this consolidates the impressions so they are more manageable.  The time of impression is conveyed by a count in a time period for every 15 minutes throughout the day and the total is calculated:

Date,PageID,Type,Status,Description,ObjectType,DateTimeOn,DateTimeOff,CycleTimeOn,CycleTimeOff,ManualDuration,DwellTime,Days,Owner,DwellTime,RepeatInterval,SoundEnabled,WebEnabled,WordCount,PreviewUrl,Tags,ZoneID,Zone,00:00,00:15,00:30,00:45,01:00,01:15,01:30,01:45,02:00,02:15,02:30,02:45,03:00,03:15,03:30,03:45,04:00,04:15,04:30,04:45,05:00,05:15,05:30,05:45,06:00,06:15,06:30,06:45,07:00,07:15,07:30,07:45,08:00,08:15,08:30,08:45,09:00,09:15,09:30,09:45,10:00,10:15,10:30,10:45,11:00,11:15,11:30,11:45,12:00,12:15,12:30,12:45,13:00,13:15,13:30,13:45,14:00,14:15,14:30,14:45,15:00,15:15,15:30,15:45,16:00,16:15,16:30,16:45,17:00,17:15,17:30,17:45,18:00,18:15,18:30,18:45,19:00,19:15,19:30,19:45,20:00,20:15,20:30,20:45,21:00,21:15,21:30,21:45,22:00,22:15,22:30,22:45,23:00,23:15,23:30,23:45

The definitions of the report tables are described below.

• Date - The date of the tracked impression.

• PageID - The internal id of the page being tracked.

• Type - Indicates the type of bulletin.

• Status - The bulletin schedule status.

• Description - The name of the bulletin.

• ObjectType - The internal data object type.

• DateTimeOn - The date that the bulletin is active (ignored when ManualDuration is set).

• DateTimeOff - The date the bulletin will become inactive (ignored when ManualDuration is set).

• CycleTimeOn - The time of day the bulletin is scheduled to activate within the date time on/off range (ignore date in cycle field).

• CycleTimeOff - The time of day the bulletin is scheduled to deactivate within the date range (ignore date in cycle field).

• ManualDuration - Indicated whether the schedule is set to until manually turned off.

• DwellTime - The time the bulletin will display on the screen.

• Days - The days that the bulletin is active.

• Owner - The internal id of the bulletins owner.

• RepeatInterval - The interval that the bulletin is scheduled to repeat in the rotation.

• SoundEnabled - Indicates if sound is enabled on the bulletin.

• WebEnabled - Indicates whether or not the bulletin will display on the accessibility site.

• WordCount - The number of words detected on the bulletin (used to determine automatic dwell time)

• PreviewUrl - Internal file information.

• Tags - Tags associated with the bulletin.

• ZoneID - Represents the internal Zone ID

• Zone - The name of the zone in which the bulletins appear.

There is a health check that will allow you to easily see how many bulletins are tracked and in which zones those bulletins reside.  

Cleanup

Impression reports are removed after a certain number of days automatically so they don't ultimately consume the entire disk in a server.  The time at which the reports will be removed can be changed to match the user's preference but it is not available in the Carousel UI, it must be changed in the database Options table: ImpressionDays which is set to 365 by default.  The reports are saved in Media\BulletinReports\<year>\<month>\<day>.zip and can be deleted from the Windows Explorer with no disastrous effects if they are no longer needed.

The reports are compressed into .zip files when written to disk.

Health Check

There is a new health check that will show you how many bulletins are tracked, which zones those bulletins are on and how big the reports are.  This can be used by us to determine if the reports are getting out of control or to confirm bulletins are set to be tracked.