Subscriber & Data Management Flashcards
What are Data Extensions in Marketing Cloud?
Flexible data storage solutions within Email Studio, acting like tables to hold subscriber data that doesn’t fit standard profile attributes
Handling, Integrating, Enabling
Name three reasons to use Data Extensions
1) Handling varied data structures
2) Integrating external data
3) Enabling targeted sends
How do you update a Filtered Data Extension with new records?
Use the “Refresh” function
Can you explain the “Randomise” function for Data Extensions?
It creates new Data Extensions by randomly splitting existing ones into subsets
How do Data Extensions help with email personalisation?
They store custom data that can be included in email messages
What is the purpose of a SQL Query Activity in Marketing Cloud?
To retrieve specific data from data extensions using custom SQL queries and store the results
What is a crucial step to ensure accurate field naming in your SQL query?
Drag and drop fields from the data extension list instead of manually typing them
Can you use both “JOIN” and “SELECT “ in the same SQL query within a SQL Query Activity?
It is not recommended. Specify individual columns instead of using “SELECT ”
What are the three data handling options when configuring a SQL Query Activity?
1) Append 2) Update 3) Overwrite
Where can you monitor the execution history and results of your SQL Query Activity?
In the activity logs
What is the primary function of Audience Builder in Marketing Cloud?
To dynamically segment contacts into targeted audiences based on attributes and behaviors
Explain the difference between “Audiences” and “Segments” in Audience Builder.
Audiences are broad collections of contacts, while Segments are subsets with specific criteria within an Audience
Which tab in Audience Builder is used to suppress specific contacts from an audience?
The “Exclusions” tab
How can you utilise segmented audience data in other Marketing Cloud activities?
By publishing the audiences as Data Extensions
What is the purpose of “Dimension Packages” in Audience Builder?
To define the organisation and display of subscriber data in the Attribute Library
What are Auto-Suppression Lists in Marketing Cloud
Account or business unit-level lists that automatically exclude specific email addresses from Email Studio sends, acting as “do-not-contact” lists
What are Auto-Suppression Lists in Marketing Cloud?
Account or business unit-level lists that automatically exclude specific email addresses from Email Studio sends, acting as “do-not-contact” lists
Provide three common use cases for Auto-Suppression Lists
1) Addresses with spam complaints
2) Unsubscribe lists from previous providers
3) Competitors’ email addresses
What is the scope difference between Child Business Unit and Enterprise Business Unit for Auto-Suppression Lists?
Child Business Unit limits suppression to that specific unit, while Enterprise Business Unit applies it account-wide
What happens to the triggered send queue when you enable an Auto-Suppression List?
It is republished with the changes, but existing content is not updated.
Will subscribers already in the triggered send queue be suppressed when an Auto-Suppression List is enabled?
No, they will not be suppressed.