Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In AMPscript, I need help with the coding part of this exercise. I need the code for the pre - fill and the update. Please

In AMPscript, I need help with the coding part of this exercise. I need the code for the pre-fill and the update. Please don't provide an AI generated solution, as they do not work :
1. Create four Data extensions:
"Subscribers" with subscriber attributes: SubscriberKey, FirstName, LastName, EmailAddress, PhoneNumber, BirthDate, Gender, Country, LastUpdated Date
*"Newsletter" with information about newsletter subscribers: SubscriberKey, Subscribed (true/false), LastUpdatedDate
*"SpecialOffers" with information about newsletter subscribers: SubscriberKey, Subscribed (true/false), LastUpdatedDate
*"Events" with information about newsletter subscribers: SubscriberKey, Subscribed (true/false),LastUpdatedDate
1.Fill data in above data extensions with dummy data
2.Create a simple email with a link at the bottom that says Update your preferences" which takes the subscribers to the Custom Profile & Subscription Center you are going to build.
Create a Custom Profile & Subscription center on a CloudPage with the following fields:FirstName (text field),
LastName (text field),
EmailAddress (text field),PhoneNumber (text field),BirthDate (date field),Gender (drop-down list with options male/female/prefer not to say), Country (drop down or text field)
Three checkboxes for subscription preferences:
*Newsletter,
*Special Offers,
*Events. Any changes to attributes should be updated in the Subscribers Data Extension. The checkboxes for each communication type should be reflected by a subscribed field in a relevant Data Extension (true/false). For each form submission, LastUpdatedDate needs to be written into a Data Extension.
Make sure the form is pre-populated with data when a subscriber visits the website.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design And Relational Theory Normal Forms And All That Jazz

Authors: Chris Date

1st Edition

1449328016, 978-1449328016

More Books

Students also viewed these Databases questions

Question

Explain the function and purpose of the Job Level Table.

Answered: 1 week ago