Integrating VWO with Amazon S3

Amazon Simple Storage Service (Amazon S3) is an object storage service that offers industry-leading scalability, data availability, security, and performance. Amazon S3 provides easy-to-use management features so you can organize your data and configure finely-tuned access controls to meet your specific business, organizational, and compliance requirements.

Amazon S3 customers access their data through a web browser or command-line interface. Also, customers can choose the geographical location where their data is stored. You can learn more about Amazon S3 here. 

How Can VWO-Amazon S3 Integration Help You?

• Ability to export VWO Campaigns data daily
• Eliminates the need to download CSV from VWO’s dashboard manually
• Use platforms like Amazon Redshift to leverage and understand your audiences journey in VWO

Enabling the VWO-Amazon S3 Integration for Your VWO Account

Enabling the VWO-Amazon S3 integration is a five-step process:

1. Enable Amazon S3 integration in VWO
2. Create a bucket in the AWS dashboard
3. Create a policy in the AWS dashboard
4. Add a user in the AWS dashboard
5. Specify security credentials in VWO

Let’s have a look at actions you need to perform at each of these steps.

Enable Amazon S3 Integration in VWO

To enable the Amazon S3 integrations in VWO, follow this:

Procedure

1. Log in to your VWO account.
2. From the left panel of your VWO dashboard, go to the INTEGRATIONS tab. 
3. Click on the Amazon S3 integration and enable it by clicking the Enable Now button. Once enabled, the Amazon S3 screen within the VWO’s Integration section looks like this:

Create a Bucket in the AWS Dashboard

Once you’ve enabled Amazon S3 in your VWO account, the next step is to create a bucket in your AWS dashboard. Here’s how you can create one:

Procedure

1. Log in to your AWS account.
2. In your AWS dashboard, type S3 in the search bar and select Services > S3.
3. To create a bucket, click Create bucket.
4. In the UI that appears, enter the Bucket name.
5. To finalize your bucket creation, click Create bucket at the bottom of the page.

Create a Policy in the AWS Dashboard

Once you’ve created a bucket in your AWS account, the next step is to create a policy in your AWS dashboard. Here’s how you can create one:

Procedure

1. Log in to your AWS account.
2. In your AWS dashboard, type IAM in the search bar and select Services > IAM.
3. Go to Access Management > Policies.
   
4. To create a policy, click Create Policy.
5. In the UI that appears, go to the JSON tab and enter the following code snippet. Once done, click Next: Review. 
6. In the UI that appears, enter your policy name and review your configurations. Once done, click Create policy.

Add a User in the AWS Dashboard

Once you’ve created a policy in your AWS account, the next step is to add a user to your AWS dashboard. Here’s how you can create one:

Procedure

1. Log in to your AWS account.
2. In your AWS dashboard, type IAM in the search bar and select Services > IAM.
3. To add a user, go to Access Management > Users.
   
4. To add a user, click Add user.
5. In the UI that appears, do the following:
   • In the User name field, specify the user name.
   • Select the Access type as Programmatic access.
   • Once done, click Next: Permissions.
6. From the list of policies that appears, select the one specified in Step-5 of the Create a Policy in AWS Dashboard procedure, and click Next: Tags.
7. Review your user configurations, click Create user.
   
8. On successful creation of a user, the security credentials are generated, which you can download using the Download.csv button.

Specify Security Credentials in VWO

Once you’ve created a user in your AWS account, the next step is to add the generated security credentials in the Amazon S3 > Config tab of your VWO account. Here’s how you can do it:

Procedure

1. Log in to your VWO account.
2. From the left panel of your VWO dashboard, go to the INTEGRATIONS > Amazon S3 > Config tab. 
3. In the Bucket name field, enter the one specified in Step-4 of the Creating a Bucket in AWS Dashboard procedure.
4. In the Access key field, enter the access key value present in the credentials file. 
5. In the Secret key field, enter the secret key value present in the credentials file. 
6. Click TEST CONNECTION to validate if VWO can write data to the specified bucket.
7. On successful validation, the connection results are displayed to the right.
8. To finalize your configuration, click SAVE.

Sending VWO Campaign’s Data to Amazon S3

Once the integration is enabled, you can choose to send the VWO campaign’s data to Amazon S3 at per campaign level. By default, Amazon S3 integration is enabled for the new VWO testing campaigns. 

If you wish to enable Amazon S3 integration for your existing campaigns, you can edit your campaign settings, as shown below.

Specifications of VWO Campaign Data Sent to Amazon S3

Upon successful setup, a CSV file is created in Amazon S3 for every campaign. The path where you can find the campaign’s data: bucketName/accountId/campaignId/yyyymmdd.csv.gz. The path where you can find the campaign’s metadata: bucketName/accountId/campaignId/meta.csv.gz. You can also find a sample campaign data and metadata file here.

Viewing Your Test ID in VWO

To view your test ID in VWO, follow this:

Procedure

1. Login to your VWO account. 
2. Go to the relevant testing dashboard and select the test you want to view the ID for, say A/B.
3. From the SUMMARY page of your test, go to SETTINGS >SUMMARY. 
4. To view your Test ID, scroll down to the OTHER INFORMATION section and check for the CAMPAIGN ID.