MCE-Dev-201 Salesforce Certified Marketing Cloud Engagement Developer Questions and Answers

To collect a representative sample from a larger data set, the developer should use the NTILE (C) SQL function. The NTILE function is used to distribute rows into a specified number of approximately equal-sized buckets or tiles, which can be useful for sampling purposes.

Example usage:

SELECT * FROM ( SELECT *, NTILE(10) OVER (ORDER BY SomeField) AS TileNumber FROM LargeDataSet ) AS Sample WHERE TileNumber = 1

This query divides the dataset into 10 tiles and selects rows from the first tile, effectively providing a sample.

To transform the date and time ' Data_Enrolled ' from Daylight Savings time and fall back one hour, the developer should use the following AMPscript function:

%%=DateAdd(Data_Enrolled, -1, ' H ' )=%%

This function subtracts one hour from the ' Data_Enrolled ' date and time.

When creating a Server-to-Server Installed Package and associated API Integration in Marketing Cloud, it is essential to grant specific scopes (permissions) to the API Integration component. This ensures that the integration has the necessary access to perform its tasks without granting unnecessary permissions.

Salesforce Installed Packages and API Integrations

The purpose of the IF statement in the AMPscript code is to check if any rows are returned by the LookupRows function. If rows are returned, it retrieves the image field from the data extension and sets the image source accordingly. If no rows are returned, it defaults to using a standard image.

Salesforce AMPscript LookupRows Function

To select a unique list of subscribers who have made multiple purchases, the developer should use the following SQL statement:

SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey HAVING COUNT(*) > 1

This query groups the records by SubscriberKey and selects only those groups where the count of records is greater than one, indicating multiple purchases.

A " 401 Unauthorized " error typically indicates an issue with authentication or permissions. Since the Client ID and Client Secret have been successfully used in other REST calls, the most likely cause is insufficient permissions for sending emails.

Check Send Permissions: Ensure that the appropriate permissions for sending emails have been granted to the Client ID and Client Secret in the Installed Packages. Without these permissions, the API call will fail with a 401 error.

Salesforce Installed Packages and Permissions

Using the RaiseError AMPscript function allows a developer to handle errors when necessary data for building an email is missing. The possible outcomes of using this function include:

The send fails (A) - The entire email send can be stopped if a critical error is encountered.

The email is not sent to the particular subscriber (B) - The send can be aborted for specific subscribers who do not have the necessary data.

The Contact Delete process in Marketing Cloud removes contact data from the contact model but does not remove records from the data extensions themselves.

Contact Delete Process: When you perform a Contact Delete in Contact Builder, it removes the contact data from the contact model but leaves the actual rows in the data extensions intact.

Salesforce Contact Deletion Process

Exclusion Scripts are used to exclude subscribers from email sends based on specific criteria. This functionality can be applied in various sending scenarios within Salesforce Marketing Cloud.

Journey Builder Send Email Activity: In Journey Builder, exclusion scripts can be applied to Email Activities to ensure specific subscribers are excluded based on the business rules.

Salesforce Journey Builder Email Activity

Content Builder Send Flow: When sending emails through Content Builder, exclusion scripts can be used to filter out subscribers who meet the exclusion criteria.

To write an Exclusion Script to exclude sending an email at send time when comparing against a Boolean field in the Sendable Data Extension, the developer can use:

%%SendBoo1 < 1 (B) - This script directly checks if the Boolean field SendBoo1 is less than 1, effectively excluding records where the field is false.

%%=Lookup( ' Excluded ' , ' SendBoo1 ' , ' Subscribekey ' , _Subscribekey) == false (C) - This script performs a lookup to check the value of SendBoo1 in the ' Excluded ' data extension, comparing it against the Subscribekey. If the value is false, the email is excluded.

To retrieve the value of the AMPscript variable named subKey in Server-Side JavaScript (SSJS), the following statement should be used:

Var.Get( " subKey " );

This statement retrieves the value of the specified AMPscript variable within SSJS.

To reference subscriber, system, and sendable Data Extension attributes for content personalization using SSJS, the correct syntax is < ctrl:field name= " attributeName " / > . This tag allows you to dynamically insert the value of an attribute into the email content.

< ctrl:field > Tag: This tag is used to insert the value of an attribute from a Data Extension or subscriber attribute into the content. The name attribute of the < ctrl:field > tag specifies which attribute ' s value should be used.

%%[ var @firstName set @firstName = AttributeValue( " FirstName " ) ]%% Hello, < ctrl:field name= " FirstName " / > !

Salesforce SSJS Guide

This syntax ensures that the correct personalization attributes are pulled into the email, enabling dynamic and personalized content based on subscriber data.

To export send data to their SFTP, the following automations can be used:

Tracking Extract > File Transfer (B) - This automation extracts tracking data and then transfers the file to an SFTP location.

Query (Data Views) > Data Extension Extract > File Transfer (C) - This automation queries the data views to gather the necessary data, extracts the data from the data extension, and then transfers the file to an SFTP location.

When configuring a Send Log Data Extension, it is crucial to follow best practices to ensure efficient tracking and data management.

Use Data Retention: Implementing data retention policies helps manage the volume of data stored in the send log, improving performance and reducing storage costs.

Limit Custom Fields: Limiting the number of custom fields to 10 or fewer helps maintain the efficiency and performance of the data extension.

Salesforce Send Log Data Extension

To determine if a specific text string exists in a tab-delimited list of values, the BuildRowSetFromString AMPscript function is the most appropriate. This function splits the string into a rowset, making it easier to search for the specific text.

BuildRowSetFromString Function: This function converts a delimited string into a rowset, which can then be iterated over or searched using other AMPscript functions.

SET @values = " val1\tval2\tval3 " SET @rowset = BuildRowSetFromString(@values, " \t " ) SET @rowCount = RowCount(@rowset) SET @found = " false " FOR @i = 1 TO @rowCount DO SET @row = Row(@rowset, @i) SET @value = Field(@row, 1) IF @value == " specificText " THEN SET @found = " true " /* exit the loop if found */ BREAK ENDIF NEXT @i

Salesforce AMPscript Function Reference

To build out a series of CloudPages that will interact with several REST APIs, the developer should use SSJS (Server-Side JavaScript) (C). SSJS is supported in Marketing Cloud and provides robust capabilities for interacting with external APIs, handling HTTP requests, and processing data.

To accurately identify subscribers who have unsubscribed from any of the child business units in an Enterprise 2.0 account, it is necessary to create data extracts of all subscribers within each child business unit. This approach ensures that unsubscribes specific to each business unit are captured.

Data Extracts: By creating data extracts within each child business unit, you can gather comprehensive unsubscribe data for all subscribers specific to each unit.

Salesforce Enterprise 2.0 Account Management

To ensure the expiration date on a coupon is the last day of the month, the developer should find the first day of the next month and subtract one day (A). This approach guarantees that the expiration date is set to the last day of the current month.

Example AMPscript:

SET @firstDayNextMonth = DateAdd(DatePart(Now(), " MM " ), 1, " M " ) SET @lastDayCurrentMonth = DateAdd(@firstDayNextMonth, -1, " D " )

To ensure the MobileConnect Contact is tied to the Email Contact when making a QueueMO call for an existing email subscriber, the parameter to include is emailaddress. This ensures that the MobileConnect Contact is correctly linked to the existing Email Contact.

For pushing real-time updates to a data extension, the following API options are available:

Use the DataExtensionObject SOAP object (A) - This object allows you to perform various operations such as insert, update, and delete on data extensions through SOAP API calls.

Use the DataExtension SOAP object (C) - Similar to DataExtensionObject, this object provides capabilities to manage data extensions and their records via SOAP API.

These APIs allow for real-time interaction with data extensions, making them suitable for updating the product catalog.

When logging unsubscribe events from a CloudPage using the LogUnsubEvent Execute Call, it ' s crucial to capture and provide both the SubscriberKey and the JobID. The SubscriberKey uniquely identifies the subscriber, while the JobID identifies the specific email job from which the subscriber is unsubscribing.

SubscriberKey: Identifies the subscriber in the Marketing Cloud.

JobID: Identifies the email job that triggered the unsubscribe event.

Salesforce LogUnsubEvent Documentation

To create a JavaScript Web Token (JWT) using a key from Key Management in Salesforce Marketing Cloud, the GetJWTByKeyName function should be used. This function generates a JWT using the specified key from Key Management.

Salesforce JWT Documentation

To append the subscriber ' s zip code to a link and ensure that the clicks are tracked, you should use the Lookup function to retrieve the zip code from the data extension and the RedirectTo function to create the link with tracking enabled.

Lookup: Retrieves the zip code from the data extension.

RedirectTo: Ensures that the link with the appended zip code is tracked.

Example:

ampscript

Copy code

%%[ SET @zipcode = Lookup( " DataExtensionName " , " zipcode " , " SubscriberKey " , _subscriberkey) SET @link = Concat( " http://example.com?zip= " , @zipcode) ]%% < a href= " %%=RedirectTo(@link)=%% " > Click Here < /a >

Salesforce AMPscript Lookup Function

Salesforce AMPscript RedirectTo Function

The " Overwrite " import operation is used when you want to completely replace the contents of a Data Extension with the contents of the import file. This operation adds new records from the file and removes any records that are not present in the file.

Overwrite Operation: This will ensure that the Data Extension contains only the records present in the CSV file. Any existing records in the Data Extension that are not in the file will be deleted.

Salesforce Marketing Cloud Import Activity

Switching to Tenant Specific Endpoints (TSEs) provides the benefit of improved API performance (D). Tenant Specific Endpoints are designed to provide optimized performance by ensuring that API calls are routed through endpoints that are dedicated to a specific tenant, reducing latency and potential congestion issues associated with shared endpoints.

To ensure the security of Client ID and Client Secret credentials, they should be stored securely and not exposed in the application source code or URL parameters.

Environment Variables: Setting credentials as environment variables in the application platform is a secure way to handle sensitive information. This method ensures that the credentials are not hardcoded in the source code and can be managed securely by the application platform.

Environment Variables

Key Management System (KMS): Storing credentials in a key management system (KMS) provides an additional layer of security. KMS solutions are designed to securely store and manage sensitive information such as API keys, passwords, and other credentials.

To ensure that clicks are tracked for a dynamic link created using AMPscript, the developer should wrap the link variable in a RedirectTo function and include an alias attribute for tracking purposes.

RedirectTo Function: This function helps ensure that the link click is properly tracked by Salesforce Marketing Cloud (SFMC). The function takes a URL and ensures that tracking parameters are appended correctly.

%%[ SET @dynamicLink = " http://example.com/?id= " + AttributeValue( " SubscriberID " ) ]%% < a href= " %%=RedirectTo(@dynamicLink)=%% " > Click Here < /a >

Salesforce AMPscript Functions - RedirectTo

Alias Attribute: Including an alias attribute provides a way to label the link, which assists in tracking and reporting.

< a href= " %%=RedirectTo(@dynamicLink)=%% " alias= " DynamicLink " > Click Here < /a >

To retrieve a row of data from a data extension using the SOAP API, the developer should use the DataExtensionObject API Object. This object allows for operations such as retrieving, updating, and inserting rows within a data extension.

To retrieve which subscribers were sent a particular email using the Marketing Cloud SOAP API, the developer should use the SentEvent (C) SOAP API object. This object records the event when an email is successfully sent to a subscriber.

The developer can find information about the available properties for the DataExtensionField SOAP API object in the Developer Center at https://developer.salesforce.com (B). The Developer Center provides comprehensive documentation and reference materials for Salesforce APIs, including the SOAP API.

To programmatically inject Contacts into a journey via the REST API, the recommended route is /interaction/v1/events. This endpoint allows you to trigger an event which can be configured to start a journey for the specified contacts.

When working with a REST API that returns data in JavaScript Object Notation (JSON) and needing to efficiently ingest the data and write it to a data extension, the developer should use the Server-Side JavaScript function ParseJSON. This function parses a JSON string and converts it into a JavaScript object, which can then be manipulated and written to a data extension.

To handle unexpected errors gracefully in a custom subscription center, wrapping the code in a Server-Side JavaScript (SSJS) Try/Catch block is recommended.

Try/Catch Block: Using a Try/Catch block in SSJS allows the developer to catch and handle exceptions, providing a mechanism to manage errors without disrupting the user experience.

SSJS Example:

< script runat= " server " > Platform.Load( " Core " , " 1 " ); try { // Code that may throw an error } catch (e) { // Handle the error Write(Stringify(e)); } < /script >

Salesforce Server-Side JavaScript (SSJS) Guide

To get a list of subscribers who were sent an email within the past 12 months, you should query the Job and Sent data views. These data views contain detailed information about email sends and can be used to filter subscribers based on the send date.

SQL Query Example:

SELECT s.SubscriberKey FROM _Sent s JOIN _Job j ON s.JobID = j.JobID WHERE j.SendDate > = DATEADD(month, -12, GETDATE())

Salesforce Data Views

The RedirectTo AMPscript function prevents link href values from getting recorded in tracking (C). When RedirectTo is used, it bypasses the standard link wrapping and tracking process, causing the link click not to be captured in the tracking data.

To secure a CloudPage and its elements (such as images) using SSL, a single SSL certificate can be used if both the CloudPage and the images are hosted under the same domain. This SSL certificate ensures that all content served from that domain is encrypted and secure.

Salesforce SSL Certificates

Before using the ' contacts/ ' route of the REST API to update records in a data extension, the developer should verify that the data extension should be linked in an AttributeGroup in Contact Builder (D). This ensures that the data extension is part of the contact model and can be accessed and updated using the REST API.

The IIF function in AMPscript is a shorthand way to perform conditional logic within an inline expression. It evaluates a condition and returns one of two values based on whether the condition is true or false.

AMPscript IIF Example:

%%=IIF(@level = ' premier ' , ' You are a premier member! ' , ' Upgrade to premier now! ' )=%%

Salesforce AMPscript IIF Function

To determine the best identifier for subscribers across all channels, Contact Key (A) should be recommended. The Contact Key is a unique identifier that can be used consistently across all channels, ensuring a unified view of the subscriber ' s interactions and data.

To execute daily reports on all subscriber activity without impacting send performance, the best practice is to copy new Send Log records to an Archive data extension, then run reports from the Archive data extension (C). This approach ensures that the reporting activity does not interfere with the performance of ongoing send operations.

The Contact Delete feature can be used within an Enterprise 2.0 account from the Parent account (B). This ensures centralized management and compliance with organizational data governance policies.

To dynamically populate the physical address of a company ' s locations using the variable @address and ensure the fastest possible performance for millions of subscribers, the recommended AMPscript solution is:

%%[ SET @address = Lookup( " Building_Locations " , " Address " , " Id " , @Id) ]%%

This solution uses the Lookup function, which retrieves a specific field value from a data extension based on the given criteria. It is efficient and performs well for high-volume sends.

To trigger an email send in Marketing Cloud when a purchase is made on a website, you can use either the REST API or the SOAP API. Both APIs provide methods to send triggered emails.

REST API: The REST API can be used to trigger emails by making a call to the /messaging/v1/messageDefinitionSends/{key}/send endpoint.

SOAP API: The SOAP API can also be used to trigger sends by utilizing the TriggeredSend object.

Salesforce Marketing Cloud REST API

Salesforce Marketing Cloud SOAP API

To successfully create a TriggerSend object using AMPscript ' s API functions, the following objects are required:

TriggerSendDefinition (B) - Defines the parameters of the triggered send, including the email to be sent and the associated attributes.

Subscribers (D) - Represents the individual recipients who will receive the email.

These objects ensure that the correct email is sent to the specified subscribers when the TriggerSend is executed.

Regarding the Marketing Cloud SOAP API, the following statements are true:

Most SOAP calls can be synchronous or asynchronous (B) - This means that API calls can either wait for the operation to complete (synchronous) or proceed with other tasks while waiting for the response (asynchronous).

Uses XML in request and response body (C) - The SOAP API utilizes XML for both requests and responses, providing a standardized format for data interchange.

The SubscriberKey is the appropriate parameter to use when appending data to links via the Web Analytics Connector. This parameter uniquely identifies subscribers across all sends and ensures accurate tracking of subscriber behavior.

Subscriber Key: A unique identifier for a subscriber that remains consistent across all data extensions and sends.

Salesforce Web Analytics Connector

In Salesforce Marketing Cloud, you can use either AMPscript or Server-Side JavaScript (SSJS) in email messages. Both languages are supported and can be used to manipulate data, create dynamic content, and perform other server-side operations.

Salesforce Programming Languages in Emails

The Balance field is a text field and contains the value " S6.96 " , which is a string. The IF statement is comparing a string with a numeric value (6.00). Since the operands are not of the same data type, this can yield unintended results. To correctly compare the balance, the string should be converted to a numeric value.

Example:

%%[ SET @Balance = " 6.96 " /* Simulating text field value */ IF (Value(@Balance) > 6.00) THEN SET @Result = ' Balance is more than $6.00 ' ENDIF ]%%

Salesforce AMPscript Data Types and Conversion

In the provided AMPscript, the IF statement checks the length of the @point variable and sets @value accordingly. Since x = ' Tacos ' has a length of 5, it meets the first condition Length(@point) > 1, which sets @value to 1. Subsequent conditions are not evaluated because the first condition is already true.

AMPscript IF-ELSEIF Example:

%%[ SET @point = RequestParameter( ' x ' ) SET @value = 5 IF Length(@point) > 1 THEN SET @value = 1 ELSEIF Length(@point) > 2 THEN SET @value = 2 ELSEIF Length(@point) > 3 THEN SET @value = 3 ELSEIF Length(@point) > 4 THEN SET @value = 4 ENDIF ]%%

Salesforce AMPscript Documentation

When preparing data to be used in Contact Builder, the following factors should be taken into consideration:

Assigning data relationships and primary keys across all channels (A) - This ensures that data is linked properly and can be utilized across different marketing channels.

Verifying data address marketing needs (B) - Ensuring that the data aligns with the marketing goals and requirements.

Normalizing data to reduce redundancy (E) - Organizing the data to eliminate duplicate entries and improve efficiency.

The Sent data view contains records of all emails that have been sent, including details such as JobID, EventDate, and other relevant information. To gather the required information about emails deployed in the last seven days, the Sent data view should be used.

Query Example:

SELECT JobID, EventDate, COUNT(*) as SentCount FROM _Sent WHERE EventDate > = DATEADD(day, -7, GETDATE()) GROUP BY JobID, EventDate

Salesforce Data Views

To populate a data extension with the date of the most recent click for each subscriber, the developer should use the following SQL query:

SELECT c.SubscriberKey, MAX(c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey

This query selects the SubscriberKey and the maximum eventDate for each subscriber from the _Click Data View, ensuring that the most recent click date is retrieved.

To retrieve tracking data for all sends associated with a specific JobID, including Sends, Opens, Clicks, and Bounces, the developer can use the following activities:

Tracking Extract Activity (A) - This activity extracts tracking data such as sends, opens, clicks, and bounces into a file, which can then be used for reporting or further processing.

SQL Query Activity (D) - This activity can query the data views to gather tracking data directly from the Salesforce Marketing Cloud databases. The developer can write SQL queries to select specific tracking information based on the JobID.