Loading
Marketing Cloud Personalization
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Create a Source Data Extension in Marketing Cloud

            You are here:

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

            Create a Source Data Extension in Marketing Cloud

            In CSV export files from Marketing Cloud Engagement data extensions into Marketing Cloud Personalization using ETL data feeds.

            Required Editions

            Permissions Needed
            To create a target data extension: A role with Administrator permissions
            1. From the main navigation in Marketing Cloud Engagement, select Audience Builder | Contact Builder.
            2. Click Data Extensions.
            3. Click Create.
            4. Complete the values in the Properties section.

              Value

              Setting
              Creation Method Create from New
              Name Enter a descriptive name for the segment. To more easily identify the data extension in Contact Builder, we recommend using a name that matches the segment.
              Description Enter a description so you can more easily identify the data extension in Contact Builder.
              Is Sendable Select to make the data extension available as the send source.
              Is Testable Select to make the data extension available for testing.
            5. Click Next.
            6. For Data Retention, click On to set a data retention policy for the data extension.
            7. To apply the data retention policy to any entities, select the Apply To option for them.
            8. Define how long you want to retain data in the Retention Period section. For example, enter “6” in the number field and select “Months” as the time frame to enforce a six-month data retention policy.
            9. Click Next.
            10. Configure the columns you want to load.
              Note
              Note Column names must match field names specified in the ETL file requirements. Attributes must exist in the Personalization system and must be prepended with attribute:. To learn more, see Available ETL Data Feeds.
              The following example shows configuring an ETL data feed for user or subscriber data (see User ETL Data Feed). The first column is required, maps to an identity attribute, and is configured as the primary key. The remaining columns are mapped to other user attributes.
              Note
              Note When defining data extension fields, don’t specify a value of Date for any attribute data types.
              Column Name Settings
              attribute:sfmcContactKey
              • Name: attribute:sfmcContactKey
              • Data Type: Text
              • Length: 50
              • Primary Key: Selected
              • Nullable: Not selected
              attribute:name
              • Name: attribute:name
              • Data Type: Text
              • Length: 50
              • Primary Key: Not Selected
              • Nullable: Selected
              attribute:isLoggedIn
              • Name: attribute:isLoggedIn
              • Data Type: Text
              • Length: 50
              • Primary Key: Not Selected
              • Nullable: Selected
              attribute:firstVisitDate
              • Name: attribute:firstVisitDate
              • Data Type: Text
              • Length: 50
              • Primary Key: Not Selected
              • Nullable: Selected
            11. Click Create and then OK.
            12. Open the data extension and save the External Key. You need the external key when you set up data extracts in Automation Studio.
             
            Loading
            Salesforce Help | Article