1. Help Center
  2. Event Data & Reports
  3. πŸ“– Understanding the Brella Traffic Analytics

A Quick Glance to Your Event Stream Traffic Results using Google Sheets

Learn to read what session had the most viewers and what time your viewers were the most active on the streams tab, and more!

We know 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.

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:

Once you know the definitions, let's start answering the most asked questions regarding streams data:

Let's start! πŸš€

🎯 This article gives a stream traffic general overview if you wish to learn who watched a specific session or which companies were present at your event, export the stream interactions file, and analyze from scratch.

πŸ‘‰ Using Google Sheets for data analysis

  1. Go to the Admin panel, and export the streaming traffic file: Stream name activity csv.
  2. When importing the file to Google sheets, this page will show (below) select Create new spreadsheet and Comma as Separator type.

  3. Click Import data.
  4. And click on Open now.
  5. Once the file opens, you will see a piece of tabular information. 

  6. To analyze your data, you need to start filtering the columns as explained in the questions below. Please note that the graphs are made in Google Data Studio, which can also be done in Google Sheets as you go. In case you are unfamiliar with Google Sheets, there are plenty of Youtube tutorial videos on how to use filters, etc.

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 use 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 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 avg 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.

⚑ Let's say your event is over, and now you're ready to start seeing the results!

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 fast 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-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 Mobility Session! 🀸

Attendees love a break and interactive session. The most popular session was an energizing session done by one of our founders. πŸ’ͺ

What session was the most popular at quick glance?

To give you a better idea of how the user activity looked during the whole event day. Check the video below.

stream traffic activity

      *Unique visitors on the second day of VSU 3.0 made in Google Data Studio*.

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, 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."

companies present at event

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-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.

Screenshot 2021-04-20 at 22.51.03

 


Last updated on April 2021. 

Written by Stephanie Campano Valenzuela. 

Stephanie-rounded

If you didn’t find an answer to your questions, please contact the Support Team here.

πŸ‘‡