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

Calls

Column Name	Data Type	Description
id	INT	Unique identifier for each call record.
direction	VARCHAR(10)	Direction of the call (e.g., “inbound”, “outbound”).
international	BOOLEAN	Indicates if the call was international (true/false).
department	VARCHAR(50)	Department associated with the call.
duration	INT	Duration of the call in seconds.
call_id	VARCHAR(50)	Unique identifier for the call (provided by Zoom or other system).
connect_type	VARCHAR(20)	Type of connection (e.g., “PSTN”, “VoIP”).
call_type	VARCHAR(20)	Type of call (e.g., “audio”, “video”).
caller_name	VARCHAR(100)	Name of the caller.
caller_did_number	VARCHAR(20)	Direct Inward Dialing (DID) number of the caller.
caller_number_type	VARCHAR(20)	Type of caller’s number (e.g., “mobile”, “landline”).
caller_country_iso_code	VARCHAR(5)	ISO country code of the caller’s location.
caller_country_code	VARCHAR(5)	Country code of the caller’s phone number.
callee_ext_id	VARCHAR(50)	Extension ID of the callee (if applicable).
callee_name	VARCHAR(100)	Name of the callee.
callee_email	VARCHAR(100)	Email address of the callee.
callee_did_number	VARCHAR(20)	Direct Inward Dialing (DID) number of the callee.
callee_ext_number	VARCHAR(20)	Extension number of the callee (if applicable).
callee_ext_type	VARCHAR(20)	Type of callee’s extension (e.g., “internal”, “external”).
callee_number_type	VARCHAR(20)	Type of callee’s number (e.g., “mobile”, “landline”).
callee_country_iso_code	VARCHAR(5)	ISO country code of the callee’s location.
callee_country_code	VARCHAR(5)	Country code of the callee’s phone number.
site_id	VARCHAR(50)	Identifier for the site associated with the call.
site_name	VARCHAR(100)	Name of the site associated with the call.
start_time	DATETIME	Timestamp when the call started.
end_time	DATETIME	Timestamp when the call ended.
call_result	VARCHAR(50)	Result of the call (e.g., “completed”, “missed”, “busy”).
recording_status	VARCHAR(20)	Status of the call recording (e.g., “available”, “unavailable”).
load_date	DATETIME	Timestamp when the record was loaded into the database.

Meetings

Column Name	Data Type	Description
uuid	VARCHAR(36)	Unique identifier for the meeting (UUID format).
id	VARCHAR(50)	Unique identifier for the meeting (provided by Zoom or other system).
topic	VARCHAR(255)	Topic or title of the meeting.
host	VARCHAR(100)	Name of the meeting host.
email	VARCHAR(100)	Email address of the meeting host.
user_type	VARCHAR(20)	Type of user (e.g., “host”, “co-host”, “participant”).
start_time	DATETIME	Timestamp when the meeting started.
end_time	DATETIME	Timestamp when the meeting ended.
duration	INT	Duration of the meeting in minutes.
participants	INT	Number of participants in the meeting.
has_pstn	BOOLEAN	Indicates if the meeting had PSTN (Public Switched Telephone Network) users.
has_archiving	BOOLEAN	Indicates if the meeting was archived.
has_voip	BOOLEAN	Indicates if the meeting had VoIP (Voice over IP) users.
has_3rd_party_audio	BOOLEAN	Indicates if the meeting had 3rd-party audio participants.
has_video	BOOLEAN	Indicates if the meeting had video participants.
has_screen_share	BOOLEAN	Indicates if screen sharing was used in the meeting.
has_recording	BOOLEAN	Indicates if the meeting was recorded.
has_sip	BOOLEAN	Indicates if SIP (Session Initiation Protocol) was used in the meeting.
has_manual_captions	BOOLEAN	Indicates if manual captions were enabled in the meeting.
has_automated_captions	BOOLEAN	Indicates if automated captions were enabled in the meeting.
has_meeting_summary	BOOLEAN	Indicates if a meeting summary was generated.
audio_quality	VARCHAR(20)	Overall audio quality of the meeting (e.g., “good”, “poor”).
video_quality	VARCHAR(20)	Overall video quality of the meeting (e.g., “good”, “poor”).
load_date	DATETIME	Timestamp when the record was loaded into the database.

Users

Column Name	Data Type	Description
id	VARCHAR(50)	Unique identifier for the user (provided by Zoom or other system).
first_name	VARCHAR(100)	First name of the user.
last_name	VARCHAR(100)	Last name of the user.
display_name	VARCHAR(150)	Display name of the user (e.g., full name or nickname).
email	VARCHAR(100)	Email address of the user.
type	INT	Type of user (e.g., 1 for basic, 2 for licensed, 3 for on-prem).
pmi	VARCHAR(20)	Personal Meeting ID (PMI) of the user.
timezone	VARCHAR(50)	Timezone of the user.
verified	BOOLEAN	Indicates if the user’s email is verified (true/false).
created_at	DATETIME	Timestamp when the user account was created.
language	VARCHAR(10)	Language preference of the user (e.g., “en” for English).
status	VARCHAR(20)	Status of the user (e.g., “active”, “inactive”, “pending”).
role_id	VARCHAR(50)	Identifier for the user’s role (if applicable).
user_created_at	DATETIME	Timestamp when the user was created (if different from created_at).
last_login_time	DATETIME	Timestamp of the user’s last login.
last_client_version	VARCHAR(20)	Version of the client used during the user’s last login.
phone_number	VARCHAR(20)	Phone number of the user.
dept	VARCHAR(100)	Department the user belongs to.
employee_unique_id	VARCHAR(50)	Unique identifier for the employee (if applicable).
pic_url	VARCHAR(255)	URL of the user’s profile picture.
load_date	DATETIME	Timestamp when the record was loaded into the database.

Call logs

column_name	data_type	description
id	BIGINT	Unique identifier for the call record.
direction	VARCHAR(20)	Direction of the call (e.g., inbound, outbound).
international	BOOLEAN	Indicates if the call was international.
duration	INT	Duration of the call (in seconds).
call_id	VARCHAR(50)	Unique identifier for the specific call instance.
connect_type	VARCHAR(20)	Type of connection for the call.
call_type	VARCHAR(20)	Type of the call (e.g., voice, video).
caller_name	VARCHAR(100)	Name of the caller.
caller_did_number	VARCHAR(20)	Dialed number identification of the caller.
caller_number_type	VARCHAR(20)	Type of the caller’s number (e.g., mobile, landline).
caller_country_iso_code	VARCHAR(3)	ISO code of the caller’s country.
caller_country_code	INT	Country code of the caller.
callee_ext_id	BIGINT	Extension ID of the callee.
callee_name	VARCHAR(100)	Name of the callee.
callee_did_number	VARCHAR(20)	Dialed number identification of the callee.
callee_ext_number	VARCHAR(20)	Extension number of the callee.
callee_ext_type	VARCHAR(20)	Type of the callee’s extension.
callee_number_type	VARCHAR(20)	Type of the callee’s number (e.g., mobile, landline).
callee_country_iso_code	VARCHAR(3)	ISO code of the callee’s country.
callee_country_code	INT	Country code of the callee.
site_id	BIGINT	Identifier for the site associated with the call.
site_name	VARCHAR(100)	Name of the site associated with the call.
start_time	DATETIME	Time when the call started.
answer_time	DATETIME	Time when the call was answered.
end_time	DATETIME	Time when the call ended.
call_result	VARCHAR(20)	Result of the call (e.g., connected, missed).
recording_status	VARCHAR(20)	Status of the call recording.
department	VARCHAR(100)	Department associated with the call.
caller_ext_id	BIGINT	Extension ID of the caller.
caller_email	VARCHAR(100)	Email address of the caller.
caller_ext_number	VARCHAR(20)	Extension number of the caller.
caller_ext_type	VARCHAR(20)	Type of the caller’s extension.
caller_device_type	VARCHAR(50)	Type of device used by the caller.
callee_email	VARCHAR(100)	Email address of the callee.
spam	BOOLEAN	Indicates if the call was identified as spam.
group_id	BIGINT	Identifier for the group associated with the call.
callee_employee_id	BIGINT	Employee ID of the callee.
caller_employee_id	BIGINT	Employee ID of the caller.
load_date	DATETIME	Date when the call record was loaded into the system.

Call Logs Detail

column_name	data_type	description
id	BIGINT	Unique identifier for the call record.
direction	VARCHAR(20)	Direction of the call (e.g., inbound, outbound).
international	BOOLEAN	Indicates if the call was international.
duration	INT	Duration of the call (in seconds).
call_id	VARCHAR(50)	Unique identifier for the specific call instance.
connect_type	VARCHAR(20)	Type of connection for the call.
call_type	VARCHAR(20)	Type of the call (e.g., voice, video).
caller_name	VARCHAR(100)	Name of the caller.
caller_did_number	VARCHAR(20)	Dialed number identification of the caller.
caller_number_type	VARCHAR(20)	Type of the caller’s number (e.g., mobile, landline).
caller_country_iso_code	VARCHAR(3)	ISO code of the caller’s country.
caller_country_code	INT	Country code of the caller.
callee_ext_id	BIGINT	Extension ID of the callee.
callee_name	VARCHAR(100)	Name of the callee.
callee_email	VARCHAR(100)	Email address of the callee.
callee_did_number	VARCHAR(20)	Dialed number identification of the callee.
callee_ext_number	VARCHAR(20)	Extension number of the callee.
callee_ext_type	VARCHAR(20)	Type of the callee’s extension.
callee_number_type	VARCHAR(20)	Type of the callee’s number (e.g., mobile, landline).
callee_country_iso_code	VARCHAR(3)	ISO code of the callee’s country.
callee_country_code	INT	Country code of the callee.
site_id	BIGINT	Identifier for the site associated with the call.
site_name	VARCHAR(100)	Name of the site associated with the call.
start_time	DATETIME	Time when the call started.
end_time	DATETIME	Time when the call ended.
answer_time	DATETIME	Time when the call was answered.
caller_ext_id	BIGINT	Extension ID of the caller.
caller_email	VARCHAR(100)	Email address of the caller.
caller_ext_number	VARCHAR(20)	Extension number of the caller.
caller_ext_type	VARCHAR(20)	Type of the caller’s extension.
caller_device_type	VARCHAR(50)	Type of device used by the caller.
department	VARCHAR(100)	Department associated with the call.
caller_employee_id	BIGINT	Employee ID of the caller.
callee_employee_id	BIGINT	Employee ID of the callee.
load_date	DATETIME	Date when the call record was loaded into the system.

Call Logs Paths

column_name	data_type	description
id	BIGINT	Unique identifier for the event record.
direction	VARCHAR(20)	Direction of the event (e.g., inbound, outbound).
international	BOOLEAN	Indicates if the event was international.
event	VARCHAR(50)	Type or name of the event.
result	VARCHAR(50)	Result of the event.
node	VARCHAR(100)	Node or server involved in the event.
segment	VARCHAR(50)	Segment or part of the system related to the event.
call_id	VARCHAR(50)	Unique identifier for the call instance.
connect_type	VARCHAR(20)	Type of connection for the event.
call_type	VARCHAR(20)	Type of the call (e.g., voice, video).
caller_name	VARCHAR(100)	Name of the caller.
caller_did_number	VARCHAR(20)	Dialed number identification of the caller.
caller_number_type	VARCHAR(20)	Type of the caller’s number (e.g., mobile, landline).
caller_country_iso_code	VARCHAR(3)	ISO code of the caller’s country.
caller_country_code	INT	Country code of the caller.
callee_ext_id	BIGINT	Extension ID of the callee.
callee_name	VARCHAR(100)	Name of the callee.
callee_email	VARCHAR(100)	Email address of the callee.
callee_did_number	VARCHAR(20)	Dialed number identification of the callee.
callee_ext_number	VARCHAR(20)	Extension number of the callee.
callee_ext_type	VARCHAR(20)	Type of the callee’s extension.
callee_number_type	VARCHAR(20)	Type of the callee’s number (e.g., mobile, landline).
callee_device_type	VARCHAR(50)	Type of device used by the callee.
callee_country_iso_code	VARCHAR(3)	ISO code of the callee’s country.
callee_country_code	INT	Country code of the callee.
site_id	BIGINT	Identifier for the site associated with the event.
site_name	VARCHAR(100)	Name of the site associated with the event.
start_time	DATETIME	Time when the event started.
end_time	DATETIME	Time when the event ended.
operator_ext_number	VARCHAR(20)	Extension number of the operator.
operator_ext_id	BIGINT	Extension ID of the operator.
operator_ext_type	VARCHAR(20)	Type of the operator’s extension.
operator_name	VARCHAR(100)	Name of the operator.
is_node	BOOLEAN	Indicates if the event is associated with a node.
device_private_ip	VARCHAR(20)	Private IP address of the device involved.
device_public_ip	VARCHAR(20)	Public IP address of the device involved.
talk_time	INT	Talk time duration (in seconds).
hold_time	INT	Hold time duration (in seconds).
wait_time	INT	Wait time duration (in seconds).
call_log_id	VARCHAR(50)	Identifier for the call log.
answer_time	DATETIME	Time when the event was answered.
voicemail_id	VARCHAR(50)	Identifier for the voicemail associated with the event.
result_reason	VARCHAR(100)	Reason for the event’s result.
caller_ext_id	BIGINT	Extension ID of the caller.
caller_email	VARCHAR(100)	Email address of the caller.
caller_ext_number	VARCHAR(20)	Extension number of the caller.
caller_ext_type	VARCHAR(20)	Type of the caller’s extension.
caller_device_type	VARCHAR(50)	Type of device used by the caller.
department	VARCHAR(100)	Department associated with the event.
press_key	VARCHAR(10)	Key pressed during the event (e.g., in IVR).
recording_id	VARCHAR(50)	Identifier for the recording.
recording_type	VARCHAR(20)	Type of recording.
caller_employee_id	BIGINT	Employee ID of the caller.
callee_employee_id	BIGINT	Employee ID of the callee.
ai_call_summary_id	VARCHAR(50)	Identifier for the AI call summary.
load_date	DATETIME	Date when the event record was loaded into the system.

Users Info

column_name	data_type	description
id	BIGINT	Unique identifier for the user record.
first_name	VARCHAR(100)	User’s first name.
last_name	VARCHAR(100)	User’s last name.
display_name	VARCHAR(200)	User’s display name, potentially a combination of first/last.
email	VARCHAR(255)	User’s email address.
type	VARCHAR(50)	User’s type or classification.
role_name	VARCHAR(100)	Name of the user’s role or permission level.
pmi	BIGINT	Personal Meeting ID (likely numerical).
use_pmi	BOOLEAN	Indicates if the user uses their Personal Meeting ID.
personal_meeting_url	VARCHAR(255)	URL for the user’s Personal Meeting.
timezone	VARCHAR(100)	User’s timezone.
verified	BOOLEAN	Indicates if the user’s account is verified.
dept	VARCHAR(100)	User’s department.
created_at	DATETIME	Date and time the user account was created.
last_login_time	DATETIME	Date and time of the user’s last login.
cms_user_id	VARCHAR(100)	CMS (Content Management System) User ID.
jid	VARCHAR(255)	User’s Jabber ID or similar messaging identifier.
group_ids	VARCHAR(255)	Comma-separated or JSON array of group IDs the user belongs to.
im_group_ids	VARCHAR(255)	IM (Instant Messaging) Group IDs the user belongs to.
account_id	BIGINT	Account ID associated with the user.
language	VARCHAR(50)	User’s preferred language.
phone_country	VARCHAR(50)	User’s phone country.
phone_number	VARCHAR(50)	User’s phone number.
status	VARCHAR(50)	User’s status (e.g., active, inactive).
job_title	VARCHAR(100)	User’s job title.
cost_center	VARCHAR(100)	User’s cost center.
company	VARCHAR(100)	User’s company.
location	VARCHAR(100)	User’s location.
login_types	VARCHAR(255)	Comma-separated or JSON array of user’s login types.
role_id	BIGINT	ID of the user’s role.
account_number	VARCHAR(50)	Account number associated with the user.
cluster	VARCHAR(50)	Cluster the user is associated with.
zoom_one_type	VARCHAR(50)	Type of Zoom One subscription or service.
user_created_at	DATETIME	Another field possibly capturing user creation timestamp.
last_client_version	VARCHAR(50)	Version of the client last used by the user.
pic_url	VARCHAR(255)	URL of the user’s profile picture.
phone_numbers	VARCHAR(255)	Comma-separated or JSON array of user’s phone numbers.
vanity_url	VARCHAR(255)	Vanity URL associated with the user’s profile.
load_date	DATETIME	Date when the user record was loaded into the system.

Phone Users

column_name	data_type	description
id	BIGINT	Unique identifier for the user phone record.
phone_user_id	BIGINT	Identifier for the user’s phone service within the system.
email	VARCHAR(255)	Email address associated with the phone user.
extension_id	BIGINT	Identifier for the user’s phone extension.
extension_number	VARCHAR(20)	Number of the user’s phone extension.
status	VARCHAR(50)	Status of the user’s phone service (e.g., active, inactive).
calling_plans	VARCHAR(255)	Comma-separated or JSON array of calling plans assigned.
phone_numbers	VARCHAR(255)	Comma-separated or JSON array of phone numbers associated.
site_id	BIGINT	Identifier for the site the user’s phone service is on.
site_admin	BOOLEAN	Indicates if the user is a site administrator.
emergency_address.id	BIGINT	Identifier for the user’s emergency address.
emergency_address.country	VARCHAR(50)	Country of the user’s emergency address.
emergency_address.address_line1	VARCHAR(255)	First line of the user’s emergency address.
emergency_address.address_line2	VARCHAR(255)	Second line of the user’s emergency address (if applicable).
emergency_address.city	VARCHAR(100)	City of the user’s emergency address.
emergency_address.state_code	VARCHAR(10)	State or region code of the user’s emergency address.
emergency_address.zip	VARCHAR(20)	ZIP or postal code of the user’s emergency address.
department	VARCHAR(100)	Department associated with the user.
policy	Object	Policy object of the user
load_date	DATETIME	Date when the user record was loaded into the system.

Call Logs Metrics

column_name	data_type	description
call_log_id	VARCHAR(50)	Unique identifier for the call log record.
total_time	INT	Total duration of the call (in seconds).
inbound_time	INT	Duration of the inbound portion of the call (in seconds).
outbound_time	INT	Duration of the outbound portion of the call (in seconds).
hold_time	INT	Total time the call was placed on hold (in seconds).
wait_time	INT	Total time the caller waited before connection (in seconds).
abandoned	BOOLEAN	Indicates if the call was abandoned.
voicemail	BOOLEAN	Indicates if the call went to voicemail.
transfers	INT	Number of times the call was transferred.
holds	INT	Number of times the call was placed on hold.

We can fetch more tables based on the requirement like

Panelists
Past webinar pools
Meetings
Billing reports