AMPscript for Salesforce Marketing Cloud

Name: AMPscript for Salesforce Marketing Cloud
Rating: 4.5 (180 reviews)

Beginner to Advanced

Created byFrancois Domain

Last updated 5/2024

English

What you'll learn

Master the fundamentals of AMPscript to dynamically generate personalized content and enhance user engagement within Salesforce Marketing Cloud.
Develop the skills to write and troubleshoot your own scripts, including conditional statements and variables to drive targeted marketing campaigns.
Learn expert techniques for leveraging data extensions and utilizing AMPscript in email and landing pages
Gain hands-on experience with real-world examples and exercises that prepare you for any business scenario.
In this course, we will go through logic, maths, formatting, data transformation, data extraction and much more!

Course content

10 sections • 71 lectures • 2h 18m total length

Introduction2:08
Welcome to 'AMPscript for Salesforce Marketing Cloud: Beginner to Advanced'!

As you prepare to embark on this journey, get to know your instructor and take a sneak peek at what's headed your way...
Methodology1:32
Learn more about the methodology used in this course: we will start with a user story, learn the necessary concepts, go through examples and finally solve the user story. Hands-on, as much as possible!
Recap4:19
Quick recap about AMPscript basics:
Attributes,
Substitution Strings,
Functions,
Variables,
AMPscript Blocks

Context1:34
During this course, we will be spending a lot of time in out small virtual gift shop with 2 retail locations and a warehouse. As the new Salesforce Marketing Cloud Developer, the Marketing team has already a lot of requests for us...
ProperCase()1:27
Quick warm-up to make sure we all can use the ProperCase() function in situ.
ProperCase()
ProperCase(): Solution1:01
Solution for the ProperCase() assignment
Variables0:48
Review how to declare, set variables, assign a value using attributes and render it.
Variables
Variables: Solution1:02
Solution for the Variable assignment.

Introduction to Data Retrieval with AMPscript1:33
Warm-up finished, let's start the real adventure with Data Retrieval in AMPscript.
Lookup() part 14:58
The Marketing team would already like to make a few changes on our code... Like showing the product name instead of its ID.
Lookup()
Lookup() part 1: Solution0:56
Solution for the Lookup Assignment
Lookup() part 20:43
The Marketing team is curious about the stock of the recommended product in each store...
Lookup() part 2
Lookup() part 2: Solution1:36
Solution for the Lookup() assignment part 2
Concat()1:56
Ever wondered what "concatenate" means? You're about to get the answer...
Concat()
Concat(): Solution1:32

Introduction to Logic with AMPscript1:22
Conditional statements allow personalisation at scale. Implementing logic is not that difficult, actually it's pretty... logic!
If... EndIf2:30
The basic logic check : IF .. EndIf.
If... Then... EndIf
If... Then... EndIf: Solution1:28
Solution for the If... EndIf Assignment.
Else1:54
Implement fallback actions with ELSE.
Else
Else: Solution0:50
Solution for the ELSE assignment.
ElseIf7:49
Add levels of complexity by adding ElseIf statements.
ElseIf
ElseIf: Solution1:37
Solution for the ElseIf Assignment.
== and !=1:31
Equals, Strict Equals, and Different...
== and !=
== and !=: Solution0:58
Solution for the Equals assignment.
Output()2:05
Output values without leaving the comfort of your AMPscript block.
Output()
Output(): Solution1:09
Solution for the Output Assignment.
And2:02
Fine-tune logic statements with the AND operator
And
And: Solution2:13
Solution for the AND assignment
... Or ...3:57
After AND, let's look at OR...
Or...
Or: Solution0:47
Solution for the OR Assignment.
Logic Operators Precedence4:01
Using AND and OR in the same statement is possible, and oftenly needed, However, Operator Precedence play a big role in what the experience will look like.
Nested IF Statements
Nested IF Statements: Solution1:41
If, If, If... Learn how to imbricate IF statements.
IIF2:59
Make decisions quicker with IIF
RaiseError()2:27
Need to stop an email from going out? We can do that programmatically too.

Section Intro: LookupRows and associated functions0:53
LookupRows and its assistants have their own section - lucky them.
LookupRows()3:34
Get the bigger picture with LookupRows
LookupRows()
LookupRows(): Solution2:22
Solution for the LookupRows assignment.
For... Do... Next3:17
AMPscript processes its code from top to bottom. Always.
Well... Almost, always.
LookupOrderedRows()1:51
Order the rows you retrieve with LookupOrdredRows.
LookupOrderedRows()
LookupOrderedRows(): Solution3:01
Solution for the LookupOrderedRows assignment
Use Case: Swap out of stock products for another one.0:53
Use case: Swap a recommended product that is currently out of stock for the most expensive product from our catalogue.
Product Swap - Use Case: Solution
LookupOrderedRows() part 2: Solution2:35
Solution for the Use Case: swap recommended product.

Introduction to Out of the box Formatting with AMPscript0:55
Data Presentation: automation formatting in AMPscript
FormatCurrency()3:28
Format currencies in one click.
FormatCurrency()
FormatCurrency(): Solution1:37
Solution for the FormatCurrency assignment
FormatNumber()1:41
Format Numbers as easily as the currencies.
FormatDate()3:00
Gear up for the most comprehensive Format function.
FormatDate()
FormatDate(): Solution1:03
Solution for the FormatDate Assignment
Format()0:52
Versatilty meets Formatting
DateAdd()1:34
Add, remove intervals with DateAdd.
DateAdd()
DateAdd(): Solution0:59
Solution for the DateAdd assignment
IndexOf()1:51
Where's Wally? Leverage IndexOf to find anything in your data...
IndexOf()
IndexOf(): Solution1:33
Solution for the IndexOf assignment
Replace()1:23
Substitute strings with Replace...
Replace()
Replace(): Solution0:29
Solution for the Replace() assignment.
ReplaceList()1:11
Heavy replacement job? Try ReplaceList
Substring()1:54
Don't truncate your strings with a chainsaw - use Substring (it's safer).
Length()0:35
As it says on the tin...
Substring()
Substring(): Solution0:44
Solution for the Substring Assignment

Requirements

Access to a Salesforce Marketing Cloud instance is required for the hands-on exercises.
Some knowledge of basic AMPscript concepts like Attributes, variables and AMPscript blocks is beneficial.
For a better start, users with zero AMPscript experience could take the Introductory course "AMPscript for Ultra Beginners"

Description

Hello and welcome to this AMPscript for Marketing Cloud course. My name is Francois Domain, and I will guide you on a journey to mastering AMPScript with ease and, hopefully, with a bit of fun. With over a decade of experience in the Marketing Technology sector, I have dedicated a great part of my career to leveraging the power of AMPScript to create highly personalized and dynamic marketing campaigns.

To ensure you become proficient in AMPScript, regardless of your starting level, we will start with the very basics of AMPScript for those of you who may have little or no experience with it. Step by step, we will unpack all the essential functions and concepts, we will learn the syntax, look at a few examples and finally reinforce your learning through practical examples.

So it’s not just about learning in theory; it’s about getting your hands dirty with actual use cases. By the end of this course, you will not just understand AMPScript, but you will also be able to apply it confidently to solve real-world challenges in the Salesforce Marketing Cloud environment.

This course, loosely based on my AMPscript guide “AMPscript for Salesforce Marketing Cloud”, is meticulously designed to offer you practical, hands-on learning. To get the most out of our sessions, you'll need access to a Salesforce Marketing Cloud instance, as we'll be working through real-life examples together. By the end of our time, you'll have gained the confidence and skills to apply AMPscript effectively in any marketing scenario.

Who this course is for:

Marketers who would like to push the limits of Personalisation at Scale and leverage the full power of Marketing Cloud to deliver best in class communications to their subscribers.
Marketing exec who would like to ideate or get inspiration from use cases and real life examples of using AMPscript in Marketing Cloud.

AMPscript for Salesforce Marketing Cloud

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 8min

Setup your Environment1 lecture • 1min

Getting started5 lectures • 6min

Data Retrieval with AMPscript7 lectures • 13min

AMPscript Logic19 lectures • 43min

Maths in AMPscript6 lectures • 12min

LookupRows and associated functions8 lectures • 18min

Out of the box Formatting with AMPscript17 lectures • 25min

Interaction with Data Extensions via AMPscript4 lectures • 9min

Course Wrap Up1 lecture • 3min

Requirements

Description

Who this course is for: