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: https://docs.google.com/forms/d/e/1FAIpQLSd818LIrzBEFaoA0h0PWgMZGWcRMPg_k_5t5cIIpMfia0-wmQ/viewform?usp=pp_url&entry.1345373543=James&entry.1970641631=Bond&entry.1109494443=james.bond@mi6.com. You need to populate the fields highlighted in bold using AMPscript code.

Download CSV
SubscriberKey Email FirstName LastName SurveyUrl
9083 james.bond@mi6.com James Bond https://docs.google.com/forms/d/e/1FAIpQLSd818LIrzBEFaoA0h0PWgMZGWcRMPg_k_5t5cIIpMfia0-wmQ/viewform?usp=pp_url
5367 tony.stark@starkindustries.com Tony Stark https://docs.google.com/forms/d/e/1FAIpQLSd818LIrzBEFaoA0h0PWgMZGWcRMPg_k_5t5cIIpMfia0-wmQ/viewform?usp=pp_url
2961 ellen.ripley@weyland.com Ellen Ripley https://docs.google.com/forms/d/e/1FAIpQLSd818LIrzBEFaoA0h0PWgMZGWcRMPg_k_5t5cIIpMfia0-wmQ/viewform?usp=pp_url
8753 indiana.jones@marshall.edu Indiana Jones https://docs.google.com/forms/d/e/1FAIpQLSd818LIrzBEFaoA0h0PWgMZGWcRMPg_k_5t5cIIpMfia0-wmQ/viewform?usp=pp_url
5619 harry.potter@hogwarts.edu Harry Potter https://docs.google.com/forms/d/e/1FAIpQLSd818LIrzBEFaoA0h0PWgMZGWcRMPg_k_5t5cIIpMfia0-wmQ/viewform?usp=pp_url

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: https://docs.google.com/forms/d/e/1FAIpQLSd818LIrzBEFaoA0h0PWgMZGWcRMPg_k_5t5cIIpMfia0-wmQ/viewform?usp=pp_url&entry.1345373543=James&entry.1970641631=Bond&entry.1109494443=james.bond@mi6.com 
 
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!

[yikes-mailchimp form="1"]