Zoom Power BI Connector: Webinars, Meetings, Calls

Zoom Power BI connector by VIDI enables you to analyze all your zoom calls, web meetings as well as the webinar registrants & participants. Here is what you get:

All your Zoom data connected to Power BI automatically
A free customisable Zoom Power BI Template
Store the data in the database or data warehouse of your choice
Customize or enhance data based on your requirement

Zoom Power BI Dashboards

How Our Zoom Power BI connector works?

Create a serverless job on the cloud of your choice to fetch the data from zoom accounts on a regular basis
Store the data in the database or data warehouse of your choice. You can either bring your own database or we can create a new one for this. It can be any SQL database or warehouse e.g (SQL Server, Postgresq, Mysql, BigQuery, Snowflake, etc.,)
You can let us know the customisations you want to perform on your data. This includes any transformations that are to be performed to match with your organisation’s standards
You can tell us the list of tables that you are looking for in zoom and we can fetch only them
You can also tell us how your report should look like and we can store the data in the format which is ready to consume

This is a lightweight serverless solution which drastically reduces the cost with minimal monitoring and offers lots of customisations.

Zoom Power BI Connector Tables

Below are the list of tables we are extracting

Webinars

Webinars table scheduled by or on behalf a webinar host

Column Name	Data Type	Description
agenda	String	Webinar description. The agenda length gets truncated to 250 characters when you list all webinars for a user. To view the complete agenda, retrieve details for a single webinar,
created_at	DateTime	The webinar’s creation time.
duration	Integer	The webinar’s duration, in minutes.
host_id	String	The host’s ID.
id	Integer	The webinar ID.
join_url	String	The URL to join the webinar.
start_time	DateTime	The webinar’s start time.
timezone	String	The Webinar’s timezone
topic	String	The webinar’s topic.
type	Integer	The webinar type.5 – A webinar.6 – A recurring webinar without a fixed time.9 – A recurring webinar with a fixed time.
uuid	String	The webinar’s universally unique identifier (UUID). Each webinar instance generates a webinar UUID.
is_simulive	Boolean	Whether the webinar is simulive.

Registrants

All the users that are registered for a webinar

Column Name	Data Type	Description
id	String	Registrant ID.
address	String	The registrant’s address.
city	String	The registrant’s city.
comments	String	The registrant’s questions and comments.
country	String	The registrant’s two-letter ISO country code.
custom_questions	Array of Object	Information about custom questions.<title, value>
email *	Email	The registrant’s email address. See Email address display rules for return value details.
first_name *	String	The registrant’s first name. Constraints: Max 64 chars.
industry	String	The registrant’s industry.
job_title	String	The registrant’s job title.
last_name	String	The registrant’s last name. Constraints: Max 64 chars.
no_of_employees	Enum	The registrant’s number of employees in range.
org	String	The registrant’s organization.
phone	String	The registrant’s phone number.
purchasing_time_frame	Enum	The registrant’s purchasing time frame.
role_in_purchase_process	Enum	The registrant’s role in the purchase process.
state	String	The registrant’s state or province.
status	Enum	The status of the registrant’s registration.
zip	String	The registrant’s ZIP or postal code.
create_time	Date-Time	The time when the registrant registered.
join_url	String	The URL that an approved registrant can use to join the meeting or webinar.
webinar_id	Integer	Id of the webinar

Polls

Polls in a webinar

Column Name	Data Type	Description
id	String	ID of the Poll.
status	Enum	Status of the Poll.
anonymous	Boolean	Allow meeting participants to answer poll questions anonymously.
poll_type	Integer	The type of poll.
questions	Array	Information about the poll’s questions.
title	String	Pool’s title
webinar_id	Integer	Id of the webinar

Participants

list of all the participants who attended a webinar hosted in the past.

Column Name	Data Type	Description
id	String	The participant’s unique identifier.
name	String	The participant’s name.
user_id	String	The participant’s ID assigned upon joining the webinar.
registrant_id	String	The participant’s unique registrant ID. Returns only if the registrant_id value is passed for include_fields query parameter. Does not return if the type query parameter is set to live.
user_email	Email	Email address of the participant. Returns an empty string if the participant is not part of the host’s account, with some exceptions.
join_time	DateTime	The participant’s join time.
leave_time	DateTime	The participant’s leave time.
duration	Integer	The participant’s attendance duration.
failover	Boolean	Indicates whether failover occurred during the webinar.
status	Enum	The participant’s status.
total_records	Integer	The total number of records available across all pages.
webinar_id	Integer	Id of the webinar

Absentees

List absentees of a webinar.

Column Name	Data Type	Description
id	String	Registrant ID.
address	String	The registrant’s address.
city	String	The registrant’s city.
comments	String	The registrant’s questions and comments.
country	String	The registrant’s two-letter ISO country code.
custom_questions	Array	Information about custom questions.
email *	Email	The registrant’s email address. See Email address display rules for return value details.
first_name *	String	The registrant’s first name. Constraints: Max 64 chars.
industry	String	The registrant’s industry.
job_title	String	The registrant’s job title.
last_name	String	The registrant’s last name. Constraints: Max 64 chars.
no_of_employees	Enum	The registrant’s number of employees.
org	String	The registrant’s organization.
phone	String	The registrant’s phone number.
purchasing_time_frame	Enum	The registrant’s purchasing time frame.
role_in_purchase_process	Enum	The registrant’s role in the purchase process.
state	String	The registrant’s state or province.
status	Enum	The status of the registrant’s registration.
zip	String	The registrant’s ZIP or postal code.
create_time	DateTime	The time when the registrant registered.
join_url	String	The URL that an approved registrant can use to join the meeting or webinar.
webinar_id	String	Id of the webinar

We can fetch more tables based on the requirement like

Panelists
Past webinar pools
Meetings
Billing reports