Day 20 Challenge Resources

A rental company sends a survey to its customers after each booking. The company has recently switched to Marketing Cloud, and would now like to direct customers to a Google form while pre-filling the First Name, Last Name, and Email fields on the form. The marketing team stores survey URLs, along with customer information, in a data extension.

For this challenge, we will be using a Google Form URL and pre-filling the form fields upon page load. The Google Form URL appears as follows: You need to populate the fields highlighted in bold using AMPscript code.

Download CSV
SubscriberKey Email FirstName LastName SurveyUrl
9083 James Bond
5367 Tony Stark
2961 Ellen Ripley
8753 Indiana Jones
5619 Harry Potter

You can use the email copy below to compose your email.

Hi JamesBond,
Thank you for choosing Next Rental. We value your business and want to improve our services to better serve you. 

Please take a moment to complete a short survey about your recent rental. Your feedback helps us to enhance our services. 

Take the survey: 
Thank you for your time and feedback. We look forward to serving you again. 

Best regards,
Next Rental 

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!