Community reporting
Canvas Views report
The main advantage of Canvas Views is the ability to analyse visitor activity on various canvases for each attendee, as well as overall. This feature provides insights into attendee behaviour, allowing you to determine the number of unique visitors to each canvas and track when each canvas was first viewed per attendee.
Column Headers
The column headers for Block Metrics are constructed as follows:
Canvas ID | Canvas Name | data type
For example:
canvas 144 | Session Canvas: Broadcast | Views
canvas 144 | Session Canvas: Broadcast | First Viewed
Data
Views: This indicates the number of times an attendee has loaded a canvas. If an attendee has not accessed a canvas, a zero will be displayed in that cell.
First Viewed: This presents a timestamp of the date in 24-hour time format of when the canvas or page was first loaded.
Summarise Data
Using Microsoft Excel, you can easily add SUM or COUNT formulas at the bottom of the dataset to summarise the number of times a canvas was viewed or the total number of unique attendees. For enhanced reporting, consider using the SUBTOTAL formula, which updates dynamically when filters are applied to the data.
The subtotal formula consists of the SUBTOTAL function, an option to specify the type of subtotal and the range of cells to which the formula is applied. Please note that the steps outlined here may differ if you use Google Sheets or other applications.
For example, to count how many attendees viewed a canvas, the following formula could be applied to the First Viewed column:
=SUBTOTAL(3, W2:W99)
Alternatively, to find the total number of times a canvas has been viewed by all attendees, the following formula could be applied to the Views column:
=SUBTOTAL(9, W2:W99)
Please note that analysis via Google Sheets or other applications may differ from the steps outlined here.
Notes:
It’s best practice to name your canvases in the Community configuration thoughtfully. Including descriptive identifiers such as the session, vendor, or page name in the Canvas Name field will improve the reporting experience by facilitating organisation and sorting. For example, “Sales 101 session”.
Block Metrics report
The key benefit of Block Metrics is the visibility it provides into attendee interactions across the various blocks throughout an event’s Community. This feature helps you identify the most popular aspects of the Community, track attendee engagement with content, measure duration, and assess overall participation in the event.
Various block metrics columns will be populated with different data depending on the block type.
Column Headers
The column headers for Block Metrics are constructed as follows:
Block type | Block ID | Block Name | Interaction
For example:
Live Stream data
Block Type: simulated_live_stream | ID: 1514 | Lobby Live stream #1 | First Playback
Block Type: simulated_live_stream | ID: 1514 | Lobby Live stream #1 | Time Watched
Live Chat data
Block Type: live_chat / ID: 648 / Session 1 / Participated
Live Reactions data
Block Type: live_reaction / ID: 655 / Session 1 / Reacted: Like
Block Type: live_reaction / ID: 655 / Session 1 / Reacted: Celebrate
Quick Survey
Block Type: quick_survey / ID: 924 / Session 1 / Responded: Rate this session
Data
Live Stream
- Time Watched shows the total duration that attendees watched the live stream, presented in a time format.
- First Playback includes a timestamp of the date in 24-hour time format of when the block was first watched
Live Chat
Live Chat reporting identifies whether attendees interacted with various live chat blocks within the Community. A “Y” will be displayed if an attendee participated, while a blank cell indicates no participation.
Live Reactions
Live Reaction data indicates how many times an attendee interacted with each reaction type in a
Live Reaction block. Where no interactions have been recorded, a zero will be presented in the cell.
Video On Demand
- First Playback includes a timestamp of the date in 24-hour time format of when the block was first watched
- Plays indicate how many times the attendee has clicked the play button
Interaction data for other block types follows the same concept.
Additional and more specific results can be achieved via Explore Interactions in Jomablue.
Summarise Data
In Microsoft Excel, you can easily add SUM or COUNT formulas at the bottom of the dataset to summarise attendee interaction with a block, total minutes consumed for a Live Stream, or the number of unique attendees. Using a SUBTOTAL formula can help dynamically update totals based on applied filters.
The subtotal formula consists of the SUBTOTAL function, an option specifying the type of subtotal you wish to apply and the range of cells the formula is applied to.
For example, to count how many attendees participated in Live Chat, the following formula could be applied:
=SUBTOTAL(3, W2:W99)
Alternatively, to count how many times a Live Reaction type was selected by all attendees, the following formula could be applied:
=SUBTOTAL(9, W2:W99)
Please note that analysis via Google Sheets or other applications may differ from the steps outlined here.
Notes:
When naming your blocks in the Community configuration, it’s recommended to include details such as the session or vendor and the content in the Block Name field. This practice improves the reporting experience by aiding in the grouping and sorting of blocks, for example, “Sales 101 Session - Workshop 3 VOD.”
When summing a range of cells that represent duration (e.g., Broadcast or Live Stream blocks), ensure the cell number format is set correctly in Excel:
- Locate the column containing the Time Watched
- Select the cell that includes the formula
- Within the Number section of the Home ribbon, choose the dropdown
- Select More Number Formats…
- Select Custom from the Category section
- Scroll through the Type section and select [h]:mm:ss
If this option doesn’t exist, you can type “[h]:mm:ss” into the dialogue box at the top of the Type section - Press OK
In the number formatting, the square brackets around the “h” (representing hours) ensure values greater than 24 will be displayed and not converted to days. For example, without the square brackets, a value of 30 will be displayed as 6, as in “1 day and 6 hours” and the number of days may not be displayed unless the cell was formatted as d:hh:mm.
