Salesforce Marketing-Cloud-Consultant Dumps

To troubleshoot the connection between Sales Cloud and Marketing Cloud, a consultant should start by validating Marketing Cloud and Sales Cloud permissions for the connecting users. The connecting users are the users who authenticated Marketing Cloud Connect in both systems. They need to have certain permissions and roles in both systems to enable full functionality of Marketing Cloud Connect. References: &type=5

To configure specific data extensions, like Product Information, that are used by several business units (BU), Northern Trail Outfitters should share data extensions from the top-level BU. Sharing data extensions from the top-level BU allows marketers to grant access to common data sources across multiple child BUs without creating local copies or duplicating data. References: &type=5

A contact is a person who interacts with a brand across one or more channels, such as email, mobile, web, etc. A contact is identified by a contact key, which is usually the same as the subscriber key in Marketing Cloud or the contact or lead ID in Sales Cloud. When users register with the mobile app, they will create new contacts in Marketing Cloud with their device IDs as contact keys. However, these contacts will not be associated with their contact keys in Sales Cloud until they are synchronized through Marketing Cloud Connect, which can take up to 24 hours. Therefore, newly registered users will create additional contacts in Marketing Cloud until they are matched with their existing contacts in Sales Cloud. References: &type=5 &type=5

To report on ‘Not Sent’ contacts in Journey Builder, Northern Trail Outfitters should use the standard report ‘Subscribers Not Sent to’. This report shows how many contacts were not sent an email due to various reasons, such as unsubscribes, bounces, duplicates, or errors. References: &type=5

The email address that would appear as the From Address for the automatic reply to the customer is reply@marketingcloud.com. This is because Northern Trail Outfitters has configured their Reply Mail Management settings to forward replies to customerservice@nto.com and send an auto-reply message to the customer’s email address. The From Address for the auto-reply message is always reply@marketingcloud.com, regardless of the original From Address or the forwarding address. References: &type=5

Creating and enabling a BLOCKOUT window in MobileConnect can be used to prevent SMS messages from being sent during certain hours of the day. A BLOCKOUT window is a time period during which no messages are sent or received by MobileConnect, regardless of when they were scheduled or triggered. References: &type=5

Two solutions that could pull in the RSS feed at the time of send for Northern Trail Outfitters’ weekly email newsletter are:

• AMPscript. AMPscript is a scripting language that can be used to retrieve and display dynamic content from external sources, such as RSS feeds, in emails.
• External Content. External Content is a feature that allows marketers to create blocks of content from external sources, such as RSS feeds, in Content Builder.

Dynamic Content is not a solution for pulling in RSS feeds, as it is used to display different content based on subscriber attributes or rules. Personalization Strings are not a solution for pulling in RSS feeds, as they are used to display subscriber or account information in emails. References: &type=5

Three questions that are relevant to determining a solution for automating a process of importing data from a data warehouse into Marketing Cloud are:

• Is the data file a delta or a historical file? This question will help determine how to handle existing records and avoid duplication or overwrite. A delta file contains only new or updated records, while a historical file contains all records regardless of changes.
• Will the data file be placed on the SFTP at the same time daily? This question will help determine how to schedule an automation or trigger an event based on file drop. If the data file is placed on the SFTP at different times, then a File Drop Automation may be more suitable than a Scheduled Automation.
• Does someone need to be notified if an error happens on import? This question will help determine how to handle errors and exceptions during import. If someone needs to be notified, then an email notification activity or a verification activity may be added to the automation.

Whether the data extension has a data relationship or not is not relevant to determining a solution for importing data, as it is only used for creating relationships between data extensions in Email Studio. Whether the file has more than 5,000 rows or not is not relevant to determining a solution for importing data, as it does not affect how data is imported or processed. References: &type=5 &type=5

 To simplify the sending process using Marketing Cloud with as little additional setup as possible, the customer should create a journey and use Salesforce Data and the Reports object as the entry source. This will allow them to use their existing complex reports in Sales Cloud as criteria for injecting contacts into the journey and sending them emails. References: &type=5

A limitation that the consultant should consider when recommending Field-Level Encryption is that Field-Level Encryption doesn’t support segmenting, filtering, or querying encrypted fields. Field-Level Encryption is a feature that allows marketers to encrypt sensitive data in Marketing Cloud using encryption keys and algorithms. However, encrypted fields cannot be used for segmenting subscribers using filters or queries, as they cannot be evaluated or compared with other values. References: &type=5

A Sender Authentication Package (SAP) is a set of features that authenticate an email sender’s identity and reputation, such as a private domain, a dedicated IP address, a link customization, and a reply mail management. By having an additional SAP for the new domain comms.nto.com.au, NTO can send emails from their new domain without impacting deliverability. An additional IP address is not required if they already have one for their SAP. An additional private domain is not enough to authenticate their sender identity and reputation. Registering the new domain in From Address Management is not necessary if they have an SAP for the new domain. References: &type=5 &type=5

To select an audience of subscribers who have made purchases in the last 6 months, but are yet to be loyalty members, Northern Trail Outfitters should use Contact Builder Attribute Groups. Attribute Groups are collections of data extensions and data sources that are linked by common fields or attributes. Attribute Groups allow marketers to create segments and filters based on data from multiple sources, such as purchase data and loyalty data. References: &type=5

To connect relational data into their journey without overloading the entry data, Northern Trail Outfitters should use Data Designer. Data Designer is a tool that allows marketers to create attribute groups that link different data sources in Contact Builder. This way, they can access relational data in decision splits and other journey activities without having to include all the data in the entry source data extension. References: &type=5

To send an email to customers who need to reset their password on their website, Northern Trail Outfitters should use Transactional Messaging API. Transactional Messaging API is a tool that allows marketers to send transactional emails with high priority and reliability. The emails are sent as quickly as possible and can be personalized with dynamic content. The web server can receive a notification when the email is sent by using callbacks or tracking events. References: &type=5

To initiate sends when contacts for select accounts are created, Northern Trail Outfitters should use a Salesforce Data Entry Source on the Contact Object. A Salesforce Data Entry Source is a feature that allows marketers to inject contacts into a journey based on changes or events in Sales Cloud objects, such as contacts or accounts. Using a Salesforce Data Entry Source on the Contact Object will allow Northern Trail Outfitters to trigger sends when a contact record is created for a specific account. References: &type=5

Two considerations that should be made when using a File Drop Automation are:

• They may utilize an external FTP site. A File Drop Automation can be configured to use an external SFTP location as well as an Enhanced FTP location for file triggers.
• The directory is unable to be used by another File Drop Automation. A File Drop Automation can only use one directory for file triggers, and that directory cannot be used by another File Drop Automation.

The directory used by the file trigger can be inside or outside the import directory, as long as it is not used by another File Drop Automation. The directory can contain more than five file triggers, but only one file trigger can start an automation at any given time. References: &type=5

Using an import activity to import a file from the SFTP can be used to maintain an auto-suppression list. An import activity allows users to import data from a file on the Marketing Cloud FTP into a data extension or list. An auto-suppression list is a type of exclusion list that prevents subscribers from receiving certain types of messages based on criteria such as email address, subscriber key, or domain. References: &type=5 &type=5

To send SMS and push notifications together with emails as part of a new customer onboarding journey, Northern Trail Outfitters should use a GUID or another generated ID for Contact Key. A Contact Key is a unique identifier for each contact in Marketing Cloud across different channels and platforms. A GUID or another generated ID is recommended as a Contact Key because it is persistent, consistent, and channel-agnostic. References: &type=5

Datorama is a product that enables marketers to connect and unify their data sources, visualize and analyze their data, and optimize their marketing performance. Datorama can help NTO centralize their analytics data from Marketing Cloud, Sales Cloud, and other sources, and provide insights and recommendations to drive return on investment and growth via their marketing sends. References: &type=5

The subscriber key is a unique identifier for each subscriber in Marketing Cloud. It is used to track subscriber preferences, behaviors, and attributes across channels and business units. If the previous send used email address as a subscriber key, it would not match the subscriber key in Sales Cloud, which is usually the contact or lead ID. Therefore, the email opt out status would not be synchronized between Marketing Cloud and Sales Cloud, and the customer could receive an email through MCC even after unsubscribing from the previous send. References: &type=5

Publication List and Auto-Suppression List can be used to control what content is available to certain users and business units based on their preferences and send volume. A Publication List allows subscribers to opt in or out of different types of communications, while an Auto-Suppression List automatically excludes subscribers from receiving certain messages based on criteria such as frequency or content category. References: &type=5 &type=5

To provide near real-time data in a 30-day welcome journey, Northern Trail Outfitters should use contact data using synchronized data sources. This will allow them to access the most up-to-date data from their CRM system in decision splits and other journey activities. Journey data is static and based on the entry source data extension, which may not reflect recent changes in CRM. Contact data mapped through profile attributes or imported from CRM reports may not be as timely or accurate as synchronized data sources. References: &type=5 &type=5

A journey that allows re-entry after exiting can be used to have a periodic, dynamic newsletter send to a set data extension that changes from day-to-day. A journey with this setting can admit contacts into the journey multiple times as long as they meet the entry criteria. The View As Web Page link will not be broken when the audience is refreshed daily because the link is based on the Job ID and Subscriber ID, which are unique for each send. References: &type=5 &type=5

To send an SMS message and capture the responses in a data extension using AMPscript, Northern Trail Outfitters should use two MobileConnect templates: Text Response and Data Capture. Text Response is a template that allows marketers to send a text message to a mobile number and receive a reply. Data Capture is a template that allows marketers to use AMPscript to insert the reply into a data extension. References: &type=5 &type=5

To use the Ad Campaign Activity in a Journey Builder journey, Northern Trail Outfitters should enable Advertising Studio. Advertising Studio is a tool that allows marketers to create and manage advertising campaigns on different platforms, such as Facebook, Google, or Twitter. The Ad Campaign Activity is a feature of Advertising Studio that allows marketers to add contacts from a journey to an advertising audience and target them with relevant ads. References: &type=5 &type=5

To send an auto-reply message using a pre-defined HTML email when subscribers reply to an email, Northern Trail Outfitters should create a triggered send and from a sender profile properties page, enable ‘Custom Reply Mail Management Settings’, ‘Use Auto Reply’ and ‘Reply using triggered send’ options, then select the triggered send email. This will allow them to use a custom HTML email as an auto-reply message instead of a plain text message. References: &type=5 &type=5

To import new contacts gathered from an external web form at high frequency into Marketing Cloud, Northern Trail Outfitters should perform a daily bulk export to SFTP for import via automation. This will allow them to batch the contacts into one file per day and import them into Marketing Cloud using an automation that runs at a scheduled time. References: &type=5

To send emails to loyalty members based on recent activity, a contact data entry source can be used to segment the data based on attributes and filters configured in Contact Builder. This allows for more flexibility and scalability than using a data extension entry source with an applied filter. References: &type=5 &type=5

To choose a subscriber key for Marketing Cloud, Northern Trail Outfitters should use a value that is unique, persistent, and channel-agnostic. A CRM ID or a loyalty program number are both good options, as they meet these criteria and can be used to identify and track subscribers across different channels and platforms. Email and mobile device ID are not good options, as they are not unique or persistent (subscribers can change their email or device) and they are specific to one channel (email or mobile). References: &type=5

The LookupRows AMPscript function returns a rowset from a data extension that matches the specified criteria. It can be used to retrieve multiple rows of data from a data extension based on one or more column values. For example, NTO can use the LookupRows function to retrieve all rows from the second data extension that have the same session ID as the subscriber in the sendable data extension, and then loop through the rowset to display the product data for each abandoned cart item in the email. References: content.meta/mc-programmatic-content/lookuprows.htm

This personalization string is used to direct a subscriber to a web version of the email, allowing them to view the email online even if their email client does not support HTML. For more information on personalization strings, please see the documentation here:  &type=5.

The %%view_email_url%% personalization string is a system-generated link that allows subscribers to view a web page version of an email. It can be included as the href attribute in a ‘view online’ link in an email template to enable users to view the email in a browser if they have trouble viewing it in their email client. The %%view_as_webpage%% personalization string is deprecated and should not be used. The %%vawp%% personalization string is an alias for %%view_as_webpage%% and should not be used either. The %%view_online%% personalization string does not exist. References: &type=5 &type=5

Three tasks that a consultant would suggest for using Journey Builder instead of Automation Studio are:

• Building simple segmented campaigns without SQL queries. Journey Builder allows marketers to create simple segmented campaigns using filters and rules without writing SQL queries. Automation Studio requires SQL queries for creating complex segments using data extensions.
• Designing decision logic via an intuitive user interface. Journey Builder allows marketers to design decision logic using activities such as decision splits, engagement splits, or random splits via an intuitive user interface. Automation Studio requires scripting or coding for creating decision logic using activities such as script activities or verification activities.
• Setting behavior-based goals. Journey Builder allows marketers to set behavior-based goals using criteria such as email opens, clicks, conversions, or custom events. Automation Studio does not have a feature for setting behavior-based goals.

Processing zipped encrypted files containing subscriber data is a task that a consultant would suggest for using Automation Studio instead of Journey Builder, as Automation Studio has activities such as file transfer activities or import file activities that can handle zipped encrypted files. Creating customer segments from multiple data extensions is a task that a consultant would suggest for using Automation Studio instead of Journey Builder, as Automation Studio has activities such as query activities or filter activities that can create customer segments from multiple data extensions. References: &type=5 &type=5

To inject customers into journey B based on email engagement in journey A, Northern Trail Outfitters should use an engagement split followed by a contact activity in journey A. The engagement split can evaluate if customers opened or clicked the email in journey A. The contact activity can update a boolean field on an engagement data extension that indicates if customers are eligible for journey B. Then, an automation can run a query activity to select the customers who have the boolean field set to true and inject them into journey B. References: &type=5 &type=5

To maintain a good sender reputation, Northern Trail Outfitters should have one dedicated IP address for every 100,000 messages send per month. This will help them avoid IP throttling and blacklisting issues. A shared IP address is not recommended for their volume, and having multiple SAPs for different types of sends is not necessary. They should also send consistently and avoid large spikes or drops in their sending volume. References: &type=5 &type=5

To separate subscriber opt-outs of the Enterprise and children’s brands, Northern Trail Outfitters should select “Subscribers will be unsubscribed from this business unity only” in Settings for each child business unit. This will allow subscribers to unsubscribe from one brand without affecting their subscription status for another brand. References: &type=5

Two best practices that should be utilized for configuring customer data for long-term cleanliness and maintainability are:

• When using an external database of record, utilize that system’s identifier as the contact key. This will ensure that contacts can be identified and tracked across different channels and platforms using a consistent and persistent value.
• Define the subscriber key as a unique value that does not relate to a specific channel. This will allow contacts to change their email or mobile device without affecting their subscriber key or losing their tracking history.

Configuring Contact Builder to automatically generate a unique subscriber key is not recommended, as it may create duplicate or inconsistent records if contacts already have an identifier in another system. Regularly merging duplicate contacts is not a best practice, but rather a remedial action that should be avoided by using proper data hygiene techniques. References: &type=5

The Transactional Messaging API can be used to send email to customers who log in for the first time on a new IP. The Transactional Messaging API allows for fast and reliable delivery of transactional messages, such as password resets, order confirmations, or account alerts. The message can include information related to the login IP by using personalization strings or AMPscript variables. References:

A query activity is an automation studio activity that allows querying data from data extensions or data views using SQL statements. A data extension entry source is a journey builder entry source that allows injecting contacts into a journey based on a data extension. Journey activities are actions that occur within a journey, such as sending an email or updating a contact attribute. By using a query activity to filter contacts who have not made a purchase in the last six months from their order data extension, NTO can create a sendable data extension with those contacts and use it as a data extension entry source for their journey. Then, by using journey activities, they can communicate the same message across all channels to those contacts. References: &type=5 &type=5 &type=5

To send an email with 10 personalized fields from multiple data extensions to an audience of over one million subscribers, Northern Trail Outfitters should create and send to a sendable data extension containing those needed fields using a query activity. A query activity can join and filter data from multiple data extensions and populate a sendable data extension with the required fields for personalization. This will improve the email send performance and avoid timeouts or errors. References: &type=5 &type=5

MobileConnect Demographics is a data source that is supported to personalize SMS messages. MobileConnect Demographics is a system-generated attribute group that contains information about mobile subscribers, such as phone number, locale, status, keyword, and source. This information can be used to insert personalization strings or AMPscript variables into SMS messages. References: &type=5 &type=5

To integrate a new dataset with pre-existing contacts, Northern Trail Outfitters should create a new data extension and link it to the other data extension. A data extension is a table that stores data in Marketing Cloud, such as contact information or purchase history. Data extensions can be linked by common fields or attributes using Contact Builder or SQL queries. References: &type=5

To fulfill the requirement that the data in the sandbox should never be mixed with data in production during testing cycles, Northern Trail Outfitters should implement two separate Marketing Cloud instances. A Marketing Cloud instance is an independent environment that contains its own data, configuration, and functionality. Having two separate instances for sandbox and production will ensure data isolation and security during testing cycles. References: &type=5

To ensure there’s a limit to the number of times a particular image asset can be chosen for a customer, Northern Trail Outfitters should set fatigue rules for the product asset classes. Fatigue rules are settings that allow marketers to control how often an asset can be selected for a customer within a specified time period. For example, a fatigue rule can prevent an asset from being selected more than once in 14 days. References: &type=5

A filtered keyword list is a list of words or phrases that trigger an automated response when a subscriber replies with them to an email. For example, if “take me off your list” or “opt out” are added to a filtered keyword list with an unsubscribe action, any subscriber who replies with those phrases will be automatically unsubscribed from future emails. This can help NTO handle manual unsubscribe requests more efficiently and avoid sending unwanted emails to their customers. References: &type=5 &type=5