What: The Amazon Web Services (S3) connection allows you to synchronize data from various marketing platforms and databases into BlueConic via delimited flat files on servers. User profiles can be created or enhanced with this data and BlueConic information can be shared with marketing platforms. This connection supports scheduled batch import and export.
About BlueConic: BlueConic is a Customer Data Platform that harnesses the data required to power the recognition of an individual at each interaction, and then synchronizes their intent across the marketing ecosystem. Click here to learn more.
Why: Transfer customer data from and to internal data warehouses, CRM databases, analytics platforms and other marketing systems to enrich BlueConic profiles with purchase history, predictive analytics segmentation (e.g. propensity modeling and lifecycle signals). This data can then be utilized directly within BlueConic or synchronized out to other marketing platforms to interact with users with relevancy and enable right-time messaging, or to enrich data and enhance capabilities with behavioral data collected by BlueConic and profile data integrated from other systems.
CSV file format
Before we delve into the CSV file and field handling settings, let's first have a look at the actual text format of the file that we're about to import. Let's assume we're about to import the following data:
This would be exported as the following CSV text file:
id,ib_avg,ib_ddg,ib_z1,ib_z2 aghvww32,4123551,GK,open,3 agkkemw3,4233215,GK,open,0 alfk3oor,4135111,GR,open, bezz5las,4009852,GR,closed,0 c9uuz5g0,4823507,K,closed,1 cc2rkes6,4222941,G,open,1
The first line of the CSV file is expected to contain column names, separated by a comma. Each following line is expected to contain values with the same amount of columns.
Configuring the connection
In the side bar on the left are a number of tabs. There is a setup section and there are import and export goals. Goals can be activated or deactivated with the checkbox in front of the name. Multiple goals can be added by using the [Add goal] button at the bottom of the page and you can delete or copy goals by hovering over them and selecting the "x" respectively copy icon.
Click on a goal to open its tab and see the configuration options for that goal. The name of the goal can be changed by editing it at the top of the goal configurations.
Authentication and run
This is where you set up the authentication that will allow BlueConic to connect to the Amazon Web Services (S3) platform. Look up and enter the configuration parameters:
- Access key ID
- Enter the Amazon Web Services (S3) access key ID that you can retrieve via the security credentials page.
- Secret access key
- Enter the Amazon Web Services (S3) secret access key. You can create a new access key for your account by going to the security credentials page. In the "Access Key" section, click "Create New Access Key". After saving the connection, the secret key will be hidden. You can click "Change secret access key" to change the existing key.
- AWS (S3) region
- Pick the AWS region of your Amazon S3 Bucket. Picking an incorrect region may lead to connection problems.
For more information on working with credentials, read AWS Security Credentials.
Import goals allow you to import data from Amazon Web Services (S3) into BlueConic. To do this, complete the steps that are outlined in the goal.
1. Define files to import data from
Start by selecting the S3 bucket where the files are stored that will be imported.
In order for BlueConic to be able to scan the buckets, the S3 account needs to have the "listAllBuckets" permission enabled.
Your S3 bucket can contain many files. You can specify exactly which file (or files) will be imported from by either entering a name or using wildcards to match multiple names, e.g. 10-import.csv, *.csv or *import*.
Click [Scan now] to scan the selected S3 bucket for the specified files - matches will be shown in the table below.
A preview of how a file will be scanned is available by hovering over a file and clicking "Preview fields". Here you can verify that the file and field handling has been set up correctly; are the columns matching what you thought they would be?
2. Define file and field handling
This is where you define how the contents of the imported files must be interpreted. Typically you only have to define the field separator - the character that separates the column values on every line. By default this will be the ,, but you can also use other characters like e.g. ; or |, depending on the contents of your file.
You also have the option to set more advanced options.
- Multi value separator
- If columns contain multiple values, what character separates them within the column? This character has to be different from the field separator.
- Date format
- Help BlueConic to correctly interpret date values by configuring the date format used in the file.
- Time zone
- Enter the time zone used to export date values in the file.
After saving the connection, try clicking "Preview fields" to see if the columns are being picked up the way you expect them to.
3. Link identifiers between files and BlueConic
BlueConic can only map imported data to profiles if at least one of the imported columns should be imported to a profile property that is a unique identifier. So, you need to determine how BlueConic can recognize matches:
Select a column name on the left and select the BlueConic unique identifier profile property it should match on the right hand side.
Information will only be imported if an exact match for the linked identifiers is found in an existing profile, unless the checkbox is activated to allow the creation of new profiles. In the latter case a new profile will be created in BlueConic.
4. Map Amazon Web Services (S3) data to BlueConic
Finally, configure which CSV values should be mapped to which BlueConic profile properties:
Select from the menu how the value should be imported:
- Set: Always overwrite the profile property value in BlueConic.
- Set if empty: Import the value in BlueConic only if the profile property does not contain a value yet.
- Add: Add the imported value to the list of values for the profile property. The list will only contain unique values, doubles are not imported.
- Sum: Numerically add the imported value to the value of the profile property in BlueConic. If the profile property was empty, it will be treated as 0. If the imported value is not a number, it is not imported.
You do not have to create a mapping and import every field of the CSV into BlueConic; there is no need to clutter BlueConic's data storage with values that serve no purpose in BlueConic or other connected systems. It is a best practice to only import values that are of interest to BlueConic use cases.
5. Run the connection
All that is left is to save the configuration and then run the connection.
If this is the first time you are running the connection, it is a good idea to do a test run with a small example file, to see if everything works as intended. If you are satisfied with the result, you change the import to the actual, full size file.
Frequently asked questions:
If a file has already been imported, will it be imported again?
If the connection configuration has not been changed, and a file has already been imported, it will not be imported again. If the file has changed, or the configuration has changed, files will be reimported.
The Amazon Web Services (S3) Connection is a standard plugin.