User Guide


Help Programs Creating a Program Creating a Campaign Publishing Programs Saving Programs Building Workflows Users Adding New Users Roles and Permissions Sharing and Collaboration Contacts Importing Contacts Custom Fields Apps Cloud Connect Data Processor Direct Mail Email Facebook HP SmartStream LinkedIn Microsite Raw Data Extract SMS Target Audience Twitter Events Events Goals Scores FAQs Common Questions Developers APIs and MAML APIs More Resources Change Log Knowledge Base

Raw Data Extract

Export Data from the Contact Database

Users can export raw data from the database to use in their custom-built applications or to use in data analytics. The Raw Data Extract serves the data in a comma-delimited (.csv) file.


Instructions:

1. In the configuration tab place your email or FTP info for file to be delivered

2. Under Settings, configure the following:

  • Date Range: From last schedule = last time this element's RDE has run
  • Data Schema: Leave as Flat (with IDs gives the studio contact ID, Relational gives values of relational DB tables)
  • Data Fields: These show as additional columns in the spreadsheet

3. Criteria: If All Elements is checked this will give a new row in the spreadsheet for every single action that has happened (eg. John Sample received email, John Sample opened email, John Sample clicked a link, etc.)

4. Set a Schedule. The Studio will send the results via email or FTP (based on the amount of data exported and current server volume, this could happen very quickly or it could take a bit longer)