We understand that stream traffic is crucial for you to understand how your event content did in terms of participant activity. In the end, the only way of knowing if your virtual, in-person, or hybrid event was successful is by going through feedback and data. 🎯 This article gives a stream traffic general overview to learn who watched a specific session or which companies were present at your event, export the stream interactions file, and analyze from scratch.
With our complete stream traffic reports, you can find out how many people were active during the event or what session was watched the longest, and much more. We'll go into detail later. Before that, let's open the file we'll be working with, the Stream name activity csv file, and open it on Google Sheets or your preferred tool.
For this case, we will be using Google Sheets and data results from our latest Virtual Shake Up 3.0 event.
You can start analyzing your data by exporting the stream activity file
Now that you exported the file, it's essential that you know the title definitions:
Let's start! 🚀
👉 Using Google Sheets for data analysis
Navigate to the Admin panel, - export the streaming traffic file: Stream name activity csv.
When importing the file to Google Sheets, the below pop-up will show
Select Create new spreadsheet and Comma as Separator type.
Click Import data.
Click on Open now.
It's good to know what the column title means, so you can understand what each means and how to read your data discoveries.
Definitions
Column title | Definition |
date | It’s the date of this specific interval to which the line relates. Specifically, the date and duration specified on the event details.
|
interval_start | Each interval consists of 15 mins. This column refers to the interval starting time, for instance, 09:00. |
interval_end | This column refers to the interval ending time, for example, 09:15. |
unique_viewers | The total amount of users that were watching the stream during this interval. For example, if one user watched 5 seconds at the beginning of the interval and then opened the stream again at the very end of it, it’ll be one user, not two. |
companies | The total number of unique companies for the users is identified in the column above. It can never be greater than the number of users. |
total_watch_time | This column refers to the total watch time of all viewers together in seconds. |
av_viewers | This column refers to the average viewer, calculated by dividing the Total Watch Time by all watchers at an interval duration (15 minutes). So, if two people watch half of the interval, you get one average viewer. For example, suppose Peter watched the first half and Patrick watched the second half. In that case, the amount of viewers at any given point is 1, while if they both only watched the first half, the attendance would first be two and then 0 for the second half of the interval, also averaging 1. |
total_view_count | These are clicks that users did during the interval. If a user opened it, closed it, and then opened it - there will be 2. |
What session had the most viewers?
To learn that, you need to have your schedule at hand. Below you see our Virtual Shake Up 3.0 agenda for the second day. With this, we have a timeframe to find what session was the most viewed during this day.
Once you have your event agenda, you can filter the table below that reflects the stream activity file you exported. The fastest way to learn how what session was the highest, it's by filtering the Unique Viewers from highest to lowest.
For example, the highest user activity is at the interval 10:45 -11:00 with 112 unique visitors during the event. It means that attendees were the most active from 10:45 to 11:45. In the table below, you can see that these intervals are also in the top 10.
Aligning our findings with our agenda, we can say that our "From a User Community to a Decision-Making Platform," "Mobility session," and "The 2021 Edelman Trust Barometer Session" were happening during the watch peak timeframe. So, we can confidently say that the most popular session during the event was the Mobility Session! 🤸
Attendees love a break and interactive session. The most popular session was an energizing session done by one of our founders. 💪
To give you a better idea of how the user activity looked during the whole event day. Check the video below.
What session was watched the longest?
Filter the Total Watch Time per interval column from Z-A. Now, we can see that the most-watched session was happening at intervals 12:30-12:45, 12:15-12:30, and 12:00-12:15. From the VSU 3.0 schedule, we can see that The "Neuroscience of Events" session was the session that got participants' attention and stuck till the end. Active users and unique viewers per interval results support this finding.
How many companies were present?
You can find the highest number of companies present by filtering the companies column from Z-A. With this, you can determine how many companies were present during specific sessions (intervals).
From the image below, we can see that there were 87 unique companies present at the event. This number was located on the second day of the VSU 3.0 between sessions "From a User Community to a Decision-Making Platform" and "Mobility session."
What was the highest average attendee per interval?
The average viewer is calculated by dividing the Total Watch Time by all watchers at an interval (15 minutes). So, if two people watch half of the interval, you get one average viewer.
For example, suppose Peter watched the first half and Nita watched the second half. In that case, the amount of viewers at any given point is 1, while if they both only watched the first half, the attendance would first be 2 and then 0 for the second half of the interval, also averaging 1.
The image below shows that the average density was 52.6 participants "watched the full session non-stop" from 12:30 to 12:45.
What session (interval) had the highest number of unique visits?
You can find the highest number of companies present by filtering the companies column from Z-A.
The highest total unique visits were 128 at intervals 10:30-10:45. Unique visits are clicks that attendees did during the interval. For example, if an attendee opened it, closed it, and then opened it - there will be 2.
