Day 12 Challenge Resources

A car rental company has implemented a rewards program to incentivize customers to rent from their company. If a customer rents at least 10 times, they will receive 100 reward points. For customers who have booked 9 times, the rental company will include a message encouraging them to book one more time to receive the reward. The email will include the customer’s first and last name, as well as the amount of points they have earned. The company stores their car rental transactions in a separate data extension called Rental_Transactions, which is different from the subscriber data extension.

For today’s challenge, I highly recommend using the sample data extensions provided. This will allow you to spend more time with AMPscript: Subscribers, Rental_Transactions

Download CSV
Email FirstName LastName
james.bond@mi6.com James Bond
tony.stark@starkindustries.com Tony Stark
ellen.ripley@weyland-yutani.com Ellen Ripley
indiana.jones@marshall.edu Indiana Jones
harry.potter@hogwarts.edu Harry Potter
Download CSV
Email Count
james.bond@mi6.com 10
tony.stark@starkindustries.com 12
ellen.ripley@weyland-yutani.com 3
indiana.jones@marshall.edu 6
harry.potter@hogwarts.edu 9

This is just a sample copy, but if you create the correct AMPscript, this is how your email should look.

Hello Ellen Ripley,

Congratulations on renting from our car rental services! You have rented a total of 3 time(s) and you are 7 rent(s) away to earn 100 points..

Thank you for your continued loyalty to our business. We hope to see you soon!

Best regards,
The Next Auto 

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"]