# Outbound campaigns data in the Amazon Connect data lake
<a name="data-lake-outbound-campaigns-data"></a>

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

There are two ways to access the analytics data lake and configure data to be shared: 
+ [Option 1: Use the Amazon Connect console](access-datalake.md#option1-configure-data-to-be-shared)
+ [Option 2: Use CLI or CloudShell](access-datalake.md#option2-configure-data-to-be-shared)

If you are unable to access the scheduling tables by using Option 1, try using Option 2.

## Outbound campaign events
<a name="data-lake-oc-events"></a>

Table name: outbound\$1campaign\$1events

Composite primary key: `campaign_event_id`, `instanceId`


| **Column** | **Type** | **Description** | 
| --- | --- | --- | 
| account\$1profile\$1id | String | Specifies the profile identifier for an account-based profile in Customer Profiles. | 
| instance\$1id | String | The identifier of the Amazon Connect instance. | 
| instance\$1arn | String | The ARN of the Amazon Connect instance. | 
| aws\$1account\$1id | String | The identifier of the AWS account that owns the outbound campaign.  | 
| campaign\$1id | String | The identifier for the outbound campaign. | 
| campaign\$1name | String | The name of the outbound campaign. | 
| campaign\$1initiation\$1type | String | The campaign initiation method selected for the outbound campaign. For example: CUSTOMER\$1SEGMENT, CUSTOMER\$1EVENT. | 
| campaign\$1execution\$1timestamp | Timestamp | The Timestamp indicating the start of each campaign execution. Multiple Timestamps can exist for campaigns that run repeatedly. | 
| campaign\$1event\$1id | String | The unique identifier for each outbound campaign event. | 
| campaign\$1event\$1type | String | The specific outbound campaign event type. *Campaign events:* [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/connect/latest/adminguide/data-lake-outbound-campaigns-data.html) *Email events:* [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/connect/latest/adminguide/data-lake-outbound-campaigns-data.html) *SMS events:* [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/connect/latest/adminguide/data-lake-outbound-campaigns-data.html) *Telephony events:* [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/connect/latest/adminguide/data-lake-outbound-campaigns-data.html)  | 
| campaign\$1event\$1timestamp | Timestamp | The Timestamp indicating when the outbound campaign event occurred.  | 
| delivery\$1attempt\$1id | 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\$1id | 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\$1segment\$1arn | 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\$1url\$1link\$1click | String | The URL link clicked by the outbound campaign recipient. This attribute is applicable to email campaigns.  | 
| campaign\$1is\$1final\$1status | 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\$1lake\$1last\$1processed\$1timestamp | Timestamp | 
| lambda\$1function\$1arn | String | The Lambda Function ARN invoked by Outbound Campaigns. | 
| lambda\$1invocation\$1result | String | The result of the Lambda Function invocation attempt. Set to SUCCESS: Outbound Campaigns successfully invoked the Lambda function and received a response, including [function errors](https://docs.aws.amazon.com/lambda/latest/api/API_Invoke.html#API_Invoke_ResponseSyntax) and malformed responses. Set to ERROR: Outbound Campaigns failed to invoke the Lambda function or couldn't confirm successful invocation (e.g., timeout). | 
| orchestration\$1event\$1context\$1subtype | String | Provides additional granularity for outbound campaign events indicating the specific reason a target was not reached. |