Engage flows 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 for details of what's been added to the data cloud.

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.

Flow_Definitions

The FLOW_DEFINITIONS table contains a row for each flow, a multi-step outreach sequence that can be used for many people. Each row describes how the flow is set up. When a person is added to a flow, Gong adds a row to the FLOW_INSTANCES table. The FLOW_DEFINITIONS table includes the following:

Column name	Type	Value on delete	Description
FLOW_ID	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	Unchanged	The unique ID for the flow
NAME	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	Unchanged	The name of the flow
FOLDER_ID	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	Unchanged	The ID of the folder that contains the flow
CREATED_BY_USER_ID	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	Unchanged	The Gong user ID of the person who created the flow
WORKSPACE_ID	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	Unchanged	The ID of the Gong workspace the flow belongs to
CREATED_DATETIME	Snowflake: timestamp_tz BigQuery: timestamp Databricks: timestamp Redshift: timestamp, timestamptz S3: INT64, TIMESTAMP_MICROS	Unchanged	The date and time when the flow was created
MODIFIED_DATETIME	Snowflake: timestamp_tz BigQuery: timestamp Databricks: timestamp Redshift: timestamp, timestamptz S3: INT64, TIMESTAMP_MICROS	Unchanged	The date and time when the flow was last modified
MODIFIED_BY_USER_ID	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	Unchanged	The Gong user ID of the person who last modified the flow
ACCESS_LEVEL	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	NULL	The visibility of the flow, which sets who can see it. Options include: COMPANY: available to everyone in your organization PERSONAL: available only to the flow's owner
IS_PUBLISHED	Snowflake: boolean BigQuery: bool Databricks: boolean Redshift: boolean S3: Boolean	NULL	Indicates whether the flow is published and available for use
IS_SHARED	Snowflake: boolean BigQuery: bool Databricks: boolean Redshift: boolean S3: Boolean	NULL	Indicates whether the flow is shared, including with other team members for personal flows
IS_DELETED	Snowflake: boolean BigQuery: bool Databricks: boolean Redshift: boolean S3: Boolean	Unchanged	Indicates whether the flow was deleted in Gong. Values are: False (default): flow exists in Gong True: flow was deleted in Gong
NUMBER_OF_STEPS	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	NULL	The number of configured steps in the flow
IS_AI_GENERATED	Snowflake: boolean BigQuery: bool Databricks: boolean Redshift: boolean S3: Boolean	NULL	Indicates whether the flow was generated by AI, for example by Gong Assistant. Values are: False (default): the flow was created another way, including by duplicating a flow True: the flow was generated by AI
DURATION_DAYS	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	NULL	The expected number of days from the day a person is added to the flow until its last step is due, based on the delays configured between steps
IS_DELETED_BY_ENGAGE	Snowflake: boolean BigQuery: bool Databricks: boolean Redshift: boolean S3: Boolean	Unchanged	Indicates that the flow was deleted by a team member or process in Engage
ETL_MODIFIED_DATETIME	Snowflake: timestamp_tz BigQuery: timestamp Databricks: timestamp Redshift: timestamp, timestamptz S3: INT64, TIMESTAMP_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

Flow_Step_Definitions

The FLOW_STEP_DEFINITIONS table contains a row for each step in a flow. A flow step is an individual action, such as an email, a call, or a task. Each step has a position in the flow and a delay after the previous step. The FLOW_STEP_DEFINITIONS table includes the following:

Column name	Type	Value on delete	Description
FLOW_STEP_ID	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	Unchanged	The unique ID for the step
FLOW_ID	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	Unchanged	The ID of the flow the step belongs to. Use this field to join to FLOW_DEFINITIONS.FLOW_ID.
CREATED_BY_USER_ID	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	Unchanged	The Gong user ID of the person who created the step
CREATED_DATETIME	Snowflake: timestamp_tz BigQuery: timestamp Databricks: timestamp Redshift: timestamp, timestamptz S3: INT64, TIMESTAMP_MICROS	Unchanged	The date and time when the step was created
MODIFIED_DATETIME	Snowflake: timestamp_tz BigQuery: timestamp Databricks: timestamp Redshift: timestamp, timestamptz S3: INT64, TIMESTAMP_MICROS	Unchanged	The date and time when the step was last modified
MODIFIED_BY_USER_ID	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	Unchanged	The Gong user ID of the person who last modified the step
WORKSPACE_ID	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	Unchanged	The ID of the Gong workspace the step belongs to
IS_DELETED	Snowflake: boolean BigQuery: bool Databricks: boolean Redshift: boolean S3: Boolean	Unchanged	Indicates whether the step was deleted in Gong. Values are: False (default): step exists in Gong True: step was deleted in Gong
ACTION_TYPE	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	NULL	The type of action the step performs. Options include: SEND_EMAIL: a manual email step AUTO_SEND_EMAIL: an email that Gong sends automatically CALL: a call LINKEDIN_CONNECT: a LinkedIn connection request LINKEDIN_MESSAGE: a LinkedIn message CUSTOM: a custom task
IS_AUTOMATED	Snowflake: boolean BigQuery: bool Databricks: boolean Redshift: boolean S3: Boolean	NULL	When TRUE, the step runs automatically. When FALSE, the step is run manually.
STEP_POSITION	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	NULL	The position of the step in the flow
DAYS_AFTER_PREVIOUS	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	NULL	The number of days to wait after the previous step is completed before starting this step
EMAIL_TYPE	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	NULL	The type of email step. Options are reply and new thread. This field is generally NULL for non-email steps.
EXECUTE_IMMEDIATELY	Snowflake: boolean BigQuery: bool Databricks: boolean Redshift: boolean S3: Boolean	NULL	Indicates whether the step is configured to run immediately
EXECUTION_DATETIME	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	NULL	The preferred time of day for the step to run on the day it is due
PRIORITY	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	NULL	The priority assigned to the step, which is carried onto the to-do created from the step. Options include: NONE LOW MEDIUM (default) HIGH CRITICAL
IS_DELETED_BY_ENGAGE	Snowflake: boolean BigQuery: bool Databricks: boolean Redshift: boolean S3: Boolean	Unchanged	Indicates that the step was deleted by a team member or process in Engage
ETL_MODIFIED_DATETIME	Snowflake: timestamp_tz BigQuery: timestamp Databricks: timestamp Redshift: timestamp, timestamptz S3: INT64, TIMESTAMP_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

Flow_Instances

The FLOW_INSTANCES table contains a row for each time a person is added to a flow. Each row tracks that person's progress through the flow, including its status, who it is assigned to, and when it was completed. The FLOW_INSTANCES table includes the following:

Column name	Type	Value on delete	Description
FLOW_INSTANCE_ID	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	Unchanged	The unique ID for the flow instance
WORKSPACE_ID	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	Unchanged	The ID of the Gong workspace where the flow instance exists
FLOW_DEFINITION_ID	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	Unchanged	The ID of the flow definition used for the instance. Use this field to join to FLOW_DEFINITIONS.FLOW_ID.
STATUS	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	NULL	The current lifecycle status of the flow instance
STATUS_REASON	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	NULL	The reason associated with the current status, such as manual pause, goal met, or unsubscribed
STATUS_MODIFIED_DATETIME	Snowflake: timestamp_tz BigQuery: timestamp Databricks: timestamp Redshift: timestamp, timestamptz S3: INT64, TIMESTAMP_MICROS	NULL	The date and time when the instance status was last updated
CRM_CONTACT_ID	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	NULL	The CRM ID for the contact associated with the instance
CRM_ACCOUNT_ID	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	NULL	The CRM ID for the account associated with the instance
CRM_LEAD_ID	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	NULL	The CRM ID for the lead associated with the instance
CRM_CONVERTED_LEAD_ID	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	NULL	The CRM ID for the lead after conversion, when applicable
IS_LEAD_CONVERTED	Snowflake: boolean BigQuery: bool Databricks: boolean Redshift: boolean S3: Boolean	NULL	Indicates whether the associated CRM lead was converted into a contact
LATEST_PERSON_TYPE	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	NULL	The current person type associated with the instance, such as lead or contact
CRM_OPPORTUNITY_ID	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	NULL	The CRM ID for the opportunity associated with the instance or the opportunity that provided the flow context
ASSIGNED_TO_USER_ID	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	Unchanged	The Gong user ID of the team member assigned to work the flow instance
ASSIGNED_BY_USER_ID	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	Unchanged	The Gong user ID of the person or automated process that created or assigned the flow instance
CREATED_DATETIME	Snowflake: timestamp_tz BigQuery: timestamp Databricks: timestamp Redshift: timestamp, timestamptz S3: INT64, TIMESTAMP_MICROS	Unchanged	The date and time when the flow instance was created
MODIFIED_DATETIME	Snowflake: timestamp_tz BigQuery: timestamp Databricks: timestamp Redshift: timestamp, timestamptz S3: INT64, TIMESTAMP_MICROS	Unchanged	The date and time when the flow instance was last modified
ASSIGNED_TO_MODIFIED_DATETIME	Snowflake: timestamp_tz BigQuery: timestamp Databricks: timestamp Redshift: timestamp, timestamptz S3: INT64, TIMESTAMP_MICROS	Unchanged	The date and time when the assignee last changed
COMPLETED_DATETIME	Snowflake: timestamp_tz BigQuery: timestamp Databricks: timestamp Redshift: timestamp, timestamptz S3: INT64, TIMESTAMP_MICROS	Unchanged	The date and time when the flow instance was completed, when applicable
ASSIGNMENT_METHOD	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	NULL	How the flow instance was assigned. Options include: UI: added from the Engage UI PUBLIC_API: added through the public API AUTOMATION_RULE: added by an automation rule RECOMMENDED_CONTACTS: added from recommended contacts IFRAME: added from an embedded iframe EXTENSION_SALESFORCE: added from the Salesforce extension EXTENSION_HUBSPOT: added from the HubSpot extension EXTENSION_GMAIL: added from the Gmail extension MOTION: added by a play AGENT_WORKFLOW: added by an agent workflow
ASSIGNMENT_INTEGRATION_NAME	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	Unchanged	The name of the integration that created the assignment, when the assignment came through an integration
ASSIGNMENT_AUTOMATION_ID	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	Unchanged	The ID of the automation responsible for the assignment, when applicable
START_STEP_NUMBER	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	NULL	The step number at which the person or record should begin the flow
SHOULD_SKIP_EMAILS	Snowflake: boolean BigQuery: bool Databricks: boolean Redshift: boolean S3: Boolean	NULL	Indicates whether email steps should be skipped for this instance
EMAIL_SKIP_REASON	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	NULL	The reason email steps should be skipped, when applicable
SHOULD_SKIP_CALLS	Snowflake: boolean BigQuery: bool Databricks: boolean Redshift: boolean S3: Boolean	NULL	Indicates whether call steps should be skipped for this instance
CALL_SKIP_REASON	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	NULL	The reason call steps should be skipped, when applicable
IS_DELETED	Snowflake: boolean BigQuery: bool Databricks: boolean Redshift: boolean S3: Boolean	Unchanged	Indicates whether the flow instance was deleted in Gong. Values are: False (default): flow instance exists in Gong True: flow instance was deleted in Gong
ETL_MODIFIED_DATETIME	Snowflake: timestamp_tz BigQuery: timestamp Databricks: timestamp Redshift: timestamp, timestamptz S3: INT64, TIMESTAMP_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

Flow_Step_Activity_Events

The FLOW_STEP_ACTIVITY_EVENTS table contains a row for each event that happens as a person works through a flow, such as an email being sent, opened, clicked, or replied to, a call being connected, or a meeting being booked. Each event links to the flow, flow step, and flow instance it belongs to. The FLOW_STEP_ACTIVITY_EVENTS table includes the following:

Column name	Type	Value on delete	Description
FLOW_STEP_ACTIVITY_ID	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	Unchanged	The unique ID for the flow-step activity event
WORKSPACE_ID	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	Unchanged	The ID of the Gong workspace where the event occurred
EVENT_TYPE	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	NULL	The type of event. Options are: EMAIL_SENT EMAIL_OPENED EMAIL_CLICKED EMAIL_REPLIED CALL_INITIATED CALL_CONNECTED MEETING_BOOKED
EVENT_TIMESTAMP	Snowflake: timestamp_tz BigQuery: timestamp Databricks: timestamp Redshift: timestamp, timestamptz S3: INT64, TIMESTAMP_MICROS	NULL	The date and time when the event occurred. For example, an email-open event uses the time the email was opened.
ACTIVITY_TIMESTAMP	Snowflake: timestamp_tz BigQuery: timestamp Databricks: timestamp Redshift: timestamp, timestamptz S3: INT64, TIMESTAMP_MICROS	NULL	The timestamp of the related activity. The meaning varies by activity, such as the email-sent time or call-start time.
TIME_SINCE_ACTIVITY	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	NULL	The difference between the event time and the activity time
FLOW_DEFINITION_ID	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	Unchanged	The ID of the flow associated with the event. Use this field to join to FLOW_DEFINITIONS.FLOW_ID.
FLOW_STEP_ID	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	Unchanged	The ID of the flow step associated with the event. Use this field to join to FLOW_STEP_DEFINITIONS.FLOW_STEP_ID.
FLOW_INSTANCE_ID	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	Unchanged	The ID of the assigned flow instance associated with the event. Use this field to join to FLOW_INSTANCES.FLOW_INSTANCE_ID.
FLOW_TODO_ID	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	Unchanged	The ID of the assigned flow step to-do associated with the event, when applicable
STEP_ORDER	Snowflake: BigInt, Integer, Int BigQuery: decimal, numeric Databricks: decimal, dec, numeric Redshift: decimal, numeric S3: FIXED_LEN_BYTE_ARRAY, Decimal	NULL	The position of the related step within the flow
STEP_ACTION_TYPE	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	NULL	The type of action the related step performs. Options are the same as ACTION_TYPE in FLOW_STEP_DEFINITIONS
EMAIL_CONVERSATION_ID	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	Unchanged	The ID of the related email conversation, when applicable
REPLY_EMAIL_ID	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	Unchanged	The ID of the related reply email, when applicable
CALL_CONVERSATION_ID	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	Unchanged	The ID of the related call, when applicable. For a call that was not recorded, such as a dialer activity, this is the ID of the call activity.
MEETING_CONVERSATION_ID	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	Unchanged	The ID of the related meeting conversation, when applicable
CONVERSATION_KEY	Snowflake: varchar BigQuery: string Databricks: string Redshift: varchar(MAX) S3: Byte_array, UTF8	Unchanged	A unified activity ID that can be joined with CONVERSATION_KEY in the CONVERSATIONS table
IS_DELETED	Snowflake: boolean BigQuery: bool Databricks: boolean Redshift: boolean S3: Boolean	Unchanged	Indicates whether the event was deleted in Gong. Values are: False (default): event exists in Gong True: event was deleted in Gong
ETL_MODIFIED_DATETIME	Snowflake: timestamp_tz BigQuery: timestamp Databricks: timestamp Redshift: timestamp, timestamptz S3: INT64, TIMESTAMP_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