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 contains the sentences that the freetext summary generates and the feedback summary edits or removes. | Customer called to pay their bill | no | AutoSummary | |||||||
| autosummary_sentences_added | string | autosummary_sentences_added contains the sentences added as part of feedback summary 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 | |||||||
| edited_utterances_ct | int | Count of utterances where the agent edited the text after augmentation (that replaces all text) was applied. | 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 considered 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 | |||||||
| edited_utterances_ct | int | Count of utterances where the agent edited the text after augmentation (that replaces all text) was applied. | 100 | 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