• Cert++
  • Practice
  • Certle
  • Review
  • Tracks
  • Checklist
  • Guides
  • Upgrade
Cert++
  1. Home
  3. Marketing Cloud Engagement Specialist

Marketing Cloud Engagement Specialist

Checklist progress

0/143Learned

Marketing Cloud Engagement Specialist

Study Checklist

  • Platform Administrator
  • Platform App Builder
  • Platform Foundations
  • Platform Developer
  • Platform Administrator II
  • Agentforce Sales Consultant
  • Agentforce Service Consultant
  • Platform Data Architect
  • Platform Development Lifecycle and Deployment Architect
  • Platform Identity and Access Management Architect
  • Platform Integration Architect
  • Platform Sharing and Visibility Architect
  • Heroku Architect
  • B2C Solution Architect
  • Experience Cloud Consultant
  • Agentforce Field Service and Operations Consultant
  • Agentforce Nonprofit Consultant
  • Data 360 Consultant
  • Omnistudio Consultant
  • CRM Analytics and Einstein Discovery Consultant
  • Platform User Experience Designer
  • Platform Strategy Designer
  • B2C Commerce Developer
  • JavaScript Developer
  • Omnistudio Developer
  • Platform Developer II
  • Marketing Cloud Engagement Administrator
  • Marketing Cloud Engagement Specialist
  • Marketing Cloud Engagement Consultant
  • Agentforce Sales Foundations
  • Business Analyst
  • Marketing Cloud Engagement Developer
  • Marketing Cloud Engagement Foundations
  • Agentforce Specialist
  • Agentforce Life Sciences Consultant
  • B2B Commerce Administrator AP
  • B2B Commerce Developer AP
  • Agentforce Consumer Goods AP
  • Agentforce Financial Services AP
  • Agentforce Health AP
  • Agentforce Manufacturing AP
  • MuleSoft Integration Foundations
  • MuleSoft Developer
  • MuleSoft Developer II
  • MuleSoft Platform Integration Architect
  • MuleSoft Platform Architect
  • Tableau Desktop Foundations
  • Tableau Data Analyst
  • Tableau Consultant
  • Tableau Server Administrator
  • Tableau Architect

Checklist progress

0/143Learned

  • What is the recommended character length and best practice for writing an email subject line to maximize open rates across desktop and mobile clients?
  • What is the role of the preheader text in an email, and how does it complement the subject line to influence open rates?
  • Which components of an email — subject line, preheader, CTA placement, and sender name — have the greatest impact on open and click-through rates?
  • What structural elements distinguish a high-performing transactional email from a promotional email?
  • A brand wants to increase email engagement by personalizing content. Which personalization techniques available in Marketing Cloud Email Studio are most effective for driving relevance?
  • A company is designing its first automated welcome email program. What elements — timing, content, personalization, and sequence length — should be included to maximize subscriber lifetime value?
  • A marketing team wants to improve click-through rates on a monthly newsletter. Which A/B testing strategy should they apply, and what elements are appropriate to test?
  • A retailer sends the same promotional email to its entire 500,000-subscriber list. Engagement has been declining for three months. What segmentation and personalization strategy should they adopt?
  • What is sender reputation, how is it measured by ISPs, and which Marketing Cloud sending behaviors directly affect it?
  • What is the difference between a soft bounce and a hard bounce in Marketing Cloud, and how does the platform handle each to protect sender reputation?
  • What is SPF and how does it establish email sender legitimacy and protect against spoofing?
  • What is DKIM and how does it establish email sender legitimacy and protect against spoofing?
  • What is DMARC and how does it establish email sender legitimacy and improve deliverability?
  • What is the difference between a shared IP and a dedicated IP in Marketing Cloud?
  • In what sending volume or brand scenario should a dedicated IP be used over a shared IP in Marketing Cloud?
  • A company is setting up a new dedicated IP address. What is the IP warming process, and what sending volume ramp schedule should they follow to avoid deliverability issues?
  • Which content elements — image-to-text ratio, link quantity, spam trigger words, and HTML structure — can negatively affect email deliverability?
  • Which HTML and CSS practices — inline styles, table-based layouts, excessive JavaScript — affect how an email is rendered by spam filters and major email clients?
  • What is a feedback loop (FBL), how does it work between ISPs and senders, and what action should Marketing Cloud take when a subscriber marks an email as spam through an FBL?
  • What role does the List-Unsubscribe header play in deliverability and subscriber management, and how does Marketing Cloud support it?
  • A marketer notices that emails to Gmail addresses have a higher spam placement rate than to other ISPs. Which sender reputation and authentication factors should they investigate first?
  • A company's bounce rate has spiked after importing a purchased list. What are the deliverability consequences, and what steps should be taken to remediate the sender reputation?
  • What is the difference between single opt-in and double opt-in subscription processes, and in which scenarios should each be used?
  • What is implied consent versus express consent, and how does this distinction affect email acquisition and list management practices?
  • What CAN-SPAM Act requirements must be included in every commercial email?
  • What are the consequences of CAN-SPAM non-compliance?
  • What is a preference center, what subscriber data should it capture, and how does it reduce unsubscribes while improving list quality?
  • How does CASL differ from CAN-SPAM in terms of consent requirements?
  • What does CASL vs CAN-SPAM mean for a U.S. company sending emails to Canadian subscribers?
  • A subscriber has not opened or clicked any email in 12 months. What re-engagement campaign strategy should be used, and at what point should the subscriber be removed from the active list?
  • A company's unsubscribe rate is increasing month over month. What subscriber retention strategies — frequency management, preference centers, content personalization — should be implemented?
  • A company wants to grow its email list quickly. A vendor offers to sell a list of 200,000 contacts. What are the risks and best-practice recommendations in this scenario?
  • What is Content Builder in Marketing Cloud, and what capabilities does it provide for creating and managing email content compared to the legacy Classic Email editor?
  • When should a marketer use Triggered Sends versus Journey Builder to send transactional or event-driven emails, and what are the key differences?
  • What is a Delivery Profile in Marketing Cloud, and what settings does it control that affect how an email is delivered to recipients?
  • What is the Test Send feature in Marketing Cloud, and what are its limitations compared to sending to a full production list?
  • What is the purpose of the Validation step in the Email Studio send flow, and what issues does it check for before allowing an email to be sent?
  • A team needs to preview how their email will render on 20 different email clients before launching a campaign. Which Marketing Cloud tool supports this, and how does it work?
  • A marketer needs to send a one-time promotional blast to a static subscriber list. Which Marketing Cloud tool and send flow should they use?
  • What is a Sender Profile in Marketing Cloud, and which fields does it define that affect how an email appears in the recipient's inbox?
  • What is a Publication List in Marketing Cloud, and how does it differ from a Suppression List in the context of send configuration?
  • What tracking settings are available when configuring an email send in Marketing Cloud, and what does enabling link tracking do at the subscriber level?
  • What is Send Throttling in Marketing Cloud, and in what scenario should it be enabled when scheduling a large campaign?
  • What data does Send Time Optimization (STO) use to determine optimal send time?
  • What is the difference between scheduling a send and using Send Time Optimization (STO) in Marketing Cloud?
  • What is a Reply Mail Management (RMM) profile, and how does it handle auto-replies and unsubscribe requests received in the reply inbox?
  • A company has multiple brands and wants each brand's emails to show a different From Name, From Address, and Reply-To address. How should Sender Profiles be configured in Marketing Cloud?
  • A company wants to exclude customers who have made a purchase in the last 7 days from a promotional campaign. How should the suppression list or exclusion logic be configured in the send settings?
  • What is the difference between a Template, an Email Message, and a Content Block in Content Builder, and how do they relate to each other in the content hierarchy?
  • What is a Campaign in Marketing Cloud, and how does it aggregate sends, messages, and assets for reporting and organization purposes?
  • How are folders used in Content Builder to organize email assets, and what are the best practices for folder structure in a multi-brand Marketing Cloud implementation?
  • How does version history work for email assets in Content Builder, and what restoration options are available if a recent change needs to be reverted?
  • A marketing team has dozens of emails used across multiple campaigns. How should tags and campaigns be used in Content Builder to make assets easy to find and reuse?

Given a customer scenario, recommend the appropriate marketing automation solution.

0/7

  • What is Automation Studio, and what types of tasks and activities can it execute compared to Journey Builder?
  • What is a Triggered Send in Marketing Cloud, and how does it differ from a Journey Builder entry event in terms of architecture and use case?
  • What are the three schedule options available in Automation Studio — Run Once, Scheduled, and Triggered — and when should each be used?
  • A company needs to import a file from an SFTP server daily, run a SQL query to segment the data, and then send an email to the resulting audience. Which tool handles this end-to-end workflow?
  • A company wants to run a multi-step lead nurture program triggered when a prospect fills out a web form and then branches based on subsequent email engagement. Which tool is most appropriate?
  • A company needs to send a birthday email to subscribers on their birthday every year. Should they use Automation Studio or Journey Builder, and why?
  • A marketer wants to re-send a campaign email to subscribers who did not open it within 72 hours. Should they use Automation Studio, Journey Builder, or another tool?

Given a customer scenario, build the appropriate Automation Studio solution.

0/10

What activities are available in Automation Studio, and what is the difference between Steps and Activities within an automation workflow?

Learn this concept
Unseen

How does the SQL Query activity work in Automation Studio, and what is its relationship to data extensions in terms of input and output?

Learn this concept
Unseen

What is the Filter activity in Automation Studio, how does it relate to data filters created in Email Studio, and when would it be used in place of a SQL Query activity?

Learn this concept
Unseen

What is the File Transfer activity in Automation Studio, and when is it used in combination with an Import File activity?

Learn this concept
Unseen

What is the Wait activity in Automation Studio, and how does it differ in behavior from a Wait activity in Journey Builder?

Learn this concept
Unseen

What notification options are available in Automation Studio when an automation completes successfully or fails, and how are they configured?

Learn this concept
Unseen

A triggered automation fires when a file is dropped in a specific SFTP folder. What is this trigger type called, and how is the folder path configured in Automation Studio?

Learn this concept
Unseen

A company needs to import subscriber data from an external SFTP location nightly and populate a sendable data extension. How should the Import File activity be configured in Automation Studio?

Learn this concept
Unseen

A company wants to export tracking data from Marketing Cloud to an external BI tool nightly. Which Automation Studio activities should be used, and in what order?

Learn this concept
Unseen

An automation has three sequential steps: SQL Query → Send Email → Data Extract. Step 2 fails because no records were returned by the SQL Query. What happens to the automation, and how should error handling be configured?

Learn this concept
Unseen

Given a customer scenario, build the appropriate Journey Builder solution.

0/15

  • What is a Journey Builder Entry Source, and what are the different entry source types available — Data Extension, CloudPage, API Event, Audience, and Salesforce Data — and when is each appropriate?
  • What is the Decision Split activity in Journey Builder, and how does it route contacts based on attribute values or engagement data?
  • What is the Engagement Split in Journey Builder, and how does it differ from a Decision Split in terms of what data it evaluates?
  • What is a Random Split activity in Journey Builder, and in what business scenarios would it be used for A/B testing within a journey?
  • What is a Journey Builder Goal, and how does reaching the goal affect a contact's path through the remaining journey steps?
  • What is Exit Criteria in Journey Builder, and how does it differ from a Journey Goal in terms of when and how contacts are removed from an active journey?
  • What is the difference between Journey Builder's 'Re-Entry' settings — No Re-Entry, Re-Entry Anytime, and Re-Entry Only After Exiting — and when should each be configured?
  • What is the Update Contact activity in Journey Builder, and how is it used to modify contact data or data extension field values as a subscriber progresses through a journey?
  • What is the Contact Delete activity in Journey Builder, and when should it be used in a journey workflow?
  • What is the Einstein STO (Send Time Optimization) activity in Journey Builder, and how does it determine the optimal send time for each individual contact?
  • A marketer wants to inject contacts from an external system into an active Journey via API. Which Journey Builder API event type and configuration should be used?
  • A company wants subscribers who abandon their shopping cart to receive three emails over five days, stopping if they complete a purchase. How should this Journey Builder journey be designed?
  • A company wants contacts who make a purchase to immediately exit an abandonment journey, even if they are mid-step waiting for an email send. How should Exit Criteria be configured to accomplish this?
  • A company launches a Journey and then realizes they need to modify the email used in Step 3. The Journey is currently active with contacts inside it. What are the constraints on editing an active Journey?
  • A company wants to pause all active journeys temporarily for a system maintenance window. What are the implications of pausing a Journey, and how does it affect contacts currently inside the journey?
  • What is a Data Extension in Marketing Cloud, and how does it differ from a Subscriber List in terms of structure, use cases, and capabilities?
  • What data field types are available when creating a Data Extension — Text, Number, Date, Boolean, EmailAddress, Phone, Decimal, Locale — and when should each be used?
  • What is a Sendable Data Extension, and what configuration is required — primary key, subscriber relationship field — to make a data extension sendable?
  • What is the All Subscribers list in Marketing Cloud, and how does a Sendable Data Extension interact with it during a send?
  • What is the difference between a Standard Data Extension, a Filtered Data Extension, and a Random Data Extension in Marketing Cloud?
  • What is a Data Retention Policy on a Data Extension, and what options — Individual Records, All Records, All Records and Data Extension — are available, and how do they differ?
  • A company needs to store order history data for use in personalized emails. They expect 5 million rows and need data purged after 90 days. How should the Data Extension be configured?
  • A company needs to create a Data Extension that stores subscriber product preferences as a child record for each subscriber. How should the relationship field and primary key be defined to support personalized email sends?
  • What are the methods available to import data into a Marketing Cloud Data Extension — UI import, Import Activity, API, Contact Builder — and when should each be used?
  • What file formats does the Import Activity in Marketing Cloud support?
  • What configuration options — overwrite, append, update, update and add — are available in the Import Activity, and how does each affect existing records?
  • What is the difference between importing into the All Subscribers list versus importing directly into a Data Extension?
  • What is the SFTP configuration in Marketing Cloud, and how is it used for automated data imports via Automation Studio?
  • A company imports a subscriber file with 10,000 rows and 300 fail during import due to invalid email addresses. Where can they find the error log, and what does each error type indicate?
  • A company receives a nightly CRM extract file in pipe-delimited format. How should the Import Activity and File Transfer activity be configured in Automation Studio to process this file?
  • What is a Filtered Data Extension, how is it created from a source Data Extension, and what are its limitations compared to a SQL Query result?
  • What is a Random Data Extension in Marketing Cloud, and in what scenario would it be used for audience splitting?
  • What is the Query Activity in Automation Studio, and how is SQL used to create targeted subscriber segments in a target Data Extension?
  • What are the system data views available in Marketing Cloud — _Subscribers, _Open, _Click, _Bounce, _Unsubscribe, _Sent — and how can they be queried in the Query Activity?
  • What is a data filter in Marketing Cloud Email Studio, how is a filter definition created, and how does applying a filter to a data extension differ from running a SQL query in Automation Studio?
  • A company needs to create a refreshable segment of subscribers who have a loyalty tier of 'Gold' from a master data extension. Should they use a Filtered Data Extension or a SQL Query activity, and why?
  • A company wants to target subscribers who opened any email in the last 30 days but did not purchase. How should this audience be defined using a SQL Query Activity against the _Open and purchase data extension tables?
  • A company needs to identify subscribers who received an email from Campaign A but did not click, and were also tagged as 'VIP' in their profile data extension. How should this SQL query be structured?
  • What subscriber statuses exist in Marketing Cloud — Active, Unsubscribed, Bounced, Held — and how does each status affect whether an email is sent to that subscriber?
  • What is the Held status in Marketing Cloud, how does a subscriber reach Held status, and what must occur before Marketing Cloud will attempt to send to that subscriber again?
  • What is the difference between a global unsubscribe and a list-level unsubscribe in Marketing Cloud, and how does each affect future sends?
  • What is a Suppression List in Marketing Cloud, and how does it differ from an Exclusion Script (AMPscript) and a Publication List in controlling who receives an email?
  • What is List Detective in Marketing Cloud, what types of addresses does it flag or suppress automatically, and how does it protect sender reputation during a send?
  • Where can a marketer find the Send Log or Job send summary report to diagnose why specific subscribers did not receive a send that targeted them?
  • A subscriber unsubscribed from a specific publication list but continues to receive emails from a different publication list. Is this behavior expected, and how does Marketing Cloud's subscription model support this?
  • A company wants to honor subscribers' channel and frequency preferences set in a preference center. Which Marketing Cloud data structures and send configurations support this requirement?
  • A marketer sends to a Data Extension of 50,000 records but only 45,000 emails are delivered. What are the possible reasons for this discrepancy — unsubscribes, bounces, suppression lists, hold status — and how should each be investigated?
  • What is Delivered Rate, and how is it calculated relative to Total Sent, Bounced, and Filtered emails?
  • What is the difference between Unique Opens and Total Opens in Marketing Cloud email tracking, and which metric is more meaningful for evaluating campaign performance?
  • What is the Bounce Rate metric, and how does Marketing Cloud distinguish between Soft Bounce, Hard Bounce, and Block/Technical Bounce in the tracking data?
  • What is Click-to-Open Rate (CTOR), how is it calculated, and what does a high CTOR paired with a low open rate indicate about a campaign?
  • What does the Unsubscribe Rate metric measure, at what threshold does it typically indicate a list quality or targeting problem, and what actions should follow?
  • What is the Complaint Rate (spam complaint rate) metric, how is it tracked in Marketing Cloud, and what threshold should trigger immediate remediation action?
  • What is a Forwarded email in Marketing Cloud tracking, and how is it distinguished from a regular open in the tracking data?
  • A campaign shows a high open rate but a very low click rate. What does this metric combination indicate, and what changes should be evaluated?
  • Where in Marketing Cloud can a marketer access the detailed tracking results for a completed send, and what information is available at the job level versus the subscriber level?
  • What are the standard tracking reports available in the Reports section of Marketing Cloud, and which one provides a cross-send aggregate view of a campaign's performance?
  • What tracking data is stored in the Marketing Cloud system data views — _Open, _Click, _Bounce, _Unsubscribe, _Sent — and how can they be queried to build a custom performance dashboard?
  • A marketer wants to analyze link-level click performance within a single email send. Which report or view in Marketing Cloud provides per-link click counts and unique click rates?
  • A marketer completed an A/B test send and needs to determine which version performed better. What metrics should they compare, and where are A/B test results surfaced in Marketing Cloud?
  • What is the difference between a Standard Report and a Custom Report in Marketing Cloud, and when would a marketer need to create a custom report?
  • How is an automated report configured in Marketing Cloud to be delivered via email on a recurring schedule, and which report types support automation?
  • What is Intelligence Reports (formerly Datorama Reports for Email) in Marketing Cloud, and how does it differ from the standard Analytics Builder reports in terms of visualization and data aggregation capability?
  • What is the Data Extract activity in Automation Studio as it relates to analytics, and how can it be used to export tracking data for use in an external reporting system?
  • A marketing manager wants a weekly summary of all sends across all business units delivered to their inbox every Monday morning. How should this be configured in Marketing Cloud Reports?
  • A company wants to compare email performance trends across 12 months and multiple business units in a single dashboard view. Which Marketing Cloud reporting tool is best suited for this, and why?
  • What is Einstein Engagement Scoring in Marketing Cloud, and what subscriber-level predictions does it generate?
  • What is Einstein Send Time Optimization (STO), how does it differ from rule-based send time scheduling, and in what scenario would it be recommended over manual scheduling?
  • What is Einstein Frequency, and how does it help marketers optimize the number of messages sent to each subscriber to balance engagement against fatigue?
  • What is Einstein Content Selection, and how does it automatically choose the best performing content variant for each subscriber in an email?
  • What is Einstein Messaging Insights, and what types of anomalies or performance deviations does it surface to marketers proactively?
  • A company wants to predict which subscribers are at risk of unsubscribing. Which Einstein feature addresses this, and what data does it use to generate the prediction?
  • A marketer wants to improve subject line effectiveness across multiple campaigns over time without manually running A/B tests. Which Einstein Marketing Cloud feature should they use?

Prepare for the Exam

Play Today's Certle
Back to track

Study Community

Ask questions and get the latest info from other Marketing Cloud Engagement Specialist studiers. 593 members and growing.

Go to Discord

How does the SQL Query activity work in Automation Studio, and what is its relationship to data extensions in terms of input and output?

Explainer

Learn More

Practice Question

Keep going

Next conceptWhat is the Filter activity in Automation Studio, how does it relate to data filters created in Email Studio, and when would it be used in place of a SQL Query activity?

Checklist progress

0/143 (0%)

0 of 143 concepts learned

Tip: You can filter concepts by status.

Prepare for the Exam

Play Today's Certle
Back to track

Study Community

Ask questions and get the latest info from other Marketing Cloud Engagement Specialist studiers. 593 members and growing.

Go to Discord

Explainer

SQL Query activities in Automation Studio retrieve and transform data using SQL statements to populate Data Extensions. They function as a bridge between source data, such as system data views or existing extensions, and target Data Extensions configured for specific automation workflows.

Core information
  • Query activities use a QueryText property to define the SQL logic that selects and transforms data from source Data Extensions.
More details and nuances
  • You cannot retrieve the status or completion time of a query activity when managing it via the API.