She chooses the Email Clicks data extension that holds the results of the query activity.Isabelle clicks Validate Syntax to make sure her SQL is constructed correctly.SELECT c.SubscriberKey, c.EventDate as, c.LinkName as Isabelle writes this SQL syntax for the query activity.Isabelle also adds a field that contains the unique tracking alias for the dynamic link in the first email message.This field provides the EmailID for the SQL statement that identifies the email message itself. Isabelle adds a field for the Email ID of the first message to the data extension.Isabelle adds the name, external key, and description to the query activity.In Automation Studio, click Activities.Follow along as she creates this activity. Isabelle navigates to Automation Studio in Marketing Cloud and creates a new query activity for this campaign. Create a Query Activity for Automation Studio Marketing Cloud isn't available in the Trailhead Playground. Don't try to follow these steps in your Trailhead Playground. Read along to learn how your admin would take the steps in a production org. If you’re not an admin for Marketing Cloud, that’s OK. In this module, we assume you are a Marketing Cloud admin with the proper permissions to create journeys and SQL activities. Let’s follow along as she builds the other components of her journey. But first, Isabelle creates her email messages and the Email Clicks data extension in Marketing Cloud. Instead, she needs to create a custom decision split. Since she’s using AMPscript in the links, she knows she can’t use a standard engagement split to drive her journey.
Automation studio vs journey builder registration#
If her contacts click the registration link in the first email, she doesn’t want to send any future invites to those contacts. These email messages use AMPscript in the links and URLs, and she’s given each link a unique tracking alias for the personalized VIP offer included. Her next campaign uses a single journey to deliver two invitation emails (though she might add more, if needed). She wants to invite VIP customers to an exclusive event. Isabelle Givens is the digital marketing manager for Northern Trail Outfitters. Create journey paths based on AMPscript links in an email.Develop the journey decision splits, goals, and entry settings.After completing this unit, you’ll be able to: