Data Extensions in the Salesforce Marketing Cloud (ExactTarget) platform are simply database tables in which you can store data you need for your campaigns.
You can add rows to data extensions using:
With the API, you have a few options — SOAP being the most complex, AMPScript the simplest:
You can use AMPScript in emails, landing pages or SMS keyword configurations. I’ll use AMPScript in this example.
Here’s how you add or update a single row in a data extension named My_Test_DataExtension using the UpsertDE() function:
Here’s a breakdown of the UpsertDE() arguments in this example:
- The name of the data extension to receive the data
- Number of columns you’re using to check to see if there’s a matching row already in the data extension. (This means there will be only 1 pair of name and value arguments following this parameter. You could specify more.)
- The lookup column
- The lookup value
- Column 1 to update
- Column 1 update value
- Column 2 to update
- Column 2 update value