Knowledge Base

What: The Profile Export connection allows you to synchronize data to various marketing platforms and databases from BlueConic via delimited flat files. User profile property information can be exported for one or multiple segments.

Why: Transfer customer data to internal data warehouses, CRM databases, analytics platforms, and other marketing systems to enrich data and enhance capabilities with behavioral data collected by BlueConic and profile data integrated from other systems. 

Configuring the connection

Schedule Settings

To learn more about schedule settings, read Scheduling Connections.

Connection settings

Depending on your choice for the export system, the configuration settings consist of the following options:

Segments

Limit your data to only the relevant data for the system you are exporting to by selecting appropriate segment(s).

Export System

There are three ways to transfer the export data:

• SFTP: Transfer the data to a remote SFTP server.
• Email: Send the data to email recipients.
• S3: Transfer the data to an Amazon S3 bucket.

SFTP server

Enter the name of the SFTP server you want the profile exports uploaded to.

Port

Enter the port number of the SFTP server. Typically this is 22.

SFTP Server Path

Enter the directory path on the SFTP server to determine where the export file will be saved. 

Username

The username for BlueConic to connect to the SFTP server with.

Authentication method

Select the authentication method you want to use to connect to the SFTP server: password authentication or public key authentication.

Password

The password associated with the username for password authentication.

Private key

Upload the private key associated with the username for public key authentication.

Email recipient(s)

Enter one or more email addresses to receive the profile exports.

Bucket

Enter the Amazon S3 Bucket name. Read more on using Amazon S3 Buckets.

Access Key ID

Enter the Amazon S3 Access Key ID. You can retrieve the access key ID from the Security Credentials page. Read more on AWS Security Credentials.

Secret Access Key

Enter the Amazon S3 Secret Access Key. You can create new access keys for the account by going to the Security Credentials page. In the Access Keys section, click Create New Access Key. Read more on AWS Security Credentials.

Replace IDs

Select this if you want the export to contain names of interactions, channels and domains instead of their BlueConic IDs.

Date format

Select the date format that you prefer. There are five formats available:

• Timestamp, the number of milliseconds since Jan 1st, 1970. (example: "1324483200000")
• ISO 8601 (example: "2021-12-21 17:00:00")
• US (example: "12/21/2022 5:00:00 PM")
• NL (example: "21-12-2021 17:00:00")
• UK (example: "21/12/2021 17:00:00")

Note that all dates will be exported in UTC timezone, regardless of the configured date format. 

Email notifications

Enter one or more email addresses that should receive email notifications when the connection runs or fails to run.

Transfer mappings

Map the fields that are to be exported from BlueConic. The name entered for the CSV field name will appear in the header in the CSV export.

For each field to be mapped from the CSV file, select [Add Transfer Mapping] and select the profile property to export. Enter desired CSV field names at the right. These will be exported in the first row. In addition to the fields you select, users' BlueConic profile IDs will be exported in the first column.