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

For handling a daily file drop that requires immediate processing:

File Drop Automation: Use File Drop Automation triggered by the presence of a new file on the SFTP. This automatically starts the import and subsequent data handling processes.

Workflow Details: Start with an Import File Activity to load data into the staging data extension, followed by SQL Query Activity 1 to segment the data into one target data extension and SQL Query Activity 2 for the other.

To differentiate between marketing and transactional emails effectively:

Sender Profile: Define separate sender profiles for marketing and transactional emails. This includes different From Names and possibly different From Email addresses to help recipients distinguish between different types of emails.

Delivery Profile: Set up different delivery profiles for marketing and transactional emails. These can specify different IP addresses, helping to segment and manage sender reputation for different types of email communications.

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

When creating a data extension for subscriber data from a data warehouse, fields that typically require minimal consideration for size or scalability include:

Number: Fields designated as 'Number' generally consume less storage space and are straightforward in terms of scalability and processing within data extensions.

Boolean: Boolean fields, representing simple true/false values, are highly efficient in terms of storage and processing, making them less of a concern in terms of scalability.

The error in the File Drop Automation is due to the filename pattern not matching exactly because of additional seconds and milliseconds in the filename. To resolve this issue:

Modify the Import File activity to use the %%FILENAME_FROM_TRIGGER%% personalization string. This ensures that the Import File activity dynamically accepts the filename exactly as it is uploaded to the SFTP location.

Update the filename pattern in the automation setup to avoid hardcoding the date format and instead rely on the filename that triggered the automation.

By using %%FILENAME_FROM_TRIGGER%%, the automation becomes flexible and will correctly handle any file name that matches the initial pattern triggering the automation, regardless of additional timestamp details.

The behavior where customers unsubscribe via the Marketing Cloud default Profile Center and do not receive emails from any other business unit is explained by:

D. Business unit unsubscribe setting causes an Enterprise level unsubscribe. This setting means that when a subscriber opts out using the default Profile Center, they are unsubscribed at the enterprise level, impacting all business units within the organization.

To enhance mobile adoption strategies, Northern Trail Outfitters can leverage the following reports:

A. Email Performance by Device: This report provides insights into how subscribers are interacting with emails across different devices, which can help NTO understand device preferences and optimize their mobile content.

B. Time Between Send and Engagement: This report tracks the time it takes for recipients to engage with emails after they are sent, helping to determine the effectiveness of timing and content across different platforms, including mobile devices.

The Content Builder Settings under Setup allow the admin to create a default Header and Footer for emails. These settings apply to emails created in Content Builder only. The other settings do not have an option to create a default Header and Footer for emails.

When creating custom roles in Marketing Cloud, it's important to consider that:

B. Custom roles are only available within the business unit in which they were created. This means that the scope of the custom roles is limited to the specific business unit, and they do not automatically apply to other business units within the same Marketing Cloud account.

For the financial services customer's need to manage multiple accounts that share the same email address but maintain separate subscriber attributes, the correct component to use is the Subscriber Key. This key uniquely identifies each subscriber in Marketing Cloud, enabling multiple profiles (each associated with different accounts) to share a single email address but retain distinct attributes and engagement tracking.

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.

To automate the process of unsubscribing customers who request removal via email replies, the Marketing Cloud admin should first ensure that Reply Mail Management (RMM) is enabled in the account. This feature manages responses to emails sent from Marketing Cloud. Additionally, within RMM settings, the admin should select "Unsubscribe Manual requests." This setting enables the system to automatically process unsubscribe requests from customers who manually reply asking to be removed from mailing lists. This helps in maintaining compliance with customer preferences and email marketing laws.

As the Marketing Cloud admin plans to expand the data model to include SMS and Push channels, it's important to prepare the data model for high data quality:

A. Remove nonessential data for marketing purposes: This helps streamline data management and ensures the data model is not cluttered with irrelevant information, making it easier to manage and use.

B. Identify and assign appropriate keys to tie records together: Proper key management ensures that different data sources can be linked effectively, facilitating a unified view across different marketing channels.

C. Normalize data and fields to prevent redundancy: Normalization reduces data redundancy and inconsistency, which is essential for maintaining data integrity and efficiency in a multi-channel environment.

For the entertainment company's setup using Contact Builder and Journey Builder, the two data sources essential to incorporate are:

A. Customer Data: This is crucial because it includes basic customer identifiers such as email addresses, which are necessary for sending emails and personalizing communications.

B. Event Registration: This data is critical as it contains the event-specific details needed for the decision splits in the journey, such as event ID, event type, and event name, which will determine the content of emails, including dynamic venue details through AMPscript.

These data sources ensure that the journeys can be personalized and targeted based on the customer's registered events, enhancing the relevance and effectiveness of the communications.

To append UTM tracking parameters to links in emails:

Use Parameter Manager: This functionality within Marketing Cloud allows for the addition of UTM parameters to links across emails systematically. It provides a centralized control over tracking parameters, making it easy to manage and apply consistent tracking across various campaigns.

Configuration: Set up the UTM parameters in the Parameter Manager and these will be automatically appended to all links in the emails sent.

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.

Datorama is a marketing intelligence platform that can integrate data from various sources, such as Marketing Cloud, Google Analytics, Facebook Ads, and DoubleClick Bid Manager, and provide insights and analytics to optimize marketing campaigns.

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.

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 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.

Given the website outage experienced by NTO during a peak shopping period:

D. Create and send an apology email that includes a discount for a future purchase to all customers: This action acknowledges the inconvenience caused by the outage and incentivizes customers to return to the site. Offering a discount can help mitigate any negative sentiment and encourage customers to complete their interrupted purchases.

This approach helps to maintain customer goodwill and potentially recover some of the lost sales due to the outage.

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.

To enhance personalized interactions and increase purchase frequency using Journey Builder:

Channel Preference: Understanding the preferred communication channels of customers allows for personalized and effective outreach, potentially increasing engagement and response rates.

Last Purchase Date: Tracking when a customer last made a purchase can help in timing communications effectively, triggering reminders or promotions at optimal times to encourage repeat purchases.

To avoid storing sensitive data in the cloud, the admin should use Tokenized Sending. This feature allows Marketing Cloud to send emails without storing sensitive data such as credit card numbers or social security numbers. Instead, Marketing Cloud uses tokens that are replaced with actual data at send time by an external system.

In the scenario of managing data relationships for an eCommerce site:

B. Create a one-to-many relationship between Orders and Order_Details: This relationship allows multiple order details (such as individual items, quantities, and prices) to be associated with a single order, reflecting the typical structure of an eCommerce transaction.

D. Create a one-to-one relationship between Order_Details and Products: This relationship links each order detail line to a specific product, allowing for detailed tracking and analysis of product sales.

These relationships set up a logical and functional structure in Data Designer, enabling effective data management and utilization for reporting and customer insights.

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 automatically add tracking parameters to all links in emails sent from Email Studio, the admin should configure:

Web Analytics Connector: This feature automatically appends tracking parameters to URLs in emails to integrate with web analytics tools like Google Analytics.

Configuration Steps: Set up the Web Analytics Connector by specifying the desired tracking parameters in the Email Studio settings. This ensures all outgoing emails automatically include these parameters without the need for manual coding.

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.

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 efficiently manage limited licenses and ensure continuity in campaign management while the campaign manager is on parental leave:

Deactivate the Existing User: Temporarily deactivate the campaign manager's user account. This action frees up a license without deleting the user's historical data or settings.

Reassign the License: Assign the freed-up license to a new user who will temporarily fill the campaign manager's role. This approach maintains operational efficiency and compliance with license limitations.

To achieve faster send speeds for large volumes of emails, the functionality known as Burst Sending should be utilized. Burst Sending allows Marketing Cloud to process and send large batches of emails quickly, meeting high send speed goals by maximizing the throughput of the sending infrastructure.

The Sender Authentication Package (SAP) allows the image URLs to be wrapped with the appropriate brand URL, which enhances the branding and deliverability of the emails. The SAP does not affect the profile center branding, the click domain, or the IP warming.

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.

To solicit website feedback directly within an email without navigating away from the email, the feature to use is B. Email Form Content Block. This block allows subscribers to submit feedback directly within the email, enhancing user experience and increasing the likelihood of feedback submission since the subscriber does not need to leave their email environment.

To verify if a Sender Authentication Package (SAP) has been set up, check:

Tracked Links Prefix: If all links in emails sent start with click.email.nto.com, it indicates that a SAP is configured for link rewriting to include the company’s domain.

CloudPages URL: Personalized URLs for CloudPages that use the domain cloud.email.nto.com also suggest that SAP is set up, ensuring that all customer-facing URLs reflect the organization’s branding.

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.

 To search for a Salesforce contact in All Subscribers, the admin should use the 18-digit contact ID as the subscriber key. This is because Marketing Cloud Connect uses the 18-digit contact ID as the subscriber key for contacts synchronized from Salesforce. The email address is not a reliable identifier as it can change or be duplicated

Before configuring Social Studio for managing social media accounts, ensure these prerequisites are met:

Facebook Ad Manager: Access to Facebook Ad Manager is essential for managing and monitoring Facebook advertising campaigns directly from Social Studio.

Login Details: Have the necessary login credentials for each social media account that will be managed through Social Studio to ensure seamless integration and management across platforms.

A multiplier is applied to each SMS message based on the destination country, which could explain why NTO is already at 75% utilization for their annual Super Messages. For example, sending an SMS message to a subscriber in Germany consumes 1.5 Super Messages, while sending an SMS message to a subscriber in India consumes 3 Super Messages. The other options are not true or relevant.

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.