Day 11 Challenge Resources
A marketer at an outdoor gear company wants to add a section in their weekly email that shows a random summer trail destination in the subscriber’s city. The list of summer trail destinations is stored in a data extension called “Summer_Trails”. The marketer needs to create an AMPscript code to get a random summer trail destination and add it to the email.
For today’s challenge, you’ll need multiple data extensions. But don’t worry, I’ve got you covered! I’ve created some datasets that you can download: Subscribers, Summer_Trails
| FirstName | LastName | City | |
|---|---|---|---|
| john.doe@gmail.com | John | Doe | Los Angeles |
| jane.smith@yahoo.com | Jane | Smith | Chicago |
| sara.wilson@hotmail.com | Sara | Wilson | New York |
| mike.brown@gmail.com | Mike | Brown | Houston |
| emily.jones@hotmail.com | Emily | Jones | Miami |
| … | … | … | … |
| Trail | City |
|---|---|
| Mountain View Trail | Los Angeles |
| The Highline Trail | Denver |
| Mount Assiniboine Trail | Vancouver |
| Cirque of the Towers Trail | Seattle |
| Skyline Trail | Calgary |
| … | … |
Here is the email preview generated based on one of the sample records.
Hello,
Summer is here and it's the perfect time for a hike! We wanted to share some amazing trail destinations in your city to explore. Our team has picked out great trails that are perfect for every skill level.
One of the trails we recommend is The Bay Trail. It's perfect for hikers of all levels and offers breathtaking views of the surrounding landscape.
Best,
The Outdoor Equipment Company
Crafted with 💜 by AMPscript30.
AMPScripted Smiles Ltd.
456 Data Extension Drive Suite 321, Loop City,
Variable Valley, DE 12345