Data Exporter Overview

Sailthru Data Exporter is an individually priced product offering from Sailthru.

The Sailthru Data Exporter allows for a one-time or daily recurring export to a client-managed secure SFTP site or Amazon S3 bucket.

Included in the export is campaign, triggered, and user data that includes list memberships, var values, purchase data, and more. (A full list of fields and collections are included on this page.)

  • Profile data is exported for users that have updated profiles from activity since the previous day.
  • Campaign data includes basic information about campaigns sent on the previous day
  • Campaign message data includes metadata on all emails sent as part of each campaign sent on the previous day, and all campaign emails sent over the past 7 days that generated user activity.
  • Triggered message data includes metadata on all emails sent as part of each triggered email sent on the previous day, and all triggered emails sent over the past 7 days that generated user activity.

Once you prepare your upload site using the Sailthru public key, the initial upload begins the following morning.

Note that you can alternatively perform an export of user data for a given list on the My Sailthru “Lists” page (see Export Lists and User Profile Data) or using the export_list_data job in the Sailthru API.

 

Setup

To receive daily and/or one-time historical exports from Sailthru, you must request one or both types of exports from Sailthru and configure a destination where Sailthru will upload the data. We recommend configuring an Amazon S3 bucket that you own and maintain to receive these exports.

 

Amazon S3

  1. Permission the Sailthru user account to be able to write to a bucket that is owned by your company as per this AWS documentation. You will use the Sailthru public S3 account principalarn:aws:iam::728023223659:user/integ.
    Click to view and customize the S3 account bucket policy
    {
        "Version": "2012-10-17",
        "Statement": [
            {
                "Sid": "bucket permissions",
                "Effect": "Allow",
                "Principal": {
                    "AWS": "arn:aws:iam::728023223659:user/integ"
                },
                "Action": [
                    "s3:GetBucketLocation",
                    "s3:ListBucket"
                ],
                "Resource": "arn:aws:s3:::yourcompanyname-sailthru-data"
            },
            {
                "Sid": "key permissions",
                "Effect": "Allow",
                "Principal": {
                    "AWS": "arn:aws:iam::728023223659:user/integ"
                },
                "Action": [
                    "s3:PutObject",
                    "s3:GetObject",
                    "s3:DeleteObject",
                    "s3:PutObjectAcl",
                    "s3:GetObjectAcl"
                ],
                "Resource": "arn:aws:s3:::yourcompanyname-sailthru-data/*"
            }
        ]
    }
  1. Provide your Sailthru representative with the bucket name and a path to export to.

Alternate Connection Method

If for some reason that Amazon S3 is not an option, an alternative method to receive exports is via SFTP.

  1. Create a user with write permission and allow the Sailthru public key (below) to log in as that user. Consult your SFTP server documentation to determine how this is done. Note: depending on your server’s configuration, you may need to remove the comment field `Sailthru Report Delivery` from the Sailthru public key.
  2. Send the username and hostname to Sailthru, along with an optional path and folder to export to, otherwise the root directory is used.

The Sailthru public SFTP key:

ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAgEAtwmLED75SHzCWTm6HGheO6HAmhDYGsDEVj6lrlGqdDNaObqqOI3wWuuBS6VKx1ZovYjNiQyDRWXfru0IGFu4EoeWo2lyQuHGYOPShTuy0tLtkTMljx1XnlwxX2p4cRZ/ZGQsPAjJmIpQttGpT5VyvPYxKPuF3H3ldPxjffmSpt4bUqbOyGsXI6riA1jvTVt46hf/UN2Or23FwpoXp6gdKZJfvVThXNwXk2+tpKrnzltt2wiSyMui7AXCcU4o9fvk8iG3JN7IKIkg0Fp0IxVpbJi14h/2YbtPuK7tbORneC2VnWYAvE5INfzNejEJcEtHyR32nXEiLXt3QNgikNgjPqBNiuwQ9QsILD+GfAZWpN8xp5NmEogTpoOkYRXdlkBZBpmIlZmC7H+LsrzZ+XYWccwPOd5hpGsSyr5ijBkZfd3TIgEkc/kK76Eg2HOsBBMjcmUG7F7+JAs617P5r+vJsPMYi0xj4dXsqTgGjBJleUC+S6xIOojCZzQ7eGIKaXVUFHZFE6Q7D0RPYZw3R/9XqZwMQIhsR6zgwcT2Phd206nnLsq8Y2BgRsmdU3EcL4CdWUfTWjqssP7nHvjf6o6xsBWPKtl4+YJaFom0P68ZNEuvJDcLmKMd4a5oe+CyvhYdYUVJ1t5aJ2ZRNzUe2EHuQG1g4IKo0tfaj9/gosdvhx0= Sailthru Report Delivery
(Triple-click to highlight, then copy.)

Top