Once you’re inside Email Studio, you can navigate to ‘ Subscribers’ → Data Extensions in the drop down. This brings me to the overview screen. If you’re new to Marketing Cloud , these data extensions may be there by default because they are system generated.
Follow these steps to create a data extension in Marketing Cloud Email Studio. Click Subscribers. Click Data Extensions . Click Create and choose an option: Enter information in the Properties section: Complete the information in the Type section: Complete the information in the Fields section for each field. Click Save.
A data extension is simply a table with fields of data about your contacts. Data extensions can be standalone or related to other data extensions . You can use the data to run queries, pull information, and send to a subset of subscribers.
By definition , a sendable data extension is a data extension that has a column mapped to the All Subscriber List. e.g if you have a ContactId that represents that SubscriberKey in that data extension , you would have to map it to SubscriberKey so that system can resolve it at send time.
There are three ways to import data into a data extension . For Upload File: File Name: Type MasterSubscriber. csv. Delimiter: Comma. Date Format: English.
Data Extensions are typically defined as Sendable and/or Testable . Sendable can be used for sending emails. Testable can be used for testing emails. A Data Extension can be both, either, or neither.
What is the difference between organizing your data in a list and organizing it in a data extension ? A) In a list , you organize subscribers by name. In a data extension , you organize them by region. You can use a list , but not a data extension , to store sendable subscriber data .
Primary Key – a key in a relational database that is unique for each record. It is a unique identifier, and cannot contain null values. You can have more than 1 primary key , and it uniquely identifies a row in a data extension. It also ensures records are not overwritten when you create an import activity.
AMPscript is a scripting language that you can embed within HTML emails, text emails, landing pages, SMS messages, and push notifications from MobilePush. The Marketing Cloud application handles all AMPscript calls at the end of the email send. Review developer information for AMPscript .