Automation using Cloud Pages and Journey Builder in SFMC

-

 

Restaurant Reservation Automation using Cloud Pages and Journey Builder in SFMC

In this task, we will build a complete automation flow using Cloud Pages, Data Extensions, Journey Builder, and Email Studio.

The objective is to learn how Cloud Pages capture user data, store it inside Data Extensions, and trigger automated emails using Journey Builder.

Learning Objective

This task helps understand:

  • Creating forms using Cloud Pages
  • Storing form submissions using AMPscript (InsertDE)
  • Using Data Extensions as Journey Entry Source
  • Sending automated confirmation emails
  • Difference between:
    • Main Data Extension
    • Cloud Page Data Extension

Method 1 — Using Main Data Extension

Step 1: Create Data Extension

Create:

Restaurant_Reservation_DE

Fields:

FieldType
SubscriberKeyText
FirstNameText
EmailAddressEmailAddress
ReservationDateDate


GuestsNumber

Screenshot: Data Extension Structure



Step 2: Create Email Template

Create reservation confirmation email.

Example:

Hello %%FirstName%%,

Your reservation is confirmed.

Date:
%%ReservationDate%%

Time:
%%ReservationTime%%

Guests:
%%Guests%%

Screenshot: Email Template Preview



Step 3: Create Cloud Page Form

Create reservation form with fields:

Name

Email

Reservation Date

Reservation Time

Guests

Store records inside:

Restaurant_Reservation_DE

Screenshot: Cloud Page Form



Step 4: Build Journey

Use:

Restaurant_Reservation_DE

as Journey Entry Source.

Journey Flow:

Restaurant_Reservation_DE

        ↓

Reservation Confirmation Email

        ↓

Exit

Screenshot: Journey Canvas



Result: Every reservation submission automatically triggers an email.

Method 2 — Using Cloud Page Data Extension

Instead of storing records directly inside the main DE, create another DE.

Create:

CloudPage_Reservation_DE

Fields:

FieldType
SubscriberKeyText
FirstNameText
EmailAddressEmailAddress
ReservationDateDate
ReservationTimeText
GuestsNumber

Screenshot: Cloud Page DE Structure



Step 2: Update Cloud Page

Change storage target from:

Restaurant_Reservation_DE

to:

CloudPage_Reservation_DE

Now form submissions will store records in the Cloud Page DE.

Screenshot: Cloud Page Code



Step 3: Create Journey

Journey Entry Source:

CloudPage_Reservation_DE

Journey:

CloudPage_Reservation_DE

        ↓

Reservation Confirmation Email

        ↓

Exit

Screenshot: Journey Builder Canvas



Result: Every form submission triggers automated email confirmation.

Final Architecture

METHOD 1

Cloud Page

      ↓

Restaurant_Reservation_DE

      ↓

Journey Builder

      ↓

Email



METHOD 2

Cloud Page

      ↓

CloudPage_Reservation_DE

      ↓

Journey Builder

      ↓

Email



Key Learning Outcome

Through this task we learned:

  • Cloud Pages can collect customer information.
  • Form submissions can be stored using Data Extensions.
  • Data Extensions can trigger Journey Builder automations.
  • Automated emails can be sent after every submission.
  • Cloud Pages can work with both:
    • Main Data Extensions
    • Dedicated Cloud Page Data Extensions

End-to-End Flow

Customer fills form

        ↓

Cloud Page

        ↓

Store data in DE

        ↓

Journey Entry Source

        ↓

Confirmation Email

This flow is commonly used in restaurant bookings, webinar registrations, event forms, reservations, and lead capture systems in Salesforce Marketing Cloud.

Comments

Post a Comment

Popular posts from this blog

Mastering CASE Statement in Salesforce Marketing Cloud (SFMC SQL)

-
Image
  Mastering CASE Statement in Salesforce Marketing Cloud (SFMC SQL) In Salesforce Marketing Cloud (SFMC) , data alone is not useful unless you can convert it into actionable marketing insights . This is where the CASE statement becomes powerful. It allows you to: Segment users Personalize campaigns Define marketing strategies Automate decision-making directly in SQL In this blog, I’ll walk through real-world SFMC use cases , along with queries and outputs , exactly how they are used in marketing scenarios. 📊 Dataset Used (Customer_Master) We are using a sample Data Extension: 🔹 What is CASE in SFMC SQL? The CASE statement works like IF-ELSE logic , helping marketers categorize users dynamically. 👉 Instead of manually creating segments, SQL does it for you.  Use Case 1: Age Group Segmentation 🧾 Query SELECT FirstName, CASE WHEN Age < 18 THEN 'Minor' WHEN Age BETWEEN 18 AND 40 THEN 'Adult' ELSE 'Senior' END AS ...
Read more

A/B Testing in Salesforce Marketing Cloud (Step-by-Step Guide)

-
Image
   A/B Testing in Salesforce Marketing Cloud (Step-by-Step Guide) A/B testing is one of the most powerful features in Salesforce Marketing Cloud that helps marketers optimize email performance using real data. In this blog, I’ll walk you through how I created A/B tests for: ✅ Subject Line ✅ Preheader Let’s dive in 👇 📌 Step 1: Create Two Email Variations The first step is to create two different email versions with: Different subject lines Different preheaders Different content These variations will be used for testing performance. Email A    Email B    📌 Step 2: Create a New A/B Test Go to A/B Testing Click on Create New Test Give your test a name Select Subject Line Test Browse and select both email versions Enter: "vs Subject Line" for testing Click Next 📌 Step 3: Select Recipients Now choose your audience: Select from: List Data Extension Data Filter You can also define: Publicati...
Read more

📧 Creating & Sending a Test Email in Salesforce Marketing Cloud (SFMC)

-
Image
  📧 Creating & Sending a Test Email in Salesforce Marketing Cloud (SFMC) In this task, I learned how to create an email template and send a test email using Email Studio in Salesforce Marketing Cloud. This is a fundamental skill for email marketing because it ensures your email looks perfect before sending it to real users. 🚀 Step-by-Step Process 1. Go to Email Studio Login to SFMC Navigate to Email Studio 👉 This is where all email-related activities like content creation, sending, and tracking are done. 2. Open Content Builder Click on the Content tab 👉 Content Builder is used to create and manage emails, images, and templates. 3. Create a New Email Click on Create Select Email Message 4. Choose Creation Option You will see multiple options: Template Template + AMP HTML HTML + AMP Text Only Existing Email 👉 We select: Template Reason: Easy drag-and-drop builder No coding required 5. Select Layout Choose ...
Read more