Salesforce Marketing Cloud : Ampscript in 10 Minutes

Salesforce Marketing Cloud

Ampscript in 10 Minutes

Variables

%%[

Var @a

Set @a = 10

]%%

<h1>%%=v(@a)=%%</h1>

Lookup

Lookup("DENAME",

"EmailAddress",

"SubscriberKey", 

@lookupValue)

LookupRows

set @rows = LookupRows("DENAME","flag", true)

set @rowCount = rowcount(@rows)

if @rowCount > 0 then

  for @i = 1 to @rowCount do

    var @emailAddress, @firstName, @rank

    set @row = row(@rows, @i) 

    set @emailAddress = field(@row,"emailAddress")

    ]%%

    <br>emailAddress: %%=v(@emailAddress)=%%

    %%[  next @i ]%%

%%[ else ]%% No rows found %%[ endif ]%%

InsertDE

This function inserts a row in a Data Extension

InsertDE("DENAME",

"EmailAddress", 

@emailAddress,

"SubscriberKey", 

@subscriberKey)

UpdateDE

This function updates the Data Extension 

UpdateDE("DENAME",1,

"EmailAddress", @emailAddress, 

"Update", @updateDate)

RetrieveSalesforceObjects

This function retrieves fields from a record in a Sales or Service Cloud 

standard or custom object.

set @subdetails = 

RetrieveSalesforceObjects(

   "Contact",

   "LastName,Email",

   "Id", "=", _subscriberKey )

UpdateSingleSalesforceObject

This function updates a record in a Sales or Service Cloud 

standard or custom object.

set @updatedetails = 

UpdateSingleSalesforceObject(

      "Contact",

   @Id,

      "LastName", @lastName,

      "Email", @email)

InvokeExecute

Unsubscribe Management - “ Marketing Cloud API “

set @er = CreateObject("ExecuteRequest")

SetObjectProperty(@er,"Name","LogUnsubEvent")

set @prop = CreateObject("APIProperty")

SetObjectProperty(@prop, "Name", "SubscriberKey")

SetObjectProperty(@prop, "Value", "_subscriberKey ")

AddObjectArrayItem(@er, "Parameters", @prop)

set @invokeStatusObj = InvokeExecute(@er, 

@invokeStatusMessage, @invokeRequestId)