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: 1 . Create four Data extensions: Subscribers with subscriber attributes: SubscriberKey, FirstName, LastName,

In AMPscript, I need help with the coding part of this exercise: 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, Status (subscriberd/unsubscribed), LastUpdatedDate
*"SpecialOffers" with information about newsletter subscribers: SubscriberKey, Status (subscriberd/unsubscribed), LastUpdatedDate
*"Events" with information about newsletter subscribers: SubscriberKey, Status (subscriberd/unsubscribed),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 status field in a relevant Data Extension (subscribed/unsubscribed). 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
Bonus: add validation before submitting to ensure all required fields have been filled out and add email and phone number format validation (frontend).

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

How do Excel Pivot Tables handle data from non OLAP databases?

Answered: 1 week ago