Loading
Prepare for Email to Become the Default Login ExperienceRead More
Integrate and Analyze Marketing Data with Marketing Cloud Intelligence
Create a Database Export

You are here:

  1. Salesforce Help
  2. Docs
  3. Marketing Cloud Intelligence

Create a Database Export

Create a database export to export marketing data from Marketing Cloud Intelligence, and import it to an external database. Select the criteria that you want to export, define scheduling to determine when the export occurs, and map the source data fields to the database fields.

Required Editions

User Permissions Needed
To create a database export: Admin

Before creating a database export, configure the database you’re connecting to. This is done in the Integrations tab. For more information see Adding or Editing Database Integrations.

  1. From the Analyze & Act tab, select Database Exports.
  2. Click Create New.
  3. Define the data that you want to export.
  4. Map the source data fields to the destination database fields.
  5. Configure the database export feed.
  6. Save your work, and run the export.

Here’s a video about database exports:

  • Define the Data to Export
    Define the source dataset by selecting the dataset, required dimensions, and measurements and date range.
  • Configure the Destination Database and Connect Data
    Set the external database where you’re exporting the data to. Databases are configured in Workspace Integrations. Configure the database first, and then you can select it.
  • Configure the Database Export Feed
    After you connect to the database and map your fields, configure how the exported data is inserted into your database table and how often to execute the export. This step defines what happens when new data is loaded into the database and how to handle it.
  • Troubleshoot Database Exports
    After a database export is created, view and manage exports execution in the History tab. If an export fails, troubleshoot to find out what happened. You can download a report, and even rerun or reprocess it.
  • Adding or Editing Database Integrations
    Before creating a database export, configure an external database to import data from Marketing Cloud Intelligence. The database user requires INSERT and DELETE permissions for at least one table. Capitalize the table name for Snowflake databases to avoid connection failures.
 
Loading
Salesforce Help | Article