SFMC AMPscript Loop - Real-Time Project Scenarios

 Real-Time Project Scenarios

Loops: A single customer can have multiple related records. Without loops, SFMC can only easily display one value.

Loops are used when a subscriber has multiple related records that need to be displayed dynamically in an email, CloudPage, or SMS. They eliminate hardcoding and allow Salesforce Marketing Cloud to process and display an unlimited number of records using the same code.

E-Commerce

%%[

VAR @rows, @count, @i, @row, @item

• Product Recommendations: SET @rows = LookupRows(

      "Product_DE_AMP",
      "Scenario",
      "Product Recommendation"
  )

• Abandoned Cart Emails: (SET @rows = LookupRows( "Product_DE_AMP", "Scenario", "Abandoned Cart")

• Order Summary: SET @rows = LookupRows( "Product_DE_AMP", "Scenario", "Order Summary" )

SET @count = RowCount(@rows)

FOR @i = 1 TO @count DO

    SET @row = Row(@rows,@i)

    SET @item = Field(@row,"ItemName")

    OUTPUT(CONCAT(@item,"<br>"))

NEXT @i

]%%

Banking

• Transaction Summary

• Reward Points

Healthcare

• Appointment Details

• Test Results

Education

• Course Lists

• Student Progress

Loyalty Programs

• Points Earned

• Rewards Redeemed

Preference Center

• Interest Categories

• Subscription Management

What is a Loop?

A loop is used to execute a block of code repeatedly until a condition is met.

Which Loop is Most Common in SFMC?

FOR Loop.

Why Use Loops?

To process multiple records dynamically and avoid hardcoding.

Which Functions Are Commonly Used with Loops?

• LookupRows()

• RowCount()

• Row()

• Field()

• IF

• ELSEIF

• ELSE

• MOD()

• AND

• OR

---

Golden Interview Formula

LookupRows()

↓

RowCount()

↓

FOR Loop

↓

Row()

↓

Field()

↓

Output()

Remember:

Fetch Records → Count Records → Loop Through Records → Read Row → Read Field → Display Data

This is the foundation of dynamic personalization in Salesforce Marketing Cloud.