---
schema_version: "1"
id: bb18424b65afe1ff119fcfd8888710fef85968666b648a7334a815ba5bb18ba5
title: Create a Target Data Extension in Marketing Cloud Engagement
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_pers_segment_load_marketing_cloud_extension.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_pers_segment_load_marketing_cloud_extension.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 491249a9f60269a2b014a465104cc0525b92af22f1d6e661e821a83637f3ac7f
description: Set up a target data extension in Marketing Cloud Engagement to map the fields in the segment that you’re exporting. After you create the data extension, save the external key to set up data extracts in Automation Studio.
products:
  - Marketing
  - Salesforce Personalization
release: "264"
---
# Create a Target Data Extension in Marketing Cloud Engagement

Set up a target data extension in Marketing Cloud Engagement to map the fields in the segment that you’re exporting. After you create the data extension, save the external key to set up data extracts in Automation Studio.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d23635e38">Permissions
              Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d23635e38 ">To create a target data extension:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d23635e38 ">A role with Administrator permissions</td>

          </tr>
        </tbody>
      </table>

1. From the main navigation in Engagement, select **Audience Builder** | **Contact Builder**.
2. Click **Data Extensions**.
3. Click **Create**.
4. Complete the information in the Properties section.
    
     
    | Item | Description |
    | --- | --- |
    | **Creation Method** | Select **Create from New**. |
    | **Name** | Enter a name that matches the segment so that you can identify the data extension in Contact Builder. |
    | **Description** | Enter a description to identify the data extension. |
    | **Is Sendable** | Makes the data extension available as the source of a send. |
    | **Is Testable** | Makes the data extension available for testing. |
5. Click **Next**.
6. To set a data retention policy for your data extension, turn on Data Retention.
7. To apply the data retention policy, select **Apply To**.
8. Configure an option for the Retention Period. For a revolving time period, enter a value in the text field and select a time frame from the dropdown. For a fixed date, select the date.
9. Click **Next**.
10. Configure the mandatory attributes.
    
    Attribute names in the segment that you’re exporting must match field names in the data extension. When you begin entering column values in a row, an empty row is added to receive the next group of attributes.
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_personalization-264-0-0-production-enus/16bf1f60-f44c-4260-a56e-f052cfe515a3/images/icon_note.png)
    
    Note If the Personalization system populates the sfmcContactKey attribute, map SubscriberKey to sfmcContactKey.
    
    <table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
            <colgroup>
              <col style="width:12.975778546712801%">
              <col style="width:28.546712802768166%">
              <col style="width:14.878892733564014%">
              <col style="width:20.415224913494807%">
              <col style="width:10.899653979238755%">
              <col style="width:12.283737024221452%">
            </colgroup>
            <thead class="slds-text-title_caps ">
              <tr class="">
                <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d23635e246">
                  <p style="margin-bottom:0;">Primary Key</p>
                </th>
                <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d23635e249">
                  <p style="margin-bottom:0;">Name</p>
                </th>
                <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d23635e252">
                  <p style="margin-bottom:0;">Data Type</p>
                </th>
                <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d23635e255">
                  <p style="margin-bottom:0;">Required (is this “Nullable”?)</p>
                </th>
                <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d23635e258">
                  <p style="margin-bottom:0;">Length</p>
                </th>
                <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d23635e261">
                  <p style="margin-bottom:0;">Default Value</p>
                </th>
              </tr>
            </thead>
            <tbody>
              <tr class="">
                <td data-label="Primary Key" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23635e246 ">
                  <p style="margin-bottom:0;">Selected</p>
                </td>
                <td data-label="Name" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23635e249 ">
                  <p style="margin-bottom:0;">userId</p>
                </td>
                <td data-label="Data Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23635e252 ">
                  <p style="margin-bottom:0;">Text</p>
                </td>
                <td data-label="Required (is this “Nullable”?)" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23635e255 ">
                  <p style="margin-bottom:0;">Not selected</p>
                </td>
                <td data-label="Length" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23635e258 ">
                  <p style="margin-bottom:0;">50</p>
                </td>
                <td data-label="Default Value" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23635e261 ">
                  <p style="margin-bottom:0;">N/A</p>
                </td>
              </tr>
              <tr class="">
                <td data-label="Primary Key" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23635e246 ">
                  <p style="margin-bottom:0;">Not selected</p>
                </td>
                <td data-label="Name" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23635e249 ">
                  <p style="margin-bottom:0;">segmentMembership</p>
                </td>
                <td data-label="Data Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23635e252 ">
                  <p style="margin-bottom:0;">Boolean</p>
                </td>
                <td data-label="Required (is this “Nullable”?)" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23635e255 ">
                  <p style="margin-bottom:0;">Selected</p>
                </td>
                <td data-label="Length" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23635e258 ">
                  <p style="margin-bottom:0;">Blank</p>
                </td>
                <td data-label="Default Value" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23635e261 ">
                  <p style="margin-bottom:0;">N/A</p>
                </td>
              </tr>
              <tr class="">
                <td data-label="Primary Key" class="slds-cell-wrap" style="vertical-align:top;" headers="d23635e246 ">
                  <p style="margin-bottom:0;">Not selected</p>
                </td>
                <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d23635e249 ">
                  <p style="margin-bottom:0;">emailAddress</p>
                </td>
                <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d23635e252 ">
                  <p style="margin-bottom:0;">Email Address</p>
                </td>
                <td data-label="Required (is this “Nullable”?)" class="slds-cell-wrap" style="vertical-align:top;" headers="d23635e255 ">
                  <p style="margin-bottom:0;">Selected</p>
                </td>
                <td data-label="Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d23635e258 ">
                  <p style="margin-bottom:0;">254</p>
                </td>
                <td data-label="Default Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d23635e261 ">
                  <p style="margin-bottom:0;">N/A</p>
                </td>
              </tr>
              <tr class="">
                <td data-label="Primary Key" class="slds-cell-wrap" style="vertical-align:top;" headers="d23635e246 ">
                  <p style="margin-bottom:0;">Not selected</p>
                </td>
                <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d23635e249 ">
                  <p style="margin-bottom:0;">sfmcContactKey</p>
                </td>
                <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d23635e252 ">
                  <p style="margin-bottom:0;">Text</p>
                </td>
                <td data-label="Required (is this “Nullable”?)" class="slds-cell-wrap" style="vertical-align:top;" headers="d23635e255 ">
                  <p style="margin-bottom:0;">Selected</p>
                </td>
                <td data-label="Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d23635e258 ">
                  <p style="margin-bottom:0;">50</p>
                </td>
                <td data-label="Default Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d23635e261 ">
                  <p style="margin-bottom:0;">N/A</p>
                </td>
              </tr>
            </tbody>
          </table>
11. Map any other attributes, like country or language using these values:
    
    <table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
            <colgroup>
              <col style="width:12.975778546712801%">
              <col style="width:28.546712802768166%">
              <col style="width:14.878892733564014%">
              <col style="width:20.415224913494807%">
              <col style="width:10.899653979238755%">
              <col style="width:12.283737024221452%">
            </colgroup>
            <thead class="slds-text-title_caps ">
              <tr class="">
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d23635e371">
                  <p style="margin-bottom:0;">Primary Key</p>
                </th>
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d23635e377">
                  <p style="margin-bottom:0;">Name</p>
                </th>
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d23635e383">
                  <p style="margin-bottom:0;">Data Type</p>
                </th>
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d23635e389">
                  <p style="margin-bottom:0;">Required (is this “Nullable”?)</p>
                </th>
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d23635e395">
                  <p style="margin-bottom:0;">Length</p>
                </th>
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d23635e402">
                  <p style="margin-bottom:0;">Default Value</p>
                </th>
              </tr>
            </thead>
            <tbody>
              <tr class="">
                <td data-label="Primary Key" class="slds-cell-wrap" style="vertical-align:top;" headers="d23635e371 ">
                  <p style="margin-bottom:0;">Not selected</p>
                </td>

                <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d23635e377 ">
                  <p style="margin-bottom:0;">&lt;Field name that maps to the attribute&gt;</p>
                </td>

                <td data-label="Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d23635e383 ">
                  <p style="margin-bottom:0;">Text</p>
                </td>

                <td data-label="Required (is this “Nullable”?)" class="slds-cell-wrap" style="vertical-align:top;" headers="d23635e389 ">
                  <p style="margin-bottom:0;">Not selected</p>
                </td>

                <td data-label="Length" class="slds-cell-wrap" style="vertical-align:top;" headers="d23635e395 ">
                  <p style="margin-bottom:0;">50</p>
                </td>

                <td data-label="Default Value" class="slds-cell-wrap" style="vertical-align:top;" headers="d23635e402 ">
                  <p style="margin-bottom:0;">N/A</p>
                </td>

              </tr>
            </tbody>
          </table>
12. Click **Create**.
13. Click **OK**.
14. Open the data extension and save the external key. You need the external key when you set up data extracts in Automation Studio.