Once you’ve added data sources in the Data Manager, you’re ready to start structuring your report. This entails choosing which information will be included in the report itself.

With fields you can add or remove categories of information you want to be included in your report using the  buttons. The selected fields will be shown as columns in your report document.

Via Alias you’re able to set individual names for your fields, which will be shown instead of the field name in the report document.

Possible fields are:

• clipDuration: Duration of the clip in seconds.milliseconds.
• clipTitle: Name of the content clip given in Creator.
• clipType: The kind of clip played (e.g. Movie, HTML or Image).
• count(*): Number of members in a grouping.
• date: Recorded date of the csv file.
• displayName: Given name of the display the content was played.
• durationPlayed: The amount of time the clip was played.
• end: End time of the played content.
• layer: The layer on which the content was played.
• playerName: Name of the player the content was played on.
• start: Start time of the played content.
• sum(clipDuration): Summed up all clip durations of the members of the grouping.
• sum(durationPlayed): Summed up all played durations of the members of the grouping.
• valid: Readiness of the content at the scheduled time.

Filters

If you would like to include or exclude special parameters from your report, you can add a filter to a particular field by double clicking on that section.

The criteria specified will display/leave out information accordingly in the generated report.

Recommendation

When filtering the specific media type “Arrangement” we recommend to use this with fitting “clipName”.

Grouping

You can group entries in the report by creating a grouping in the section on the right. By default, there are already four groupings available, as these are the most common (playerName, displayName, clipTitle, clipType).

Groupings take similar entries in the CSV files and compile them together. This makes the report easier to read and more organized.

Duration Format

You can format duration times in your report as hh:mm:ss:msmsms by selecting the “Duration formatted” option at the bottom of the Fields and Grouping section. Otherwise, durations are simply listed in seconds.

Custom SQL

Use this option to create a custom SQL command.
By default, there already is an SQL command entered but you may want to change this if you need to use different placeholders ($from, $to, $players and $displays).