[SalesForce] How to use ampscript in order to pull user data from a second data extension

We have several data extensions that have data relationships with each other.

How can I send an email using one data extension while pulling data from a second data extension to personalize my email with ampscript?

I've tried Lookup in many different ways, but I've only managed to pull one specific row (the same row which is not personalized to each user) or all rows at once. I haven't been able to pull personalized data for each user.

In practice, I want to pull data from a DE called "Survey". Each user has a specific ID and some users have an "AnswerID", which varies. I want to to create IF/THEN statements based on that AnswerID.

Thanks,
Sylvie

Best Answer

The "Lookup()" function should give you the results needed. This will allow you to send to any list or data extension and pull back records from a completely different data extension. In order for this to work, your Unique Subscriber ID on the Lookup DE would need to relate back to the subscriber you're sending to. For example, if your Specific ID matches up with Subscriber Key on your account, you can setup something similar to the below.

More info can be found here as well: Data Extension Ampscript Functions

The below creates 3 variables. "SubscriberAnswer" does your lookup to pull the value from your other data extension. This says, pull the answer from the row of data where the Column "UniqueID" matches the value of "_SubscriberKey" for the subscriber being sent to. I've added the variable "Survey" to generate a standard response when their answer is not null. Then I perform an IF/Then statement in the variable "Answer" to say, If the variable "SubscriberAnswer" is null, pull back "Please fill out Survey", otherwise just pull back the value for "SubscriberAnswer". Hope that is clear and useful. Thanks!

%%[
Var @SubscriberAnswer, @Survey, @Answer
Set @SubscriberAnswer = Lookup("Survey","Answer","UniqueID",_subscriberkey)
Set @Survey = Concat("Thank You.  Your results can be found here:", "  ", @SubscriberAnswer)
Set @Answer = IIF(Empty(@SubscriberAnswer), "Please fill out Survey", @Survey)
]%%
<p>
%%=v(@Answer)=%%
</p>

Related Solutions

[SalesForce] How to pull data from Data Extension to be displayed in Landing Page

I assume that your account no corresponds to subscirber id. Missing link is that in the landing page, you need to pass the account no for which value needs to be fetched.

You need to do the following steps:

In the Email Template, append the URL Link with the Account no against which you need to fetch the balance
As an optional step, you can also encrypt the account no using ampscript function
In the Landing page, use Requestparameter() ampscript function to retrieve the account no and assign it to a variable. If you have encrypted, decrypt it
Now add your query above to the landing page to fetch the value.

[SalesForce] How to Use Marketing Cloud Data relationships to Populate an Email with data from 2 Data Extensions

It is possible to include data from related tables in email content:

https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/gtlDataRelationships.htm

For Example:

<html>
   <body>
      {{#=with Order_Details}}
          <h4 class="header">{{[First_Name]}} {{[Last_Name]}}, your order ID is {{OrderID}}</h4>
          <br />
              {{#=each Order_Details}}
                  {{#Products}}
                      <strong>Product Name:</strong> {{Product_Name}}<br />
                      <strong>SKU:</strong>{{sku}}<br />
                      <img src="{{Thumbnail_URL}}" /><br />
                      {{#Product_Ratings}}
                          <strong>Most Recent Review: </strong>{{Last_Review_Text}}<br />
                          <strong># of Ratings: </strong>{{Number_of_Ratings}}<br />
                          <strong>Ave Rating: </strong>{{Average_Rating}}<br /><br /><br />
                      {{/Product_Ratings}}
                  {{/Products}}
              {{/each}}
      {{/with}}
   <body>
</html>

The {{ }} tags are references to the DE's configured with a Data Relationship. Here, we can display data from the Product Ratings DE that relate to the Products DE that relate to the Order_Details DE which references the customer.

Best Answer

Related Solutions

[SalesForce] How to pull data from Data Extension to be displayed in Landing Page

[SalesForce] How to Use Marketing Cloud Data relationships to Populate an Email with data from 2 Data Extensions

Related Topic