Appendix A: Events database data dictionary - Digital User Engagement Events Database

Appendix A: Events database data dictionary

This appendix contains the full data dictionary of all the views generated by this solution. Each view represents a distinct event that is generated by Amazon Pinpoint and Amazon Simple Email Service (Amazon SES).

campaign_send

Data view representing the campaign send event from Amazon Pinpoint. A campaign send event is generated for every endpoint when Amazon Pinpoint executes the campaign.

Field Name Data Type Description
event_timestamp Timestamp

The time when the event was reported, shown as Unix time in milliseconds.

arrival_timestamp Timestamp

The time when the event was received by Amazon Pinpoint, shown as Unix time in milliseconds.

application_id String

Amazon Pinpoint project ID used to send the campaign.

endpoint_id String

The ID of the endpoint that the campaign was sent to.

pinpoint_campaign_id String

The unique ID of the campaign that sent the message.

pinpoint_treatment_id String

If the message was sent using an A/B test campaign, this value represents the treatment number of the message. For standard campaigns, this value is 0.

aws_account_id String

The ID of the AWS account that sent the message.

message_tags Map<String, String>

Custom user-defined event map useful for tracking events from API calls. For events generated by Amazon Pinpoint, this map contains custom context values from the API call.

ingest_timestamp Timestamp

Table partition matching the location of the event in the Amazon S3 bucket. When specified in the WHERE clause, Amazon Athena scans the data only from that partition.

email_click

Data view representing the email click event from Amazon Pinpoint or Amazon SES. The click event is generated when a recipient has received the message and clicked a link in it.

Field Name Data Type Description
event_timestamp Timestamp

The time when the event was reported, shown as Unix time in milliseconds.

arrival_timestamp Timestamp

The time when the event was received by Amazon Pinpoint, shown as Unix time in milliseconds.

application_id String

Amazon Pinpoint project ID used to send the campaign.

endpoint_id String

The ID of the endpoint that the campaign was sent to.

pinpoint_campaign_id String

The unique ID of the campaign that sent the message.

pinpoint_treatment_id String

If the message was sent using an A/B test campaign, this value represents the treatment number of the message. For standard campaigns, this value is 0.

aws_account_id String

The ID of the AWS account that sent the message.

message_id String

The unique ID of the message. Amazon Pinpoint automatically generates this ID when it accepts the message.

message_send_timestamp Timestamp

The date and time when the message was sent.

from_address String

The email address that sent the message.

destination Array<String>

An array that contains the email addresses that the message was sent to.

subject String

The subject line of the email.

ip_address String

IP address of the originating click event.

user_agent String

User Agent of the browser of the originating click event.

link String

Link that clicked on originating the event.

message_tags Map<String, String>

Custom user-defined event map useful for tracking events from API calls. For events generated by Amazon SES, this map contains MessageTags from the email send. For events generated by Amazon Pinpoint, this map contains custom context values from the API call.

ingest_timestamp Timestamp

Table partition matching the location of the event in the Amazon S3 bucket. When specified in the WHERE clause, Amazon Athena scans the data only from that partition.

email_complaint

Data view representing the email complaint event from Amazon Pinpoint or Amazon SES. A complaint event is generated when a recipient received the message, and then reported the message to their email provider as spam (for example, by using the "Report Spam" feature of their email client).

Field Name Data Type Description
event_timestamp Timestamp

The time when the event was reported, shown as Unix time in milliseconds.

arrival_timestamp Timestamp

The time when the event was received by Amazon Pinpoint, shown as Unix time in milliseconds.

application_id String

Amazon Pinpoint project ID used to send the campaign.

endpoint_id String

The ID of the endpoint that the campaign was sent to.

pinpoint_campaign_id String

The unique ID of the campaign that sent the message.

pinpoint_treatment_id String

If the message was sent using an A/B test campaign, this value represents the treatment number of the message. For standard campaigns, this value is 0.

aws_account_id String

The ID of the AWS account that sent the message.

message_id String

The unique ID of the message. Amazon Pinpoint automatically generates this ID when it accepts the message.

message_send_timestamp Timestamp

The date and time when the message was sent.

from_address String

The email address that sent the message.

destination Array<String>

An array that contains the email addresses that the message was sent to.

complained_email_address String

Email address that generated the complaint event.

feedback_id String

The unique ID of the complaint event.

user_agent String

The value of the User-Agent field from the feedback report. This indicates the name and version of the system that generated the report.

complaint_feedback_type String

The value of the Feedback-Type field from the feedback report received from the ISP. This contains the type of feedback.

message_tags Map<String, String>

Custom user-defined event map useful for tracking events from API calls. For events generated by Amazon SES, this map contains MessageTags from the email send. For events generated by Amazon Pinpoint, this map contains custom context values from the API call.

ingest_timestamp Timestamp

Table partition matching the location of the event in the Amazon S3 bucket. When specified in the WHERE clause, Amazon Athena scans the data only from that partition.

email_delivered

Data view representing the email delivered event from Amazon Pinpoint or Amazon SES. A delivery event is generated when the message was delivered to the recipient.

Field Name Data Type Description
event_timestamp Timestamp

The time when the event was reported, shown as Unix time in milliseconds.

arrival_timestamp Timestamp

The time when the event was received by Amazon Pinpoint, shown as Unix time in milliseconds.

application_id String

Amazon Pinpoint project ID used to send the campaign.

endpoint_id String

The ID of the endpoint that the campaign was sent to.

pinpoint_campaign_id String

The unique ID of the campaign that sent the message.

pinpoint_treatment_id String

If the message was sent using an A/B test campaign, this value represents the treatment number of the message. For standard campaigns, this value is 0.

aws_account_id String

The ID of the AWS account that sent the message.

message_id String

The unique ID of the message. Amazon Pinpoint automatically generates this ID when it accepts the message.

message_send_timestamp Timestamp

The date and time when the message was sent.

from_address String

The email address that sent the message.

destination Array<String>

An array that contains the email addresses that the message was sent to.

subject String

The subject line of the email.

smtp_response String

The SMTP response message of the remote ISP that accepted the email from Amazon SES. This message varies by email, by receiving mail server, and by receiving ISP.

reporting_mta String

The host name of the Amazon SES mail server that sent the mail.

recipients Array<String>

A list of the intended recipients of the email to which the delivery notification applies.

processing_time_millis Integer

The time taken to send the message, shown as Unix time in milliseconds.

message_tags Map<String, String>

Custom user-defined event map useful for tracking events from API calls. For events generated by Amazon SES, this map contains MessageTags from the email send. For events generated by Amazon Pinpoint, this map contains custom context values from the API call.

ingest_timestamp Timestamp

Table partition matching the location of the event in the Amazon S3 bucket. When specified in the WHERE clause, Amazon Athena scans the data only from that partition.

email_hardbounce

Data view representing the email hardbounce event from Amazon Pinpoint or Amazon SES. A hard bounce is generated when a permanent issue prevented Amazon Pinpoint or Amazon Simple Email Service from delivering the message.

Field Name Data Type Description
event_timestamp Timestamp

The time when the event was reported, shown as Unix time in milliseconds.

arrival_timestamp Timestamp

The time when the event was received by Amazon Pinpoint, shown as Unix time in milliseconds.

application_id String

Amazon Pinpoint project ID used to send the campaign.

endpoint_id String

The ID of the endpoint that the campaign was sent to.

pinpoint_campaign_id String

The unique ID of the campaign that sent the message.

pinpoint_treatment_id String

If the message was sent using an A/B test campaign, this value represents the treatment number of the message. For standard campaigns, this value is 0.

aws_account_id String

The ID of the AWS account that sent the message.

message_id String

The unique ID of the message. Amazon Pinpoint automatically generates this ID when it accepts the message.

message_send_timestamp Timestamp

The date and time when the message was sent.

from_address String

The email address that sent the message.

destination Array<String>

An array that contains the email addresses that the message was sent to.

bounce_type String

The type of bounce, as determined by Amazon SES. For more information, see Bounce Types.

bounce_sub_type String

The subtype of the bounce, as determined by Amazon SES. For more information, see Bounce Types.

feedback_id String

A unique ID for the bounce.

reporting_mta String

The value of the Reporting-MTA field from the DSN. This is the value of the MTA that attempted to perform the delivery, relay, or gateway operation described in the DSN.

bounced_recipient_email_address String

The email address of the recipient. If a DSN is available, this is the value of the Final-Recipient field from the DSN.

bounced_recipient_action String

The value of the Action field from the DSN. This indicates the action performed by the Reporting-MTA as a result of its attempt to deliver the message to this recipient.

bounced_recipient_status String

The value of the Status field from the DSN. This is the per-recipient transport-independent status code that indicates the delivery status of the message.

bounced_recipient_diagnostic_code String

The status code issued by the reporting MTA. This is the value of the Diagnostic-Code field from the DSN. This field may be absent in the DSN (and therefore also absent in the JSON).

message_tags Map<String, String>

Custom user-defined event map useful for tracking events from API calls. For events generated by Amazon SES, this map contains MessageTags from the email send. For events generated by Amazon Pinpoint, this map contains custom context values from the API call.

ingest_timestamp Timestamp

Table partition matching the location of the event in the Amazon S3 bucket. When specified in the WHERE clause, Amazon Athena scans the data only from that partition.

email_open

Data view representing the email open event from Amazon Pinpoint or Amazon SES. An open event is generated when the recipient received the message and opened it.

Field Name Data Type Description
event_timestamp Timestamp

The time when the event was reported, shown as Unix time in milliseconds.

arrival_timestamp Timestamp

The time when the event was received by Amazon Pinpoint, shown as Unix time in milliseconds.

application_id String

Amazon Pinpoint project ID used to send the campaign.

endpoint_id String

The ID of the endpoint that the campaign was sent to.

pinpoint_campaign_id String

The unique ID of the campaign that sent the message.

pinpoint_treatment_id String

If the message was sent using an A/B test campaign, this value represents the treatment number of the message. For standard campaigns, this value is 0.

aws_account_id String

The ID of the AWS account that sent the message.

message_id String

The unique ID of the message. Amazon Pinpoint automatically generates this ID when it accepts the message.

message_send_timestamp Timestamp

The date and time when the message was sent.

from_address String

The email address that sent the message.

destination Array<String>

An array that contains the email addresses that the message was sent to.

subject String

The subject line of the email.

ip_address String

IP address of the originating click event.

user_agent String

User agent of the browser of the originating click event.

message_tags Map<String, String>

Custom user-defined event map useful for tracking events from API calls. For events generated by Amazon SES, this map contains MessageTags from the email send. For events generated by Amazon Pinpoint, this map contains custom context values from the API call.

ingest_timestamp Timestamp

Table partition matching the location of the event in the Amazon S3 bucket. When specified in the WHERE clause, Amazon Athena scans the data only from that partition.

email_rejected

Data view representing the email reject event from Amazon Pinpoint or Amazon SES. An open event is generated when the recipient received the message and opened it.

Field Name Data Type Description
event_timestamp Timestamp

The time when the event was reported, shown as Unix time in milliseconds.

arrival_timestamp Timestamp

The time when the event was received by Amazon Pinpoint, shown as Unix time in milliseconds.

application_id String

Amazon Pinpoint project ID used to send the campaign.

endpoint_id String

The ID of the endpoint that the campaign was sent to.

pinpoint_campaign_id String

The unique ID of the campaign that sent the message.

pinpoint_treatment_id String

If the message was sent using an A/B test campaign, this value represents the treatment number of the message. For standard campaigns, this value is 0.

aws_account_id String

The ID of the AWS account that sent the message.

message_id String

The unique ID of the message. Amazon Pinpoint automatically generates this ID when it accepts the message.

message_send_timestamp Timestamp

The date and time when the message was sent.

from_address String

The email address that sent the message.

destination Array<String>

An array that contains the email addresses that the message was sent to.

subject String

The subject line of the email.

reject_reason String

Reason for the message to be rejected.

message_tags Map<String, String>

Custom user-defined event map useful for tracking events from API calls. For events generated by Amazon SES, this map contains MessageTags from the email send. For events generated by Amazon Pinpoint, this map contains custom context values from the API call.

ingest_timestamp Timestamp

Table partition matching the location of the event in the Amazon S3 bucket. When specified in the WHERE clause, Amazon Athena scans the data only from that partition.

email_send

Data view representing the email send event from Amazon Pinpoint or Amazon SES. A send event is generated when the message was accepted by Amazon Pinpoint or Amazon SES and attempted to deliver it to the recipient.

Field Name Data Type Description
event_timestamp Timestamp

The time when the event was reported, shown as Unix time in milliseconds.

arrival_timestamp Timestamp

The time when the event was received by Amazon Pinpoint, shown as Unix time in milliseconds.

application_id String

Amazon Pinpoint project ID used to send the campaign.

endpoint_id String

The ID of the endpoint that the campaign was sent to.

pinpoint_campaign_id String

The unique ID of the campaign that sent the message.

pinpoint_treatment_id String

If the message was sent using an A/B test campaign, this value represents the treatment number of the message. For standard campaigns, this value is 0.

aws_account_id String

The ID of the AWS account that sent the message.

message_id String

The unique ID of the message. Amazon Pinpoint automatically generates this ID when it accepts the message.

message_send_timestamp Timestamp

The date and time when the message was sent.

from_address String

The email address that sent the message.

destination Array<String>

An array that contains the email addresses that the message was sent to.

subject String

The subject line of the email.

message_tags Map<String, String>

Custom user-defined event map useful for tracking events from API calls. For events generated by Amazon SES, this map contains MessageTags from the email send. For events generated by Amazon Pinpoint, this map contains custom context values from the API call.

ingest_timestamp Timestamp

Table partition matching the location of the event in the Amazon S3 bucket. When specified in the WHERE clause, Amazon Athena scans the data only from that partition.

email_softbounce

Data view representing the email softbounce event from Amazon Pinpoint or Amazon SES. A soft bounce is generated when a temporary issue prevented Amazon Pinpoint or Amazon Simple Email Service from delivering the message.

Field Name Data Type Description
event_timestamp Timestamp

The time when the event was reported, shown as Unix time in milliseconds.

arrival_timestamp Timestamp

The time when the event was received by Amazon Pinpoint, shown as Unix time in milliseconds.

application_id String

Amazon Pinpoint project ID used to send the campaign.

endpoint_id String

The ID of the endpoint that the campaign was sent to.

pinpoint_campaign_id String

The unique ID of the campaign that sent the message.

pinpoint_treatment_id String

If the message was sent using an A/B test campaign, this value represents the treatment number of the message. For standard campaigns, this value is 0.

aws_account_id String

The ID of the AWS account that sent the message.

message_id String

The unique ID of the message. Amazon Pinpoint automatically generates this ID when it accepts the message.

message_send_timestamp Timestamp

The date and time when the message was sent.

from_address String

The email address that sent the message.

destination Array<String>

An array that contains the email addresses that the message was sent to.

bounce_type String

The type of bounce, as determined by Amazon SES. For more information, see Bounce Types.

bounce_sub_type String

The subtype of the bounce, as determined by Amazon SES. For more information, see Bounce Types.

feedback_id String

A unique ID for the bounce.

reporting_mta String

The value of the Reporting-MTA field from the DSN. This is the value of the MTA that attempted to perform the delivery, relay, or gateway operation described in the DSN.

bounced_recipient_email_address String

The email address of the recipient. If a DSN is available, this is the value of the Final-Recipient field from the DSN.

bounced_recipient_action String

The value of the Action field from the DSN. This indicates the action performed by the Reporting-MTA as a result of its attempt to deliver the message to this recipient.

bounced_recipient_status String

The value of the Status field from the DSN. This is the per-recipient transport-independent status code that indicates the delivery status of the message.

bounced_recipient_diagnostic_code String

The status code issued by the reporting MTA. This is the value of the Diagnostic-Code field from the DSN. This field may be absent in the DSN (and therefore also absent in the JSON).

message_tags Map<String, String>

Custom user-defined event map useful for tracking events from API calls. For events generated by Amazon SES, this map contains MessageTags from the email send. For events generated by Amazon Pinpoint, this map contains custom context values from the API call.

ingest_timestamp Timestamp

Table partition matching the location of the event in the Amazon S3 bucket. When specified in the WHERE clause, Amazon Athena scans the data only from that partition.

email_unsubscribe

Data view representing the email unsubscribe event from Amazon Pinpoint or Amazon SES. The unsubscribe event is generated when a recipient received the message and clicked an unsubscribe link in it.

Field Name Data Type Description
event_timestamp Timestamp

The time when the event was reported, shown as Unix time in milliseconds.

arrival_timestamp Timestamp

The time when the event was received by Amazon Pinpoint, shown as Unix time in milliseconds.

application_id String

Amazon Pinpoint project ID used to send the campaign.

endpoint_id String

The ID of the endpoint that the campaign was sent to.

pinpoint_campaign_id String

The unique ID of the campaign that sent the message.

pinpoint_treatment_id String

If the message was sent using an A/B test campaign, this value represents the treatment number of the message. For standard campaigns, this value is 0.

aws_account_id String

The ID of the AWS account that sent the message.

message_id String

The unique ID of the message. Amazon Pinpoint automatically generates this ID when it accepts the message.

message_send_timestamp Timestamp

The date and time when the message was sent.

from_address String

The email address that sent the message.

destination Array<String>

An array that contains the email addresses that the message was sent to.

subject String

The subject line of the email.

ip_address String

IP address of the originating unsubscribe event.

user_agent String

User agent of the browser of the originating unsubscribe event.

link String

Unsubscribe link that clicked on originating the event.

unsubscribelinktag Array<String>

Link tag used to decorate the unsubscribe link.

message_tags Map<String, String>

Custom user-defined event map useful for tracking events from API calls. For events generated by Amazon SES, this map contains MessageTags from the email send. For events generated by Amazon Pinpoint, this map contains custom context values from the API call.

ingest_timestamp Timestamp

Table partition matching the location of the event in the Amazon S3 bucket. When specified in the WHERE clause, Amazon Athena scans the data only from that partition.

journey_send

Data view representing the journey send event from Amazon Pinpoint. A journey send event is generated for every endpoint that receives an email from an Amazon Pinpoint journey.

Field Name Data Type Description
event_timestamp Timestamp

The time when the event was reported, shown as Unix time in milliseconds.

arrival_timestamp Timestamp

The time when the event was received by Amazon Pinpoint, shown as Unix time in milliseconds.

application_id String

Amazon Pinpoint project ID used to send the campaign.

endpoint_id String

The ID of the endpoint that the campaign was sent to.

journey_run_id String

The unique ID of the journey run that generated the event. Amazon Pinpoint generates and assigns this ID automatically to each new run of a journey.

journey_send_status String

Indicates the delivery status of the message that's associated with the event.

journey_id String

The unique ID of the journey that generated the event.

journey_activity_id String

The unique ID of the journey activity that generated the event.

aws_account_id String

The ID of the AWS account that was used to send the message.

message_tags Map<String, String>

Custom user-defined event map useful for tracking events from API calls. For events generated by Amazon Pinpoint, this map contains custom context values from the API call.

ingest_timestamp Timestamp

Table partition matching the location of the event in the Amazon S3 bucket. When specified in the WHERE clause, Amazon Athena scans the data only from that partition.

sms_buffered

Data view representing the sms buffered event from Amazon Pinpoint. An SMS buffered event is generated when the message has been received and is still in process of being delivered to the recipient.

Field Name Data Type Description
event_timestamp Timestamp

The time when the event was reported, shown as Unix time in milliseconds.

arrival_timestamp Timestamp

The time when the event was received by Amazon Pinpoint, shown as Unix time in milliseconds.

application_id String

Amazon Pinpoint project ID used to send the campaign.

endpoint_id String

The ID of the endpoint that the campaign was sent to.

pinpoint_campaign_id String

The unique ID of the campaign that sent the message.

pinpoint_treatment_id String

If the message was sent using an A/B test campaign, this value represents the treatment number of the message. For standard campaigns, this value is 0.

aws_account_id String

The ID of the AWS account that sent the message.

sender_request_id String

A unique ID that's associated with the request to send the SMS message.

destination_phone_number String

The phone number that you attempted to send the message to.

record_status String

Additional information about the status of the message.

iso_country_code String

The country that's associated with the recipient's phone number, shown in ISO 3166-1 alpha-2 format.

number_of_message_parts String

The number of message parts that Amazon Pinpoint created in order to send the message.

message_id String

The unique ID that Amazon Pinpoint generates when it accepts the message.

message_type String

The type of message. Possible values are Promotional and Transactional.

price_in_millicents_usd Double

The amount that AWS charged you to send the message. This price is shown in thousandths of a United States cent.

message_tags Map<String, String>

Custom user-defined event map useful for tracking events from API calls. For events generated by Amazon Pinpoint, this map contains custom context values from the API call.

ingest_timestamp Timestamp

Table partition matching the location of the event in the Amazon S3 bucket. When specified in the WHERE clause, Amazon Athena scans the data only from that partition.

sms_failure

Data view representing the sms failure event from Amazon Pinpoint. A SMS failure event is generated when Amazon Pinpoint wasn’t able to deliver the message to the recipient.

Field Name Data Type Description
event_timestamp Timestamp

The time when the event was reported, shown as Unix time in milliseconds.

arrival_timestamp Timestamp

The time when the event was received by Amazon Pinpoint, shown as Unix time in milliseconds.

application_id String

Amazon Pinpoint project ID used to send the campaign.

endpoint_id String

The ID of the endpoint that the campaign was sent to.

pinpoint_campaign_id String

The unique ID of the campaign that sent the message.

pinpoint_treatment_id String

If the message was sent using an A/B test campaign, this value represents the treatment number of the message. For standard campaigns, this value is 0.

aws_account_id String

The ID of the AWS account that sent the message.

sender_request_id String

A unique ID that's associated with the request to send the SMS message.

destination_phone_number String

The phone number that you attempted to send the message to.

record_status String

Additional information about the status of the message.

iso_country_code String

The country that's associated with the recipient's phone number, shown in ISO 3166-1 alpha-2 format.

number_of_message_parts String

The number of message parts that Amazon Pinpoint created in order to send the message.

message_id String

The unique ID that Amazon Pinpoint generates when it accepts the message.

origination_phone_number String

The phone number that sent the message.

price_in_millicents_usd Double

The amount that AWS charged you to send the message. This price is shown in thousandths of a United States cent.

message_tags Map<String, String>

Custom user-defined event map useful for tracking events from API calls. For events generated by Amazon Pinpoint, this map contains custom context values from the API call.

ingest_timestamp Timestamp

Table partition matching the location of the event in the Amazon S3 bucket. When specified in the WHERE clause, Amazon Athena scans the data only from that partition.

sms_optout

Data view representing the sms optout event from Amazon Pinpoint. A SMS buffered event is generated when a customer received the message and replied by sending the opt-out keyword (usually "STOP").

Field Name Data Type Description
event_timestamp Timestamp

The time when the event was reported, shown as Unix time in milliseconds.

arrival_timestamp Timestamp

The time when the event was received by Amazon Pinpoint, shown as Unix time in milliseconds.

application_id String

Amazon Pinpoint project ID used to send the campaign.

endpoint_id String

The ID of the endpoint that the campaign was sent to.

pinpoint_campaign_id String

The unique ID of the campaign that sent the message.

pinpoint_treatment_id String

If the message was sent using an A/B test campaign, this value represents the treatment number of the message. For standard campaigns, this value is 0.

aws_account_id String

The ID of the AWS account that sent the message.

sender_request_id String

A unique ID that's associated with the request to send the SMS message.

destination_phone_number String

The phone number that you attempted to send the message to.

record_status String

Additional information about the status of the message.

iso_country_code String

The country that's associated with the recipient's phone number, shown in ISO 3166-1 alpha-2 format.

number_of_message_parts String

The number of message parts that Amazon Pinpoint created in order to send the message.

message_id String

The unique ID that Amazon Pinpoint generates when it accepts the message.

message_type String

The type of message. Possible values are Promotional and Transactional.

origination_phone_number String

The phone number that sent the message.

price_in_millicents_usd Double

The amount that AWS charged you to send the message. This price is shown in thousandths of a United States cent.

message_tags Map<String, String>

Custom user-defined event map useful for tracking events from API calls. For events generated by Amazon Pinpoint, this map contains custom context values from the API call.

ingest_timestamp Timestamp

Table partition matching the location of the event in the Amazon S3 bucket. When specified in the WHERE clause, Amazon Athena scans the data only from that partition.

sms_success

Data view representing the sms success event from Amazon Pinpoint. A SMS buffered event is generated when the message was successfully delivered to the recipient.

Field Name Data Type Description
event_timestamp Timestamp

The time when the event was reported, shown as Unix time in milliseconds.

arrival_timestamp Timestamp

The time when the event was received by Amazon Pinpoint, shown as Unix time in milliseconds.

application_id String

Amazon Pinpoint project ID used to send the campaign.

endpoint_id String

The ID of the endpoint that the campaign was sent to.

pinpoint_campaign_id String

The unique ID of the campaign that sent the message.

pinpoint_treatment_id String

If the message was sent using an A/B test campaign, this value represents the treatment number of the message. For standard campaigns, this value is 0.

aws_account_id String

The ID of the AWS account that sent the message.

sender_request_id String

A unique ID that's associated with the request to send the SMS message.

destination_phone_number String

The phone number that you attempted to send the message to.

record_status String

Additional information about the status of the message.

iso_country_code String

The country that's associated with the recipient's phone number, shown in ISO 3166-1 alpha-2 format.

number_of_message_parts String

The number of message parts that Amazon Pinpoint created in order to send the message.

message_id String

The unique ID that Amazon Pinpoint generates when it accepts the message.

message_type String

The type of message. Possible values are Promotional and Transactional.

origination_phone_number String

The phone number that sent the message.

price_in_millicents_usd Double

The amount that AWS charged you to send the message. This price is shown in thousandths of a United States cent.

message_tags Map<String, String>

Custom user-defined event map useful for tracking events from API calls. For events generated by Amazon Pinpoint, this map contains custom context values from the API call.

ingest_timestamp Timestamp

Table partition matching the location of the event in the Amazon S3 bucket. When specified in the WHERE clause, Amazon Athena scans the data only from that partition.