Feed Schemas
File Exporter Feed Schemas
Feed Schemas
File Exporter Feed Schemas
The tables below provide detailed information regarding the schema for exported data files that ASAPP can make available to customers 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
| name | type | description | example | aggregates | primary | created_date | updated_date | 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 | None | None | None | common | |||||
| conversation_id | string | The ASAPP issue or conversation id. | ABC21352352 | None | None | None | common | |||||
| external_conversation_id | VARCHAR(255) | The conversation id provided by the customer | vjs654 | None | None | None | common | |||||
| agent_id | varchar(255) | The agent identifier in the conversation provided by the customer. | cba321 | None | None | None | common | |||||
| summary_id | VARCHAR(36) | Unique identifier for AutoSummary feedback and free-text summary events | 57ffe572-e9dc-4546-963b-29d90b0d92a9 | None | None | None | AutoSummary | |||||
| autosummary_feedback_ts | timestamp | The timestamp of the autosummary_feedback_summary event. | 2023-05-01 14:00:09 | None | None | None | 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 | None | None | None | AutoSummary | |||||
| company_marker | varchar(255) | Identifier of the customer-company. | agnostic | None | None | None | common | |||||
| dt | varchar(255) | Date string when summary feedback was submitted. | 2019-11-08 | None | None | None | common | |||||
| hr | varchar(255) | Hour string when summary feedback was submitted. | 18 | None | None | None | 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
| name | type | description | example | aggregates | primary | created_date | updated_date | 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 | None | None | None | common | |||||
| conversation_id | string | The ASAPP issue or conversation id. | ABC21352352 | None | None | None | common | |||||
| external_conversation_id | VARCHAR(255) | The conversation id provided by the customer | vjs654 | None | None | None | common | |||||
| agent_id | varchar(255) | The agent identifier in the conversation provided by the customer. | cba321 | None | None | None | common | |||||
| summary_id | VARCHAR(36) | Unique identifier for AutoSummary feedback and free-text summary events | 57ffe572-e9dc-4546-963b-29d90b0d92a9 | None | None | None | AutoSummary | |||||
| autosummary_free_text_ts | timestamp | The timestamp of the autosummary_free_text_summary event. | 2023-05-01 14:00:09 | None | None | None | 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 | None | None | None | AutoSummary | |||||
| is_autosummary_feedback_used | integer | An indicator that the AutoSummary had a feedback summary. | 1 | None | None | None | AutoSummary | |||||
| is_autosummary_feedback_edited | integer | An indicator that the AutoSummary had a feedback summary that was edited. | 0 | None | None | None | 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 | None | None | None | AutoSummary | |||||
| autosummary_feedback_length | integer | Length of the Feedback AutoSummaries. Will only have a value when there is both freetext and feedback summaries. | 54 | None | None | None | 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 | None | None | None | 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 | None | None | None | 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 | None | None | None | AutoSummary | |||||
| company_marker | varchar(255) | Identifier of the customer-company. | agnostic | None | None | None | common | |||||
| dt | varchar(255) | Date string when summary feedback was submitted. | 2019-11-08 | None | None | None | common | |||||
| hr | varchar(255) | Hour string when summary feedback was submitted. | 18 | None | None | None | common |
Table: autosummary_structured_data
The autosummary structured data table stores the raw output of ASAPP’s API. Structured Data relies on yes/no answers from an LLM to provide data that 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
| name | type | description | example | aggregates | primary | created_date | updated_date | 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 | None | None | None | common | |||||
| conversation_id | string | The ASAPP issue or conversation id. | ABC21352352 | None | None | None | common | |||||
| external_conversation_id | VARCHAR(255) | The conversation id provided by the customer | vjs654 | None | None | None | common | |||||
| agent_id | varchar(255) | The agent identifier in the conversation provided by the customer. | cba321 | None | None | None | common | |||||
| structured_data_id | varchar(36) | Unique identifier for AutoSummary structured data event | 57ffe572-e9dc-4546-963b-29d90b0d92a9 | None | None | None | common | |||||
| structured_data_ts | timestamp | The timestamp of the autosummary_structured_data event. | 2023-05-01 14:00:09 | None | None | None | common | |||||
| structured_data_field_id | varchar(255) | The structured data id. | q_issue_escalated | None | None | None | common | |||||
| structured_data_field_name | varchar(255) | The structured data name. | Issue escalated | None | None | None | common | |||||
| structured_data_field_value | varchar(255) | The structured data value. | No | None | None | None | common | |||||
| structured_data_field_category | varchar(255) | The structured data category. | Outcome | None | None | None | common | |||||
| company_marker | varchar(255) | Identifier of the customer-company. | agnostic | None | None | None | common | |||||
| dt | varchar(255) | Date string when summary structured data was generated. | 2019-11-08 | None | None | None | common | |||||
| hr | varchar(255) | Hour string when summary structured data was generated. | 18 | None | None | None | common |
Table: staging_conversation_state
issue-grain table that combines data from AutoCompose, AutoTranscribe, AutoSummary, Chat Core, Ingestion services and Intent Classification. This table will be populated daily and contains the hour for time zone conversion later. Each record represents one day of data for each conversation. Conversation data can be split across multiple days.
Sync Time: 1d
Unique Condition: company_marker, conversation_id, dt, hr
| name | type | description | example | aggregates | primary | created_date | updated_date | ignore | pii | release_state | specific_use | feature_group |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| conversation_id | timestamp | The ASAPP issue or conversation id. | ABC21352352 | None | None | None | 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 | None | None | None | Conversation | |||||
| first_event_ts | timestamp | Timestamp of the first event associated with the conversation_id. | 2018-06-23 21:28:23 | None | None | None | 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 | None | None | None | Conversation | |||||
| external_conversation_id | VARCHAR(255) | The conversation id provided by the customer. | 750068130001 | None | None | None | 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 | None | None | None | Conversation | |||||
| customer_id | varchar(255) | The customer identifier provided by the customer. | abc123 | None | None | None | 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 | None | None | None | Conversation | |||||
| last_agent_id | varchar(191) | The last agent identifier in the conversation provided by the customer. | abc123 | None | None | None | Conversation | |||||
| all_agent_ids | A list of all the agent identifiers within the conversation provided by the customer. | [abc123,abc456] | None | None | None | Conversation | ||||||
| customer_utterance_ct | Count of all customer messages. | 5 | None | None | None | Conversation | ||||||
| agent_utterance_ct | Count of all agent messages. | 16 | None | None | None | Conversation | ||||||
| customer_first_utterance_ts | timestamp | Timestamp of the first customer utterance. | 2019-11-08 14:00:07 | None | None | None | Conversation | |||||
| agent_first_utterance_ts | Timestamp of the first agent utterance. | 2019-11-08 14:00:07 | None | None | None | Conversation | ||||||
| customer_last_utterance_ts | timestamp | Timestamp of the last customer utterance. | 2019-11-08 14:00:07 | None | None | None | Conversation | |||||
| agent_last_utterance_ts | Timestamp of the last agent utterance. | 2019-11-08 14:00:07 | None | None | None | Conversation | ||||||
| autosuggest_utterance_ct | Count of utterances where AutoSuggest was used. | 6 | None | None | None | AutoCompose | ||||||
| autocomplete_utterance_ct | Count of utterances where AutoComplete was used. | 2 | None | None | None | AutoCompose | ||||||
| phrase_autocomplete_utterance_ct | Count of utterances where Phrase AutoComplete was used. | 0 | None | None | None | AutoCompose | ||||||
| custom_drawer_utterance_ct | Count of utterances where Custom Drawer was used. | 1 | None | None | None | AutoCompose | ||||||
| custom_insert_utterance_ct | Count of utterances where Custom Insert was used. | 0 | None | None | None | AutoCompose | ||||||
| global_insert_utterance_ct | Count of utterances where Global Insert was used. | 1 | None | None | None | AutoCompose | ||||||
| fluency_apply_utterance_ct | Count of utterances where Fluency Apply was used. | 0 | None | None | None | AutoCompose | ||||||
| fluency_undo_utterance_ct | Count of utterances where Fluency Undo was used. | 0 | None | None | None | AutoCompose | ||||||
| autosummary_structured_summary_tags_event_ts | timestamp | The timestamp of the last autosummary_structured_summary_tags event. | 2019-11-08 14:00:07 | None | None | None | AutoSummary | |||||
| autosummary_tags | string | Comma-separated list of tags or codes indicating key topics of this conversation. | {\"server\":\"some-server\",\"server_version\":\"unknown\"} | None | None | None | AutoSummary | |||||
| autosummary_free_text_summary_event_ts | timestamp | The timestamp of the last autosummary_free_text_summary event. | 2019-11-08 14:00:07 | None | None | None | AutoSummary | |||||
| autosummary_text | string | Text summarizing the conversation. | Unresponsive Customer. | None | None | None | 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 | None | None | None | 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 | None | None | None | 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 | None | None | None | 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 | None | None | None | 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 | None | None | None | Conversation | |||||
| autosummary_feedback_ct | bigint | Count of AutoSummaries that received Feedback for the conversation. | 4 | None | None | None | Conversation | |||||
| autosummary_feedback_edited_ct | bigint | Count of AutoSummaries that received edited Feedback for the conversation. | 3 | None | None | None | Conversation | |||||
| autosummary_free_text_length_sum | bigint | Sum of the length of all the FreeText AutoSummaries for the conversation. | 80 | None | None | None | Conversation | |||||
| autosummary_feedback_length_sum | bigint | Sum of the length of all the Feedback AutoSummaries for the conversation. | 120 | None | None | None | Conversation | |||||
| autosummary_levenshtein_distance_sum | bigint | Sum of the Levenshtein edit distances between the AutoSummaries FreeText and Feedback. | 40 | None | None | None | Conversation | |||||
| first_intent_effective_ts | timestamp | The timestamp of the last first_intent event. | 2019-11-08 14:00:07 | None | None | None | JourneyInsight | |||||
| first_intent_message_id | string | The id of the message that was sent with the first intent. | 01GA9V1F2B7Q4Y8REMRZ2SXVRT | None | None | None | JourneyInsight | |||||
| first_intent_intent_code | string | The intent code associated with the rule that was sent as the first intent within the conversation. | INCOMPLETE | None | None | None | 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 | None | None | None | JourneyInsight | |||||
| first_intent_is_known_good | boolean | Indicates if the classification for the first_intent data comes from a known good. | FALSE | None | None | None | JourneyInsight | |||||
| conversation_metadata_effective_ts | timestamp | The timestamp of the last conversation metadata | 2019-11-08 14:00:07 | None | None | None | Metadata | |||||
| conversation_metadata_lob_id | string | Line of business ID from Conversation Metadata | 1038 | None | None | None | Metadata | |||||
| conversation_metadata_lob_name | string | Line of business descriptive name from Conversation Metadata | manufacturing | None | None | None | Metadata | |||||
| conversation_metadata_agent_group_id | string | Agent group ID from Conversation Metadata | group59 | None | None | None | Metadata | |||||
| conversation_metadata_agent_group_name | string | Agent group descriptive name from Conversation Metadata | groupXYZ | None | None | None | Metadata | |||||
| conversation_metadata_agent_routing_code | string | Agent routing attribute from Conversation Metadata | route-13988 | None | None | None | Metadata | |||||
| conversation_metadata_campaign | string | Campaign from Conversation Metadata | campaign-A | None | None | None | Metadata | |||||
| conversation_metadata_device_type | string | Client device type from Conversation Metadata | TABLET | None | None | None | Metadata | |||||
| conversation_metadata_platform | string | Client platform type from Conversation Metadata | IOS | None | None | None | Metadata | |||||
| conversation_metadata_company_segment | []string | Company segment from Conversation Metadata | [“Sales”,“Marketing”] | None | None | None | Metadata | |||||
| conversation_metadata_company_subdivision | string | Company subdivision from Conversation Metadata | operating | None | None | None | Metadata | |||||
| conversation_metadata_business_rule | string | Business rule from Conversation Metadata | Apply customer’s discount | None | None | None | Metadata | |||||
| conversation_metadata_entry_type | string | Type of entry from Conversation Metadata, e.g., proactive vs reactive | reactive | None | None | None | Metadata | |||||
| conversation_metadata_operating_system | string | Operating system from Conversation Metadata | OPERATING_SYSTEM_MAC_OS | None | None | None | Metadata | |||||
| conversation_metadata_browser_type | string | Browser type from Conversation Metadata | Safari | None | None | None | Metadata | |||||
| conversation_metadata_browser_version | string | Browser version from Conversation Metadata | 14.1.2 | None | None | None | Metadata | |||||
| contact_journey_contact_id | string | (NULLIFIED) Conversation Contact ID | None | None | None | 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 | None | None | None | Contact | |||||
| contact_journey_first_contact_utterance_ts | timestamp | First utterance in the contact | 2023-06-11 18:32:21 | None | None | None | Contact | |||||
| contact_journey_last_contact_utterance_ts | timestamp | Last utterance in the contact | 2023-06-11 18:40:29 | None | None | None | Contact | |||||
| contact_journey_contact_start_ts | timestamp | First event in the contact | 2023-06-11 18:30:29 | None | None | None | Contact | |||||
| contact_journey_contact_end_ts | timestamp | Last event in the contact | 2023-06-11 18:58:29 | None | None | None | Contact | |||||
| aug_metrics_effective_ts | timestamp | Timestamp of the last augmentation metrics event | ”2023-08-09T19:21:34.224620050Z” | None | None | None | AutoCompose | |||||
| augmented_utterances_ct | Count of all utterances that used any augmentation feature (excluding fluency) | 100 | None | None | None | AutoCompose | ||||||
| multiple_augmentation_features_used_ct | Count utterances where multiple augmentation features (excluding fluency) were used | 100 | None | None | None | AutoCompose | ||||||
| autosuggest_ct | Count of utterances where only AutoSuggest augmentation is used (excluding fluency) | 100 | None | None | None | AutoCompose | ||||||
| autocomplete_ct | Count of utterances where only AutoComplete augmentation is used (excluding fluency) | 100 | None | None | None | AutoCompose | ||||||
| phrase_autocomplete_ct | Count of utterances where only Phrase AutoComplete augmentation is used (excluding fluency) | 100 | None | None | None | AutoCompose | ||||||
| custom_drawer_ct | Count of utterances where only Custom Drawer augmentation is used (excluding fluency) | 100 | None | None | None | AutoCompose | ||||||
| custom_insert_ct | Count of utterances where only Custom Insert augmentation is used (excluding fluency) | 100 | None | None | None | AutoCompose | ||||||
| global_insert_ct | Count of utterances where only Global Insert augmentation is used (excluding fluency) | 100 | None | None | None | AutoCompose | ||||||
| unknown_augmentation_ct | Count of utterances where only an unidentified augmentation was used (excluding fluency) | 100 | None | None | None | AutoCompose | ||||||
| fluency_apply_ct | Count of utterances where Fluency Apply augmentation is used | 100 | None | None | None | AutoCompose | ||||||
| fluency_undo_ct | Count of utterances where Fluency Undo augmentation is used | 100 | None | None | None | 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 | None | None | None | 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 | None | None | None | 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 | None | None | None | 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 | None | None | None | 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 | None | None | None | 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 | None | None | None | AutoCompose | |||||
| single_intent_effective_ts | timestamp | The timestamp of the last single intent event. | 2019-11-08 14:00:07 | None | None | None | ||||||
| single_intent_intent_code | string | Intent code | CHECK_COVERAGE | None | None | None | ||||||
| single_intent_intent_name | string | Intent name | Check Coverage | None | None | None | ||||||
| single_intent_messages_considered_ct | bigint | How many utterances were consided to calculate a single intent code. | 2 | None | None | None | ||||||
| company_marker | string | Identifier of the customer-company. | agnostic | None | None | None | Conversation | |||||
| dt | string | Date string representing the date during which the conversation state happened. | 2019-11-08 | None | None | None | Conversation | |||||
| hr | string | Hour string representing the hour during which the conversation state happened. | 18 | None | None | None | Conversation |
Table: staging_utterance_state
utterance-grain insights into a conversation. Each record represents an utterance, or message, within a conversation. The UtteranceDetails feed captures data from AutoCompose, AutoTranscribe, Chat Core, and Ingestion services. This table will be populated daily but contains the hours for time zone conversion later.
Sync Time: 1d
Unique Condition: company_marker, conversation_id, message_id
| name | type | description | example | aggregates | primary | created_date | updated_date | ignore | pii | release_state | specific_use | feature_group |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| conversation_id | string | The ASAPP issue or conversation id. | ABC21352352 | None | None | None | Conversation | |||||
| message_id | string | This is the ULID id of a given message. | 01GASGE3WAG84BGARCS238Z0FG | None | None | None | 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 | None | None | None | Conversation | |||||
| chat_message_event_ts | timestamp | The timestamp of the last chat_message event. | 2018-06-23 21:28:23 | None | None | None | Conversation | |||||
| external_conversation_id | VARCHAR(255) | The issue or conversation id from the customer/client perspective. | ffe8a632-545f-4c2e-a0ae-c296e6ad4a22 | None | None | None | Conversation | |||||
| sender_type | string | The type of sender. | SENDER_CUSTOMER | None | None | None | Conversation | |||||
| sender_id | string | Unique identifier of the sender user. | ffe8a632-545f-4c2e-a0ae-c296e6ad4a25 | None | None | None | Conversation | |||||
| private_message_ct | bigint | Number of private messages, a private message is only when it was between agents/admins not the customer. | 1 | None | None | None | Conversation | |||||
| tags | string | Key-value map of additional properties. | {} | None | None | None | Conversation | |||||
| utterance_augmentations_effective_ts | timestamp | The timestamp of the last utterance_augmentations event. | 2018-06-23 21:28:23 | None | None | None | AutoCompose | |||||
| augmentation_type_list | string | DEPRECATED Type of augmentation used. If multiple augmentations were used, a comma-separated list of types. | AUTOSUGGEST,AUTOCOMPLETE | None | None | None | AutoCompose | |||||
| num_edits_ct | bigint | Number of edits made to an augmented message. | 2 | None | None | None | 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? | None | None | None | AutoCompose | |||||
| time_to_action_seconds | float | Number of seconds between the agent sending their previous message and their first action for composing | 3.286 | None | None | None | AutoCompose | |||||
| crafting_time_seconds | float | Number of seconds between the agent’s first action and last action for composing this message. | 0.0 | None | None | None | 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 | None | None | None | AutoCompose | |||||
| phrase_autocomplete_presented_ct | bigint | Number of phrase autocomplete suggestions presented to the agent. | 1 | None | None | None | AutoCompose | |||||
| phrase_autocomplete_selected_ct | bigint | Number of phrase autocomplete suggestions selected by the agent. | 0 | None | None | None | AutoCompose | |||||
| utterance_message_metrics_effective_ts | timestamp | The timestamp of the last utterance_message_metrics event. | 2018-06-23 21:28:23 | None | None | None | Conversation | |||||
| utterance_length | int | Length of utterance message. | 13 | None | None | None | Conversation | |||||
| agent_metadata_effective_ts | timestamp | The timestamp of the last agent_metadata event. | 2018-06-23 21:28:23 | None | None | None | Conversation | |||||
| agent_metadata_external_agent_id | string | The external rep/agent identifier. | abc123 | None | None | None | Conversation | |||||
| agent_metadata_event_ts | timestamp | The timestamp of when this event happened (system driven). | 2018-06-23 21:28:23 | None | None | None | Conversation | |||||
| agent_metadata_start_ts | timestamp | The timestamp of when the agent started. | 2018-06-23 21:28:23 | None | None | None | Conversation | |||||
| agent_metadata_lob_id | string | Line of business id. | lobId_7 | None | None | None | Conversation | |||||
| agent_metadata_lob_name | string | Line of business descriptive name. | lobName_7 | None | None | None | Conversation | |||||
| agent_metadata_group_id | string | Group id. | groupId_7 | None | None | None | Conversation | |||||
| agent_metadata_group_name | string | Group descriptive name. | groupName_7 | None | None | None | Conversation | |||||
| agent_metadata_location | string | Agent’s supervisor Id. | supervisorId_7 | None | None | None | Conversation | |||||
| agent_metadata_languages | string | Agent’s languages. | [{“value”:“en-us”}] | None | None | None | Conversation | |||||
| agent_metadata_concurrency | int | Number of issues that the agent can take at a time. | 3 | None | None | None | 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 | None | None | None | 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 | None | None | None | Conversation | |||||
| agent_metadata_ranking | int | Agent’s rank. | 2 | None | None | None | Conversation | |||||
| agent_metadata_vendor | string | Agent’s vendor. | vendor_7 | None | None | None | Conversation | |||||
| agent_metadata_job_title | string | Agent’s job title. | jobTitle_7 | None | None | None | Conversation | |||||
| agent_metadata_job_role | string | Agent’s role. | jobRole_7 | None | None | None | Conversation | |||||
| agent_metadata_work_shift | string | The hours or shift name they work. | workShift_7 | None | None | None | Conversation | |||||
| agent_metadata_attributes_attr_01_name | string | Name of the arbitrary attribute (not indexed or used internally, used as pass through). | name | None | None | None | Conversation | |||||
| agent_metadata_attributes_attr_01_value | string | Value of the arbitrary attribute (not indexed or used internally, used as pass through). | attr1_name | None | None | None | Conversation | |||||
| agent_metadata_attributes_attr_02_name | string | Name of the arbitrary attribute (not indexed or used internally, used as pass through). | name | None | None | None | Conversation | |||||
| agent_metadata_attributes_attr_02_value | string | Value of the arbitrary attribute (not indexed or used internally, used as pass through). | attr2_name | None | None | None | Conversation | |||||
| agent_metadata_attributes_attr_03_name | string | Name of the arbitrary attribute (not indexed or used internally, used as pass through). | name | None | None | None | Conversation | |||||
| agent_metadata_attributes_attr_03_value | string | Value of the arbitrary attribute (not indexed or used internally, used as pass through). | attr3_name | None | None | None | Conversation | |||||
| agent_metadata_attributes_attr_04_name | string | Name of the arbitrary attribute (not indexed or used internally, used as pass through). | name | None | None | None | Conversation | |||||
| agent_metadata_attributes_attr_04_value | string | Value of the arbitrary attribute (not indexed or used internally, used as pass through). | attr4_name | None | None | None | Conversation | |||||
| agent_metadata_attributes_attr_05_name | string | Name of the arbitrary attribute (not indexed or used internally, used as pass through). | name | None | None | None | Conversation | |||||
| agent_metadata_attributes_attr_05_value | string | Value of the arbitrary attribute (not indexed or used internally, used as pass through). | attr5_name | None | None | None | Conversation | |||||
| agent_metadata_attributes_attr_06_name | string | Name of the arbitrary attribute (not indexed or used internally, used as pass through). | name | None | None | None | Conversation | |||||
| agent_metadata_attributes_attr_06_value | string | Value of the arbitrary attribute (not indexed or used internally, used as pass through). | attr6_name | None | None | None | Conversation | |||||
| agent_metadata_attributes_attr_07_name | string | Name of the arbitrary attribute (not indexed or used internally, used as pass through). | name | None | None | None | Conversation | |||||
| agent_metadata_attributes_attr_07_value | string | Value of the arbitrary attribute (not indexed or used internally, used as pass through). | attr7_name | None | None | None | Conversation | |||||
| agent_metadata_attributes_attr_08_name | string | Name of the arbitrary attribute (not indexed or used internally, used as pass through). | name | None | None | None | Conversation | |||||
| agent_metadata_attributes_attr_08_value | string | Value of the arbitrary attribute (not indexed or used internally, used as pass through). | attr8_name | None | None | None | Conversation | |||||
| agent_metadata_attributes_attr_09_name | string | Name of the arbitrary attribute (not indexed or used internally, used as pass through). | name | None | None | None | Conversation | |||||
| agent_metadata_attributes_attr_09_value | string | Value of the arbitrary attribute (not indexed or used internally, used as pass through). | attr9_name | None | None | None | Conversation | |||||
| agent_metadata_attributes_attr_10_name | string | Name of the arbitrary attribute (not indexed or used internally, used as pass through). | name | None | None | None | Conversation | |||||
| agent_metadata_attributes_attr_10_value | string | Value of the arbitrary attribute (not indexed or used internally, used as pass through). | attr10_name | None | None | None | Conversation | |||||
| augmented_utterances_ct | int | Count of all utterances that used any augmentation feature (excluding fluency) | 1 | None | None | None | AutoCompose | |||||
| multiple_augmentation_features_used_ct | int | Count utterances where multiple augmentation features (excluding fluency) were used. | 1 | None | None | None | AutoCompose | |||||
| autosuggest_ct | int | Count of utterances where only AutoSuggest augmentation is used (excluding fluency) | 1 | None | None | None | AutoCompose | |||||
| autocomplete_ct | int | Count of utterances where only AutoComplete augmentation is used (excluding fluency) | 1 | None | None | None | AutoCompose | |||||
| phrase_autocomplete_ct | int | Count of utterances where only Phrase AutoComplete augmentation is used (excluding fluency) | 1 | None | None | None | AutoCompose | |||||
| custom_drawer_ct | int | Count of utterances where only Custom Drawer augmentation is used (excluding fluency) | 1 | None | None | None | AutoCompose | |||||
| custom_insert_ct | int | Count of utterances where only Custom Insert augmentation is used (excluding fluency) | 1 | None | None | None | AutoCompose | |||||
| global_insert_ct | int | Count of utterances where only Global Insert augmentation is used (excluding fluency) | 1 | None | None | None | AutoCompose | |||||
| unknown_augmentation_ct | int | Count of utterances where only an unidentified augmentation was used (excluding fluency) | 1 | None | None | None | AutoCompose | |||||
| fluency_apply_ct | int | Count of utterances where Fluency Apply augmentation is used | 1 | None | None | None | AutoCompose | |||||
| fluency_undo_ct | int | Count of utterances where Fluency Undo augmentation is used | 1 | None | None | None | AutoCompose | |||||
| company_marker | string | Identifier of the customer-company. | agnostic | None | None | None | Conversation | |||||
| dt | string | Date string representing the date during which the utterance state happened. | 2018-06-23 | None | None | None | Conversation | |||||
| hr | string | Hour string representing the hour during which the utterance state happened. | 21 | None | None | None | Conversation |
Table: utterances
New S3 feed with the raw utterance so the customers can map the messageID and metadata to the utterances. utterance-grain insights into a conversation. Each record represents an utterance, or message, within a conversation. The RawUtterance feed captures data from Chat Core. It will be small and locked down security wise but will have a messageID to utterance mapping. So clients can see the actual utterances since they aren’t included in the utterance state file. It won’t be accessible internally though and will only have a max of 32 days data before we purge for security reasons. This export will be sent daily and contains the hour for time zone conversion later
Sync Time: 1d
Unique Condition: company_marker, conversation_id, message_id
| name | type | description | example | aggregates | primary | created_date | updated_date | ignore | pii | release_state | specific_use | feature_group |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| conversation_id | string | The ASAPP issue or conversation id. | ABC21352352 | None | None | None | Conversation | |||||
| message_id | This is the ULID id of a given message. | 01GASGE3WAG84BGARCS238Z0FG | None | None | None | 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 | None | None | None | Conversation | |||||
| chat_message_event_ts | The timestamp of the last chat_message event. | 2018-06-23 21:28:23 | None | None | None | Conversation | ||||||
| external_conversation_id | VARCHAR(255) | The issue or conversation id from the customer/client perspective. | ffe8a632-545f-4c2e-a0ae-c296e6ad4a22 | None | None | None | Conversation | |||||
| utterance | Text of the utterance message. | Hello, I need to talk to an agent | None | None | None | Conversation | ||||||
| company_marker | string | Identifier of the customer-company. | agnostic | None | None | None | Conversation | |||||
| dt | string | Date string representing the date during which the utterance state happened. | 2018-06-23 | None | None | None | Conversation | |||||
| hr | string | Hour string representing the hour during which the utterance state happened. | 21 | None | None | None | Conversation |
Last Updated November 25, 2024
Was this page helpful?