Category: AMPscript30

Challenge https://ampscript30.com/ampscript-challenge-day20/ To create dynamic URL for subscriber to click on within the email body. Solution Preview Summary After concatenating the URL, I chose to add it to the text “Take the survey” via the Link button with Link to “Other” and then paste the AMPscript code to the Link URL column. Alternatively, it can […]

Challenge https://ampscript30.com/ampscript-challenge-day19/ To show custom image based on subscriber’s loyalty level. Solution Preview Summary Use the ContentImagebyKey(“Customer Key”) function to retrieve the image to the email content – make sure to use the Customer Key on the image (can be found on the image details). I made a mistake by writing the “ELIF” keyword instead […]

Challenge https://ampscript30.com/ampscript-challenge-day18/ To create reminder emails that display the appointment details. Solution Preview Summary Use ContentBlockbyName(1, 2, 3, 4, 5) to retrieve the pre-set content block in the email body. My understand of the challenge is to create multiple content blocks based on different appointment code to show different instruction messages, but due to my […]

Challenge https://ampscript30.com/ampscript-challenge-day17/ To display books borrow history for today and before based on different transaction dates. Solution Preview Summary Use LookupOrderedRows() function to returns a specified number of rows in the defined order with specified conditions on fields. The function returns an empty set when no values match.

Challenge https://ampscript30.com/ampscript-challenge-day16/ To display dynamic content using For loop. Solution Preview Summary Similar logic with the Day 15 challenge. After adding the error handler, MC will be able to display the error message and the email will not render for that particular subscriber as the process will be stopped.

Challenge https://ampscript30.com/ampscript-challenge-day15/ To display dynamic content using For loop. Solution Preview Summary For loop syntax: The <start expression> should be the start counter (usually set to 1), and the <end expression> should be the end counter (usually set another variable to the total count of rows and use it as the end counter). Since the […]

Challenge https://ampscript30.com/ampscript-challenge-day14/ To write the send date into another Data Extension. Solution Preview Summary UpsertDE(name of data extension from which to update the specified row, number of columns used to build WHERE clause, column name to build WHERE clause, value used to build WHERE clause, column name to build INSERT clause, value used to build […]

Challenge https://ampscript30.com/ampscript-challenge-day13/ To provide a limited amount of discount codes to customers, once discount codes run out offer a smaller discount. Solution Preview Summary ClaimRowValue(name of data extension for claim or retrieve action, name of column in data extension from which to retrieve the return value, name of column in data extension that indicates a […]

Challenge https://ampscript30.com/ampscript-challenge-day12/ To display customers’ transaction and loyalty details on the email. Solution Preview Summary Use LookupRows(name of data extension from which to return specified rows, column name used to identify rows to return, value used to match rows to return) to look up rows in another Data Extension based on the matched values. Use […]

Challenge https://ampscript30.com/ampscript-challenge-day11/ Solution Preview Summary Data Extension Import – when importing data to a data extension, if a primary key is selected and multiple rows of data with the same primary exist, only one of the rows will be imported. Thus if the Record Count is lower than it’s supposed to be, double-check on the […]