File Exporter Feed Schema

The tables below provide detailed information regarding the schema for exported data files that we can make available to you via the File Exporter API.

Table: autosummary_feedback

The autosummary feedback table stores summary text submitted by the agent after they have reviewed and edited it. This export will be sent daily and contains the hour for time zone conversion later.

Sync Time: 1d

Unique Condition: company_marker, conversation_id, summary_id

Column	Type	Description	Example	Aggregates	Notes	Date Added	Date Modified	Ignore	PII	release state	Specific Use	Feature Group
instance_ts	timestamp	The time window of computed elements. This window is usually 15 minutes or 1 hour depending on the generation time. Times are rounded down to the nearest interval (for a time of 12:34 and an interval of 15m, this is 12:30). As an example, for a 15 minute interval an instance_ts of 12:30 implies events from 12:30 -> 12:45. All times are in UTC.	2019-11-08 14:00:06.957000+00:00					no			common
conversation_id	string	Unique identifier generated by the ASAPP application for the issue or conversation.	ABC21352352					no			common
external_conversation_id	VARCHAR(255)	Client-provided issue identifier.	vjs654					no			common
agent_id	varchar(255)	The agent identifier in the conversation provided by the customer.	cba321					no			common
summary_id	VARCHAR(36)	Unique identifier for AutoSummary feedback and free-text summary events	57ffe572-e9dc-4546-963b-29d90b0d92a9					no			AutoSummary
autosummary_feedback_ts	timestamp	The timestamp of the autosummary_feedback_summary event.	2023-05-01 14:00:09					no			AutoSummary
autosummary_feedback	string	Text submitted with agent edits, summarizing the conversation from the autosummary freetext API call.	Customer chatted in to check whether the app worked					no			AutoSummary
company_marker	varchar(255)	Identifier of the customer-company.	agnostic					no			common
dt	varchar(255)	Date string when summary feedback was submitted.	2019-11-08					no			common
hr	varchar(255)	Hour string when summary feedback was submitted.	18					no			common

Table: autosummary_free_text

The autosummary free text table stores the raw output of ASAPP’s API. It is the unedited summary initially shown to the agent to be reviewed. This export will be sent daily and contains the hour for time zone conversion later.

Sync Time: 1d

Unique Condition: company_marker, conversation_id, summary_id

Column	Type	Description	Example	Aggregates	Notes	Date Added	Date Modified	Ignore	PII	release state	Specific Use	Feature Group
instance_ts	timestamp	The time window of computed elements. This window is usually 15 minutes or 1 hour depending on the generation time. Times are rounded down to the nearest interval (for a time of 12:34 and an interval of 15m, this is 12:30). As an example, for a 15 minute interval an instance_ts of 12:30 implies events from 12:30 -> 12:45. All times are in UTC.	2019-11-08 14:00:06.957000+00:00					no			common
conversation_id	string	Unique identifier generated by the ASAPP application for the issue or conversation.	ABC21352352					no			common
external_conversation_id	VARCHAR(255)	Client-provided issue identifier.	vjs654					no			common
agent_id	varchar(255)	The agent identifier in the conversation provided by the customer.	cba321					no			common
summary_id	VARCHAR(36)	Unique identifier for AutoSummary feedback and free-text summary events	57ffe572-e9dc-4546-963b-29d90b0d92a9					no			AutoSummary
autosummary_free_text_ts	timestamp	The timestamp of the autosummary_free_text_summary event.	2023-05-01 14:00:09					no			AutoSummary
autosummary_free_text	string	Unedited text summarizing the conversation at the time of the autosummary free text API call.	Customer chatted in to check whether the app worked					no			AutoSummary
is_autosummary_feedback_used	integer	An indicator that the AutoSummary had a feedback summary.	1					no			AutoSummary
is_autosummary_feedback_edited	integer	An indicator that the AutoSummary had a feedback summary that was edited.	0					no			AutoSummary
autosummary_free_text_length	integer	Length of the FreeText AutoSummaries. Will only have a value when there is both freetext and feedback summaries.	54					no			AutoSummary
autosummary_feedback_length	integer	Length of the Feedback AutoSummaries. Will only have a value when there is both freetext and feedback summaries.	54					no			AutoSummary
autosummary_levenshtein_distance	integer	Levenshtein edit distances between the AutoSummaries FreeText and Feedback. Will only have a value when there is both freetext and feedback summaries.	0					no			AutoSummary
autosummary_sentences_removed	string	autosummary_sentences_removed contain the sentenses that are generated in freetext summary and got edited or removed feedback summary.	Customer called to pay their bill					no			AutoSummary
autosummary_sentences_added	string	autosummary_sentences_added contain the sentenses that are added as part of feedback summary in compared to freetext summary.	Customer called to pay the bill					no			AutoSummary
company_marker	varchar(255)	Identifier of the customer-company.	agnostic					no			common
dt	varchar(255)	Date string when summary feedback was submitted.	2019-11-08					no			common
hr	varchar(255)	Hour string when summary feedback was submitted.	18					no			common

Table: autosummary_structured_data

The autosummary structured data table stores the raw output of ASAPP’s API. These structured data outputs consist of LLM generated answers to yes/no questions along with extracted entities based on configuration settings. These outputs can be aggregated and packaged into business insights. This export will be sent daily and contains the hour for time zone conversion later.

Sync Time: 1d

Unique Condition: company_marker, conversation_id, structured_data_id, structured_data_field_id

Column	Type	Description	Example	Aggregates	Notes	Date Added	Date Modified	Ignore	PII	release state	Specific Use	Feature Group
instance_ts	timestamp	The time window of computed elements. This window is usually 15 minutes or 1 hour depending on the generation time. Times are rounded down to the nearest interval (for a time of 12:34 and an interval of 15m, this is 12:30). As an example, for a 15 minute interval an instance_ts of 12:30 implies events from 12:30 -> 12:45. All times are in UTC.	2019-11-08 14:00:06.957000+00:00					no			common
conversation_id	string	Unique identifier generated by the ASAPP application for the issue or conversation.	ABC21352352					no			common
external_conversation_id	VARCHAR(255)	Client-provided issue identifier.	vjs654					no			common
agent_id	varchar(255)	The agent identifier in the conversation provided by the customer.	cba321					no			common
structured_data_id	varchar(36)	Unique identifier for AutoSummary structured data event	57ffe572-e9dc-4546-963b-29d90b0d92a9					no			common
structured_data_ts	timestamp	The timestamp of the autosummary_structured_data event.	2023-05-01 14:00:09					no			common
structured_data_field_id	varchar(255)	The structured data id.	q_issue_escalated					no			common
structured_data_field_name	varchar(255)	The structured data name.	Issue escalated					no			common
structured_data_field_value	varchar(255)	The structured data value.	No					no			common
structured_data_field_category	varchar(255)	The structured data category.	Outcome					no			common
company_marker	varchar(255)	Identifier of the customer-company.	agnostic					no			common
dt	varchar(255)	Date string when summary structured data was generated.	2019-11-08					no			common
hr	varchar(255)	Hour string when summary structured data was generated.	18					no			common

Table: contact_entity_generative_agent

hourly snapshot of contact grain generative_agent data including both dimensions and metrics aggregated over “all time” (two days in practice).

Sync Time: 1h

Unique Condition: company_marker, conversation_id, contact_id

Column	Type	Description	Example	Aggregates	Notes	Date Added	Date Modified	Ignore	PII	release state	Specific Use	Feature Group
company_marker	string	The ASAPP identifier of the company or test data source.	acme			2025-01-06 00:00:00	2025-01-06 00:00:00	no
conversation_id	string	Unique identifier generated by the ASAPP application for the issue or conversation.	ABC21352352			2025-01-06 00:00:00	2025-01-06 00:00:00	no
contact_id	string					2025-01-06 00:00:00	2025-01-06 00:00:00	no
instance_ts	timestamp	The time window of computed elements. This window is usually 15 minutes or 1 hour depending on the generation time. Times are rounded down to the nearest interval (for a time of 12:34 and an interval of 15m, this is 12:30). As an example, for a 15 minute interval an instance_ts of 12:30 implies events from 12:30 -> 12:45. All times are in UTC.	2019-11-08 14:00:06.957000+00:00			2025-01-06 00:00:00	2025-01-06 00:00:00	no
generative_agent_turns__turn_ct	int	Number of turns.	1			2025-01-06 00:00:00	2025-01-06 00:00:00	no
generative_agent_turns__turn_duration_ms_sum	bigint	Total number of milliseconds between PROCESSING_START and PROCESSING_END across all turns.	2			2025-01-06 00:00:00	2025-01-06 00:00:00	no
generative_agent_turns__utterance_ct	int	Number of generative_agent utterances.	2			2025-01-06 00:00:00	2025-01-06 00:00:00	no
generative_agent_turns__contains_escalation	boolean	Boolean indicating the presence of a turn in the conversation that ended with an indication to escalate to a human agent.	1			2025-01-06 00:00:00	2025-01-06 00:00:00	no
generative_agent_turns__is_contained	boolean	Boolean indicating whether or not the conversation was contained (NOT generative_agent_turns__contains_escalation).	1			2025-01-06 00:00:00	2025-01-06 00:00:00	no
generative_agent_tasks__first_task_name	varchar(255)	Name of the first task entered by generative_agent.	SomethingElse			2025-01-06 00:00:00	2025-01-06 00:00:00	no
generative_agent_tasks__last_task_name	varchar(255)	Name of the last task entered by generative_agent.	SomethingElse			2025-01-06 00:00:00	2025-01-06 00:00:00	no
generative_agent_tasks__task_ct	int	Number of tasks entered by generative_agent.	2			2025-01-06 00:00:00	2025-01-06 00:00:00	no
generative_agent_tasks__configuration_id	varchar(255)	The configuration version that produced generative_agent actions.	4ea5b399-f969-49c6-8318-e2c39a98e817			2025-01-06 00:00:00	2025-01-06 00:00:00	no

Table: staging_conversation_state

This issue-grain table provides a consolidated view of metrics produced across multiple ASAPP services for a given issue. The table is populated daily and includes hour-level data for time zone conversion.

Sync Time: 1d

Unique Condition: company_marker, conversation_id, dt, hr

Column	Type	Description	Example	Aggregates	Notes	Date Added	Date Modified	Ignore	PII	release state	Specific Use	Feature Group
conversation_id	timestamp	Unique identifier generated by the ASAPP application for the issue or conversation.	ABC21352352					no			Conversation
instance_ts	timestamp	The time window of computed elements. This window is usually 15 minutes or 1 hour depending on the generation time. Times are rounded down to the nearest interval (for a time of 12:34 and an interval of 15m, this is 12:30). As an example, for a 15 minute interval an instance_ts of 12:30 implies events from 12:30 -> 12:45. All times are in UTC.	2019-11-08 14:00:06.957000+00:00					no			Conversation
first_event_ts	timestamp	Timestamp of the first event associated with the conversation_id.	2018-06-23 21:28:23					no			Conversation
conversation_start_ts	timestamp	Timestamp indicating the start of the conversation as provided by the customer; this will be null if is not provided or conversation started on a previous day. Alternative timestamps include the customer_first_utterance_ts and agent_first_response_ts timestamps or the first_event_ts (earliest time for ASAPP involvement).	2019-11-08 14:00:07					no			Conversation
external_conversation_id	VARCHAR(255)	The conversation id provided by the customer.	750068130001					no			Conversation
conversation_customer_effective_ts	timestamp	The timestamp of the last change to the customer_id provided by the customer.	2019-11-08 14:00:07					no			Conversation
customer_id	varchar(255)	The customer identifier provided by the customer.	abc123					no			Conversation
conversation_agent_effective_ts	timestamp	The timestamp of the last change to the agent_id provided by the customer.	2019-11-08 14:00:07					no			Conversation
last_agent_id	varchar(191)	The last agent identifier in the conversation provided by the customer.	abc123					no			Conversation
all_agent_ids		A list of all the agent identifiers within the conversation provided by the customer.	[abc123,abc456]					no			Conversation
customer_utterance_ct		Count of all customer messages.	5					no			Conversation
agent_utterance_ct		Count of all agent messages.	16					no			Conversation
customer_first_utterance_ts	timestamp	Timestamp of the first customer utterance.	2019-11-08 14:00:07					no			Conversation
agent_first_utterance_ts		Timestamp of the first agent utterance.	2019-11-08 14:00:07					no			Conversation
customer_last_utterance_ts	timestamp	Timestamp of the last customer utterance.	2019-11-08 14:00:07					no			Conversation
agent_last_utterance_ts		Timestamp of the last agent utterance.	2019-11-08 14:00:07					no			Conversation
autosuggest_utterance_ct		Count of utterances where AutoSuggest was used.	6					no			AutoCompose
autocomplete_utterance_ct		Count of utterances where AutoComplete was used.	2					no			AutoCompose
phrase_autocomplete_utterance_ct		Count of utterances where Phrase AutoComplete was used.	0					no			AutoCompose
custom_drawer_utterance_ct		Count of utterances where Custom Drawer was used.	1					no			AutoCompose
custom_insert_utterance_ct		Count of utterances where Custom Insert was used.	0					no			AutoCompose
global_insert_utterance_ct		Count of utterances where Global Insert was used.	1					no			AutoCompose
fluency_apply_utterance_ct		Count of utterances where Fluency Apply was used.	0					no			AutoCompose
fluency_undo_utterance_ct		Count of utterances where Fluency Undo was used.	0					no			AutoCompose
autosummary_structured_summary_tags_event_ts	timestamp	The timestamp of the last autosummary_structured_summary_tags event.	2019-11-08 14:00:07					no			AutoSummary
autosummary_tags	string	Comma-separated list of tags or codes indicating key topics of this conversation.	{"server":"some-server","server_version":"unknown"}					no			AutoSummary
autosummary_free_text_summary_event_ts	timestamp	The timestamp of the last autosummary_free_text_summary event.	2019-11-08 14:00:07					no			AutoSummary
autosummary_text	string	Text summarizing the conversation.	Unresponsive Customer.					no			AutoSummary
is_autosummary_structured_summary_tags_used		An indicator that the conversation had AutoSummary structured summary tags. When aggregating from conversation by day to conversation use MAX().	1					no			AutoSummary
is_autosummary_free_text_summary_used		An indicator that the conversations had AutoSummary free text summary. When aggregating from conversation by day to conversation use MAX().	1					no			AutoSummary
is_autosummary_feedback_used	int	An indicator that the conversation had AutoSummary feedback summary. When aggregating from conversation by day to conversation use MAX().	1					no			AutoSummary
is_autosummary_used		An indicator that the conversation that had any response (tag, free text, feedback) in Autosummary. When aggregating from conversation by day to conversation use MAX().	1					no			AutoSummary
is_autosummary_feedback_edited	int	An indicator that the conversation had at least one AutoSummary that received Feedback with an edited summary. When aggregating from conversation by day to conversation use MAX().	1					no			Conversation
autosummary_feedback_ct	bigint	Count of AutoSummaries that received Feedback for the conversation.	4					no			Conversation
autosummary_feedback_edited_ct	bigint	Count of AutoSummaries that received edited Feedback for the conversation.	3					no			Conversation
autosummary_free_text_length_sum	bigint	Sum of the length of all the FreeText AutoSummaries for the conversation.	80					no			Conversation
autosummary_feedback_length_sum	bigint	Sum of the length of all the Feedback AutoSummaries for the conversation.	120					no			Conversation
autosummary_levenshtein_distance_sum	bigint	Sum of the Levenshtein edit distances between the AutoSummaries FreeText and Feedback.	40					no			Conversation
first_intent_effective_ts	timestamp	The timestamp of the last first_intent event.	2019-11-08 14:00:07					no			JourneyInsight
first_intent_message_id	string	The id of the message that was sent with the first intent.	01GA9V1F2B7Q4Y8REMRZ2SXVRT					no			JourneyInsight
first_intent_intent_code	string	The intent code associated with the rule that was sent as the first intent within the conversation.	INCOMPLETE					no			JourneyInsight
first_intent_intent_name	string	The intent name correspondent to the intent_code that was sent as the first intent within the conversation.	INCOMPLETE					no			JourneyInsight
first_intent_is_known_good	boolean	Indicates if the classification for the first_intent data comes from a known good.	FALSE					no			JourneyInsight
conversation_metadata_effective_ts	timestamp	The timestamp of the last conversation metadata	2019-11-08 14:00:07					no			Metadata
conversation_metadata_lob_id	string	Line of business ID from Conversation Metadata	1038					no			Metadata
conversation_metadata_lob_name	string	Line of business descriptive name from Conversation Metadata	manufacturing					no			Metadata
conversation_metadata_agent_group_id	string	Agent group ID from Conversation Metadata	group59					no			Metadata
conversation_metadata_agent_group_name	string	Agent group descriptive name from Conversation Metadata	groupXYZ					no			Metadata
conversation_metadata_agent_routing_code	string	Agent routing attribute from Conversation Metadata	route-13988					no			Metadata
conversation_metadata_campaign	string	Campaign from Conversation Metadata	campaign-A					no			Metadata
conversation_metadata_device_type	string	Client device type from Conversation Metadata	TABLET					no			Metadata
conversation_metadata_platform	string	Client platform type from Conversation Metadata	IOS					no			Metadata
conversation_metadata_company_segment	[]string	Company segment from Conversation Metadata	[“Sales”,“Marketing”]					no			Metadata
conversation_metadata_company_subdivision	string	Company subdivision from Conversation Metadata	operating					no			Metadata
conversation_metadata_business_rule	string	Business rule from Conversation Metadata	Apply customer’s discount					no			Metadata
conversation_metadata_entry_type	string	Type of entry from Conversation Metadata, e.g., proactive vs reactive	reactive					no			Metadata
conversation_metadata_operating_system	string	Operating system from Conversation Metadata	OPERATING_SYSTEM_MAC_OS					no			Metadata
conversation_metadata_browser_type	string	Browser type from Conversation Metadata	Safari					no			Metadata
conversation_metadata_browser_version	string	Browser version from Conversation Metadata	14.1.2					no			Metadata
contact_journey_contact_id	string	(NULLIFIED) Conversation Contact ID						no			Contact
contact_journey_last_conversation_inactive_ts	timestamp	Last time the conversation went inactive (may be limited to voice conversations)	2023-06-11 18:45:29					no			Contact
contact_journey_first_contact_utterance_ts	timestamp	First utterance in the contact	2023-06-11 18:32:21					no			Contact
contact_journey_last_contact_utterance_ts	timestamp	Last utterance in the contact	2023-06-11 18:40:29					no			Contact
contact_journey_contact_start_ts	timestamp	First event in the contact	2023-06-11 18:30:29					no			Contact
contact_journey_contact_end_ts	timestamp	Last event in the contact	2023-06-11 18:58:29					no			Contact
aug_metrics_effective_ts	timestamp	Timestamp of the last augmentation metrics event	”2023-08-09T19:21:34.224620050Z”					no			AutoCompose
augmented_utterances_ct		Count of all utterances that used any augmentation feature (excluding fluency)	100					no			AutoCompose
multiple_augmentation_features_used_ct		Count utterances where multiple augmentation features (excluding fluency) were used	100					no			AutoCompose
autosuggest_ct		Count of utterances where only AutoSuggest augmentation is used (excluding fluency)	100					no			AutoCompose
autocomplete_ct		Count of utterances where only AutoComplete augmentation is used (excluding fluency)	100					no			AutoCompose
phrase_autocomplete_ct		Count of utterances where only Phrase AutoComplete augmentation is used (excluding fluency)	100					no			AutoCompose
custom_drawer_ct		Count of utterances where only Custom Drawer augmentation is used (excluding fluency)	100					no			AutoCompose
custom_insert_ct		Count of utterances where only Custom Insert augmentation is used (excluding fluency)	100					no			AutoCompose
global_insert_ct		Count of utterances where only Global Insert augmentation is used (excluding fluency)	100					no			AutoCompose
unknown_augmentation_ct		Count of utterances where only an unidentified augmentation was used (excluding fluency)	100					no			AutoCompose
fluency_apply_ct		Count of utterances where Fluency Apply augmentation is used	100					no			AutoCompose
fluency_undo_ct		Count of utterances where Fluency Undo augmentation is used	100					no			AutoCompose
message_edits_ct	bigint	Total accumulated sum of the number of characters entered or deleted by the user and not by augmentation, after the most recent augmentation that replaces all text in the composer (AUTOSUGGEST, AUTOCOMPLETE, CUSTOM_DRAWER). If the agent selected a suggestion and sends without any changes, this number is 0.	100					no			AutoCompose
time_to_action_seconds	float	Total accumulated sum of the number of seconds between the agent sending their previous message and their first action for composing this message.	100					no			AutoCompose
crafting_time_seconds	float	Total accumulated sum of the number of seconds between the agent’s first action and last action for composing this message.	100					no			AutoCompose
dwell_time_seconds	float	Total accumulated sum of the number of seconds between the agent’s last action for composing this message and the message being sent	100					no			AutoCompose
phrase_autocomplete_presented_ct	bigint	Total accumulated sum of the number of phrase autocomplete suggestions presented to the agent. Resets when augmentation_type resets	100					no			AutoCompose
phrase_autocomplete_selected_ct	bigint	Total accumulated sum of the number of phrase autocomplete suggestions selected by the agent. Resets when augmentation_type resets.	100					no			AutoCompose
single_intent_effective_ts	timestamp	The timestamp of the last single intent event.	2019-11-08 14:00:07					no
single_intent_intent_code	string	Intent code	CHECK_COVERAGE					no
single_intent_intent_name	string	Intent name	Check Coverage					no
single_intent_messages_considered_ct	bigint	How many utterances were consided to calculate a single intent code.	2					no
company_marker	string	Identifier of the customer-company.	agnostic					no			Conversation
dt	string	Date string representing the date during which the conversation state happened.	2019-11-08					no			Conversation
hr	string	Hour string representing the hour during which the conversation state happened.	18					no			Conversation

Table: staging_utterance_state

This utterance-grain table contains insights for individual conversation messages. Each record in this dataset represents an individual utterance, or message, within a conversation. The table is populated daily and includes hour-level data for time zone conversion purposes.

Sync Time: 1d

Unique Condition: company_marker, conversation_id, message_id

Column	Type	Description	Example	Aggregates	Notes	Date Added	Date Modified	Ignore	PII	release state	Specific Use	Feature Group
conversation_id	string	Unique identifier generated by the ASAPP application for the issue or conversation.	ABC21352352					no			Conversation
message_id	string	This is the ULID id of a given message.	01GASGE3WAG84BGARCS238Z0FG					no			Conversation
instance_ts	timestamp	The time window of computed elements. This window is usually 15 minutes or 1 hour depending on the generation time. Times are rounded down to the nearest interval (for a time of 12:34 and an interval of 15m, this is 12:30). As an example, for a 15 minute interval an instance_ts of 12:30 implies events from 12:30 -> 12:45. All times are in UTC.	2019-11-08 14:00:06.957000+00:00					no			Conversation
chat_message_event_ts	timestamp	The timestamp of the last chat_message event.	2018-06-23 21:28:23					no			Conversation
external_conversation_id	VARCHAR(255)	The issue or conversation id from the customer/client perspective.	ffe8a632-545f-4c2e-a0ae-c296e6ad4a22					no			Conversation
sender_type	string	The type of sender.	SENDER_CUSTOMER					no			Conversation
sender_id	string	Unique identifier of the sender user.	ffe8a632-545f-4c2e-a0ae-c296e6ad4a25					no			Conversation
private_message_ct	bigint	Number of private messages, a private message is only when it was between agents/admins not the customer.	1					no			Conversation
tags	string	Key-value map of additional properties.					no			Conversation
utterance_augmentations_effective_ts	timestamp	The timestamp of the last utterance_augmentations event.	2018-06-23 21:28:23					no			AutoCompose
augmentation_type_list	string	DEPRECATED Type of augmentation used. If multiple augmentations were used, a comma-separated list of types.	AUTOSUGGEST,AUTOCOMPLETE					no			AutoCompose
num_edits_ct	bigint	Number of edits made to an augmented message.	2					no			AutoCompose
selected_suggestion_text	string	DEPRECATED The text inserted into the composer by the last augmentation that replaced all text (AUTOSUGGEST,	Hi. How may I help you?					no			AutoCompose
time_to_action_seconds	float	Number of seconds between the agent sending their previous message and their first action for composing	3.286					no			AutoCompose
crafting_time_seconds	float	Number of seconds between the agent’s first action and last action for composing this message.	0.0					no			AutoCompose
dwell_time_seconds	float	Number of seconds between the agent’s last action for composing this message and the message being sent.	0.844					no			AutoCompose
phrase_autocomplete_presented_ct	bigint	Number of phrase autocomplete suggestions presented to the agent.	1					no			AutoCompose
phrase_autocomplete_selected_ct	bigint	Number of phrase autocomplete suggestions selected by the agent.	0					no			AutoCompose
utterance_message_metrics_effective_ts	timestamp	The timestamp of the last utterance_message_metrics event.	2018-06-23 21:28:23					no			Conversation
utterance_length	int	Length of utterance message.	13					no			Conversation
agent_metadata_effective_ts	timestamp	The timestamp of the last agent_metadata event.	2018-06-23 21:28:23					no			Conversation
agent_metadata_external_agent_id	string	The external rep/agent identifier.	abc123					no			Conversation
agent_metadata_event_ts	timestamp	The timestamp of when this event happened (system driven).	2018-06-23 21:28:23					no			Conversation
agent_metadata_start_ts	timestamp	The timestamp of when the agent started.	2018-06-23 21:28:23					no			Conversation
agent_metadata_lob_id	string	Line of business id.	lobId_7					no			Conversation
agent_metadata_lob_name	string	Line of business descriptive name.	lobName_7					no			Conversation
agent_metadata_group_id	string	Group id.	groupId_7					no			Conversation
agent_metadata_group_name	string	Group descriptive name.	groupName_7					no			Conversation
agent_metadata_location	string	Agent’s supervisor Id.	supervisorId_7					no			Conversation
agent_metadata_languages	string	Agent’s languages.	[{"value":"en-us"}]					no			Conversation
agent_metadata_concurrency	int	Number of issues that the agent can take at a time.	3					no			Conversation
agent_metadata_category_label	string	An agent category label that indicates the types of workflows these agents have access to or problems they solve.	categoryLabel_7					no			Conversation
agent_metadata_account_access_level	string	Agent levels mapping to the level of access they have to make changes to customer accounts.	accountAccessLevel_7					no			Conversation
agent_metadata_ranking	int	Agent’s rank.	2					no			Conversation
agent_metadata_vendor	string	Agent’s vendor.	vendor_7					no			Conversation
agent_metadata_job_title	string	Agent’s job title.	jobTitle_7					no			Conversation
agent_metadata_job_role	string	Agent’s role.	jobRole_7					no			Conversation
agent_metadata_work_shift	string	The hours or shift name they work.	workShift_7					no			Conversation
agent_metadata_attributes_attr_01_name	string	Name of the arbitrary attribute (not indexed or used internally, used as pass through).	name					no			Conversation
agent_metadata_attributes_attr_01_value	string	Value of the arbitrary attribute (not indexed or used internally, used as pass through).	attr1_name					no			Conversation
agent_metadata_attributes_attr_02_name	string	Name of the arbitrary attribute (not indexed or used internally, used as pass through).	name					no			Conversation
agent_metadata_attributes_attr_02_value	string	Value of the arbitrary attribute (not indexed or used internally, used as pass through).	attr2_name					no			Conversation
agent_metadata_attributes_attr_03_name	string	Name of the arbitrary attribute (not indexed or used internally, used as pass through).	name					no			Conversation
agent_metadata_attributes_attr_03_value	string	Value of the arbitrary attribute (not indexed or used internally, used as pass through).	attr3_name					no			Conversation
agent_metadata_attributes_attr_04_name	string	Name of the arbitrary attribute (not indexed or used internally, used as pass through).	name					no			Conversation
agent_metadata_attributes_attr_04_value	string	Value of the arbitrary attribute (not indexed or used internally, used as pass through).	attr4_name					no			Conversation
agent_metadata_attributes_attr_05_name	string	Name of the arbitrary attribute (not indexed or used internally, used as pass through).	name					no			Conversation
agent_metadata_attributes_attr_05_value	string	Value of the arbitrary attribute (not indexed or used internally, used as pass through).	attr5_name					no			Conversation
agent_metadata_attributes_attr_06_name	string	Name of the arbitrary attribute (not indexed or used internally, used as pass through).	name					no			Conversation
agent_metadata_attributes_attr_06_value	string	Value of the arbitrary attribute (not indexed or used internally, used as pass through).	attr6_name					no			Conversation
agent_metadata_attributes_attr_07_name	string	Name of the arbitrary attribute (not indexed or used internally, used as pass through).	name					no			Conversation
agent_metadata_attributes_attr_07_value	string	Value of the arbitrary attribute (not indexed or used internally, used as pass through).	attr7_name					no			Conversation
agent_metadata_attributes_attr_08_name	string	Name of the arbitrary attribute (not indexed or used internally, used as pass through).	name					no			Conversation
agent_metadata_attributes_attr_08_value	string	Value of the arbitrary attribute (not indexed or used internally, used as pass through).	attr8_name					no			Conversation
agent_metadata_attributes_attr_09_name	string	Name of the arbitrary attribute (not indexed or used internally, used as pass through).	name					no			Conversation
agent_metadata_attributes_attr_09_value	string	Value of the arbitrary attribute (not indexed or used internally, used as pass through).	attr9_name					no			Conversation
agent_metadata_attributes_attr_10_name	string	Name of the arbitrary attribute (not indexed or used internally, used as pass through).	name					no			Conversation
agent_metadata_attributes_attr_10_value	string	Value of the arbitrary attribute (not indexed or used internally, used as pass through).	attr10_name					no			Conversation
augmented_utterances_ct	int	Count of all utterances that used any augmentation feature (excluding fluency)	1					no			AutoCompose
multiple_augmentation_features_used_ct	int	Count utterances where multiple augmentation features (excluding fluency) were used.	1					no			AutoCompose
autosuggest_ct	int	Count of utterances where only AutoSuggest augmentation is used (excluding fluency)	1					no			AutoCompose
autocomplete_ct	int	Count of utterances where only AutoComplete augmentation is used (excluding fluency)	1					no			AutoCompose
phrase_autocomplete_ct	int	Count of utterances where only Phrase AutoComplete augmentation is used (excluding fluency)	1					no			AutoCompose
custom_drawer_ct	int	Count of utterances where only Custom Drawer augmentation is used (excluding fluency)	1					no			AutoCompose
custom_insert_ct	int	Count of utterances where only Custom Insert augmentation is used (excluding fluency)	1					no			AutoCompose
global_insert_ct	int	Count of utterances where only Global Insert augmentation is used (excluding fluency)	1					no			AutoCompose
unknown_augmentation_ct	int	Count of utterances where only an unidentified augmentation was used (excluding fluency)	1					no			AutoCompose
fluency_apply_ct	int	Count of utterances where Fluency Apply augmentation is used	1					no			AutoCompose
fluency_undo_ct	int	Count of utterances where Fluency Undo augmentation is used	1					no			AutoCompose
company_marker	string	Identifier of the customer-company.	agnostic					no			Conversation
dt	string	Date string representing the date during which the utterance state happened.	2018-06-23					no			Conversation
hr	string	Hour string representing the hour during which the utterance state happened.	21					no			Conversation

Table: utterances

This S3 captures raw utterances, enabling customers to map message IDs and metadata to specific utterances. Each record in this feed represents an individual message within a conversation, providing utterance-level insights. The feed remains minimal and secure, including a comprehensive mapping of message IDs to their corresponding utterances, information not available in the utterance state file. For security purposes, this feed will only be accessible externally, retaining a maximum of 32 days of data before purging. The feed will be exported daily, with time-stamped data for time zone conversion.

Sync Time: 1d

Unique Condition: company_marker, conversation_id, message_id

Column	Type	Description	Example	Aggregates	Notes	Date Added	Date Modified	Ignore	PII	release state	Specific Use	Feature Group
conversation_id	string	Unique identifier generated by the ASAPP application for the issue or conversation.	ABC21352352					no			Conversation
message_id		This is the ULID id of a given message.	01GASGE3WAG84BGARCS238Z0FG					no			Conversation
instance_ts	timestamp	The time window of computed elements. This window is usually 15 minutes or 1 hour depending on the generation time. Times are rounded down to the nearest interval (for a time of 12:34 and an interval of 15m, this is 12:30). As an example, for a 15 minute interval an instance_ts of 12:30 implies events from 12:30 -> 12:45. All times are in UTC.	2019-11-08 14:00:06.957000+00:00					no			Conversation
chat_message_event_ts		The timestamp of the last chat_message event.	2018-06-23 21:28:23					no			Conversation
external_conversation_id	VARCHAR(255)	The issue or conversation id from the customer/client perspective.	ffe8a632-545f-4c2e-a0ae-c296e6ad4a22					no			Conversation
utterance		Text of the utterance message.	Hello, I need to talk to an agent					no			Conversation
company_marker	string	Identifier of the customer-company.	agnostic					no			Conversation
dt	string	Date string representing the date during which the utterance state happened.	2018-06-23					no			Conversation
hr	string	Hour string representing the hour during which the utterance state happened.	21					no			Conversation

Last Updated: 2025-01-16 06:37:08 UTC