---
title: "Calls and conversations tables"
slug: "calls-and-conversations-tables"
updated: 2026-10-13T08:57:29Z
published: 2026-10-13T08:57:29Z
canonical: "help.gong.io/calls-and-conversations-tables"
---

> ## 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.

# Calls and conversations 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:
> 
> 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.

****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 | Value on delete | Description |
| --- | --- | --- | --- |
| CONVERSATION_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | 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 | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | NULL | The date and time the conversation occurred |
| CONVERSATION_KEY | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The primary key for the conversation. As there are different types of conversations, such as calls or emails, this value is unique for all conversation types. |
| CONVERSATION_TYPE | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX)**S3**: Byte_array, UTF8 **S3**: Byte_array, UTF8 | NULL | The type of the conversation. Options are: - call - email - meeting |
| WORKSPACE_IDS | **Snowflake**: array (string) **BigQuery**: json **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The IDs of the workspaces the conversation is associated with |
| IS_DELETED | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | Unchanged | Indicates whether the conversation was deleted in Gong. Values are: - False (default): conversation exists in Gong - True: conversation 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. |

****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 | Value on delete | Description |
| --- | --- | --- | --- |
| BROWSER_DURATION_SEC | **Snowflake**: float **BigQuery**: float64 **Databricks**: float, double **Redshift**: real, float4, float8, double precision **S3**: Float | NULL | The amount of time in seconds the browser was shared during the call |
| CALL_SPOTLIGHT | **Snowflake**: variant **BigQuery**: json **Databricks**: string **Redshift**: varchar(MAX) **S3**: UTF8 | NULL | A JSON which contains the call [highlight](/v1/docs/capture-and-analyze-calls#review-your-call) data. Displayed in the **Brief** tab of the call page. See below for an example of the JSON. |
| CALL_SPOTLIGHT_BRIEF | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | A [summary](/v1/docs/review-what-happened-in-a-call) of the call. Displayed in the **Brief** tab of the call page. |
| CALL_SPOTLIGHT_KEY_POINTS | **Snowflake**: Array of varchars **BigQuery**: json **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The key points of the call. Displayed in the **Brief** tab of the call page. |
| CALL_SPOTLIGHT_NEXT_STEPS | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The steps that should be done when the call is completed. Displayed in the **Brief** tab of the call page. |
| CALL_SPOTLIGHT_AUTOMATIC_DISPOSITION | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The code of the outcome of the call as determined by Gong’s AI. Only populated for SDR calls One of the following: - no_voicemail - left_voicemail - number_not_in_service - line_is_busy - follow_up - meeting_booked - bad_timing - has_a_solution - bad_persona - wrong_number - gave_referral - bad_fit - opt_out - hung_up - gatekeeper - not_interested |
| CALL_SPOTLIGHT_OUTCOME | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | Not populated as of October 2024. Available in CALL_SPOTLIGHT_AUTOMATIC_DISPOSITION. |
| CALL_SPOTLIGHT_TYPE | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The type of call the highlight is for. Options are: - sdr_call - long_sales_call |
| CALL_URL | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The URL for the call |
| CONVERSATION_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | 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 | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The key for the conversation the call is associated with. (Unique) |
| DIRECTION | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | Indicates who made the call. Options are: - INBOUND - OUTBOUND - CONFERENCE - UNKNOWN |
| DISPOSITION | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The outcome of the call |
| EFFECTIVE_START_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | Unchanged | The scheduled start date and time of the call. If a call is rescheduled, this field updated with the new time. If a call starts later than scheduled, but the scheduled time isn’t changed, the field retains the scheduled start time. Only relevant if the call status is COMPLETED. |
| IS_PRIVATE | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | NULL | True if the call is a private call |
| OWNER_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The owner of the call. (Foreign key, `users` table) |
| PHONE_NUMBER | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The phone number of the prospect |
| PLANNED_END_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | NULL | The date and time the call was planned to end. |
| PLANNED_START_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | NULL | The date and time the call was planned to start. |
| PURPOSE | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The purpose of the call. |
| PRESENTATION_DURATION_SEC | **Snowflake**: float **BigQuery**: float64 **Databricks**: float, double **Redshift**: real, float4, float8, double precision **S3**: Float | NULL | The amount of time a presentation was shared during the call |
| QUESTION_COMPANY_COUNT | **Snowflake**: BigInt, Integer, Int **BigQuery:** decimal, numeric **Databricks**: decimal, dec, numeric **Redshift**: decimal, numeric **S3**: FIXED_LEN_BYTE_ARRAY, Decimal | NULL | The number of questions asked by people on the call from the company |
| QUESTION_NON_COMPANY_COUNT | **Snowflake**: BigInt, Integer, Int **BigQuery:** decimal, numeric **Databricks**: decimal, dec, numeric **Redshift**: decimal, numeric **S3**: FIXED_LEN_BYTE_ARRAY, Decimal | NULL | The number of questions asked by customers on the call |
| SCOPE | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | Indicates whether the call is an internal call only. Options are: - INTERNAL - EXTERNAL - UNKNOWN |
| SKIP_REASON | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | For calls that aren’t recorded, the skip code for the reason the call wasn’t recorded. See [Skip codes for unrecorded calls](/v1/docs/skip-codes-for-unrecorded-calls) |
| STATUS | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The status of the call recording, automatically assigned by Gong. You can filter reports based on the call 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 |
| SOURCE_SYSTEM | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The telephony system the call was made on |
| TITLE | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The title of the call |
| WEBCAM_NON_COMPANY_DURATION_SEC | **Snowflake**: float **BigQuery**: float64 **Databricks**: float, double **Redshift**: real, float4, float8, double precision **S3**: Float | NULL | The amount of time in seconds the customer had their webcam on |
| WEBCAM_OWNER_DURATION_SEC | **Snowflake**: float **BigQuery**: float64 **Databricks**: float, double **Redshift**: real, float4, float8, double precision **S3**: Float | NULL | The amount of time in seconds the host had their webcam on |
| WORKSPACE_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The workspace the call is associated with |
| IS_DELETED | **nowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | Unchanged | Indicates whether the call was deleted in Gong. Values are: - False (default): call exists in Gong - True: call 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. |

****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 | Value on delete | Description |
| --- | --- | --- | --- |
| CONVERSATION_KEY | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The key for the conversation the call is associated with. (Unique) |
| DURATION | **Snowflake**: BigInt, Integer, Int **BigQuery:** decimal, numeric **Databricks**: decimal, dec, numeric **Redshift**: decimal, numeric **S3**: FIXED_LEN_BYTE_ARRAY, Decimal | NULL | The duration of the call (in seconds) |
| END_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | NULL | The actual date and time the call ended. |
| 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 |
| LANGUAGE | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The code for the language the call was made in |
| MEDIA_TYPE | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | Sets the media for the call. Options are: - AUDIO - VIDEO |
| IS_DELETED | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | Unchanged | Indicates whether the call recording was deleted in Gong. Values are: - False (default): call recording exists in Gong - True: call recording was deleted in Gong |
| START_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | NULL | The actual start date and time of the call. |
| 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. |

****Call_Transcripts****

The `CALL_TRANSCRIPTS` table contains a row for each call. The transcript is a JSON with details about who said what and at what point in the conversation. You can see an example of the JSON received below the table.

The `CALL_TRANSCRIPTS` table includes the following:

| Column name | Type | Value on delete | Description |
| --- | --- | --- | --- |
| CONVERSATION_KEY | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The key for the conversation the call is associated with. (Unique) |
| TRANSCRIPT | **Snowflake**: array (string) **BigQuery**: json **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | A JSON of the transcript of the entire call. The transcript includes speaker segments, so you can see who said what and when in the call. |
| WORKSPACE_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The workspace the call is associated with |
| IS_DELETED | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | Unchanged | Indicates whether the call transcript was deleted in Gong. Values are: - False (default): call transcript exists in Gong - True: call transcript 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 call transcript 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. |

The structure for the JSON is as follows:

```plaintext
[
                    {
                    "speakerId": "4968385411579794447",
                    "sentences": [
                    {
                    "startMs": 420,
                    "endMs": 10930,
                    "text": "Michael. Good to meet you!"
                    },
                    {
                    "startMs": 11780,
                    "endMs": 14900,
                    "text": "Did you just arrive here?"
                    }
                    ]
                    },
                    {
                    "speakerId": "4968385411579794447",
                    "sentences": [
                    {
                    "startMs": 172350,
                    "endMs": 172570,
                    "text": "Yeah, We arrived last week."
                    }
                    ]
                    }
                    ]
```

****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](/v1/docs/trackers-overview#UUID-d1a21389-cf17-b998-e73d-74d5d1107202) 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 | Value on delete | Description |
| --- | --- | --- | --- |
| KEYWORDS | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The list of keywords in the tracker (JSON array). |
| NAME | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The name of the tracker, such as Pricing. |
| TRACKER_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The unique tracker ID |
| TRACKER_TYPE | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The tracker type: - smart_tracker - keyword_tracker |
| WORKSPACE_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The workspace the tracker is associated with |
| IS_DELETED | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | Unchanged | Indicates whether the tracker was deleted in Gong. Values are: - False (default): tracker exists in Gong - True: tracker 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. |

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 | Value on delete | Description |
| --- | --- | --- | --- |
| CONVERSATION_KEY | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The ID for the conversation (foreign key) |
| COUNT | **Snowflake**: BigInt, Integer, Int **BigQuery:** decimal, numeric **Databricks**: decimal, dec, numeric **Redshift**: decimal, numeric **S3**: FIXED_LEN_BYTE_ARRAY, Decimal | NULL | The number of times the tracker occurs. |
| TRACKER_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The tracker ID (foreign key) |
| TRACKER_EVIDENCE |  |  | The point in the call where the tracker content was detected. In JSON format: \| Key \| Type \| Description \| \| --- \| --- \| --- \| \| start \| number \| The time in the call the segment starts \| \| end \| number \| The time in the call the segment ends \| \| score \| number \| \| \| speakerId \| string \| The Gong ID of the person speaking \| |
| Key | Type | Description |
| start | number | The time in the call the segment starts |
| end | number | The time in the call the segment ends |
| score | number |  |
| speakerId | string | The Gong ID of the person speaking |
| TRACKER_SUMMARY |  |  | A summary of the sections of the call where the tracker content was detected. In JSON format: \| Key \| Type \| Description \| \| --- \| --- \| --- \| \| Bullets \| Array of objects \| The list of summary points. \| \| Bullets[].text \| string \| A single summary that lists the speaker, their company, and what they said \| |
| Key | Type | Description |
| Bullets | Array of objects | The list of summary points. |
| Bullets[].text | string | A single summary that lists the speaker, their company, and what they said |
| WORKSPACE_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The workspace the tracker is associated with |
| 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 |
| 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. |

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 | Value on delete | Description |
| --- | --- | --- | --- |
| CONVERSATION_KEY | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The key for the conversation |
| FIELDS_SNAPSHOT | **Snowflake**: varchar **BigQuery**: json **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | 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 | **Snowflake**: varchar **BigQuery**: json **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | Gong maps some fields in the CRM to other fields. For a list of mapped fields per CRM object see the table below |
| OBJECT_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The ID of the object in the CRM |
| OBJECT_TYPE | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The object type. Options are (in lowercase): - crm_account - crm_opportunity - crm_contact - crm_lead |
| IS_DELETED | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | Unchanged | Indicates whether the conversation context was deleted in Gong. Values are: - False (default): conversation context exists in Gong - True: conversation context 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. |

The following table shows how CRM fields are 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 |

****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 | Value on delete | Description |
| --- | --- | --- | --- |
| AFFILIATION | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | 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 |
| ASSOCIATED_OBJECT_TYPE | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The object type of the participant in the CRM. Options are: - Contact - Lead |
| CONVERSATION_KEY | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The key for the conversation the call is associated with. (Unique) |
| EMAIL_ADDRESS | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The email address of the participant |
| FIELDS_SNAPSHOT | **Snowflake**: variant **BigQuery**: json **Databricks**: string **Redshift**: varchar(MAX) | NULL | 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 |
| INVITEE_STATUS | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The invitees response to the meeting invitation. Null when conversation is not a meeting. Options are: - accepted - declined - none - tentative |
| MAPPED_FIELDS_SNAPSHOT | **Snowflake**: variant **BigQuery**: json **Databricks**: string **Redshift**: varchar(MAX) **S3**: UTF8 | NULL | Gong maps some fields in the CRM to other fields. For a list of mapped fields per CRM object see [mapped fields](/docs/calls-and-conversations-tables#mapping) |
| NAME | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The name of the participant in the conversation |
| PHONE_NUMBER | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The phone number of the participant |
| SPEAKER_ID | **Snowflake**: BigInt, Integer, Int **BigQuery:** decimal, numeric **Databricks**: decimal, dec, numeric **Redshift**: decimal, numeric **S3**: FIXED_LEN_BYTE_ARRAY, Decimal | NULL | The ID of the person speaking as listed in the call transcript. Transcripts are found in the `CALL_TRANSCRIPT` table. |
| TYPE | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | 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 | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The participant's Gong user ID. Null if they are not a Gong user. |
| IS_DELETED | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | Unchanged | Indicates whether the participant was deleted in Gong. Values are: - False (default): participant exists in Gong - True: participant 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. |

****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 ID for the call. For details on meetings, see [View meetings without scheduled recordings](/v1/docs/view-meetings-without-scheduled-recordings) . The `MEETINGS` table includes the following:

| Column name | Type | Value on delete | Description |
| --- | --- | --- | --- |
| CALL_CONVERSATION_KEY | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The conversation key of the call for the meeting. Null when there is no call associated with the meeting. |
| CALL_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The call ID |
| CONVERSATION_ID | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | 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 | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | The primary key for the meeting in Snowflake. (Unique) |
| CREATED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | NULL | The date and time the meeting created |
| END_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | NULL | The date and time the meeting is schedule to end |
| IS_ALL_DAY | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | NULL | When true, indicates the meeting will last the whole day |
| IS_CANCELED | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | NULL | When true, indicates the meeting was cancelled |
| IS_INTERNAL | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | NULL | When true, indicates the meeting is internal |
| IS_RECURRING | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | NULL | When true, sets that this is a recurring meeting |
| MODIFIED_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | NULL | The last date and time the meeting was modified |
| ORGANIZER_USER_ID | **Snowflake:** number **BigQuery:** decimal, numeric **Databricks**: decimal, dec, numeric **Redshift**: decimal, numeric **S3**: FIXED_LEN_BYTE_ARRAY, Decimal | NULL | The Gong user ID of the person who organized the meeting |
| START_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | NULL | The date and time the meeting is scheduled to start |
| TITLE | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | The title of the meeting |
| WORKSPACE_IDS | **Snowflake**: array (string) **BigQuery**: json **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | A list of the workspace IDs the meeting is associated with |
| IS_DELETED | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | Unchanged | Indicates whether the meeting was deleted in Gong. Values are: - False (default): meeting exists in Gong - True: meeting 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. |

****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 | Value on delete | Description |
| --- | --- | --- | --- |
| AUTO_SUBMITTED_TYPE | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | 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 | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | 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 | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | Unchanged | 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 | **Snowflake**: varchar **BigQuery**: string **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | INBOUND or OUTBOUND. Whether the email originated from a customer (inbound) or is an email to the customer (outbound) |
| IS_AUTO_SUBMITTED | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | NULL | When true, indicates that the email is submitted automatically |
| IS_MEETING_INVITE | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | NULL | When true, indicates the email is an invitation for a meeting |
| OOO_RETURN_DATE | **Snowflake**: dateTime **BigQuery**: date **Databricks**: date **Redshift**: date **S3**: UTF8 | NULL | Indicates the return date of an out of office email. NULL for non OOO emails. |
| SENT_DATETIME | **Snowflake**: timestamp_tz **BigQuery**: timestamp **Databricks**: timestamp **Redshift**: timestamp, timestamptz **S3**: INT64, TIMETAMP_MICROS | NULL | The timestamp for when the email was sent |
| WORKSPACE_IDS | **Snowflake**: array (string) **BigQuery**: json **Databricks**: string **Redshift**: varchar(MAX) **S3**: Byte_array, UTF8 | NULL | A list of the workspace IDs the email is associated with |
| IS_DELETED | **Snowflake**: boolean **BigQuery**: bool **Databricks**: boolean **Redshift**: boolean **S3**: Boolean | Unchanged | Indicates whether the email was deleted in Gong. Values are: - False (default): email exists in Gong - True: email 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. |

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).