External service: FTP or email delimited file (.csv) export

Before we get started, please make sure you've read our arcticle and created your data fields to be used in this integration. 

 

You can schedule a delimited file of respondent data to be delivered via email or FTP from the ion platform. The file can be delivered at the top of the hour with a frequency of your choosing. This document provides step-by-step instructions for setting up and scheduling a delimited file delivery.

Before we begin

There are few items you'll need to roundup prior to setting up the integration, listed below

  • Destination for delimited file
  • Email address(es)
  • AND/OR FTP details
    • FTP host
    • FTP username
    • FTP password
    • FTP path


There are a few steps to take in the ion platform before setting up the integration, listed below:  

  • Create data collection fields
  • Create ion form(s)
  • Set-up testing creative

Let's get started!

1. Create field mapping

Taking the steps below will map your ion data collection fields to their corresponding external field names. To get started, add your new field mapping:

  1. Click the Integrations tab in your ion console’s side nav
  2. Click green “New field mapping” button
  3. Label the field mapping and optionally add a description
  4. From the Integration type menu, select “Delimited file”
  5. Save

2. Add Outbound fields to field mapping

Outbound fields define the data you extend from ion to your external web form.

  1. Click the green “New outbound field” button to add a field to your field mapping.
    • To add a form field, use the Data Collection drop-down menus to select the data field category then data collection field
    • OR, to add an ion Core field, select from the Core Field drop-down menu
    • OR, to export multiple ion fields to one external field, use the Mashup Field by plugging {{DataName}} {{DataName2}} , etc. into the editor
    • OR, to reformat a value prior to export, use the JavaScript field to add logic around the value collected in ion. To access data collection fields via Javascript, use respondent.dataname.
  2. Check "Required" if a value must be present for the export to run
  3. Optionally add a default value
  4. Enter the key name
  5. Repeat these steps for each field that should be included in the Field Mapping

3. Create integration

  1. Navigate back to the Integrations screen
  2. Click Integrations tab
  3. Click green “New integration” button
  4. Enter label
  5. Optionally add a description
  6. Select the Field Mapping you’ve just created
  7. Select your preferences from the formatting dropdown items
  8. If the file is being delivered via FTP, input the delivery details in the FTP fields
  9. Save
  10. Click on the calendar icon beside the integration label to schedule delivery times
  11. Click on the envelope icon beside the integration label to add the email distribution list
    • If the file is being delivered via FTP, you can also receive the file via email

4. Add integration to ion campaigns

The ion platform runs scheduled integrations at their scheduled time once they’ve been allocated to a campaign.

  1. Navigate to the Campaign Management screen
  2. Click the Actions dropdown menu and select Scheduled Exports
  3. Check off the delimited file and save
  4. Repeat for each applicable campaign

5. Test integration

To test your integration, use the testing creative you set up prior to beginning the integration steps. Please note, integrations do not run in Preview Mode so you'll want to open a traffic source URL for testing. The integration will run at its scheduled time. You’ll want to check that the data you submitted was received by the email distribution list and/or FTP site.

Nice work!

Once you’ve completed these steps, your integration is ready for use. You can now schedule delivery for all applicable campaigns.