Day 15 Challenge Resources
An auto shop plans to send emails to customers every six months and recommend services based on their car’s mileage at the time of the last service. The recommended services are stored in a separate database, and a marketer wants to dynamically display these services in the email for each customer.
We have some new columns that store lengthy content, make sure to set the field length accordingly. Subscribers, Services
| FirstName | LastName | Mileage | |
|---|---|---|---|
| james.bond@mi6.com | James | Bond | 40000 |
| tony.stark@starkindustries.com | Tony | Stark | 60000 |
| ellen.ripley@weyland.com | Ellen | Ripley | 80000 |
| indiana.jones@marshall.edu | Indiana | Jones | 80000 |
| … | … | … | … |
| Mileage | Name | Description |
|---|---|---|
| 40000 | Oil Change | Replace the oil in a car’s engine. |
| 40000 | Fluid Checking | Check the levels of various fluids in a car such as brake fluid and coolant. |
| 40000 | Tires Rotating | Switch the position of a car’s tires to ensure even wear and tear. |
| 60000 | Oil Change | Replace the oil in a car’s engine. |
| … | … | … |
To test this challenge, send a test email and check if the Reconfirmation_Log data extension has been populated.
Hi James Bond,
As we enjoy the remaining days of summer, its time to think about getting your vehicle ready for fall adventures and winter road trips. Now is a great time to check major components like tires, brakes and batteries to help give you confidence on the roads as the days get shorter and the weather begins to change.
Here are recommended services:
- Oil Change: Replace the oil in a car's engine.
- Fluid Checking: Check the levels of various fluids in a car such as brake fluid and coolant.
- Tires Rotating: Switch the position of a car's tires to ensure even wear and tear.
Visit your nearby Next Auto dealer for all your vehicle needs.
Best regards,
Next Auto
Crafted with 💜 by AMPscript30.
AMPScripted Smiles Ltd.
456 Data Extension Drive Suite 321, Loop City,
Variable Valley, DE 12345