Adapty UA’s integration with Amazon S3 allows you to store user acquisition campaign data securely in one central location. You will be able to save your campaign performance data, attribution data, and user acquisition events to your Amazon S3 bucket as .csv files.
To set up this integration, you will need to follow a few simple steps in the AWS Console and Adapty UA dashboard.

How to set up Amazon S3 integration

To start receiving data, you’ll need the following credentials:

1. Access key ID
2. Secret access key
3. S3 bucket name
4. Folder name inside the S3 bucket

Step 1. Create Amazon S3 credentials

This guide will help you create the necessary credentials in your AWS Console.

1.1. Create Access Policy

1. Navigate to the IAM Policy Dashboard in your AWS Console
2. Select the option to Create Policy

3. In the Policy editor, paste the following JSON and change adapty-s3-integration-test to your bucket name:

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Sid": "AllowListObjectsInBucket",
            "Effect": "Allow",
            "Action": "s3:ListBucket",
            "Resource": "arn:aws:s3:::adapty-s3-integration-test"
        },
        {
            "Sid": "AllowAllObjectActions",
            "Effect": "Allow",
            "Action": "s3:*Object",
            "Resource": [
                "arn:aws:s3:::adapty-s3-integration-test/*",
                "arn:aws:s3:::adapty-s3-integration-test"
            ]
        },
        {
            "Sid": "AllowBucketLocation",
            "Effect": "Allow",
            "Action": "s3:GetBucketLocation",
            "Resource": "arn:aws:s3:::adapty-s3-integration-test"
        }
    ]
}

4. After completing the policy configuration, you may choose to add tags (optional) and then click Next to proceed to the final step
5. In this step, you will name your policy and simply click on the Create policy button to finalize the creation process

1.2. Create IAM user

To enable Adapty UA to upload raw data reports to your bucket, you will need to provide them with the Access Key ID and Secret Access Key for a user who has write access to the specific bucket.

1. Navigate to the IAM Console and select the Users section
2. Click on the Add users button

3. Give the user a name, choose Access key – Programmatic access, and proceed to permissions

4. For the next step, please select the Add user to group option and then click the Create group button

5. Next, you need to assign a name to your User Group and select the policy that was previously created by you
6. Once you have selected the policy, click on the Create group button to complete the process

7. After successfully creating the group, please select it and proceed to the next step

8. Since this is the final step for this section, you may proceed by simply clicking on the Create User button

9. Lastly, you can either download the credentials in .csv format or alternatively, copy and paste the credentials directly from the dashboard

Step 2. Configure integration in Adapty UA

1. Go to Integrations -> Amazon S3
2. Turn on the Export install events to Amazon S3 toggle.
3. Fill out the following fields to build a connection between Amazon S3 and Adapty UA profiles:

Field	Description
Access Key ID	A unique identifier that is used to authenticate a user or application’s access to an AWS service. Find this ID in the downloaded csv file .
Secret Access Key	A private key that is used in conjunction with the Access Key ID to authenticate a user or application’s access to an AWS service. Find this Key in the downloaded csv file .
S3 Bucket Name	A globally unique name that identifies a specific S3 bucket within the AWS cloud. S3 buckets are a simple storage service that allows users to store and retrieve data objects, such as files and images, in the cloud.
Folder Inside the Bucker	The name of the folder that you want to have inside the selected S3 bucket. Please note that S3 simulates folders using object key prefixes, which are essentially folder names.
Region (Optional)	Get your Region from the AWS Management Console under your IAM user account.

Manual data export

In addition to the automatic event data export to Amazon S3, Adapty UA also provides a manual file export functionality. With this feature, you can select a specific date for the user acquisition data and export it to your S3 bucket manually. This allows you to have greater control over the data you export and when you export it.

Table structure

In AWS S3 integration, Adapty UA provides a table to store historical data for installation events. The table contains information about the user profile, revenue and proceeds, and the origin store, among other data points.

Here is the table structure for the events:

Column	Description
adapty_profile_id	Unique Adapty profile identifier
install_id	Unique installation identifier
created_at	Record creation timestamp (ISO 8601)
installed_at	App installation timestamp (ISO 8601)
store	App store (ios, android)
country	User’s country code (ISO 3166-1 alpha-2)
ip_address	Client IP address
idfa	iOS Identifier for Advertisers
idfv	iOS Identifier for Vendors
gaid	Google Advertising ID (Android)
android_id	Android device ID
app_set_id	Android App Set ID
channel	Attribution channel
campaign_id	Campaign identifier
campaign_name	Campaign name
adset_id	Ad set identifier
adset_name	Ad set name
ad_id	Ad identifier
ad_name	Ad name
keyword_id	Keyword identifier
keyword_name	Keyword name
asa_org_id	Apple Search Ads organization ID
asa_keyword_match_type	ASA keyword match type (Exact, Broad)
asa_attribution	ASA attribution data (JSON string)
asa_conversion_type	ASA conversion type
asa_country_or_region	ASA country or region
asa_creative_set_name	ASA creative set name
fbclid	Facebook Click ID
ttclid	TikTok Click ID
utm_source	UTM source parameter
utm_medium	UTM medium parameter
utm_campaign	UTM campaign parameter
utm_term	UTM term parameter
utm_content	UTM content parameter