ASAPP · Schema

Asapp Messaging Feeds

CompanyAIConversational AIContact CenterCustomer ExperienceCustomer ServiceGenerative AIAgent AssistSpeech RecognitionKnowledge Base
View JSON Schema on GitHub

JSON Schema

asapp-messaging-feeds.json Raw ↑
{
    "schemas": [
     {
      "name": "exports",
      "source": "",
      "source_type": "exports",
      "tables": [
       {
        "active_date": "2020-11-10T00:00:00",
        "actual_eol_date": null,
        "change_log": [],
        "columns": [
         {
          "aggregates": null,
          "created_date": "2020-11-10 00:00:00",
          "deleted_date": "",
          "description": "The ASAPP rep/agent identifier.",
          "example": 123008,
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "rep_id",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar(191)",
          "updated_date": "2020-11-10 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2020-11-10 00:00:00",
          "deleted_date": "",
          "description": "Name of agent",
          "example": "John",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "rep_name",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar(191)",
          "updated_date": "2020-11-10 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2020-11-10 00:00:00",
          "deleted_date": "",
          "description": "Indicates status of the agent.",
          "example": "ONLINE",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "status_description",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar",
          "updated_date": "2020-11-10 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2020-11-10 00:00:00",
          "deleted_date": "",
          "description": "Timestamp at which this agent entered that status.",
          "example": "2018-06-10 14:23:00",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "status_start_ts",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "datetime",
          "updated_date": "2020-11-10 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2020-11-10 00:00:00",
          "deleted_date": "",
          "description": "Timestamp at which this agent exited that status.",
          "example": "2018-06-10 14:23:00",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "status_end_ts",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "datetime",
          "updated_date": "2020-11-10 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2020-11-10 00:00:00",
          "deleted_date": "",
          "description": "Time in seconds that the agents spent in that status.",
          "example": "2353.23",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "status_time_seconds",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "double",
          "updated_date": "2020-11-10 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2025-01-09 00:00:00",
          "deleted_date": "",
          "description": "Name of the company associated with the data.",
          "example": "acme",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "company_name",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar(255)",
          "updated_date": "2025-01-09 00:00:00"
         }
        ],
        "deprecation_date": null,
        "description": "The admin_activity table tracks ONLINE/OFFLINE statuses and logged in time in seconds for agents who use Admin.",
        "expected_eol_date": null,
        "metadata": {},
        "modified_date": "2025-01-09T00:00:00",
        "name": "admin_activity",
        "ordering_key": "",
        "pii": "",
        "primary_key": "company_marker, rep_id, status_description, status_start_ts",
        "release_state": "",
        "replacement_table": "",
        "schema": "metrics",
        "source": "airflow/exports/admin_activity.sql",
        "source_type": "exports",
        "specific_use": "",
        "sync_time": "1h",
        "version": "1"
       },
       {
        "active_date": "2022-01-31T00:00:00",
        "actual_eol_date": null,
        "change_log": [],
        "columns": [
         {
          "aggregates": null,
          "created_date": "2022-01-31 00:00:00",
          "deleted_date": "",
          "description": "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. ",
          "example": null,
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "instance_ts",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "timestamp",
          "updated_date": "2022-01-31 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2022-01-31 00:00:00",
          "deleted_date": "",
          "description": "The ASAPP company marker.",
          "example": "spear, aa",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "company_marker",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar(191)",
          "updated_date": "2022-01-31 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2022-01-31 00:00:00",
          "deleted_date": "",
          "description": "The ASAPP rep/agent identifier.",
          "example": 123008,
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "rep_id",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar(191)",
          "updated_date": "2022-01-31 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2022-01-31 00:00:00",
          "deleted_date": "",
          "description": "agent journey event type on record",
          "example": "CUSTOMER_TIMEOUT, TEXT_MESSAGE",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "event_type",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar(191)",
          "updated_date": "2022-01-31 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2022-01-31 00:00:00",
          "deleted_date": "",
          "description": "count of the agent journey event type on record",
          "example": "",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "event_count",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "bigint",
          "updated_date": "2022-01-31 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2022-01-31 00:00:00",
          "deleted_date": "",
          "description": "number of times that a rep disconnected for less than 1 hour",
          "example": "",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "disconnected_count",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "bigint",
          "updated_date": "2022-01-31 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2022-01-31 00:00:00",
          "deleted_date": "",
          "description": "cumulative number of seconds that a rep disconnected for less than 1 hour",
          "example": "",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "disconnected_seconds",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "bigint",
          "updated_date": "2022-01-31 00:00:00"
         }
        ],
        "deprecation_date": null,
        "description": "Aggregated counts of various agent journey event types partitioned by rep_id",
        "expected_eol_date": null,
        "metadata": {},
        "modified_date": "2024-01-12T00:00:00",
        "name": "agent_journey_rep_event_frequency",
        "ordering_key": "",
        "pii": "",
        "primary_key": "primary-key: rep_id, event_type, company_marker, instance_ts",
        "release_state": "",
        "replacement_table": "",
        "schema": "exports",
        "source": "airflow/exports/agent_journey_rep_event_frequency.sql",
        "source_type": "exports",
        "specific_use": "",
        "sync_time": "1d",
        "version": "1"
       },
       {
        "active_date": "2022-03-09T00:00:00",
        "actual_eol_date": null,
        "change_log": [],
        "columns": [
         {
          "aggregates": null,
          "created_date": "2022-03-09 00:00:00",
          "deleted_date": "",
          "description": "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. ",
          "example": null,
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "instance_ts",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "timestamp",
          "updated_date": "2022-03-09 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2022-03-09 00:00:00",
          "deleted_date": "",
          "description": "DEPRECATED 2024-03-25",
          "example": 10001,
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "company_id",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "bigint",
          "updated_date": "2022-03-09 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2022-03-09 00:00:00",
          "deleted_date": "",
          "description": "The ASAPP issue or conversation id.",
          "example": 21352352,
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "issue_id",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "bigint",
          "updated_date": "2022-03-09 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2022-03-09 00:00:00",
          "deleted_date": "",
          "description": "The ASAPP internal customer identifier.",
          "example": 123008,
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "customer_id",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "bigint",
          "updated_date": "2022-03-09 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2022-03-09 00:00:00",
          "deleted_date": "",
          "description": "The ASAPP rep/agent identifier.",
          "example": 123008,
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "rep_id",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar(191)",
          "updated_date": "2022-03-09 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2022-03-09 00:00:00",
          "deleted_date": "",
          "description": "",
          "example": "",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "rep_assigned_ts",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "timestamp without time zone",
          "updated_date": "2022-03-09 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2022-03-09 00:00:00",
          "deleted_date": "",
          "description": "Timestamp of autopilot form/flow being recommended by MLE or timestamp of flow sent from quick send. issue_id + form_recommended_event_ts should be unique",
          "example": "",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "form_start_ts",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "timestamp without time zone",
          "updated_date": "2022-03-09 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2022-03-09 00:00:00",
          "deleted_date": "",
          "description": "Timestamp of recommended autopilot form being dismissed.",
          "example": "",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "form_dismissed_event_ts",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "timestamp without time zone",
          "updated_date": "2022-03-09 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2022-03-09 00:00:00",
          "deleted_date": "",
          "description": "Timestamp the autopilot form being presented to end user.",
          "example": "",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "form_presented_event_ts",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "timestamp without time zone",
          "updated_date": "2022-03-09 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2022-03-09 00:00:00",
          "deleted_date": "",
          "description": "Timestamp the autopilot form being submitted by end user",
          "example": "",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "form_submitted_event_ts",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "timestamp without time zone",
          "updated_date": "2022-03-09 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2022-03-09 00:00:00",
          "deleted_date": "",
          "description": "An ASAPP identifier assigned to a particular flow executed during a customer event or request.",
          "example": "347bdddb-d3a1-45fc-bbcd-dbd3a175fc1c",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "flow_id",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar(255)",
          "updated_date": "2022-03-09 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2022-03-09 00:00:00",
          "deleted_date": "",
          "description": "The ASAPP text name for a given flow which was executed during a customer event or request.",
          "example": "FirstChatMessage, AccountNumberFlow",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "flow_name",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar(255)",
          "updated_date": "2022-03-09 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2022-03-09 00:00:00",
          "deleted_date": "",
          "description": "How the flow is being sent by the agent. manual: sent manually from the quick send dropdown in desk accept: sent by accept recommendation by ML server",
          "example": "",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "form_start_from",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "character varying(191)",
          "updated_date": "2022-03-09 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2022-03-09 00:00:00",
          "deleted_date": "",
          "description": "Is this a secure form flow.",
          "example": "false",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "is_secure_form",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "boolean",
          "updated_date": "2022-03-09 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2022-03-09 00:00:00",
          "deleted_date": "",
          "description": "The ASAPP queue identifier which the issue was placed.",
          "example": 210001,
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "queue_id",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "integer",
          "updated_date": "2022-03-09 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2022-03-09 00:00:00",
          "deleted_date": "",
          "description": "Mode of the desktop that the rep is logged into (CHAT or VOICE).",
          "example": "CHAT, VOICE",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "asapp_mode",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar(191)",
          "updated_date": "2022-03-09 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2022-03-09 00:00:00",
          "deleted_date": "",
          "description": "Name of the company associated with the data.",
          "example": "acme",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "company_name",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar(255)",
          "updated_date": "2022-03-09 00:00:00"
         }
        ],
        "deprecation_date": null,
        "description": "This table contains factual data about autopilot flow.",
        "expected_eol_date": null,
        "metadata": {},
        "modified_date": "2024-05-24T00:00:00",
        "name": "autopilot_flow",
        "ordering_key": "",
        "pii": "",
        "primary_key": "company_marker, issue_id, form_start_ts",
        "release_state": "",
        "replacement_table": "",
        "schema": "metrics",
        "source": "airflow/exports/autopilot_flow.sql",
        "source_type": "exports",
        "specific_use": "",
        "sync_time": "1h",
        "version": "1"
       },
       {
        "active_date": "2018-11-07T00:00:00",
        "actual_eol_date": null,
        "change_log": [],
        "columns": [
         {
          "aggregates": null,
          "created_date": "2018-11-07 00:00:00",
          "deleted_date": "",
          "description": "deprecated: 2019-09-25",
          "example": 21352352,
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "conversation_id",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "bigint",
          "updated_date": "2018-11-07 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2018-11-07 00:00:00",
          "deleted_date": "",
          "description": "deprecated: 2019-09-25",
          "example": 123008,
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "first_agent_id",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar(191)",
          "updated_date": "2018-11-07 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2018-11-07 00:00:00",
          "deleted_date": "",
          "description": "The ASAPP internal customer identifier.",
          "example": 123008,
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "customer_id",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "bigint",
          "updated_date": "2018-11-07 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2018-11-07 00:00:00",
          "deleted_date": "",
          "description": "The timestamp of the first customer utterance for an issue.",
          "example": "2018-09-05 19:58:06",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "first_utterance_ts",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar(255)",
          "updated_date": "2018-11-07 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2018-11-07 00:00:00",
          "deleted_date": "",
          "description": "Time of the first customer message in the conversation.",
          "example": "'Pay my bill', 'Check service availability'",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "first_utterance_text",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar(255)",
          "updated_date": "2018-11-07 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2018-11-07 00:00:00",
          "deleted_date": "",
          "description": "Code name which are used for classifying customer queries in first interaction.",
          "example": "PAYBILL, COVERAGE",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "first_intent_code",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar(255)",
          "updated_date": "2018-11-07 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2018-11-07 00:00:00",
          "deleted_date": "",
          "description": "Alternative second best code name which are used for classifying customer queries in first interaction.",
          "example": "PAYBILL, COVERAGE",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "first_intent_code_alt",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar(255)",
          "updated_date": "2018-11-07 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2018-11-07 00:00:00",
          "deleted_date": "",
          "description": "The final code name classifying the customer's query, based on the flow navigated; defaults to the first interaction code if no flow was followed.",
          "example": "PAYBILL, COVERAGE",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "final_intent_code",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar(255)",
          "updated_date": "2018-11-07 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2018-11-07 00:00:00",
          "deleted_date": "",
          "description": "A comma-separated list of all intent codes from the customer\u2019s flow navigation. If no flow was navigated, this will match the first intent code.",
          "example": "OUTAGE,CANT_CONNECT",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "intent_path",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar(255)",
          "updated_date": "2018-11-07 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2018-11-07 00:00:00",
          "deleted_date": "",
          "description": "The number of times a disambiguation event was presented for an issue.",
          "example": "2",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "disambig_count",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "bigint",
          "updated_date": "2018-11-07 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2018-11-07 00:00:00",
          "deleted_date": "",
          "description": "Indicates whether free-text disambiguation was used to help the customer present a clearer intent, based on the number of texts sent to AI.",
          "example": "true, false",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "ftd_visit",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "boolean",
          "updated_date": "2018-11-07 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2018-11-07 00:00:00",
          "deleted_date": "",
          "description": "The last FAQ identifier presented for an issue.",
          "example": "FORGOT_LOGIN_faq",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "faq_id",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar(255)",
          "updated_date": "2018-11-07 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2018-11-07 00:00:00",
          "deleted_date": "",
          "description": "The last deep-link URL clicked during the issue resolution process.",
          "example": "asapp-pil://acme/JSONataDeepLink",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "final_action_destination",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar(255)",
          "updated_date": "2018-11-07 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2018-11-07 00:00:00",
          "deleted_date": "",
          "description": "Indicates whether the initial intent associated with the chat was correct, based on feedback from the agent.",
          "example": "true, false",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "is_first_intent_correct",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "boolean",
          "updated_date": "2018-11-07 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2019-09-27 00:00:00",
          "deleted_date": "",
          "description": "The ASAPP issue or conversation id.",
          "example": 21352352,
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "issue_id",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "bigint",
          "updated_date": "2019-09-27 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2019-09-27 00:00:00",
          "deleted_date": "",
          "description": "The first ASAPP rep/agent identifier found in a window of time. ",
          "example": 123008,
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "first_rep_id",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar(191)",
          "updated_date": "2019-09-27 00:00:00"
         },
         {
          "aggregates": null,
          "created_date": "2019-11-01 00:00:00",
          "deleted_date": "",
          "description": "Name of the company associated with the data.",
          "example": "acme",
          "extra": null,
          "feature_group": "",
          "ignore": null,
          "name": "company_name",
          "notes": null,
          "pii": "",
          "primary": null,
          "release_state": "",
          "specific_use": "",
          "type": "varchar(255)",
          "updated_date": "2024-05-24 00:00:00"
         }
        ],
        "deprecation_date": null,
        "description": "The convos_intents table lists the current state for intent and utterance information associated with a conversation/issue that had events within the identified 15 minute time window. This table will include unended conversations.",
        "expected_eol_date": null,
        "metadata": {},
        "modified_date": "2024-05-24T00:00:00",
        "name": "convos_intents",
        "ordering_key": "",
        "pii": "",
        "primary_key": "issue_id",
        "release_state": "",
        "replacement_table": "",
        "schema": "metrics",
        "source": "airflow/exports/convos_intents.sql",
        "source_type": "exports",
        "specific_use": "",
        "sync_time": "1h",
        "version": "1"
       },
       {
        "active_date": "2018-11-07T00:00:00",
        "actual_eol_date": null,
        "change_log": [],
        "columns": [
         {
          "aggregates": null,
          "created_date": "2018-11-07 00:00:00",
          "deleted_date": "",
          "description": "deprecated: 2019-09-25",
          "example": 21352352,
          "extra": null,
          "feature_g

# --- truncated at 32 KB (590 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/asapp/refs/heads/main/json-schema/asapp-messaging-feeds.json