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

Download CSV
Email FirstName LastName James Bond Tony Stark Ellen Ripley Indiana Jones Harry Potter
Download CSV
SubscriberKey Email FirstName LastName SendDate
9083 James Bond 2023-04-12
5367 Tony Stark 2023-04-03
2961 Ellen Ripley 2023-03-08
8753 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

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