Toggle Side Panel
Close search

Activity › Forums › Salesforce® Discussions › What are the various types of Data Extensions in Salesforce Marketing Cloud ?

Tagged: , , , , , , , , ,

  • madhulika shah

    Member
    July 18, 2018 at 9:37 AM

    Hello Prachi,

    Data Extensions are repository or list of emails to send. Data extension is made up of any combinations of these field types:

    1. Text – letters, numbers, and spaces.
    2. Number – Decimal values are not supported.
    3. Date – A system date. You can use an AMPscript function to format this value when you present it in a message.
    4. Boolean – A 0 or 1 value.
    5. Email Address – An email address.
    6. Phone – A phone number. Accepts any string with 10 or 11 digits in it and strips out non-digit characters.
    7. Decimal – A number with a decimal point.
    8. Local – ISO Country & Language codes
  • [adinserter block='9']

  • Parul

    Member
    September 28, 2018 at 5:20 PM

    Viewing and Working with your Data Extensions:

    To view your data extensions, go to SUBSCRIBERS>>DATA EXTENSIONS.

    From the list view of your data extensions you can utilize the below shortcuts:
    Import – Upload contacts to your list
    Filter – Shortcut to build a filtered data extension off your list
    Split – Create a data extension containing a random set of contacts from your list
    Export – Download your list
    Send – Open a wizard to select an email to send to the list

  • Karma Dorjee

    Member
    June 30, 2019 at 3:11 AM

    Data Extension(DE) are similar to table in DMBS database system, it has unique structure to hold different types of data.

    Following are types of Data Extension:

    1. Standard Data Extension
      1. Sendable Data Extension
      2. Non-Sendable Data Extension
      3. Testable Data Extension
      4. Template based Data Extension (Eg: Send log DE, Triggered Send DE)
    2. Filter Data Extension
    3. Random Data Extension

    If your Marketing Cloud is connected with Salesforce org, you will Synchronised Data Extension (Salesforce_Contact, Saleaforce_lead), you cannot create this kind DE, this will be created by system while introducing the Salesforce Objects in Salesforce Marketing Cloud.

    Also you night have noticed, Salesforce Data Extension, these DEs are derived from Salesforce objects or reports.

     

Log In to reply.