Data Modelling Flashcards
What is the Organizational Structure of the Enterprise 2.0 License
A tenant is the top-level account and all associated Business Units.
Each of these Business Units can also have child Business Units, and
essentially function as multiple Enterprise-level accounts.
What is the Organizational Structure of the Enterprise License
A tenant is the top-level account and all associated Lock & Publish and On-Your-Behalf Business Units.
These Business Units inherit content from the parent with editable areas that can be sent to their subscribers.
What is the Organizational Structure of the Core License
A tenant is the single account.
There are no child Business Units of any kind.
What is the definition of a Contact in Marketing Cloud
A contact is a person you send messages to through any marketing
channel. A contact appears in All Contacts.
What is the definition of a Contact in Marketing Cloud
A subscriber is a person who opted to receive communications, or
belongs to a particular channel. Subscribers can be imported or created
manually and are stored in data extensions.
What is the definition of a Contact Key in Marketing Cloud
The Contact Key is a unique identifier that is assigned to a contact and used to relate a contact record to the corresponding subscriber information.
What is the definition of a ContactID in Marketing Cloud
ContactID is a system-defined identifier that is provisioned when a contact is created. This is often used as an identifier when working with the API.
What is the definition of a List in Marketing Cloud
The default method of storing subscriber data in
the Email application - i.e. All Subscribers is a List.
Lists are always sendable - they require minimal
configuration and setup.
Lists use the standard profile & subscription
centers - e.g. birthday & preference center info.
When an attribute is created, it’s added to every
list in Email Studio, including All Subscribers.
What is the definition of a Data Extension in Marketing Cloud
A data extension (DE) is a custom table of data.
It can store any kind of data
Commerce - Store Information - Product Catalogs - Subscribers - Activity - Web Analytics - Inventory.
Each DE can comprise of different attributes -
e.g. if I made a table for Subscribers, and a table for
Product Descriptions - the attributes you’d want to
store would be different.
When to use a List rather than Data Extension
Less than 500k Subscribers
Don’t require fast import speeds
Plan to use a limited number of attributes
When to use a Data Extension rather than List
More than 500k Subscribers
Got to go fast
Plan to use Triggered Sends
Use the SOAP or REST APIs
What are the three types of data extensions in Marketing Cloud
Standard data extensions - are used for building a custom set of fields.
Filtered data extensions - are used to create a subset/segment from an existing data extension.
Random data extensions - allow you to randomly select subscribers from a source data extension.
What two things must you have on a sendable data extension
Defined Send Relationship (subscriber key/email address).
Designated attribute with an ‘email address data type’.
