Day 14 Challenge Resources
A media company wants to send an email to its subscribers every six months to confirm their interest in receiving emails. A marketer needs to set up code in the email so that it automatically updates a separate data extension and records when the newsletter reconfirmation email is sent.
When importing data for this challenge, make sure to define a primary key for data extensions properly. Subscribers, Reconfirmation_Log
| 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 |
| … | … | … |
| SubscriberKey | FirstName | LastName | SendDate | |
|---|---|---|---|---|
| 9083 | james.bond@mi6.com | James | Bond | 2023-04-12 |
| 5367 | tony.stark@starkindustries.com | Tony | Stark | 2023-04-03 |
| 2961 | ellen.ripley@weyland-yutani.com | Ellen | Ripley | 2023-03-08 |
| 8753 | indiana.jones@marshall.edu | Indiana | Jones | 2023-03-11 |
| … | … | … | … | … |
To test this challenge, send a test email and check if the Reconfirmation_Log data extension has been populated.
Hi Han,
We hope you've been enjoying our services over the past few months. We wanted to remind you that we periodically ask our customers to confirm their interest in receiving our emails.
If you're still interested in receiving our emails, please click the link below to confirm your subscription. It only takes a few seconds!
Confirm Subscription
Thanks for being a valued customer. We look forward to continuing to serve you.
Best regards,
Next Media
Crafted with 💜 by AMPscript30.
AMPScripted Smiles Ltd.
456 Data Extension Drive Suite 321, Loop City,
Variable Valley, DE 12345