Setting up the export of data to Oracle CrowdTwist

Exporting Oracle Unity segments to Oracle CrowdTwist allows you to deliver a personalized member experience to your customers. These segments can be used in CrowdTwist to deliver the following:

Learn more about Segmentation from the Oracle CrowdTwist Help Center.

Before you begin

Before you start exporting data to CrowdTwist, you will need to contact your CrowdTwist account manager so that the Secure FTP (SFTP) location can be set up to receive Oracle Unity segments.

When the SFTP location is ready, your account manager will send the details needed to configure the data export.

Review the following requirements for files exported to CrowdTwist.

  • Naming convention of files : SegmentName_YYYYMMDD_HHMM. The timestamp is in 24-hour format.
  • Supported file type : CSV.
  • The file has two headers, ID and CTUserID. The headers are case sensitive.

CrowdTwist will do the following validations on the exported files.

  • The CSV file has the correct naming convention and each row has one user entry.
  • Duplicate entries will be removed.
  • New lists of users will be created when a new file is exported with a new timestamp.
  • The maximum file size is 128 MB.
  • If a CTUserID doesn't exist on the CrowdTwist platform, the user will be stored without any validation.

Setting up the export of data to CrowdTwist requires the following tasks:  

  1. Create a CrowdTwist destination
  2. Create a CrowdTwist campaign (You have the option of creating a campaign or export job to send the data out of Oracle Unity. These steps focus on creating a campaign.)

Create a CrowdTwist destination

The first step in setting up the data export is to create a destination.

To create a CrowdTwist destination: 

  1. Click the Oracle icon Image of the application navigation button. Use it to access the different parts of Oracle Unity. in the bottom-right corner to open the navigation menu.
  2. Select Destinations.
  3. In the top-right corner, click Create destination.

Step 1: Define destination details

The job details section allows you to define the type of destination and how it will display in Oracle Unity.

Enter the information for the destination.

  • Type: Use the drop-down list to select CrowdTwist.
  • An image of the CrowdTwist destination type

  • Name: Enter a name. The name must be 1 or more characters, up to a maximum of 50. Use only letters (a–z and A–Z), numbers (0–9), underscores (_), hyphens (-), and spaces. The first character cannot be a space.
  • Destination ID: The unique system identifier that is auto-populated from the destination name you enter. You can't change this value after you create the destination.

  • Description: Enter a description. This field is optional, but it is highly recommended to add descriptions for any entity created. This helps all other users get additional context when using and navigating Oracle Unity. The description can have a maximum of 512 characters with no restrictions on characters used.

An image of the job details section

Step 2: Configure server settings

Important: When defining the authentication settings, make sure that one of the approved algorithms below is used to access the destination. If one of these algorithms is not used, Oracle Unity will not be able to successfully connect to the destination.

Algorithm type Algorithm
Cipher aes256-ctr
Cipher aes192-ctr
Cipher aes128-ctr

Configure the server settings for the campaign.

  • SFTP server name: Enter the hostname for your organization's SFTP server. This field requires a user name and host name, formatted as username@sftpserverhostname.com.
  • Authentication key: Select the file that has the authentication key needed to access the SFTP server. Oracle Unity will process the file and display the authentication key.
  • Folder name: Enter the path name to the folder on the SFTP server where Oracle Unity should export files to.

Once you enter all the details, click Verify connection to ensure that Oracle Unity can access the server.

An image of the server details section

If there are connection issues, it could be for one of the following reasons:

  • An incorrect SFTP server name.
  • An incorrect authentication key.
  • An incorrect Folder name.

If you still encounter connection issues, contact your IT administrator for further investigation.

Step 3: Configure file settings

The files details section defines the format of the destination files.

An image of the files details section

  • File name: Enter the file name and extension to use for the exported files. A timestamp and file number will be added as a suffix identifying when the file was created. The timestamp will be in the format yyyy-MM-dd-HH-mm-ss-SSS. You can use characters from all languages supported in the language settings.
  • Example: If you enter the file name as Export_file_01, a timestamp will be added as a suffix and the file will be named Export_file_01_2021-05-12-12-56-12-926_0.csv. The timestamp is 2021-05-12-12-56-12-926. The "0" indicates it is the first exported file with the same timestamp.

  • Format: The format of the exported file must be in CSV format. Fields in the exported file will be separated by commas.
  • Date format: The date format must be yyyyMMdd_HHmm.
  • Compression format: Files for the CrowdTwist destination type can't be compressed. They will be exported in CSV format.

Step 5: Save and publish the new destination

When finished defining the destination, scroll to the top of the page and click Save or Save and close.

Once you create the destination, you will need to publish the changes.

Create a CrowdTwist campaign

After creating and publishing the destination, you can create the campaign.

To create the campaign:

  1. Click the Oracle icon Image of the application navigation button. Use it to access the different parts of Oracle Unity. in the bottom-right corner to open the navigation menu.
  2. Select Campaigns.
  3. In the top-right corner, click Create campaign.

The Create campaign page is displayed.

Step 1: Define campaign details

The campaign details section allows you to define how the campaign will display in Oracle Unity.

To define the campaign details:

  1. Enter the details for the campaign.
  2. An image of the Campaign details section

    • Name: Enter a name. The name must be 1 or more characters, up to a maximum of 30. Use only letters (a–z and A–Z), numbers (0–9), underscores (_), hyphens (-), and spaces. The first character cannot be a space.
    • Campaign ID: The unique system identifier that is auto-populated from the job name you enter. You can't change this value after you create the campaign.

    • Description: Enter a description. This field is optional, but it is highly recommended to add descriptions for any entity created. This helps all other users get additional context when using and navigating Oracle Unity. The description can have a maximum of 512 characters with no restrictions on characters used.
  3. Click Continue.

Step 2: Select destination

You will select the CrowdTwist destination you created earlier.

To select the destination:

  1. Select the CrowdTwist destination.
  2. Enter a file name for the exported file.
  3. Click Verify connection to ensure that Oracle Unity can access the destination.
  4. After verifying the connection, click Continue.

Step 3: Select segment

You will select the segment you want to export to CrowdTwist.

Warning: Make sure that the segment you select has the following configurations for personalization attributes.
  • The only two personalization attributes for the segment are ID and CTUserID.
  • If an alias is used for the CTUserID attribute, it needs to be exactly CTUserID and is case-sensitive.

If these configurations are not followed, then CrowdTwist will not be able to process the segment successfully.

To select a segment: 

  1. Search by the segment name and click An image of the Find button. Use it to search for segments.. Then, select the segment. The personalization attributes for the segment will display.
  2. Review the details for the segment and click Continue.

Step 4: Schedule and notify

You will need to configure the schedule and notification settings for the campaign.

An image of the Schedule and notify section

To schedule the campaign and define the notification settings:

  1. Configure the schedule for the campaign:
    • Click Recurring to automatically run the campaign job on a regular schedule.
    • Click On demand to run the campaign job as needed.
  2. If the campaign job is recurring, select the Frequency, Start time, and Days it will run.
  3. In the field for Notify, enter the email addresses of people to be notified when the campaign job runs. Separate multiple emails with a comma.
  4. If you only want a notification if the campaign job fails, click the checkbox Only notify on failure.

Step 5: Save and publish the campaign

After saving the campaign you will need to publish the changes before it can run.

To save and publish the campaign:

  1. Scroll to the top of the page and click Save or Save and close.
  2. Follow the steps for Publishing changes.

Using Oracle Unity segments in CrowdTwist

Use the CrowdTwist Control Center to manage your programs, activities, and rewards for Oracle Unity segments.

Visit the Segmentation area of CrowdTwist to view all segments. To view the details on a specific segment, click View.

An image of the Segmentation area of CrowdTwist

An image of the details for a CrowdTwist segment

Learn more

Creating segments

Creating destinations

Creating campaigns

integrate, integration, crowdtwist, oracle crowdtwist, how to integrate, link, link oracle apps, link oracle crowdtwist, export to crowdtwist, export data