Salesforce Marketing Cloud Project | SFMC Aviation Booking History Email (Part 2 – AMPscript Logic) скачать в хорошем качестве

Salesforce Marketing Cloud Project | SFMC Aviation Booking History Email (Part 2 – AMPscript Logic)

In Part 2 of this Salesforce Marketing Cloud mini project, we implement the core AMPscript logic to send a personalized airline travel history email using the data model built in Part 1. This video focuses on real-world AMPscript usage, where passenger booking data is spread across multiple data extensions and must be dynamically retrieved inside the email. 🚀 In this video you will learn: • How to fetch Passenger ID from the sendable Data Extension • Use LookupRows() to retrieve booking history • Use RowCount() to check if a passenger has traveled or not • Implement IF / ELSE logic for conditional content • Loop through booking records using FOR loop • Extract values using Row() and Field() functions • Fetch related Flight and Airline details using nested Lookup() • Display dynamic output using the v() function 🧠 Business Logic Covered: • Show “Looks like you haven’t traveled with us yet” if no bookings exist • Show passenger travel history if bookings are available • Handle multiple bookings per passenger (one-to-many scenario) 🛠 This video is ideal for: ✔ Salesforce Marketing Cloud beginners ✔ Developers learning AMPscript ✔ SFMC Email Studio practitioners ✔ Anyone preparing for real-world SFMC projects or interviews 👉 Important: Make sure you watch Part 1 (Data Modeling) before this video, as all Contact Builder relationships and Data Extensions are already configured there. 🔔 Subscribe and stay tuned — Part 3 (E-commerce Domain Mini Project) is coming soon! #SalesforceMarketingCloud #SFMCProject #AMPscript #EmailPersonalization #LookupRows #ForLoop #EmailStudio #MarketingCloud