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.
For more information, see Adding or Editing Database Integrations.
After you connect to the database, map the fields from your source data to the database fields to ensure that the data is connected properly.
- From the Export tab, select Database Exports.
- Create a database export, or edit one.
- At the bottom of the page, select Map to Destination.
- In the Destination Database area, select the database that you’re exporting to.
- After you connect to a database, all tables in the database that the user has INSERT and DELETE permissions for are available for selection.
- Select the table that you’re connecting to. After you select a table, all available fields appear in the Mapping area farther down the page. The fields change according to the table that you select.
- In the Mapping area, map fields from the dataset to the required field in the database. For example, map the measurement Website Clicks to Clicks.
- Repeat this step for all dimensions and measurements that you want to map.
- To move onto the next step, click Next.