The All-Event Export (i.e., raw event export), accessible from the Dashboard, allows you to download raw, detailed audience consumption events in CSV format. For valuable insight, you can filter this data by date range enabling correlation and comparison with other datasets, such as departmental or territory information from your HRIS or performance data in your sales enablement tool.
Given the granularity of the data—where a single user interaction with a single episode can generate over a hundred events—be mindful that the resulting file size may exceed the processing capabilities of standard spreadsheet software. To manage this, consider limiting the date range to reduce data volume or use our analytics API to integrate with your BI tool of choice. Contact support@ustudio.com for more information about leveraging our analytics API.
The following values are Included in the All-Event Export:
- Timestamp - The date and time the event happened in UTC. The format is “YYYY-MM-DD HH:MI:SS”.
- User_Id - The unique uStudio ID of the User that prompted this event.
-
Event_Type - The type of event that happened. Event types include:
- download - The user downloaded an episode
- login - The user logged into the podcast application (note, this should not be interpreted as unique sessions, as login is not required with each session)
- played_time - Corresponds to a player.progress event for each 1% of an Episode consumed. The “Played_Time” field shows the number of seconds consumed for each 1% of the Episode.
- player.impression - The media player was loaded.
- player.play - The media was played.
- player.progress - Corresponds to a played_time event for each 1% of an Episode consumed. The “Progress” field shows the percent of the Episode consumed.
- player.ratechange - The user changed the speed of the content playback.
- share - The user shared an Episode
- subscribe - The user subscribed or unsubscribed from a Show. If is_active is true (1), the user subscribed. If is_active was false (0), the user unsubscribed.
- Show_Title - The title of the Show of the Episode that was consumed.
- Episode_Title - The title of the Episode that was consumed.
- Played_Time - For the played_time event, shows the number of seconds in 1% of the Episode consumed.
- Is_Active - True or false value for the like and subscribe events.
- Show_Id - The unique uStudio ID of the Show. This is necessary because Show titles may change over time, but the ID never changes.
- Episode_Id - The unique uStudio ID of the Episode. This is necessary because Episode titles may change over time, but the ID never changes.
- Application - Will have a value of WEB or MOBILE when the event is triggered from within the uStudio application. Value can also represent an external application, such as “SharePoint”, to indicate events that were triggered from an embed.
- Email - The email address of the User that fired this event (if available).
- Group - A list of Group IDs of which the User was a member when this event fired.
Formatting Your User Activity Report:
The User Activity Report comes as a CSV file and there are a few quick tips you can do to help you find your information a little faster.
- Open the file in Excel and save as a .xlsx file, or import the file into BI tool like PowerBI.
- By default, the file is sorted by timestamp. If you want to sort your file in a different way here are a few suggestions:
- Sort your file by events to see all the downloads, logins, etc grouped together
- Sort your file by show to see how a particular show is doing
- Add filters to the file and use these to filter down to certain shows, episodes, or actions.
- Filter your event type by progress and then filter out all percentages except for major milestones like 10% increments or 20% increments to see where your user base is focusing their time.
Learn more about all the sections of the Dashboard.
- Program Overview
- Usage Trends
- Program Content Metrics
- Named User Analytics
- All-Event Export
