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:
Below are the list of tables we are extracting
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. |
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 * | 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 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 |
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 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 |
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 * | 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 |
| 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. |
| 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. |
| 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. |
| 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). |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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
