CSV Loader

Use your CSV files to import data directly to Woopra

Requirements

Identify Imports

  • Unique Identifier such as an Email.

Track Imports

  • Event data with timestamps. Each row should have a timestamp associated with the data. The data can contain events or contacts, as long as it has a date such as a created_at timestamp.
  • Unique Identifier such as an Email.

Steps to Import

The import is a two-step process. You'll need to upload the CSV and then create the task.

Upload CSV File

  1. Navigate to the Configure tab at the top then click on CSV Loader on the left side.
  1. Click to upload or drag and drop your CSV file.
  2. Select the configuration options. You can select between a comma, tab, or a custom delimiter. You will also want to indicate whether the first line contains title information.
  1. Save the connection.

Create Task

  1. Once the upload is complete, navigate to the Tasks section on the left side under the Data Loader.
  2. Select CSV as the source, and then select the CSV you have uploaded.
  1. Select whether the data imported is an identify or track event. Check out the source configurations for more details.
  2. Select the mapping which will typically be 'email' to the 'email' in Woopra. This tells Woopra how to link the data to the correct profiles.
  3. Add in the visitor properties or event properties that are associated with the event. If you are importing a track event, you will also need to name the event. For example, if you are importing a payment event, you'll want to label this event something such as 'make payment' and add the payment properties with the event such as the amount, payment method, etc.
  4. Select the timestamp column in your CSV.
  5. Save, preview, and activate. If the data looks good in the preview, you're ready to activate the task and the import will start.