What does this AWS Solutions Implementation do?

Customers expect businesses and brands to understand them uniquely and communicate to them with relevant and timely messaging. Rising to meet these expectations, modern data-driven marketers look to data to understand their customers to deliver the right message, on the right channel, at the right time.

Amazon Simple Email Service (Amazon SES) and Amazon Pinpoint provide powerful tools to orchestrate and deliver communications using email, SMS, voice, and mobile push channels. In addition to providing rich dashboards showing aggregate engagement data, both Amazon SES and Amazon Pinpoint allow real-time engagement event streaming to Amazon Kinesis. These events include email sends, email opens, email clicks, email bounces, email spam complaints, SMS sends, SMS failures, SMS opt outs, and custom application events.

The Digital User Engagement Events Database solution is a reference implementation that automatically provisions and configures the AWS services necessary to start analyzing the real-time stream of engagement data from Amazon SES and Amazon Pinpoint.

AWS Solutions Implementation overview

The diagram below presents the architecture you can automatically deploy using the solution's implementation guide and accompanying AWS CloudFormation template.

Multi-Region Application Architecture | Architecture Diagram
 Click to enlarge

Digital User Engagement Events Database solution architecture

This solution deploys an AWS CloudFormation template that configures an Amazon Pinpoint event stream and an Amazon Simple Email Service configuration set to store event data in Amazon Simple Storage Service (Amazon S3). The Amazon S3 data schema is stored in an AWS Glue Data Catalog enabling data queries with Amazon Athena.

The schema created in the AWS Glue Data Catalog follows data partitioning best practices requiring the new partitions to be added as new data is persisted in Amazon S3.

Digital User Engagement Events Database

Version 1.0.0
Last updated: 06/2020
Author: AWS

Estimated deployment time: 5 min

Use the button below to subscribe to solution updates.

Note: To subscribe to RSS updates, you must have an RSS plug-in enabled for the browser you are using.  

Did this Solutions Implementation help you?
Provide feedback 

Features

Extensible

You can configure multiple Amazon Pinpoint projects and multiple Amazon Simple Email Service Configuration Sets to route events into the same database. This allows you to have a centralized database of all of your engagement events across all workloads.

Visualization

The deployed event can be pulled into visualization tools like Amazon QuickSight to create custom dashboards.

Data partitioning

The AWS CloudFormation template configures the Amazon S3 bucket with an AWS Lambda function trigger that automatically adds new table partitions as files are saved. This follows best practices and helps reduce query costs.
Build icon
Deploy a Solution yourself

Browse our library of AWS Solutions Implementations to get answers to common architectural problems.

Learn more 
Find an APN partner
Find an APN Partner

Find AWS certified consulting and technology partners to help you get started.

Learn more 
Explore icon
Explore Solutions Consulting Offers

Browse our portfolio of Consulting Offers to get AWS-vetted help with solution deployment.

Learn more