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
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 |
… | … | … |
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