Tavern Group – Personalized Welcome Email Series

A personalized three-part welcome email series developed for Tavern Group, a hospitality brand managing five different pub venues. Built using Salesforce Marketing Cloud (SFMC), AMPscript, and HTML/CSS.

Description

A personalized three-part welcome email series developed for Tavern Group, a hospitality brand managing five different pub venues. Built using Salesforce Marketing Cloud (SFMC), AMPscript, and HTML/CSS.

The project demonstrates dynamic email personalization, conditional messaging, data transformation, and the retrieval of venue-specific content from multiple Data Extensions.

Scenario

Tavern Group wants to create a personalized onboarding experience for new members who sign up at one of its five pub venues.

The goal is to welcome new members, introduce them to upcoming events, and encourage repeat visits through exclusive promotional offers.

The email series consists of three communications:

Initial Welcome Email: Sent on the day of registration.
Educational Email: Sent 3 days after the initial welcome email.
Discount Offer Email: Sent 7 days after the initial welcome email.

Each email must dynamically display information relevant to the member's registered venue, allowing the same email templates to support multiple venues without creating separate campaigns.

Requirements

Personalization

Greet each member by their first name.
Display venue-specific branding, including the venue name and logo.
Retrieve venue details such as address, contact information, and manager's name.
Personalize email subject lines based on member and venue information.
Generate a unique discount redemption code using the venue's voucher prefix and the member's ID.

Conditional Messaging

Display a fallback greeting when a member's first name is missing.
Adjust the subject line depending on whether the member's name is available.
Handle venue names that already begin with "The" to avoid duplicate wording.
Apply validation logic to handle missing records in Data Extensions.

Data Transformation

Format member names using proper capitalization.
Remove unnecessary spaces from text values.
Format event dates into a reader-friendly format.
Calculate the number of days remaining until an event.
Combine the venue voucher prefix and member ID to create a unique redemption code.

Dynamic Content

Dynamically display the correct venue logo and branding.
Insert venue-specific event details, including the event name, date, description, and URL.
Personalize the welcome message using the venue manager's name.
Include venue-specific contact details and social media links.
Display a personalized 20% discount offer and redemption code.

AMPscript Features

Personalization
Conditional Messaging
Data Transformation
Dynamic Content
Data Extension Lookups
Dynamic Subject Lines
Date Formatting and Calculations
Error Handling

AMPscript Features

Personalization
Conditional Messaging
Data Transformation
Dynamic Content
Data Extension Lookups
Dynamic Subject Lines
Date Formatting and Calculations
Error Handling

Add paragraph text. Click “Edit Text” to update the font, size and more. To change and reuse text themes, go to Site Styles.