Salesforce MCC-201 Exam

To capture open-ended feedback via SMS and write it to a data extension, using a text-response message template with embedded AMPscript is the most suitable approach. This method allows for the dynamic handling and processing of the incoming SMS responses. The AMPscript can be programmed to parse the response and write the collected data to a specified data extension, making it an effective way to capture and store open-ended feedback. Reference: Salesforce MobileConnect documentation, AMPscript in MobileConnect

To format the JSON payload from their commerce platform within the email, Northern Trail Outfitters should use the BuildRowSetFromJSON() AMPscript function. The BuildRowSetFromJSON() AMPscript function is a function that allows marketers to parse a JSON string and return a rowset object that can be used to display data within an email message. The BuildRowSetFromJSON() AMPscript function can handle nested JSON objects and arrays. Reference: https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/buildrowsetfromjson.htm

The best solution for NTO's campaign is to use a Multi-Step journey with a Data Extension/Automation entry source. This setup allows for the segmentation and targeting of the specific subscribers as per the campaign requirements. Subscribers who have not engaged with previous emails can be identified and targeted. The journey can be configured to monitor open or click activities, and if a subscriber interacts after three messages, they can be automatically removed from the campaign. This approach provides a dynamic and automated way to manage the campaign's lifecycle based on subscriber behavior. Reference: Salesforce Journey Builder documentation, Data Extension and Automation Studio in Marketing Cloud

To format the JSON payload from their commerce platform within the email, Northern Trail Outfitters should use the BuildRowSetFromJSON() AMPscript function. The BuildRowSetFromJSON() AMPscript function is a function that allows marketers to parse a JSON string and return a rowset object that can be used to display data within an email message. The BuildRowSetFromJSON() AMPscript function can handle nested JSON objects and arrays. Reference: https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/buildrowsetfromjson.htm

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. Reference: https://help.salesforce.com/s/articleView?id=sf.mc_jb_journey_builder.htm&type=5 https://help.salesforce.com/s/articleView?id=sf.mc_as_automation_studio.htm&type=5