---
title: "Forecast and Gong user tables"
slug: "forecast-and-gong-user-tables"
updated: 2026-06-07T09:26:14Z
published: 2026-06-07T09:26:14Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.gong.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Forecast and Gong user tables

> **Who can use this**: Tech admin **Available on**: Data Cloud

This section details the tables and columns available in the Gong data cloud. See [What's new in Gong Data Cloud](/v1/docs/whats-new-in-gong-data-cloud) for details of what's been added to the data cloud.

> [!NOTE]
> Note:
> 
> Some columns were configured as decimals instead of integers. From March 2026 - May 2026 we are implementing a process to change these column types to integers. As a result, you may see duplicate columns with a suffix of __NEXT. For more details, see [Numeric field type updates in the Gong data cloud](/v1/docs/numeric-field-type-updates-in-the-gong-data-cloud).

> [!NOTE]
> Note:
> 
> The Gong Data Cloud schema can change in any release, for example by adding new tables and columns. Design your integrations and queries to handle new fields to ensure your reports continue to work as the schema evolves.

****Users****

The `USERS` table contains data about each user in the system including licensing details. Use the `manager_id` field to build 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 | Value on delete | Description |
| --- | --- | --- | --- |
| ACTIVE | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | NULL | Sets whether the user is active. Users are not deleted from the system, they become inactive |
| EMAIL_ADDRESS | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The user's email address |
| FIRST_NAME | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The user's first name |
| HOME_WORKSPACE_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The ID of the team member’s home workspace |
| LAST_NAME | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The user's last name |
| LICENSED | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | NULL | Indicates whether the user has a paid license |
| LOCALE | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The user's locale |
| MANAGER_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The id of the employee's manager |
| TIME_ZONE | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The timezone the user is in (TZ format, such as America/New_York) |
| USER_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The ID of the user in Gong (unique). |
| SHOULD_IMPORT_TELEPHONY_CALLS | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | NULL | 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 | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | NULL | Indicates whether the user's web conference calls should be automatically recorded |
| SHOULD_SYNC_EMAILS | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | NULL | Indicates whether the user's emails should be automatically imported to Gong |
| TITLE | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The employee's job title |
| VALID_FROM_DATE_TIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | Unchanged | (SCD type 2.0) The date this record was created |
| VALID_TO_DATE_TIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | Unchanged | (SCD type 2.0) The date this record was changed. A null value indicates this is the current record for the user. |
| IS_DELETED | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | Unchanged | Indicates whether the user was deleted in Gong. Values are: - False (default): user exists in Gong - True: user was deleted in Gong |
| ETL_MODIFIED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | Unchanged | The date and time the data was changed |
| ROW_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The ID to identify the row in the table. |

****User_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 `USER_CRM_IDS` table includes the following:

| Column | Type | Value on delete | Description |
| --- | --- | --- | --- |
| CRM_USER_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The Gong user's ID in the CRM |
| USER_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The ID of the user in Gong (unique). |
| IS_DELETED | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | Unchanged | Indicates whether the user’s CRM ID was deleted in Gong. Values are: - False (default): User’s CRM ID exists in Gong - True: User’s CRM ID was deleted in Gong |
| ETL_MODIFIED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | Unchanged | The date and time the CRM data was modified |
| ROW_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The ID to identify the row in the table. |

****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 | Value to delete | Description |
| --- | --- | --- | --- |
| CONVERSATION_KEY | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The ID of the conversation the user made the activity on (from the conversations table) |
| GONG_ACTIVITY_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | Unchanged | The date and time of the activity |
| GONG_ACTIVITY_TYPE | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The activity type. Options are: - feedback_marked_given - feedback_marked_received - filled_scorecard - gave_comment - gave_feedback - listened_to_call - received_automatic_scorecard - received_comment - received_feedback - received_manual_scorecard - requested_feedback - shared_externally - shared_internally |
| USER_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The ID of the user who had the activity (from the users table) |
| ETL_MODIFIED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | Unchanged | The date and time the data was modified |
| ROW_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The ID to identify the row in the table. |

****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](/v1/docs/analyze-team-performance#UUID-bd22de91-1848-f843-8bc5-67d92939acff).

The `INTERACTION_STATS` table includes the following:

| Column | Type | Value on delete | Description |
| --- | --- | --- | --- |
| CONVERSATION_KEY | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The ID of the call in the conversations table |
| CALL_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The call ID |
| CALL_OWNER | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The Gong user ID of the person who owns the call |
| INTERACTIVITY | **Snowflake:**float **BigQuery**: float64 **Databricks**: float, double **Redshift**: real, float4, float8, double precision **S3**: float | NULL | 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 | **Snowflake:**float **BigQuery**: float64 **Databricks**: float, double **Redshift**: real, float4, float8, double precision **S3**: float | NULL | The longest amount of time at any one time the customer spoke in the call |
| LONGEST_MONOLOGUE | **Snowflake:**float **BigQuery**: float64 **Databricks**: float, double **Redshift**: real, float4, float8, double precision **S3**: float | NULL | The longest amount of time the user spoke at one time in the call in seconds |
| PATIENCE | **Snowflake:**float **BigQuery**: float64 **Databricks**: float, double **Redshift**: real, float4, float8, double precision **S3**: float | NULL | The average amount of time the rep waited before speaking after the customer finished speaking, in seconds |
| QUESTION_RATE | **Snowflake:**number **BigQuery:**decimal, numeric **Databricks**: decimal, dec, numeric **Redshift**: decimal, numeric **S3**: FIXED_LEN_BYTE_ARRAY, Decimal | NULL | The average number of questions the rep asked in the call |
| TALK_RATIO | **Snowflake:**number **BigQuery:**decimal, numeric **Databricks**: decimal, dec, numeric **Redshift**: decimal, numeric **S3**: FIXED_LEN_BYTE_ARRAY, Decimal | NULL | The percentage of time the user spoke in the call |
| USER_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The ID of the user who participated in the call (from the users table) |
| IS_DELETED | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | Unchanged | Indicates that the stats were deleted in Gong. The stats are also deleted in Snowflake when a conversation is deleted. Values are: - False (default): stats exists in Gong - True: stats were deleted in Gong |
| ETL_MODIFIED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | Unchanged | The date and time the data was modified |
| ROW_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The ID to identify the row in the table. |

****Workspaces****

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

| Column name | Type | Value on delete | Description |
| --- | --- | --- | --- |
| NAME | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The name of the workspace |
| WORKSPACE_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The workspace ID |
| ETL_MODIFIED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | Unchanged | The date and time the data was modified |
| IS_DELETED | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | Unchanged | Indicates whether the workspace was deleted in Gong. Values are: - False (default): workspace exists in Gong - True: workspace was deleted in Gong |
| ROW_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The ID to identify the row in the table. |

****Gong_usage****

The `GONG_USAGE` table contains information on how team members use Gong on a daily basis. Each row contains the number of times a unique action was done on a specified day. So for example, if a team member listens to 6 calls in one day, but listens to one call twice, the CALLS_LISTENED_TO column will be 5. If a team member listens to the same call on two different days, this results in two records in this table.

Metrics on how many unique calls a team member listened to in a specific time period is available by downloading the [Feature utilization report](/v1/docs/generate-a-utilization-report),

The metrics include actions done both on the mobile app and in the browser.

The table includes the following fields:

| Column name | Type | Value on delete | Description |
| --- | --- | --- | --- |
| ACCOUNTS_ASKED_ANYTHING | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of accounts for which the person asked at least one question on the USAGE_DATE. Asking multiple questions about the same account counts as one account. |
| ACCOUNTS_WITH_BRIEFS_VIEWS | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of accounts for which the person viewed a brief on the USAGE_DATE. Viewing the same brief multiple times counts as one account. |
| ADDED_PEOPLE_TO_FLOWS | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of times the user added a person to a flow in Engage |
| AI_EMAILS_GENERATED | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of times the person clicked Generate follow-up email on the USAGE_DATE. Includes all clicks, regardless of where the option appears. |
| ASKED_ANYTHING_ABOUT_A_CALL | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of questions the user asked anything about a call. This refers to questions asked in the [Ask anything about a call](/v1/docs/review-what-happened-in-a-call#ask-anything-about-a-call) on the call page. |
| ASKED_ANYTHING_ABOUT_A_DEAL_OR_ACCOUNT | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of questions the user asked anything about a deal or account |
| CALL_SCORECARDS_GIVEN | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Only shows data if the user is a manager. Number of scorecards the user filled in. |
| CALLED_WITH_GONG_DIALER | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of calls the user made with the Gong dialer |
| CALLS_ASKED_ANYTHING | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of calls for which the person asked at least one question on the USAGE_DATE. Asking multiple questions about the same call counts as one call. This refers to asking questions on all calls and not the Ask anything that is in the call page. |
| CALLS_LISTENED_TO | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of calls the user listened to in Gong |
| CALLS_WITH_BRIEFS_VIEWS | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of calls for which the person viewed a brief on the USAGE_DATE. Viewing the same brief multiple times counts as one call. |
| COMMENTED_ON_CALLS | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of comments the user made on recorded calls |
| COMPLETED_TO_DOS | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of Engage to-dos completed |
| CONDUCTED_FOLLOW_UP_STEPS | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of follow-up steps such as inline edits, the user did on a deal |
| CONTACTS_ASKED_ANYTHING | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of contacts for which the person asked at least one question on the USAGE_DATE. Asking multiple questions about the same contact counts as one contact. |
| CONTACTS_WITH_BRIEFS_VIEWS | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of contacts for which the person viewed a brief on the USAGE_DATE. Viewing the same brief multiple times counts as one contact. |
| DASHBOARDS_INTERACTED_WITH | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of dashboards the person performed an activity on on the USAGE_DATE. |
| DASHBOARDS_VIEWED | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of dashboards the person viewed on the USAGE_DATE. Viewing the same dashboard multiple times counts as one view. |
| DEALS_ASKED_ANYTHING | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of deals for which the person asked at least one question on the USAGE_DATE. Asking multiple questions about the same deal counts as one deal. |
| DEAL_BOARD_WITH_PLAYBOOK_VIEWS | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of deal boards that include a playbook the person viewed on the USAGE_DATE. Viewing the same deal board multiple times counts as one. |
| DEALS_WITH_BRIEFS_VIEWS | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of deals for which the person viewed a brief on the USAGE_DATE. Viewing the same brief multiple times counts as one deal. |
| HAD_GONG_ACTIVITY | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | NULL | When true, it indicates that the user was active in Gong on that date, even if the action was not captured by existing metrics. |
| INSPECTED_DEALS | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of deals the user looked at in detail (opened the deal panel) |
| INTERACTED_WITH_CALL_SPOTLIGHT (deprecated) | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Returns 0 |
| MINUTES_LISTENED_TO_CALLS | **Snowflake**: BigInt, Integer, Int **BigQuery:**decimal, numeric **Databricks:**decimal, dec, numeric **Redshift:**decimal, numeric **S3**: FIXED_LEN_BYTE_ARRAY, Decimal | NULL | Number of minutes the user listened to calls in Gong |
| PLAYBOOK_FIELDS_AI_SUGGESTIONS_USED | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of times the person validated an AI suggestion in a Playbook field on a deal board on the USAGE_DATE. |
| PLAYBOOK_FIELDS_MANUAL_UPDATES | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of Playbook fields the person manually updated on the USAGE_DATE. Multiple updates to the same field count as one. |
| RECORDED_CALLS | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of calls recorded in Gong for this user |
| REVIEWED_CALLS | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of calls the user reviewed |
| REVIEWED_DEAL_ANALYTICS | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of times the user viewed one of the deal analytics reports (win/loss, deal drivers) |
| REVIEWED_FORECAST | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of times the user did an action in the Forecast page, not including loading the page |
| REVIEWED_PIPELINE | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of times the user clicked on anything in the deal page |
| SENT_EMAILS_VIA_GONG | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of emails the user sent via the Gong email composer |
| SHARED_CALLS | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of calls the user shared either internally or externally |
| SUBMITTED_FORECASTS | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of times the user submitted or updated a forecast |
| USED_FORECAST_ANALYTICS | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of times the user performed an action in the Forecast analytics page, not including loading the page |
| USER_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The user’s Gong ID |
| USER_NAME | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The user’s full name |
| USAGE_DATE | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | NULL | The date the usage data is for |
| VIEWED_ANALYTIC_REPORTS | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of times the user viewed a report in Insights |
| VIEWED_CALL_SPOTLIGHT (deprecated) | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Returns 0 |
| VIEWED_INITIATIVE_BOARDS | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | Number of times the user viewed an initiative board |
| IS_DELETED | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | Unchanged | Indicates whether the record was deleted in Gong. Values are: - False (default): record exists in Gong - True: record was deleted in Gong |
| ETL_MODIFIED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | Unchanged | The date and time the data was modified |
| ROW_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The ID to identify the row in the table |

****Comments****

The `COMMENTS` table contains a row for each public comment made on a call. The `COMMENTS` table includes the following:

| Column name | Type | Value on delete | Description |
| --- | --- | --- | --- |
| COMMENT_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The Id of the comment |
| COMMENT | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The comment |
| COMMENT_TYPE | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 |  | The type of comment |
| CONVERSATION_KEY | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The unique identifier for the call the comment is associated with. (Unique) |
| CREATED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | NULL | The date and time the comment was made |
| MENTIONS | **Snowflake**: variant **BigQuery**: json **Databricks**: string **Redshift**: varchar(MAX) **S3**: UTF8 | NULL | A list of users tagged in the comment. Ids are separated with a comma |
| REPLY_TO_COMMENT_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | ID of the original comment this comment is replying to. |
| TAGS | **Snowflake**: variant **BigQuery**: json **Databricks**: string **Redshift**: varchar(MAX) **S3**: UTF8 | NULL | A list of tags set for the comment. Tags are phases prefixed with a #. Each tag in the list is separated with a comma |
| TIME_IN_CALL_SEC | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | The time in the call the comment was made, in seconds. |
| USER_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The Gong user ID for the person who made the comment. |
| IS_DELETED | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | Unchanged | Indicates whether the comment was deleted in Gong. Values are: - False: (default) Comment exists in Gong - True: Comment was deleted in Gong |
| ETL_MODIFIED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | Unchanged | The date and time the data was modified |
| ROW_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The ID to identify the row in the table. |

****Forecast_submissions****

The `FORECAST_SUBMISSIONS` table contains the most current team and individual forecasts submissions. To see previous submissions use the `FORECAST_SUBMISSIONS_HISTORY` table.

The table contains the following fields:

| Column name | Type | Value on delete | Description |
| --- | --- | --- | --- |
| FORECAST_AMOUNT_UNIT | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The unit the forecast was made in |
| FORECAST_CATEGORY_NAME | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The forecast category according to the values defined in the forecast board |
| IS_TEAM | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | NULL | When true, the forecast is a team forecast |
| LINE_OF_BUSINESS | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The name of the line of business the forecast is for |
| LINE_OF_BUSINESS_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The Gong ID for the line of business |
| NOTES | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | Notes the Gong user made on the forecast submission |
| PERIOD_NUMBER | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | 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 | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The period the forecast covers. Options are: - MONTH - QUARTER |
| PERIOD_YEAR | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | The fiscal year the forecast covers |
| SUBMIT_DATE | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | NULL | The date the forecast was submitted |
| SUBMIT_BY_USER_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The Gong user id of the user who submitted the forecast |
| SUBMISSION_TYPE | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The type of forecast submission. Options are: - MANUAL - NOTES_UPDATE - AUTOSUM - AUTOFILL - CARRY_OVER |
| USER_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | 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 | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | The forecast value |
| WEEK | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | The week during the quarter that the forecast was submitted |
| IS_DELETED | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | Unchanged | Indicates whether the forecast was deleted in Gong. Values are: - False (default): forecast exists in Gong - True: forecast was deleted in Gong |
| ETL_MODIFIED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | Unchanged | The date and time the data was modified |
| ROW_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The ID to identify the row in the table. |

****Forecast_submissions_history****

The `FORECAST_SUBMISSIONS_HISTORY` table contains current and previous team and individual forecasts submissions. Use the `SUBMIT_DATE` to determine which is the most recent submission.

> [!NOTE]
> Note:
> 
> This table shows manual user submissions. As forecasts in Gong may also include automated submissions, you may see forecast submissions in Gong which are not exported to Snowflake.

The table contains the following fields:

| Column name | Type | Value on delete | Description |
| --- | --- | --- | --- |
| FORECAST_AMOUNT_UNIT | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The unit the forecast was made in |
| FORECAST_CATEGORY_NAME | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The forecast category according to the values defined in the forecast board |
| IS_TEAM | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | NULL | When true, the forecast is a team forecast |
| LINE_OF_BUSINESS | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The name of the line of business the forecast is for |
| LINE_OF_BUSINESS_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The Gong ID for the line of business |
| NOTES | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | Notes the Gong user made on the forecast submission |
| PERIOD_NUMBER | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | 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 | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The period the forecast covers. Options are: - MONTH - QUARTER |
| PERIOD_YEAR | **Snowflake**: number **BigQuery**: decimal, numeric **Databricks**: decimal, dec, numeric **Redshift**: decimal, numeric **S3**: decimal | NULL | The fiscal year the forecast covers |
| SUBMIT_DATE | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | NULL | The date the forecast was submitted |
| SUBMIT_BY_USER_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The Gong user id of the user who submitted the forecast |
| USER_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | 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 | **Snowflake**: float **BigQuery**: decimal, numeric **Databricks**: decimal, dec, numeric **Redshift**: decimal, numeric **S3**: Float | NULL | The forecast value |
| WEEK | **Snowflake**: number **BigQuery**: decimal, numeric **Databricks**: decimal, dec, numeric **Redshift**: decimal, numeric **S3**: Decimal | NULL | The week during the quarter that the forecast was submitted |
| IS_DELETED | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | Unchanged | Indicates whether the forecast was deleted in Gong. Values are: - False (default): forecast exists in Gong - True: forecast was deleted in Gong |
| ETL_MODIFIED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | Unchanged | The date and time the data was modified |
| ROW_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The ID to identify the row in the table. |

****Forecast_targets****

The `FORECAST_TARGETS` table contains targets set for each team or for specific users. This table contains data for legacy forecast targets only. The table contains the following fields:

| Column name | Type | Value on delete | Description |
| --- | --- | --- | --- |
| IS_TEAM | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | NULL | When true, the target is a team target |
| LINE_OF_BUSINESS | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The name of the line of business the forecast target is for |
| LINE_OF_BUSINESS_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The Gong ID for the forecast target’s line of business |
| PERIOD_NUMBER | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | The number representing the period the forecast target is for. For example, if the forecast target is for Q3, this value is 3. If the forecast target is for August, this value is 8. |
| PERIOD_TYPE | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The period the forecast target covers. Options are: - MONTH - QUARTER |
| PERIOD_YEAR | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | The fiscal year the forecast target covers |
| SUBMIT_DATE | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | NULL | The date the forecast target was submitted in Gong |
| SUBMIT_BY_USER_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The Gong user id of the user who submitted the forecast target |
| TARGET_AMOUNT_UNIT | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The currency code the forecast target is submitted in |
| USER_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The user Id of the Gong user the forecast target is for. If a manager submits a forecast target 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 | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | The forecast target value |
| IS_DELETED | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | Unchanged | Indicates whether the forecast target was deleted in Gong. Values are: - False (default): forecast target exists in Gong - True: forecast target was deleted in Gong |
| ETL_MODIFIED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | Unchanged | The date and time the data was modified |
| ROW_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The ID to identify the row in the table. |

****Deal_likelihood_scores****

The `DEAL_LIKELIHOOD_SCORES` table shows a ranking Gong gives to each deal. This is a score that indicates the relative deal health according to the company's historical closed-won and closed-lost deal scores. It is calculated daily, and the new score added to the table, providing history of how the deal likelihood changed.

As the table is a standalone table, to get the details of the deal, retreive the deal details from the CRM according to the CRM_DEAL_ID. The table contains the following fields:

| Column name | Type | Description |
| --- | --- | --- |
| CRM_DEAL_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | The Id of the deal in the CRM that the deal likelihood score is for. Use this field to get the deal details from the CRM. |
| LAST_UPDATED | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | The date the score was last calculated |
| SCORE | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | The numerical score for the deal likelihood |
| SCORE_CATEGORY | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | The category for the deal likelihood score. Values are: 1-29: Low 30-75: Fair 76-99: High |
| ETL_MODIFIED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | The date and time the data was modified |
| ROW_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | The ID to identify the row in the table |

****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 | Value on delete | Description |
| --- | --- | --- | --- |
| IS_DELETED | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | Unchanged | Indicates whether the scorecard or the question were deleted |
| QUESTION_CREATED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | NULL | The date and time the question was defined |
| QUESTION_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The Id of a question included in the scorecard |
| QUESTION_IS_OVERALL_SCORE | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | NULL | Indicates whether the question enables providing an overall assessment of the call |
| QUESTION_MAX_RANGE | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | For questions with a numerical score, the maximum number that can be chosen |
| QUESTION_MIN_RANGE | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | For questions with a numerical score, the minimum number that can be chosen |
| QUESTION_MODIFIED_BY_USER_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The Id of the user who modified the question |
| QUESTION_MODIFIED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | NULL | The date and time the question was last modified |
| QUESTION_RESPONSE_OPTIONS | **Snowflake**: variant **BigQuery**: json **Databricks**: string **Redshift**: varchar(MAX) **S3**: UTF8 | NULL | The possible options in a multiple choice question |
| QUESTION_TEXT | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The text of the question |
| QUESTION_TYPE | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The type of question. Options are: - single_select - multi_select - range - open - boolean |
| SCORECARD_CREATED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | NULL | The date and time the scorecard was created |
| SCORECARD_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The scorecard Id |
| SCORECARD_IS_ENABLED | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | NULL | Indicates whether the scorecard is enabled or not |
| SCORECARD_MODIFIED_BY_USER_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The Id of the Gong user who last modified the scorecard |
| SCORECARD_MODIFIED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | NULL | The date and time the scorecard was last modified |
| SCORECARD_NAME | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The scorecard title |
| WORKSPACE_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The Id of the workspace the scorecard is associated with |
| ETL_MODIFIED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | Unchanged | The date and time the data was modified |
| ROW_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The ID to identify the row in the table. |

****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 | Value on delete | Description |
| --- | --- | --- | --- |
| ACCESSIBLE_TO | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The users who have permissions to view the scorecard. Options are: - PUBLIC - ONE_ON_ONE |
| ANSWER_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The ID for the answer |
| ANSWER_CREATED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | NULL | The date and time the answer was created |
| ANSWER_MODIFIED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS |  | The date and time the answer was last modified |
| ANSWER_NOT_APPLICABLE | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | Unchanged | Indicates if the answer is not applicable |
| ANSWER_SELECTED_OPTIONS | **Snowflake**: variant **BigQuery**: json **Databricks**: string **Redshift**: varchar(MAX) **S3**: UTF8 | NULL | The options selected in a multiple choice question |
| ANSWER_SCORE | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | The score given to the question |
| ANSWER_TEXT | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The text of the answer |
| CONVERSATION_KEY | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The key for the conversation the scorecard is being filled in for |
| GAVE_SCORECARD_USER_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The Id of the user who filled in the scorecard |
| LAST_PUBLISHED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | NULL | The date and time the answer was last published |
| QUESTION_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The Id of the question |
| QUESTION_IS_OVERALL_SCORE | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | NULL | Indicates whether the question enables providing an overall assessment of the call |
| QUESTION_MAX_RANGE | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | For questions with a numerical score, the maximum number that can be chosen |
| QUESTION_MIN_RANGE | **Snowflake**: BigInt, Integer, Int **BigQuery**: Int64 **Databricks**: BigInt, Long **Redshift**: BigInt, Int8 **S3**: BigInt | NULL | For questions with a numerical score, the minimum number that can be chosen |
| QUESTION_RESPONSE_OPTIONS | **Snowflake**: variant **BigQuery**: json **Databricks**: string **Redshift**: varchar(MAX) **S3**: UTF8 | NULL | The possible options in a multiple choice question |
| QUESTION_TEXT | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The text of the question |
| QUESTION_TYPE | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The type of question. Options are: - single_select - multi_select - range - open - boolean |
| RECEIVED_SCORECARD_USER_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The Id of the user who the scorecard was for |
| SCORECARD_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The scorecard Id. FK from the SCORECARD_QUESTIONS table. |
| SCORECARD_NAME | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The name of the scorecard |
| WORKSPACE_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The Id of the workspace the scorecard is associated with |
| ETL_MODIFIED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | Unchanged | The date and time the data was changed |
| ROW_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The ID to identify the row in the table. |

[](https://cdn.us.document360.io/2837c190-3ec8-4120-9116-6d427e774667/Images/Documentation/gong_database_reference_all_tables.json)gong_database_reference_all_tables129.95 KB[**](https://cdn.us.document360.io/2837c190-3ec8-4120-9116-6d427e774667/Images/Documentation/gong_database_reference_all_tables.json)

| ![](https://cdn.us.document360.io/2837c190-3ec8-4120-9116-6d427e774667/Images/Documentation/image-1723022223315.png) Visit our [Academy](https://academy.gong.io/courses/gong-data-cloud-playbook) and find out about using the Gong data cloud |
| --- |

A team member who manages and configures the Gong platform and handles CRM integrations, user provisioning, permissions, and system settings. [Find my Tech admin](/v1/docs/find-your-technical-or-business-admin).

Gong’s robust data sharing service that integrates Gong-enriched data with external data platforms- for deeper data analytics and advanced insights. Access to features depends on your [company’s plan and your assigned seat](/v1/docs/plans-and-seats).

## Related

- [Database design](/database-design.md)
- [Guide to analyzing Gong data with SQL queries](/guide-to-analyzing-gong-data-with-sql-queries.md)