Outbound campaigns data in Amazon Connect Analytics data lake

This topic details the content in the Amazon Connect Analytics data lake outbound campaign events table. The table lists the column, type, and description of the content.

Outbound campaign events

Table name: outbound_campaign_events

Composite primary key: campaign_event_id, instanceId

The data for this table is available starting from November 18, 2024 0:00:00 GMT.

Column	Type	Description
instance_id	String	The identifier of the Amazon Connect instance.
instance_arn	String	The ARN of the Amazon Connect instance.
aws_account_id	String	The identifier of the AWS account that owns the outbound campaign.
campaign_id	String	The identifier for the outbound campaign.
campaign_name	String	The name of the outbound campaign.
campaign_event_id	String	The unique identifier for each outbound campaign event.
campaign_event_type	String	The specific outbound campaign event type. Campaign events: CAMPAIGN_SUCCESS: The send request is successful and Amazon Connect will attempt to deliver the campaign to the recipient. CAMPAIGN_EXPIRED: The send request is successfully attempted but expired due to insufficient resources. The system will automatically retry when sufficient resources are available. CAMPAIGN_FAILURE_PERMANENT: The send request encountered an unknown error, invalid parameter, or insufficient permissions. There are no systematic retries. DROPPED_MISSING_TIMEZONE: The targeted user was dropped from the campaign because a contact timezone could not be determined as configured in the campaign. This may also occur if Amazon Connect is unable to estimate a timezone. DROPPED_CAMPAIGN_ENDED: The targeted user was dropped from the campaign because the campaign ended prior to a communication attempt. DROPPED_MISSING_CHANNEL: The targeted user was dropped from the campaign because they were missing channel endpoint (such as email or phone number) DROPPED_INVALID_TARGET: The targeted user was dropped because it was invalid or was deleted during execution DROPPED_LIMIT_BREACHED: The targeted user was dropped because the configured campaign communication limits were exceeded. DROPPED_DELIVERY_FAILURE: The targeted user was dropped because of a delivery failure. DROPPED_DELIVERY_ERROR: The targeted user was dropped because of a user configuration error. Examples include improper channel configurations or an incorrect message template. DROPPED_UNKNOWN: The targeted user was dropped for an unknown reason. Email events: Delivery: The message is delivered. Send: Amazon Connect accepted the message and attempted to deliver it. Reject: Amazon Connect detected malware and rejected the message. Bounce: An issue related to the email or server prevented Amazon Connect from delivering the message. DeliveryDelay: A temporary error occurred that delayed the delivery of the message. Amazon Connect systematically reattempts message delivery. Open: The message is received and the recipient opened it. Click: The message is received and the recipient clicked a link in it. Complaint: The message is received and the recipient reported it as spam, an unsolicited email, fraudulent, or associated to phishing activity. SMS events: TEXT_DELIVERED: The message is delivered to the specified location. TEXT_SUCCESSFUL: The message is successfully accepted by the recipient's carrier. TEXT_QUEUED: The message is queued and ready to be delivered to the recipient. TEXT_PENDING: The message hasn't yet been delivered. TEXT_BLOCKED: The recipient's device or carrier is blocking SMS messages. TEXT_TTL-EXPIRED: The SMS message couldn't be delivered within the specified time frame. TEXT_CARRIER_UNREACHABLE: An issue with the mobile network prevented the message from being delivered. This error is usually temporary. You can try to send the message again later. TEXT_INVALID: The destination phone number is not valid. TEXT_INVALID_MESSAGE: The body of the SMS message is invalid. For example: message doesn't meet the content or format requirements; and can't be delivered. TEXT_CARRIER_BLOCKED: The carrier has blocked delivery of this message. This often occurs when the carrier identifies the contents of the message as unsolicited or malicious. TEXT_UNREACHABLE: The recipient's device is currently unreachable or unavailable. For example, the device might be powered off, or might be disconnected from the network. You can try to send the message again later. TEXT_SPAM: The mobile carrier identified the contents of the message as spam and blocked delivery. TEXT_UNKNOWN: An error occurred that prevented the delivery of the message. This error is usually temporary. You can try to send the message again later. Telephony events: AMD_DISABLED: Answering machine detection is disabled. INITIATED: An outbound call was initiated or transferred. CONNECTED_TO_SYSTEM: The contact has established media (for example, it was answered by a person or by voicemail). This event is generated for any of the AnsweringMachineDetectionStatus codes. CONTACT_DATA_UPDATED: One or more of the following contact properties were updated on an outbound call: user-defined attributes and tags, routing criteria is updated or step is expired, or if Contact Lens is enabled for a given contact. QUEUED: An outbound call is queued to be assigned to an agent. CONNECTED_TO_AGENT: An outbound call is connected to an agent. DISCONNECTED: The attempt was connected but the call was not picked up, or the attempt resulted in a SIT tone. For more details on Telephony delivery outcomes (such as human answered, voicemail), query answering_machine_detection_Status and disconnect_reason from the Contacts record.
campaign_event_timestamp	Timestamp	The timestamp indicating when the outbound campaign event occurred.
delivery_attempt_id	String	The identifier for the outbound communication delivery attempt.
channel	String	The method used to contact your contact center. For example: VOICE, CHAT, EMAIL. This field may be blank for campaign events when this value is not applicable.
subtype	String	The outbound campaign delivery mode used to contact the campaign recipient. For example: connect:Email, connect:SMS, connect:Telephony. Note: Telephony includes both the Agent Assisted Voice, Automated Voice delivery modes. This field may be blank for campaign events when this value is not applicable.
profile_id	String	The unique identifier of an Amazon Connect Customer Profile. Note: This attribute is only available when you use segmentation capabilities offered with Amazon Connect Customer Profiles.
campaign_segment_arn	String	The ARN of a segment of users. Note: This attribute is only available when you use segmentation capabilities offered with Amazon Connect Customer Profiles.
campaign_url_link_click	String	The URL link clicked by the outbound campaign recipient. This attribute is applicable to email campaigns.
campaign_is_final_status	Boolean	Set to True if this is the final state of the message. There are intermediate message statuses and it can take up to 72 hours for the final state to be received. This attribute is applicable to SMS campaigns.
data_lake_last_processed_timestamp	Timestamp	The timestamp that shows the last time the data touched a record in the data lake. This can include a transformation or backfill. Note: Do not use this field to reliably determine recency of data.