Gong database reference

This section details the tables and columns available in the Gong-Snowflake database. See What's new in Gong Data Cloud for details of what's been added to the Snowflake database.

Conversations

The CONVERSATIONS table contains a row for each conversation. A conversation can be an email, call, or meeting. The CONVERSATIONS table includes the following:

Column name	Type	Description
CONVERSATION_ID	varchar	The Gong conversation id. This ID does not have to be unique. An email conversation can have the same CONVERSATION_ID as a call conversation. However, two conversations of the same type cannot have the same CONVERSATION_ID.
CONVERSATION_DATETIME	timestamp_tz	The date and time the conversation occured
CONVERSATION_KEY	varchar	The primary key for the conversation in Snowflake. As there are different types of conversations, such as calls or emails, this value is unique for all conversation types.
CONVERSATION_TYPE	varchar	The type of the conversation. Options are: call email meeting
WORKSPACE_IDS	array (string)	The IDs of the workspaces the conversation is associated with
ETL_MODIFIED_DATETIME	timestamp_tz	The date and time the data was modified
ROW_LOAD_DATETIME	timestamp_tz	See ETL_MODIFIED_DATETIME instead

Calls

The CALLS table contains a row for each call in the system, including scheduled calls that have not yet taken place. The CALLS table includes the following:

Column name	Type	Description
CALL_OWNER_WEBCAM_ON_DURATION_SEC	float	The amount of time in seconds the host had their webcam on
CALL_URL	varchar	The URL for the call
COMPANY_QUESTION_COUNT	number	The number of questions asked by people on the call from the company
CONVERSATION_KEY	varchar	The key for the conversation the call is associated with. (Unique)
CUSTOMER_QUESTION_COUNT	number	The number of questions asked by customers on the call
CUSTOMER_WEBCAM_ON_DURATION_SEC	float	The amount of time in seconds the customer had their webcam on
DIRECTION	varchar	Indicates who made the call. Options are: INBOUND OUTBOUND CONFERENCE UNKNOWN
DISPOSITION	varchar	The outcome of the call
EFFECTIVE_START_DATETIME	timestamp_tz	The actual start date of the call
IS_PRIVATE	boolean	True if the call is a private call
OWNER_ID	varchar	The owner of the call. (Foreign key, `users` table)
PLANNED_END_DATETIME	timestamp_tz	The date and time the call was planned to end.
PLANNED_START_DATETIME	timestamp_tz	The date and time the call was planned to start.
SCOPE	varchar	Indicates whether the call is an internal call only. Options are: INTERNAL EXTERNAL UNKNOWN
SYSTEM	varchar	The telephony system the call was made on
TITLE	varchar	The title of the call
STATUS	varchar	Some reports might want to exclude or include calls based on their status. Possible values: SCHEDULED PURGE_REQUESTED COMPLETED - The call was completed and processed by Gong ABORTED NOSHOW CANCELED PURGED - The call was purged from the system
ETL_MODIFIED_DATETIME	timestamp_tz	The date and time the was modified
ROW_LOAD_DATETIME (deprecated)	timestamp_tz	See ETL_MODIFIED_DATETIME instead

Call_Recordings

The CALL_RECORDINGS table contains a row for each recorded and processed call. The table includes details about the recording such as the start and end time. The CALL_RECORDINGS table includes the following:

Column name	Type	Description
CONVERSATION_KEY	varchar	The key for the conversation the call is associated with. (Unique)
DURATION	number	The duration of the call (in seconds)
END_DATETIME	timestamp_tz	The actual date and time the call ended.
ETL_MODIFIED_DATETIME	timestamp_tz	The date and time the data was modified
LANGUAGE	varchar	The code for the language the call was made in
MEDIA_TYPE	varchar	Sets the media for the call. Options are: AUDIO VIDEO
ROW_LOAD_DATETIME (deprecated)	timestamp_tz	See ETL_MODIFIED_DATETIME instead
START_DATETIME	timestamp_tz	The actual start date and time of the call.

Users

The USERS table contains personal data about each user in the system user as well as licensing details. The table also includes the manager_id so that you can build the organizational hierarchy. We also maintain history in this table using SCD type 2.0, so you can see for example, previous job titles or permissions. When one of the values is changed, the VALID_TO_DATETIME is set to the current date and a new row is added with both the new and unchanged values. The VALID_FROM_DATETIME in the new row is set to the current date and the VALID_TO_DATETIME is set to NULL.

The USERS table includes the following:

Column	Type	Description
ACTIVE	boolean	Sets whether the user is active. Users are not deleted from the system, they become inactive
EMAIL_ADDRESS	varchar	The user's email address
LOCALE	varchar	The user's locale
FIRST_NAME	varchar	The user's first name
LAST_NAME	varchar	The user's last name
LICENSED	boolean	Indicates whether the user has a paid license
MANAGER_ID	varchar	The id of the employee's manager
TIME_ZONE	varchar	The timezone the user is in (TZ format, such as America/New_York)
USER_ID	varchar	The ID of the user in Gong (unique).
SHOULD_IMPORT_TELEPHONY_CALLS	boolean	Indicates whether the user's calls recorded by an external telephony system should be automatically recorded and imported into Gong
SHOULD_RECORD_WEB_CONFERENCE_CALLS	boolean	Indicates whether the user's web conference calls should be automatically recorded
SHOULD_SYNC_EMAILS	boolean	Indicates whether the user's emails should be automatically imported to Gong
TITLE	varchar	The employee's job title
VALID_FROM_DATE_TIME	timestamp_ntz	(SCD type 2.0) The date the user started this position
VALID_TO_DATE_TIME	timestamp_ntz	(SCD type 2.0) The date the user ended this position. A null value indicates that this is the current value for the user.
ETL_MODIFIED_DATETIME	timestamp_tz	The date and time the data was changed

Users_crm_ids

In some cases, one email address can be associated with multiple CRM IDs. In order to ensure that each Gong user is associated with the correct CRM ID, we store all CRM IDs associated with the user, so that one Gong user can be associated with multiple CRM user IDs.

The USERS_CRM_IDS table includes the following:

Column	Type	Description
CRM_ID	varchar	The Gong user's ID in the CRM
USER_ID	varchar	The ID of the user in Gong (unique).

User_conversation_gong_activities

The USER_CONVERSATION_GONG_ACTIVITIES table stores details of which user performed which activity on a call. For each activity a user performs in the application, a new row is added with the user and call ids, the date of the activity and the type of the activity.

The USER_CONVERSATION_GONG_ACTIVITIES table includes the following:

Column	Type	Description
CONVERSATION_KEY	varchar	The ID of the conversation the user made the activity on (from the conversations table)
GONG_ACTIVITY_DATETIME	timestamp_tz	The date and time of the activity
GONG_ACTIVITY_TYPE	varchar	The activity type. Options are: gave_feedback requested_feedback received_feedback listened_to_call shared_externally shared_internally filled_scorecard received_scorecard gave_comment received_comment
USER_ID	number	The ID of the user who had the activity (from the users table)
ETL_MODIFIED_DATETIME	timestamp_tz	The date and time the data was modified
ROW_LOAD_DATETIME (deprecated)	timestamp_tz	See ETL_MODIFIED_DATETIME instead

Interaction_stats

The INTERACTION_STATS table contains statistics about how a rep manages their calls. Each row includes statistics for a single call, such as the rep's talk ratio, and interactivity. For a full explanation of how these metrics are calculated, see Analyze team performance.

The INTERACTION_STATS table includes the following:

Column	Type	Description
CONVERSATION_KEY	varchar	The ID of the call in the conversations table
INTERACTIVITY	double	Indicates the number of times the conversation switched between the rep and the customer. The value is based on a calculation which normalizes the number of times the conversations switched size to a 60 minute conversation.
LONGEST_CUSTOMER STORY	double	The longest amount of time at any one time the customer spoke in the call
LONGEST_MONOLOGUE	double	The longest amount of time the user spoke at one time in the call in seconds
PATIENCE	double	The average amount of time the rep waited before speaking after the customer finished speaking, in seconds
QUESTION_RATE	double	The average number of questions the rep asked in the call
TALK_RATIO	double	The percentage of time the user spoke in the call
USER_ID	number	The ID of the user who participated in the call (from the users table)
ETL_MODIFIED_DATETIME	timestamp_tz	The date and time the data was modified

Workspaces

The WORKSPACES table contains a list of the workspaces in your org and includes the following:

Column name	Type	Description
NAME	varchar	The name of the workspace
WORKSPACE_ID	varchar	The workspace ID
ETL_MODIFIED_DATETIME	timestamp_tz	The date and time the data was modified
ROW_LOAD_DATETIME (deprecated)	timestamp_tz	See ETL_MODIFIED_DATETIME instead

Trackers

Trackers are tools that identify when words, phrases or concepts are mentioned in calls, allowing you to know what your reps and customers are talking about. In addition to out-of-the-box trackers that come with Gong, you can set up your own trackers, according to your company’s business priorities, and what you want to capture insights around. See Trackers: Overview for more details.

The TRACKERS table includes both smart trackers and keyword trackers. A new row is added to the table for each tracker in the system.

The TRACKERS table includes the following:

Column name	Type	Description
KEYWORDS	varchar	The list of keywords in the tracker (JSON array).
NAME	varchar	The name of the tracker, such as Pricing.
TRACKER_ID	varchar	The unique tracker ID
TRACKER_TYPE	varchar	The tracker type: smart_tracker keyword_tracker
WORKSPACE_ID	varchar	The workspace the tracker is associated with
ETL_MODIFIED_DATETIME	timestamp_tz	The date and time the data was modified
ROW_LOAD_DATETIME (deprecated)	timestamp_tz	See ETL_MODIFIED_DATETIME instead

In the Snowflake database, a record is inserted for the tracker with all the keywords defined and in addition for each keyword in the keyword tracker. For example, if you have a tracker which is named pricing which includes the keywords, budget, price and discount, the tracker is entered to the database as follows:

tracker_id	name	keywords	type
t_1	Pricing	[budget, price, discount]	keyword_tracker
t_2	Pricing / budget	[budget]	keyword_tracker
t_3	Pricing / price	[price]	keyword_tracker
t_4	Pricing / discount	[discount]	keyword_tracker

Smart trackers are added to the table as follows:

tracker_id	name	keywords	type
t_6	My Smart Tracker	NULL	smart_tracker

Conversation_trackers

The CONVERSATION_TRACKERS table is used to associate conversations with trackers and contains the following fields:

Column name	Type	Description
CONVERSATION_KEY	varchar	The ID for the conversation (foreign key)
COUNT	int	The number of times the tracker occurs.
TRACKER_ID	varchar	The tracker ID (foreign key)
WORKSPACE_ID	varchar	The workspace the tracker is associated with
ETL_MODIFIED_DATETIME	timestamp_tz	The date and time the data was modified
ROW_LOAD_DATETIME (deprecated)	timestamp_tz	See ETL_MODIFIED_DATETIME instead

The following is an example of how the keyword trackers are added to the CONVERSATION_TRACKERS table. When the TRACKERS table has the following entries:

tracker_id	name	keywords	type
t_1	Pricing	[budget, price, discount]	keyword_tracker
t_2	Pricing / budget	[budget]	keyword_tracker
t_3	Pricing / price	[price]	keyword_tracker
t_4	Pricing / discount	[discount]	keyword_tracker
t_6	My Smart Tracker	NULL	smart_tracker

In a call where the following trackers are identified:

"Budget" found twice
“Price” found once
“My Smart Tracker” found five times

The CONVERSATION_TRACKERS table will have the following entries:

conversation_key	tracker_id	count
c_1	t_1 (Pricing)	3
c_1	t_2 (Pricing / budget)	2
c_1	t_3 (Pricing / price)	1
c_1	t_6 (My Smart Tracker)	5

The Pricing tracker (t_1) is counted three times in the conversation, as it includes mentions of the terms budget and price. The Pricing/budget (t_2) tracker is counted twice in the conversation, as this tracker only covers the term budget. The Pricing/price (t_3) tracker is counted once in the conversation, as this tracker only covers the term price.

Conversation_contexts

The CONVERSATION_CONTEXTS table enables associating a CRM object, such as an account, deal or lead, with a conversation. A conversation can be associated with multiple CRM objects. Each association is added as a new record in the CONVERSATION_CONTEXTS table.

The CONVERSATION_CONTEXTS table includes the following:

Column	Type	Description
CONVERSATION_KEY	varchar	The key for the conversation
FIELDS_SNAPSHOT	variant	A snapshot of the object's fields, that are imported to Gong, at the time of the conversation, excluding those in the `mapped_fields_snapshot` field
MAPPED_FIELDS_SNAPSHOT	variant	Gong maps some fields in the CRM to other fields. For a list of mapped fields per CRM object see Table 4, “CRM fields mapped in Gong”
OBJECT_ID	varchar	The ID of the object in the CRM
OBJECT_TYPE	varchar	The object type. Options are (in lowercase): crm_account crm_opportunity crm_contact crm_lead
PARTICIPANT_OBJECT_ID	varchar	The CRM ID of the participant
PARTICIPANT_OBJECT_TYPE	varchar	The object type of the participant in the CRM. Options are: CONTACT LEAD NULL
ETL_MODIFIED_DATETIME	timestamp_tz	The date and time the data was modified
ROW_LOAD_DATETIME (deprecated)	timestamp_tz	See ETL_MODIFIED_DATETIME instead

Table 4. CRM fields mapped in Gong

CRM object

Mapped fields in Gong

Account

name

industry

type

Opportunity (Deal)

owner

name

amount

stage

isStageClose

isStageWon

proababilityPercent

forecastCategory

Lead

status

Emails

The EMAILS table contains a row for each email and the workspaces the email is associated with. The EMAILS table includes the following:

Column name	Type	Description
AUTO_SUBMITTED_TYPE	varchar	Indicates the type of email for auto generated emails. Options are: auto_generated: Indicates that a message was generated by an automatic process, and is not a direct response to another message. auto_replied: Indicates that a message was automatically generated as a direct response to another message. auto_notified: Indicates that a message was generated by a Sieve notification system.
CONVERSATION_ID	varchar	The Gong conversation id. This ID does not have to be unique. An email conversation can have the same CONVERSATION_ID as a call conversation. However, two conversations of the same type cannot have the same CONVERSATION_ID.
CONVERSATION_KEY	varchar	The primary key for the conversation in Snowflake. As there are different types of conversations, such as calls or emails, this value is unique for all conversation types.
DIRECTION	varchar	INBOUND or OUTBOUND. Whether the email originated from a customer (inbound) or is an email to the customer (outbound)
IS_MEETING_INVITE	boolean	When true, indicates the email is an invitation for a meeting
OOO_RETURN_DATE	dateTime	Indicates the return date of an out of office email. NULL for non OOO emails.
SENT_DATETIME	datetime_tz	The timestamp for when the email was sent
WORKSPACE_IDS	array of strings	A list of the workspace IDs the email is associated with
ETL_MODIFIED_DATETIME	timestamp_tz	The date and time the data was modified
ROW_LOAD_DATETIME (deprecated)	timestamp_tz	See ETL_MODIFIED_DATETIME instead

Meetings

The MEETINGS table contains a row for each calendar meeting. Meetings may or may not have an associated call. When a meeting includes a call, the call_conversation_key contains the key for the call. For details on meetings, see View meetings without scheduled recordings . The MEETINGS table includes the following:

Column name	Type	Description
CALL_CONVERSATION_KEY	varchar	The conversation key of the call for the meeting. Null when there is no call associated with the meeting.
CONVERSATION_ID	varchar	The Gong conversation id. This ID does not have to be unique. A meeting can have the same CONVERSATION_ID as a call. However, two conversations of the same type cannot have the same CONVERSATION_ID.
CONVERSATION_KEY	varchar	The primary key for the meeting in Snowflake. (Unique)
CREATED_DATETIME	timestamp_tz	The date and time the meeting created
END_DATETIME	timestamp_tz	The date and time the meeting is schedule to end
IS_ALL_DAY	boolean	When true, indicates the meeting will last the whole day
IS_CANCELLED	boolean	When true, indicates the meeting was cancelled
IS_DELETED	boolean	When true, indicates the meeting was deleted
IS_INTERNAL	boolean	When true, indicates the meeting is internal
IS_RECURRING	boolean	When true, sets that this is a recurring meeting
MODIFIED_DATETIME	timestamp_tz	The last date and time the meeting was modified
ORGANIZER_USER_ID	varchar	The Gong user ID of the person who organized the meeting
START_DATETIME	timestamp_tz	The date and time the meeting is scheduled to start
TITLE	varchar	The title of the meeting
WORKSPACE_IDS	array of strings	A list of the workspace IDs the meeting is associated with
ETL_MODIFIED_DATETIME	timestamp_tz	The date and time the data was modified

Conversation_participants

The CONVERSATION_PARTICIPANTS table contains a row for each email recipient and a row for each call or meeting participant. The CONVERSATION_PARTICIPANTS table includes the following:

Column name	Type	Description
AFFILIATION	varchar	The company the participant is affiliated with. Options are: unclassified: Gong couldn't determine the participant's affiliation company: the participant is affiliated with company that uses Gong non_company: the participant is not affiliated with the company
CONVERSATION_KEY	varchar	The key for the conversation the call is associated with. (Unique)
EMAIL_ADDRESS	varchar	The email address of the participant
INVITEE_STATUS	varchar	The invitees response to the meeting invitation. Null when conversation is not a meeting. Options are: accepted declined none tentative
NAME	varchar	The name of the participant in the conversation
TYPE	varchar	The participant type or role in the conversation. For emails options are: to cc bcc from sender reply_to For calls options are: Invitee Attendee For meetings options are: Organizer Required Optional Resource, such as meeting room Unknown
USER_ID	varchar	The participant's Gong user ID. Null if they are not a Gong user.
ETL_MODIFIED_DATETIME	timestamp_tz	The date and time the data was modified
ROW_LOAD_DATETIME (deprecated)	timestamp_tz	See ETL_MODIFIED_DATETIME instead

Forecast_submissions

The FORECAST_SUBMISSIONS table contains team and individual forecasts submissions.

Note

This table shows manual submissions only. As forecasts in Gong may also include automated submissions, there could be discrepancies between the forecast submissions in Gong and the forecast submission data in Snowflake.

The table contains the following fields:

Column name	Type	Description
FORECAST_AMOUNT_UNIT	varchar	The unit the forecast was made in
FORECAST_CATEGORY	varchar	The forecast category according to the values defined in the forecast board
IS_TEAM	boolean	When true, the forecast is a team forecast
LINE_OF_BUSINESS	varchar	The name of the line of business the forecast is for
PERIOD_NUMBER	integer	The number representing the period the forecast is for. For example, if the forecast is for Q3, this value is 3. If the forecast is for August, this value is 8.
PERIOD_TYPE	varchar	The period the forecast covers. Options are: MONTH QUARTER
PERIOD_YEAR	integer	The year the forecast covers
SUBMIT_DATE	dateTime	The date the forecast was submitted
SUBMIT_BY_USER_ID	varchar	The Gong user id of the user who submitted the forecast
USER_ID	varchar	The user Id of the Gong user the forecast is for. If a manager submits a forecast for their team member, the USER_ID is the user Id of the team member. If the forecast is a team forecast, this is the team manager's user Id.
VALUE	float	The forecast value
WEEK	integer	The week during the quarter that the forecast was submitted
ETL_MODIFIED_DATETIME	timestamp_tz	The date and time the data was modified

Forecast_targets

The FORECAST_TARGTETS table contains targets set for each team or for specific users. The table contains the following fields:

Column name	Type	Description
FORECAST_CATEGORY	varchar	The forecast category the deal is in
IS_TEAM	boolean	When true, the target is a team target
LINE_OF_BUSINESS	varchar	The name of the line of business the target is for
PERIOD_NUMBER	integer	The number representing the period the target is for. For example, if the target is for Q3, this value is 3. If the target is for August, this value is 8.
PERIOD_TYPE	varchar	The period the target covers. Options are: MONTH QUARTER
PERIOD_YEAR	integer	The year the target covers
SUBMIT_DATE	dateTime	The date the target was submitted
SUBMIT_BY_USER_ID	varchar	The Gong user id of the user who submitted the target
TARGET_AMOUNT_CURRENCY	varchar	The currency the target was made in
USER_ID	varchar	The user Id of the Gong user who submitted the target. For team targets, this is the team manager's user Id.
VALUE	float	The target value
ETL_MODIFIED_DATETIME	timestamp_tz	The date and time the data was modified

Scorecard_questions

The SCORECARD_QUESTIONS table contains a row for each question in a scorecard. The row includes the scorecard data such as the scorecard name and the date it was created. The answers for the questions are stored in the SCORECARD_ANSWERS table. The table contains the following fields:

Column name	Type	Description
IS_DELETED	boolean	Indicates whether the scorecard or the question were deleted
QUESTION_CREATED_DATETIME	timestamp_ntz	The date and time the question was defined
QUESTION_ID	varchar	The Id of a question included in the scorecard
QUESTION_IS_OVERALL_ASSESSMENT	boolean	Indicates whether the question enables providing an overall assessment of the call
QUESTION_MAX_RANGE	number	For questions with a numerical score, the maximum number that can be chosen
QUESTION_MIN_RANGE	number	For questions with a numerical score, the minimum number that can be chosen
QUESTION_MODIFIED_BY_USER_ID	varchar	The Id of the user who modified the question
QUESTION_RESPONSE_OPTIONS	variant	The possible options in a multiple choice question
QUESTION_TEXT	varchar	The text of the question
QUESTION_TYPE	varchar	The type of question. Options are: single_select multi_select range open boolean
SCORECARD_CREATED_DATETIME	timestamp_ntz	The date and time the scorecard was created
SCORECARD_ID	varchar	The scorecard Id
SCORECARD_IS_ENABLED	boolean	Indicates whether the scorecard is enabled or not
SCORECARD_MODIFIED_BY_USER_ID	varchar	The Id of the Gong user who last modified the scorecard
SCORECARD_MODIFIED_DATETIME	timestamp_ntz	The date and time the scorecard was last modified
SCORECARD_NAME	varchar	The scorecard title
WORKSPACE_ID	varchar	The Id of the workspace the scorecard is associated with

Scorecard_answers

The SCORECARD_ANSWERS table contains a row for each answer given in the scorecard. The row includes scorecard details, the question details and the answer given. The table contains the following fields:

Column name	Type	Description
ACCESSIBLE_TO	varchar	The users who have permissions to view the scorecard. Options are: PUBLIC ONE_ON_ONE
ANSWER_CREATED_DATETIME	timestamp_ntz	The date and time the answer was created
ANSWER_MODIFIED_DATETIME	timestamp_ntz	The date and time the answer was last modified
ANSWER_NOT_APPLICABLE	boolean	Indicates if the answer is not applicable
ANSWER_SELECTED_OPTIONS	array	The options selected in a multiple choice question
ANSWER_SCORE	number	The score given to the question
ANSWER_TEXT	varchar	The text of the answer
CONVERSATION_KEY	varchar	The key for the conversation the scorecard is being filled in for
GAVE_SCORECARD_USER_ID	varchar	The Id of the user who filled in the scorecard
LAST_PUBLISHED_DATETIME	timestamp_ntz	The date and time the answer was last published
QUESTION_ID	varchar	The Id of the question
QUESTION_IS_OVERALL_ASSESSMENT	boolean	Indicates whether the question enables providing an overall assessment of the call
QUESTION_MAX_RANGE	number	For questions with a numerical score, the maximum number that can be chosen
QUESTION_MIN_RANGE	number	For questions with a numerical score, the minimum number that can be chosen
QUESTION_RESPONSE_OPTIONS	variant	The possible options in a multiple choice question
QUESTION_TEXT	varchar	The text of the question
QUESTION_TYPE	varchar	The type of question. Options are: single_select multi_select range open boolean
RECEIVED_SCORECARD_USER_ID	varchar	The Id of the user who the scorecard was for
SCORECARD_ID	varchar	The scorecard Id. FK from the SCORECARD_QUESTIONS table.
WORKSPACE_ID	varchar	The Id of the workspace the scorecard is associated with

Menu

Note

Comments

CONFIDENTIAL