What's new in Gong Data Cloud
See all documentation on the Gong Data Cloud here.
New data available in Snowflake:
-
Calls table: To enable exporting data from all telephony calls to Snowflake, the PHONE_NUMBER and CALL_CONNECTED columns were added.
-
Call_participants table: To enable exporting data from all telephony calls to Snowflake, the PHONE_NUMBER column was added.
-
All tables: The ROW_ID column was added to all tables to enable support for exporting Gong data to other data warehouses. This is currently in beta and should not be used.
The following fields have been added:
-
Comments table: The
mentions
andtags
fields were added. Thementions
field contains the Gong userId of all users mentioned in the comment with a @ sign. UserIds are separated by a comma.The
tags
field contains all phrases in the comment that start with a #. Each tag is separated by a comma. -
Calls table: On March 15th, the
source
field will be deleted from the Snowflake database. Currently, thesource
field is deprecated and has been replaced with thesource_system
field. This is to avoid having fields named with terms which are reserved words in some data warehouses. Existing data in thesystem
field will be copied to thesource_system
field.
The following is now available:
-
Conversation participants: The conversation_participants table now includes the speaker ID. This enables you to associate the participant’s Gong user with everything they say in a call. The speakerId is the speaker of each monologue in the TRANSCRIPT table.
The following is now available:
-
Indication of whether a record was deleted: Previously, deleted data was deleted from Snowflake. Now, records will no longer be deleted, instead they will be marked as having been deleted in Gong. The is_deleted field was added to the following tables:
-
conversations
-
conversation_contexts
-
conversation_participants
-
conversation_trackers
-
interaction_stats
-
meetings
-
emails
-
call_recordings
-
-
New data available in Snowflake: The following data is now available in Snowflake:
-
Comments: Analyzing comments can be used to assess coaching quality, and also to filter calls with specific hashtags or tags. Public comments made on calls are now available in the COMMENTS table in Snowflake.
-
-
New data available in Snowflake: The following has been added:
-
Call transcripts: You can now get call transcripts in Snowflake. Transcripts are saved in a JSON format in the new CALL_TRANSCRIPTS table.
-
Call spotlight: Call spotlight details, including the call brief, outline, next steps, call outcome are now stored in the CALLS table. For details on the call spotlight, see Save time with call spotlight
-
-
Ability to connect conversation participants with the relevant CRM contact: You can now connect conversation participants to the contact or lead in your CRM. The following changes were made:
Table name
Change
Description
conversation_participants
Added fields:
-
participant_object_id
-
participant_object_type
For each participant we now include details of whether the participant is a contact or a lead and the participant’s CRM ID.
conversation_context
Added crm_contact as a possible value for the type field
Adds the ability to associate contacts to conversations
-
-
Scorecard data now available: See who is filling in scorecards and how calls are scored for different reps. The SCORECARD_QUESTIONS and SCORECARD_ANSWERS tables were added to the Gong data cloud.
-
Additional call data available: You can now get more detailed call information and run detailed analysis on calls. The following fields were added to the CALLS table:
-
direction
-
system
-
scope
-
disposition
-
call_owner_webcam_on_duration_sec
-
customer_webcam_on_duration_sec
-
company_question_count
-
customer_question_count
-
-
Additional Snowflake regions now supported: Some Snowflake regions outside of the USA are now supported in the Gong Data Cloud so that anyone in those regions can now analyze their Gong data in their data warehouse.
The new regions are:
-
AWS ap-southeast-1
-
AWS ap-southeast-2
-
AWS ap_south_1
-
AWS ca_central-1
-
AWS eu-central-1
-
AWS eu-west-1
-
AWS eu-west-2
-
AWS eu_west_3
-
AZURE centralus
-
AZURE europewest
-
AZURE northeurope
-
GCP europe-west4
-
-
Analyze Forecast data: Forecast data, including individual and team forecast submissions, and individual and team targets are now available for export to a Snowflake data warehouse. The
FORECAST_SUBMISSIONS
andFORECAST_TARGETS
tables were added to the Gong data cloud. For more details, see Gong database reference. -
ID field types changed: The following changes were made:
Table name
Field name
New field type
CALLS
OWNER_ID
varchar
CONVERSATION_TRACKERS
WORKSPACE_ID
varchar
EMAILS
WORKSPACE_IDS
array of varchars
MEETINGS
WORKSPACE_IDS
array of varchars
TRACKERS
WORKSPACE_ID
varchar
USERS
USER_ID
varchar
The following data has been added to the Gong Data Cloud:
-
Meeting details: Calendar meetings are now included in Snowflake, together with the meeting’s call information and the associated CRM objects. This has been added retroactively, so all meetings are available. The MEETINGS table was added, and meeting participants now appear in the CONVERSATION_PARTICIPANTS table. Associated CRM objects have been added to the CONVERSATION_CONTEXTS table. For more details, see Gong database reference.
-
Interaction stats: Get our statistical analysis of your reps calls, so that you can see how they manage each call and identify areas they need coaching in. Interaction stats include data such as talk ratio and the reps longest monologue. The USER_CALL_INTERACTION_STATS table was added and populated with metrics from existing calls. For more details, see Gong database reference.