Subscriber and Data Management Flashcards
How do you make SendLogs?
Created as data extensions via Create from Template
How do you split synchronized data extensions into standard data extensions?
SQL queries in an automation
How do you send to a synchronized data extension?
Must be queried with SQL and split into standard data extensions. Can’t send or start a journey with a synchronized data extension.
Subscriber Key vs Subscriber ID?
Subscriber Key is user-defined, Subscriber ID is system-defined
When do you need a subscriber key?
Sendable data extensions
What are emails sent to if no publication list is chosen at send time?
The All-Subscribers list
Where are publication lists selected?
In Journey Builder- “Manage Recipients” section of Delivery Options
What’s the difference between a target data extension and an original data extension?
Target data extensions are created automatically by MC when an original data extension is filtered
What is a NotSent Tracking Extract?
Shows reasons for send failures. Is performed in Automation Studio.
What shows engagement data in Automation Studio SQL queries?
Data Views
What do Add-Only Imports require?
A primary key
What must sendable data extensions be mapped to?
All Subscribers list
How do you receive real-time data like website submissions?
API integrations
What has to be created before an SQL Query is created?
A target data extension
What are the SQL Query update options?
Append, Update, Overwrite
What are the import update options?
Add and Update, Add Only
What is a contact?
An individual who receives communication via any channel
What is a subscriber?
An individual who opted in to receive communication via a particular channel
Send Relationship
A field used at the send time to identify the email recipient
Locale Data Type
Allows two characters to define country and five characters to define language
Where are subscribers stored?
Email Studio
How are subscribers created?
Import into the All Subscribers list or being sent an email
What data type is a Subscriber Key?
Text
What must the subscriber key be if Marketing Cloud Connect is enabled?
The 18 digit lead or contact ID
What is a subscriber key used for?
Retrieving email addresses, identifying the record to update during data imports, and preference management
When do subscriber key and contact key have the same value?
Subscriber information is mapped to the Contact model before data is added to Marketing Cloud
What are the All Subscribers List statuses?
Active
Held
Bounced
Unsubscribed
What is the Held status?
Person had three or more hard or soft bounces in the last 15 days (or one hard bounce from a trusted domain). Permanently suppressed.
What is the Bounced status?
Person had 1-2 soft bounces or one hard bounce (non-trusted domain). Resets to Active if the person engages with an email.
Data Designer
Enables viewing and managing contact data by relating data to the contact record or linking data extensions
What section should be used for data management?
Contact Builder
What data model can have more than 500,000 subscribers?
Data Extension
What data model has a limited number of attributes?
List
What is the recommended data model?
Data extension
What are the types of data extensions?
Standard
Salesforce
Synchronized
What are Salesforce data extensions used for?
Sending email tracking info to Sales or Service Cloud
What are the data extension creation methods?
Create New
From Existing
From Template
What item is not copied from the original data extension when a data extension is created From Existing?
Records
What are the Data Retention Policy targets?
Individual Records
All Records
All Records and Data Extensions
Where do you view all of your Data Retention Policies?
Data Extensions dashboard view in Contact Builder
What does a primary key ensure in a data extension?
Records are not overwritten
Where are Data Extension Storage Details exported from?
A CSV in Setup/Metrics
What is the max recommended amount of columns in a data extension?
50
Send Relationship
Used at send time to identify a recipient and creates the link between the sendable data extension and the All Subscribers list
What field is the Send Relationship mapped to in the All Subscribers list?
Subscriber Key
What is checked to determine a subscriber’s status?
Send Relationship
What are the methods to add records to Marketing Cloud?
Manual Record Creation
Import
Import File Activity
Synchronized Data Sources
API Integration
SmartCapture forms
What is not required in the overwrite import type?
Primary Key
Where is manual record creation done?
Contact Builder
When should the Import record creation type be used?
One-time record additions like in-person newsletter signups
What is required to perform imports from a File Location source?
Enhanced FTP
What is the max size of an import file?
20mb
What formats can an import file be?
Comma
Tab
One-Character Delimited
What are the field mapping types?
Header Row
Ordinal
Manually
Ordinal Field Mapping Type
Maps by order of fields (first column mapped to first field, etc)
What should the Import File Activity creation type be used for?
Large-volume files
What happens to deleted data extensions?
Moved to the Recycle Bin and deleted after 30 days
What is needed before an Import File Activity for encryped files?
File Transfer activity
Where do File Transfer activities place unencrypted files?
Marketing Cloud Safehouse
Where are data filters created and how are they run?
Created in Email Studio, run by Filter activities in Automation Studio
What are the segmented data extension types?
Random data extensions
Filtered data extensions
How long will Automation Studio attempt to run an SQL Query before giving an error?
30 minutes
In SQL Queries, what has to be placed before a “From” clause to get data from a business unit’s enterprise parent account?
ENT
How long can data views store tracking data?
Six months
How are data view tables accessed?
SQL Queries
How are email sends identified?
System-defined JobId number
What are the unsubscribe types?
Universal
Global
What does a Global unsubscribe remove a person from?
All emails sent by any Marketing Cloud instance
What controls which communications subscribers receive?
Publication Lists
True/False: publication lists can receive imports
True
True/False: publication lists cannot be made public and used in a preference center
False
Profile Center
Gives control of the records stored about a person (ie name and email)
Subscription Center
Email subscription preferences page
What appears in the Tracking tab of Email Studio?
Job ID
Total Sent
Send Performance
Send Logs
Capture unique info like send fail data
How many send logs can a business unit have?
One
Tracking Extracts
Used to export email performance data
NotSent Tracking Extracts
Export send fail data