Marketing-Cloud-Developer Questions and Answers

To trigger an SMS message to a subscriber using a form published on CloudPages, the developer should use therequestToken and messageContact REST API objects (D). These objects can be used to authenticate and send the SMS message programmatically when the form is submitted.

References:

• Salesforce Marketing Cloud MobileConnect API
• Salesforce Marketing Cloud REST API

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

References:

• Salesforce Marketing Cloud SOAP API
• SentEvent Object

The error stating that the application cannot insert a duplicate value for the primary key in the data extension occurs becausethe InsertDE function cannot be used at send time. The InsertDE function is designed to insert records into a data extension, but it cannot handle the transactional nature of email sends where records might be added simultaneously.

References:

• Salesforce Marketing Cloud AMPscript InsertDE Function
• Salesforce Marketing Cloud Data Extension Best Practices

To add new customers to a cross-channel welcome campaign when they register on the company website, theJourney Builder API (D)should be used. This API allows you to programmatically inject contacts into a journey, triggering personalized marketing interactions across multiple channels.

References:

• Salesforce Marketing Cloud Journey Builder API
• Cross-Channel Campaign Management

To ensure a blank email will not be sent when creating a complex dynamic email with multiple sections and content blocks, the developer shouldconfirm every version has default content (D). This practice ensures that if any dynamic content fails to load or meet the conditions, the default content will be displayed, preventing a blank email from being sent.

References:

• Salesforce Marketing Cloud AMPscript Guide
• Salesforce Marketing Cloud Dynamic Content Best Practices

Content Builder uses the REST API to manage content within Salesforce Marketing Cloud. The REST API allows developers to create, update, retrieve, and delete content assets, making it suitable for cross-channel campaign functions.

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

References:

• Salesforce Marketing Cloud Documentation on Contact Delete
• Enterprise 2.0 Account Management

Data extension functions in AMPscript, such asLookupRows,LookupOrderedRows, andUpdateDE, can most negatively impact send processing because they involve querying and manipulating data extensions. These operations can be resource-intensive and time-consuming, especially when dealing with large data sets.

To ensure that contacts relate across different channels in Marketing Cloud, you need to link the unique identifier used across channels to the Contact ID in Contact Builder. This involves creating Attribute Groups and establishing the relationships between the unique identifier and the Contact ID.

• Link the Numeric Field Value: By linking the numeric unique identifier to the Contact ID in Attribute Groups, you ensure that each contact is uniquely identified across channels.
• Create Attribute Groups: Attribute Groups in Contact Builder allow you to map the relationships between different data sources and the Contact object, ensuring that the unique identifier is connected correctly for each channel.

To include Server-Side JavaScript (SSJS) in an email message, you need to use the<script>tag with therunat="server"attribute. This ensures that the script runs on the server side before the email is sent.

• : This is a valid way to include SSJS in an email. It specifies that the enclosed code should be executed on the server.

Platform.Load("Core","1");varrows =Platform.Function.LookupRows("DataExtensionName","EmailAddress","example@example.com");

• uk.co.certification.simulator.questionpool.PList@1c42a7e0

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.

To optimize a query activity that is currently timing out, a developer can use the following strategies:

• Use Primary key(s) on fields used in joins (C)- Ensures that the join operations are efficient by utilizing indexed fields.
• Use intermediate tables to stage data (D)- Breaks down complex queries into simpler steps, improving manageability and performance.
• Only update records that have changed since last execution (E)- Reduces the amount of data processed by focusing only on changes since the last query run.

References:

• Salesforce Marketing Cloud SQL Optimization
• Query Activity Best Practices

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.

References:

• Salesforce Marketing Cloud Documentation on Contact Builder
• Data Preparation Best Practices

=========================

To determine if a specific text string exists in a tab-delimited list of values, theBuildRowSetFromStringAMPscript 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

TheRedirectToAMPscript functionprevents link href values from getting recorded in tracking (C). WhenRedirectTois used, it bypasses the standard link wrapping and tracking process, causing the link click not to be captured in the tracking data.

References:

• Salesforce Marketing Cloud AMPscript Guide
• Link Tracking in Marketing Cloud

To successfully create a TriggeredSend object using AMPscript's API functions to send a confirmation email when an email is texted into their shortcode, the following objects are required:

• Subscribers (A)- Represents the individual recipients who will receive the triggered email.
• TriggeredSendDefinition (B)- Defines the parameters of the triggered send, including the email to be sent and the associated attributes.

References:

• Salesforce Marketing Cloud Triggered Send
• Salesforce Marketing Cloud AMPscript API Functions

To track different versions of content within an email using dynamic content contained in a series of conditionals, the marketer should use theBeginImpressionRegionAMPscript function. This function marks the beginning of a region of content to track impressions, making it easier to analyze which versions of the content were viewed.

References:

• Salesforce Marketing Cloud AMPscript Guide: BeginImpressionRegion
• Tracking Dynamic Content in Emails

To successfully create aTriggerSendobject 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.

References:

• Salesforce Marketing Cloud API
• AMPscript API Functions

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 isemailaddress. This ensures that the MobileConnect Contact is correctly linked to the existing Email Contact.

References:

• Salesforce Marketing Cloud MobileConnect API
• AMPscript and MobileConnect

Before importing a compressed file into Marketing Cloud, a File Transfer activity is required to move and decompress the file. The File Transfer activity allows you to specify the source and destination locations and to decompress the file, making it ready for the import process.

When an email is sent to a list where subscribers have no associated Subscriber Key, Marketing Cloud will use the Email Address as the Contact Key by default. This ensures that each subscriber can still be uniquely identified even if they do not have a predefined Subscriber Key.

A Query Activity in an Automation can fail for several reasons, including:

• The query takes more than 60 minutes to run (A)- Long-running queries are subject to timeouts, which can cause the query to fail.
• The query results in duplicate rows not allowed by the primary key (C)- If the query attempts to insert duplicate rows into a data extension that has a primary key constraint, it will fail.
• The query is inserting a value that is larger than the size of a field (E)- If the query attempts to insert data that exceeds the field size limits, it will result in an error.

References:

• Salesforce Marketing Cloud Query Activity
• Salesforce Marketing Cloud SQL Best Practices

The SQL statement in question does not return any records because it is joining on theEmailAddressfield, which is not present in the_BounceData View. The correct approach is to join using theSubscriberKey(orSubscriberID). Here is the corrected SQL statement:

SELECTs.EmailAddress, s.SubscriberKey, b.JobID, b.EventDate, b.SMTPBounceReasonFROM_Subscribers sJOIN_Bounce bONs.SubscriberKey=b.SubscriberKeyWHEREb.EventDate>DateAdd(DAY,-30, GETDATE())

This ensures that the join is based on theSubscriberKey, which is a common field in both data views.

References:

• Salesforce Marketing Cloud Data Views
• Query Activity Best Practices

In Salesforce Marketing Cloud, landing pages can use the Core Library and the Platform Library of Server-Side JavaScript (SSJS). The Core Library provides fundamental functions, while the Platform Library provides additional functionality to interact with Marketing Cloud-specific features.

• Core Library: Provides basic SSJS functionality.
• Platform Library: Extends SSJS functionality with additional methods specific to Marketing Cloud.

AMPscript is evaluated in the following order before an email is sent:

• Subject Line: Evaluates AMPscript in the subject line first.
• HTML Body: Evaluates AMPscript within the HTML body of the email.
• Text Body: Evaluates AMPscript within the text body of the email.

This order ensures that any dynamic content or personalization logic is correctly applied in all parts of the email.

A File Drop Automation should be configured to handle files that arrive at varying times and have unique filenames. This type of automation triggers when a file is dropped into a specific folder on the Enhanced FTP site, allowing the system to handle imports as soon as the file arrives.

An Exclusion Script is used to exclude certain subscribers from an email send based on defined criteria. It can also log or capture details of those excluded addresses for reporting purposes.

• Exclusion Script: This script runs before the send and can dynamically exclude recipients based on logic you define. It allows you to prevent competitors from receiving the email and to log their email addresses.

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.

When importing data files to Marketing Cloud, the supported file encryption options are:

• PGP encryption (A)- Pretty Good Privacy (PGP) encryption is supported for securing files.
• AES encryption (D)- Advanced Encryption Standard (AES) encryption is also supported for file security.

References:

• Salesforce Marketing Cloud File Import Activity
• File Transfer and Encryption Options

Content Builder uses the REST API to manage content within Salesforce Marketing Cloud. The REST API allows developers to create, update, retrieve, and delete content assets, making it suitable for cross-channel campaign functions.

To control the rendering of unique and default content based on the presence of subscriber data in a related data extension, the best practice is to use theRowCountfunction and anIFstatement:

%%[ VAR @rowCount SET @rowCount = RowCount(LookupRows("RelatedDataExtension", "SubscriberKey", _subscriberKey)) IF @rowCount > 0 THEN /* Render unique content */ ELSE /* Render default content */ ENDIF ]%%

This approach checks if there are any rows in the related data extension for the subscriber and conditionally renders the appropriate content.

References:

• AMPscript Guide
• Salesforce Marketing Cloud Documentation

When configuring an automation to import files placed on the SFTP, and starting the automation based on a file matching a specific naming pattern, the substitution string that represents the name of the file is%%TRIGGER_FILENAME%%. This substitution string is used to reference the filename of the triggering file in the File Import Activity.

References:

• Salesforce Marketing Cloud Documentation on Automation Studio
• File Import Activity

To ensure that emails are not sent to a competitor, the best practices are:

• Suppression List: Create a Suppression List that includes all possible email addresses from Rainbow Run. This list will prevent these email addresses from receiving emails.
• Exclusion Script: Create an Exclusion Script that checks the domain of the email address and excludes addresses from Rainbow Run.

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.

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.

References:

• Salesforce Marketing Cloud SOAP API Overview
• Salesforce SOAP API Developer Guide

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.

When importing an encrypted file from the Enhanced FTP server, you need to move the file to the Safehouse first, and then decrypt it within the Safehouse.

• Move to Safehouse: Use a File Transfer activity to move the encrypted file from the Enhanced FTP server to the Safehouse.
• Decrypt in Safehouse: Use another File Transfer activity to decrypt the file within the Safehouse.

To validate that a parent-level data extension can be accessed by a child business unit, the developer should ensure thatthe data extension is in the Shared Data Extensions folder and the query includes the ENT. prefix (A). This setup allows shared data extensions to be accessible across different business units.

References:

• Salesforce Marketing Cloud Shared Data Extensions
• Query Activities with Shared Data Extensions

To add an image to Content Builder via the API and retrieve the image's published URL, the developer shouldPOST to the REST API/asset/v1/content/assets and parse the FileProperties parameter (D). This method uploads the image and returns metadata, including the published URL, which can be extracted from the FileProperties.

References:

• Salesforce Marketing Cloud REST API: Content Builder
• Salesforce Marketing Cloud Asset API

To retrieve the value of the AMPscript variable namedsubKeyin 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.

References:

• Salesforce Marketing Cloud SSJS Guide
• AMPscript and SSJS Integration

The Event Notification Service (ENS) in Salesforce Marketing Cloud provides real-time event notifications, such as email opens and clicks. Using ENS, Northern Trail Outfitters can trigger follow-up messages based on real-time engagement data.

To configure a data extension to store data for six months, you should update the data extension configuration to include data retention settings.

• Data Retention Settings: You can configure data retention directly within the data extension settings in Email Studio to specify how long data should be retained. This ensures that data older than the specified period is automatically deleted.

In Marketing Cloud, theContact Keyshould be represented as a Text data type, even if it is a numeric value. This is because using the Text data type avoids issues related to numeric value formatting and allows for greater flexibility in handling the values.

The purpose of the IF statement in the AMPscript code is to check if any rows are returned by theLookupRowsfunction. 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.

After using themessageDefinitionSendsREST API endpoint to send a triggered send email, and receiving a 202 (success) response code, the developer can validate if the email was successfully sent by using themessageDefinitionSend/key:(key)/deliveryRecordsREST endpoint with the GET method. This endpoint provides delivery records and allows verification of the email's delivery status.

References:

• Salesforce Marketing Cloud REST API Reference
• Triggered Send Email Validation

The Contact Delete process in Marketing Cloud removes contact data from various locations to ensure complete deletion. This includes both sendable data extensions and mobile lists.

• Sendable Data Extensions: The Contact Delete process will remove contact data from sendable data extensions, ensuring that the contact is no longer present in any data used for sending.
• Mobile Lists: Contact data will also be removed from mobile lists, ensuring that the contact is fully deleted across all communication channels.

A 401 Unauthorized HTTP status message indicates that the request was not authenticated properly. This error commonly occurs when the access token is missing, invalid, or expired.

• Access Token Issues: The most common cause of a 401 error in REST API requests is related to the access token. The request must include a valid access token in the authorization header.

To manage the data model programmatically and access the Attribute Group schema, the REST API should be used. The REST API provides endpoints to interact with and retrieve information about Attribute Groups and their schemas.

When using the REST API to send emails to customers after a purchase, the developer shouldmake a token API call and re-use the token until the token expires (D). This approach optimizes API usage by reducing the number of token requests, ensuring that the token is reused until it naturally expires, after which a new token can be requested.

References:

• Salesforce Marketing Cloud API Authentication
• Token Management Best Practices