MCE-Admn-201 Salesforce Certified Marketing Cloud Engagement Administrator Questions and Answers

To create a suppression list for hard-bounced email addresses, the most direct approach is to query the Bounce Data View in SQL. This Data View contains all bounce-related information, allowing admins to specifically filter for hard bounces by the bounce category. Using a query activity, the admin can extract all hard bounce records and create a dynamic or static suppression list based on these results. This method is efficient and ensures that only relevant data is included in the suppression list.

A functionality unique to Journey Builder that is not available in Automation Studio:

Wait Activities: Journey Builder provides the flexibility to configure wait times based not just on a fixed duration but also until a specific date or time, which is essential for personalizing the timing of customer interactions based on individual behaviors or milestones.

Configure the business unit data retention setting to 12 months is the policy that the Marketing Cloud admin could configure in Setup. Business unit data retention setting is a setting that allows marketers to specify how long records in data extensions should be retained at the business unit level. By configuring the business unit data retention setting to 12 months, any inactive data that is older than 12 months will be automatically deleted from the data extensions in that business unit2

For Northern Trail Outfitters to include a Campaign Identifier (utm_campaign) to the links within a specific campaign message using Parameter Manager, the utm_campaign value should be configured at the Email level. This allows the specific campaign identifier to be applied to all links within that particular email campaign, ensuring consistent tracking and reporting across all links included in that email.

Advertising Studio supports lookalike audiences directly from Facebook only. For other networks, such as Google and Twitter, Advertising Studio can create audience segments based on Marketing Cloud data and export them to the network’s platform, where the lookalike audience can be created manually.

When considering an update to increase the session timeout setting in Marketing Cloud, the admin should review several factors:

C. Security risk of unauthorized users for longer timeout settings - Longer session timeouts can pose a security risk as it increases the window during which an unauthorized person could potentially access an unattended user session. This is particularly crucial in environments where users might share computers or work in open office environments.

D. Change impacts all users - Any change to the session timeout settings will affect all users across the platform. It's important to communicate these changes and understand the broader impact, especially in larger organizations where different teams might have different security and operational needs.

E. Typical length of time users spend in Marketing Cloud - Understanding how users interact with Marketing Cloud and the average length of their sessions can help in deciding the appropriate session timeout setting. If users typically engage in longer tasks, a longer timeout might be necessary to prevent disruptions.

 Administrator and Marketing Cloud Administrator are two standard roles that should be selected for the new user. Administrator is a standard role that grants full access to all features and functions in Marketing Cloud, such as creating and managing users, roles, permissions, business units, and security settings. Marketing Cloud Administrator is a standard role that grants access to all features and functions in Marketing Cloud except for user management. By selecting both roles, the new user will have full administrator permissions in Marketing Cloud

The issue where a customer continues to receive emails despite unsubscribing and being deleted from the data extension likely arises because the email address in All Subscribers still exists and is active. In Marketing Cloud, the All Subscribers list acts as a master list overriding subscription statuses in individual data extensions. Thus, even if a customer is removed from a specific data extension, if their status in All Subscribers is not updated to 'Unsubscribed,' they will continue to receive communications.

When enabling Multi-Org in Marketing Cloud Connect, it's important to consider:

The Multi-Org configuration does not support using a standard profile and preference center across connected business units. Each business unit operates independently.

Admins must consider alternative strategies for managing subscriber preferences across multiple Salesforce orgs linked to different business units in Marketing Cloud.

The Export Email Allowlist feature allows the admin to specify a list of email addresses that are authorized to receive data exports from Marketing Cloud. This feature can help protect against misuse of customer data by preventing unauthorized users from exporting data without approval. The other features do not directly address the requirement of restricting data exports.

 To clear inactive data stored in data extensions after 12 months, NTO should apply a row-based retention to each data extension as it is created, set to 12 months. This will delete any records that have not been modified in the last 12 months. Row-based retention can be applied to individual data extensions or data extension templates

When configuring an SFTP user in Marketing Cloud, the following considerations should be taken into account:

B. Minimum password length is 12 characters: Ensuring password security, Marketing Cloud requires SFTP passwords to have a minimum length of 12 characters.

D. Once created, the user will need to be activated in order to use the SFTP: After the SFTP user account is created, it must be activated by the admin before it can be used for file transfers.

The user in question holds roles that do not inherently include permissions to send emails. The roles assigned are:

Content Creator: Typically has permissions to create content but not necessarily to send emails.

Data Manager: Manages data but does not have email sending permissions.

Marketing Cloud Viewer: Can view campaigns and data but cannot execute or modify them.

To resolve this issue so that the user can send emails, the admin must: A. Edit permissions and Grant permissions to Send - This action involves customizing the user’s permissions to include the ability to send emails. This can be done either by adjusting the permissions in one of the existing roles (if customization is possible and appropriate) or by creating a custom role or permission set that includes email sending capabilities.

To enable subscribers to receive only the categories of emails they are interested in:

Publication Lists: Use Publication Lists to manage different categories of email content. Subscribers can choose which lists they want to subscribe to through the built-in subscription center, thereby receiving only the emails that match their interests.

Implementation: Configure multiple publication lists representing various content categories. Integrate these lists with the subscription center to allow subscribers to select their preferences.

Recommendations for integrating diverse student data into Journey Builder:

Data Designer: Utilize Data Designer to establish relationships between student data, alumni records, and the contact record. This tool allows the creation of a unified view that supports personalized journeys based on comprehensive student profiles.

Synchronized Data Sources: Implement synchronized data sources to continuously import and update data from the Sales Cloud, ensuring that the data in Marketing Cloud remains current and accurate.

The options that determine when a contact can enter a journey in Marketing Cloud's Journey Builder include:

A. Re-entry at any time: Contacts can re-enter the journey immediately after their previous participation ends.

D. No re-entry: Contacts are not allowed to re-enter the journey once they have entered it, regardless of whether they have completed it or not.

E. Re-entry only after exiting: Contacts can only re-enter the journey after they have fully exited, ensuring they complete all activities before re-entering.

Marketing Cloud authenticates several factors during user login, among which:

Whitelisted IP address check: Marketing Cloud checks if the user's IP address matches those listed in the IP whitelist settings. This is part of the security measures to ensure that only authorized accesses are allowed from secured locations.

For Northern Trail Outfitters (NTO) to send monthly statements to franchisees under a policy that requires the content not to be publicly accessible, the appropriate solution is Distributed Sending. This product allows corporate to control and manage email content centrally while enabling local franchises to send these emails directly to their respective recipients. This ensures that statements remain private and are only accessible to the intended recipients.

To sync specific contacts from Sales Cloud to Marketing Cloud without syncing all contacts, particularly when not all contacts need email communications, the admin should use a Boolean field to filter the contacts. This can be configured in the Contact Builder under Data Sources. A Boolean field allows for a simple true/false condition that can be set in Sales Cloud and used to control which records are synchronized based on their relevance for email communication. This method ensures that only contacts marked true (or false, depending on the setup) are brought into Marketing Cloud, efficiently managing the sync and keeping irrelevant contacts out of the system.

Segment by domain to limit number of sends to each email provider is the option for segmentation that aligns with the IP Warming process. IP Warming is the process of gradually increasing email volume from a new or unused IP address to build trust and credibility with Internet Service Providers (ISPs). Segmenting by domain means dividing the email list into smaller groups based on the email domain, such as gmail.com or yahoo.com. By segmenting by domain, marketers can limit the number of sends to each email provider and avoid being flagged as spam or blocked by the ISPs.

Smart Capture is the feature that should be used to create a survey form. Smart Capture is a feature that allows marketers to create and insert forms within landing pages or emails, such as surveys, polls, or feedback requests. Smart Capture can be customized with different fields, labels, buttons, and actions. Smart Capture can capture subscriber responses and store them in a data extension or update existing records in Marketing Cloud.

Creating separate business units for each brand is necessary when:

Brand-specific Domains: Separate business units allow for the configuration of brand-specific private domains, which are crucial for maintaining brand identity and trust in email campaigns by customizing link and image paths.

Use Case: If different brands under NTO need to leverage their unique domains for sending emails and hosting content, setting up distinct business units allows each brand to manage its sender profiles, content, and subscriber interactions independently.

To address the issue of accented characters appearing jumbled in a Tracking Extract, the correct settings to adjust are related to character encoding and output format.

Change Character Encoding to UTF-8: This setting ensures that the extracted file supports Unicode, which includes accented characters and other non-standard characters used globally. UTF-8 encoding is capable of representing any character in the applicable data set, making it ideal for global applications.

Select Unicode Output: This option should be enabled to ensure the file output correctly formats Unicode characters, preventing them from being displayed incorrectly.

The entry source types for Journey Builder include:

C. Data Extension, Email List, API Event, Date Based EventThese sources allow a marketing campaign to automatically start or transition contacts based on their interaction with various data sources:

Data Extension: Contacts can be injected into a journey based on records in a data extension.

Email List: Contacts from a specific email list can be used as an entry event.

API Event: This allows external systems to trigger entry into a journey.

Date Based Event: Contacts can enter a journey based on a specific date or a date attribute in a data extension.

Regarding Send Logging in Marketing Cloud:

B. AMPscript can be used to pull data from Send Logs for use within emails: AMPscript can retrieve and display data stored in Send Logs during email sends, allowing for dynamic content based on previous interactions.

C. SQL Query Activities can reference Send Logs in combination with system data views: SQL Query Activities enable more complex data retrieval and analysis, including combining Send Log data with other system data views for comprehensive reporting and segmentation.

These points underscore the functionality and utility of Send Logs in enabling dynamic content and deeper data analysis within Marketing Cloud.

To configure a journey using Path Optimizer with a holdback of 60% of the contacts until a winner has been selected, the Marketing Cloud admin needs to set:

A. Data Extension entry source: Ensures the journey is pulling contacts from a specific data extension which can be effectively managed and monitored for the experiment.

D. Winner evaluation: This setting allows the admin to specify how and when the winning path is determined, which is critical to managing the holdback and subsequent path optimization.

Setup Assistant in Marketing Cloud provides a guided setup for configuring new accounts and covers various topics to streamline the process, including:

A. Enabling Mobile Connect: This section guides admins through setting up Mobile Connect, which allows them to send SMS and MMS messages to mobile devices.

C. Configuring Journey Builder: This part of the Setup Assistant helps set up Journey Builder, guiding users on how to create and manage customer journeys effectively.

To troubleshoot issues with email sends in Salesforce Marketing Cloud:

B. Failed Sends: This link in Setup provides detailed logs and reasons why certain sends have failed, which is crucial for diagnosing problems with specific email campaigns.

D. System Status: Checking the System Status helps determine if there are any ongoing issues with the Salesforce servers that might be impacting email sends globally or regionally.

To ensure subscriber data is appropriately segregated between the EMEA and AMER teams, the Marketing Cloud admin should separate regions into different business units and apply Subscriber Filters. This setup allows for distinct data management and access controls per region, aligning with security and legal requirements. By configuring business units specific to each region, the admin can effectively control data visibility and operations within those regional contexts.

Journey Builder and Mobile Push are two products that would allow them to send push notifications to customers with their mobile app. Journey Builder is a product that allows marketers to create and execute cross-channel customer journeys based on events, activities, and goals. Journey Builder can be used to send push notifications to mobile app users as part of a journey. Mobile Push is a product that allows marketers to create, manage, and deliver push notifications to mobile app users. Mobile Push can be used to send push notifications as standalone messages or as part of a journey

To view all verified email addresses in Marketing Cloud:

Navigate to From Address Management: This section within Email Studio allows administrators to manage and view all sender addresses that have been verified and are approved for use in sending emails.

Verification and Management: This area specifically holds records of each email address that has been set up and verified, including the status of each, ensuring they are authorized to send emails from the platform.

To determine the total number of emails sent across all business units in the last calendar year, the Marketing Cloud admin should use Analytics Builder > Reports > Email Send Report. This section of Analytics Builder provides comprehensive reporting capabilities, including the ability to generate detailed reports on email sends across different business units over specified time periods.

The File Transfer Activity can be used to decrypt a file on the SFTP server using a PGP key. This activity prepares the file for importing into Marketing Cloud. The other activities do not have the option to decrypt a file.

To ensure a notification is received when a scheduled query fails, the Marketing Cloud admin should add their email address in the automation settings under "Runtime Error or Skipped Run Notification Settings." This setup in the automation configuration will alert the admin via email if there is a failure in the query's execution, enabling timely identification and resolution of issues.

For sending a promotional email to one million subscribers, a Data Extension is the most suitable data structure. Data Extensions offer robust data management capabilities, scalability, and flexibility for handling large volumes of data and complex segmentation, which is essential when dealing with a large audience size like one million subscribers. This setup allows for more detailed targeting and personalization strategies.

For handling multiple values for a subscriber attribute effectively:

Use Data Extensions: Data Extensions provide a flexible and scalable storage model that can accommodate complex data types, including multiple values for a single attribute per subscriber.

Advantages: Unlike Profile Attributes, which limit each subscriber to a single value per attribute, Data Extensions allow the creation of relational data models that can store multiple entries for individual attributes.

To pass the email address of a subscriber to a landing page through a URL parameter from a promotional email securely, the admin should use the CloudPagesURL AMPscript function. This function encrypts the email address and other parameters and generates a unique URL for each subscriber. The landing page can then use the RequestParameter AMPscript function to decrypt the email address and other parameters

To configure the data model in Marketing Cloud for effective use in Journey Builder:

Customer ID Linkage: Connect the Customers data extension to the data model using the Customer ID. This serves as a unique identifier to relate customer records across different data extensions.

One-to-Many Relationship: Establish a One-to-Many relationship between the Orders data extension and the Customers data extension. This setup accurately reflects that each customer can have multiple orders but each order is linked to only one customer, facilitating targeted messaging based on order status.

For the restaurant supply company's need to update their trade show contact collection method:

B. Microsite with Smart Capture to store entrants on a data extension: Smart Capture forms on a microsite provide a direct, digital method to collect entries efficiently and store them directly into a data extension.

D. Data Extension with double opt-in status defined: This setup helps manage consent and ensures compliance with email marketing regulations, as it allows entrants to confirm their subscription to the newsletter through a follow-up email.

These components provide an updated and efficient method for capturing and managing trade show contacts, while also ensuring compliance with marketing regulations.

To enable REST API access for external applications in Salesforce Marketing Cloud, permissions need to be configured within Installed Packages. This area allows administrators to manage API integrations and set authentication protocols.

Installed Packages: Navigate to this section in the Marketing Cloud setup menu. Create or select an existing package to configure API integration. Set up the API integration by generating the API key and secret, which are essential for authenticating the external application's API requests.

For NTO's requirement to pull detailed email metrics for each campaign across different Business Units, the appropriate report to use is the Email Send Report. This report provides comprehensive details on metrics such as number of sends, delivery rate, various bounce rates, open rate, click rate, complaint rate, and unsubscribe rate for individual email sends, which aligns well with the specified reporting needs for the quarterly meeting.