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

Download CSV
Email FirstName LastName City John Doe Los Angeles Jane Smith Chicago Sara Wilson New York Mike Brown Houston Emily Jones Miami
Download CSV
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.


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.

The Outdoor Equipment Company

Crafted with 💜 by AMPscript30.
AMPScripted Smiles Ltd.
456 Data Extension Drive Suite 321, Loop City, 
Variable Valley, DE 12345

Boost AMPscript Skills in Just 30 Days!

Whether you're just starting with AMPscript coding or looking to expand your skills, this challenge is for you!

[yikes-mailchimp form="1"]