Configuring a Contact Event Data export job
A Contact Event Data Export job lets you select the data you want to see, the format and location of the export file, and how often the file is created. Data is only available for 30 days, so best practice is to run export jobs on a daily basis.
NOTE: Although the data is available for export from the database for 30 days, the zip files, once you create them, are only available on the server for 14 days.
You create and maintain a Contact Event Data Export job the same way as other Connect Export jobs. Although you can create multiple Contact Event Data Export jobs for each account, you can only have one active Export Contact Event Data job per Event type. For example, you can set up one export job to output Bounced Event information and another to output Complaint Event information, but you cannot configure two active export jobs to output Bounced Event information.
To configure a Contact Event Data Export job
NOTE: This section describes how to configure the job using the existing Connect interface. If you are using the new Connect interface, please see the Exporting Feed Data Connect Jobs Help topic.
-
From Connect, click Create Job.
-
Choose Export Event Data Feed.
-
On the Source page of the Wizard, click check boxes for the Event Types you want to download.
We recommend that you start with these event types; you can include others as well.
-
Launch State
-
Opted In
-
Opted Out
-
Complained
-
Bounced
-
Click Next.
-
On the Target File page, in the File Location area, enter the access specifications for an Oracle Responsys file server or choose an external server.
The File Location for an Oracle Responsys File Server would look like this:
Server: files.responsys.net or files.dc2.responsys.net (Check with Support for your file server location.)
Username: RIAccountName_scp
(RIAccountName is the short name of your Oracle Responsys Account. It appears to the right of the @ in your admin login: admin@RIAccountName)
Path: choose a location.
-
In the File Specifications area, choose settings for the export file.
-
Select a character set.
If you have international characters in your DB, select Unicode (UTF-8). -
Choose Tab as the delimiter between the fields (columns) in the download file.
You can also choose comma, semicolon, or pipe as the delimiter, but tabs work best, especially if you’re including custom columns. -
Choose whether to enclose text columns in single quotes, double quote, or none.
NOTE: For accounts configured to do so, the system will replace delimiters with spaces in all text fields of exported event feed data when NONE is chosen as the enclosing character. For example, if you set up an export event feed data job using a Responsys account configured for this behavior, and then choose NONE as the field enclosure and the tab character as the field delimiter, Responsys will replace all tab characters within text fields with spaces.
-
Turn on the Insert column header as first line setting to export column headers as the first line in the exported file.
-
Choose whether to encrypt or compress your export job as a .zip file (or both).
Although you can choose not to compress or encrypt the file, the resulting raw text file takes significantly longer to download (and consumes more storage space on your file system and ours). -
Choose whether to create a Ready File for validation after the file is exported. Enter a file extension if needed.
The options are none, an empty file, and a record count. Use an empty file to validate the completion of your download process. Use a record count file (recommended) to compare simple record counts to verify that all expected record counts were transferred. This is similar to the way the count file is used to validate a job import file. The Ready file and your export job have the same name.
-
Click Next.
-
On the Options page, select whether to receive email notification after each job is run, only after a failed job, or not at all. Enter one or more email addresses if needed. Click Next.
-
On the Schedule page, choose how often you want to export the file (once a day is typically sufficient). Click Next.
-
On the Activate & Save page, choose whether to activate or deactivate the export. Add a name and description, and click Save.
The new job is listed on the All Jobs tab.