Is it possible to capture customer information into a new DE by someone clicking on a link?
As an example: capture the email address in a new DE by clicking on a link ( Click on this link to Opt-in)?
-
Are you sending Emails through Salesforce activities ?– Mohith ShrivastavaJan 23, 2015 at 13:09
-
DE = Developer Edition?– Force HeroJan 23, 2015 at 13:23
-
Sorry for not bing clear DE = data Extension in ExactTarget– Peter HoJan 23, 2015 at 13:28
Add a comment
|
2 Answers
Here's a quick example of the UpsertData() AMPScript function. This code would be in your landing page. It'll read in a URL parameter named sk and write it to the TestDE data extension.
The data extension has two columns: SubscriberKey (Text 100, primary key) and Updated (Date).
%%[
var @de, @sk, @num_filter_columns, @lookup_col_name, @lookup_col_value
var @update_col_name1, @update_col_value1, @update_col_name2, @update_col_value2
var @results
set @de = "TestDE"
set @sk = QueryParameter("sk")
set @num_update_columns = 2
set @lookup_col_name = "SubscriberKey"
set @lookup_col_value = @sk
set @update_col_name1 = "SubscriberKey"
set @update_col_value1 = @sk
set @update_col_name2 = "Updated"
set @update_col_value2 = now()
set @results = UpsertData(@de,@num_update_columns,@lookup_col_name,@lookup_col_value,@update_col_name1,@update_col_value1,@update_col_name2,@update_col_value2)
]%%
<html>
<head>
</head>
<body style="font-family:sans-serif;">
@sk: %%=v(@sk)=%%
<br>@results: %%=v(@results)=%%
</body>
</html>
Here's the output:
answered Jan 26, 2015 at 14:45
Short answer is yes, but it's not the link doing the work, it would be the page the user goes to that does the work.
You could easily create a landing page that subscribes a user to a new list by passing the email to the page as a query string.
answered Jan 23, 2015 at 13:37
-
Thanks is it possible to do a one click opt in? could we append the email to the URL dynamically?– Peter HoJan 23, 2015 at 13:40
-
-
do you have any example you could share? i know how to do the query string part not not sure how to add the email address to a new data extension part– Peter HoJan 23, 2015 at 13:44
-
1UpsertData function: help.exacttarget.com/en-US/documentation/exacttarget/content/… Jan 23, 2015 at 13:49
-
1Can also be done with the Add() SSJS function: help.exacttarget.com/en/documentation/exacttarget/content/… Jan 23, 2015 at 13:53