Configuring Destinations for Data Studio Exports

A destination is where Data Studio delivers a finished export. By default, exports are available as a downloadable file in Act-On. If you want the data to land in a team storage location without anyone having to log in and fetch it, you need to add that location as a destination first. Once added, destinations appear as options whenever you set up an export or package.

Supported destination types

Data Studio can deliver to:

• Downloadable File (default). The export is stored by Data Studio for a short time so you can download it manually.
• SFTP. Connect a secure FTP location.
• Cloud Storage: Amazon S3, Dropbox, Google Drive, Microsoft OneDrive (personal only).

What you need before you start

• Act-On administrator access.
• Credentials or an account for the destination you want to use.
• For SFTP: the receiving server's host, port, username, password or key, and the target folder path, plus cooperation from IT to allowlist Act-On's IP ranges.
• For Amazon S3: an IAM user with the correct policy (see below), the Access Key and Secret Key for that user, and the bucket name.

Add a destination

1. Go to Reports > Data Studio and click Destinations in the left menu.
2. Click Add and choose the destination type.
3. Fill in the connection details for that destination type (see the specifics below).
4. Save the destination.

SFTP requirements

If you're receiving Data Studio files by SFTP, your server must allow inbound connections from Act-On's IP ranges:

• 207.189.124.0/24
• 207.189.125.0/24
• 54.200.92.142
• 54.93.34.201
• 54.194.14.170
• 35.183.73.63

Ask your IT or networking team to add these to the allow list before you save the SFTP destination in Data Studio, otherwise connection tests and scheduled runs will fail.

Dropbox notes

When exporting to a Dropbox subfolder, prepend the subfolder name with a forward slash. Example: /aotest. Without the leading slash Data Studio may treat the value as a filename prefix instead of a folder path.

Microsoft OneDrive notes

Only personal OneDrive accounts are supported. Business accounts are not currently available as a destination. If your team uses OneDrive for Business, use SFTP or Amazon S3 instead.

Amazon S3 setup

To link an Amazon S3 bucket, you need:

• Your bucket name.
• An AWS Access Key and Secret Key belonging to an IAM user with permission to write to the bucket.

To get the keys, create an IAM user in your AWS account. AWS documentation:

• Create an IAM user in your AWS account
• Manage access keys for IAM users

Attach a policy to the IAM user that allows Data Studio to write, read, abort multipart uploads, get bucket location, and delete objects on the bucket. Example policy:

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Sid": "s3export",
            "Action": [
                "s3:PutObject",
                "s3:GetObject",
                "s3:AbortMultipartUpload",
                "s3:GetBucketLocation",
                "s3:DeleteObject"
            ],
            "Effect": "Allow",
            "Resource": [
                "arn:aws:s3:::AWSBUCKETNAME/*",
                "arn:aws:s3:::AWSBUCKETNAME"
            ]
        }
    ]
}

Replace AWSBUCKETNAME with your bucket name.

Common pitfalls