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.
SubscriberKey | 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