I'm just starting out with Exact Target and Ampscripts, but it's boggling my brain.
I've uploaded a data extension which has two columns; one showing a country name, and the other a URL to a youtube video about that country.
I'm trying to put an AMPscript into an email which will match the email recipients country of interest in our SalesForce database with a country name in the data extension and then place the appropriate URL in the body of the email.
The title fields in the Data Extension are:
Studycity
DEurl
And the title field in the SalesForce report is:
Study Where
So, the code I've created looks like this:
<-------URL correction for video study location ------->
%%[
Var @vidurl, @studycity
SET @studycity = [Study Where]
SET @vidurl = Lookup("VideoCorrection_Italy_BrochureDownload","DEurl","Studycity","@studycity")
]%%
And I use this as the href:
<a "href="%%=REDIRECTTO(@vidurl)=%%">link</a>
But for some reason, the link is not working properly. There is a link there as a result of the Ampscript, but it's not taking me anywhere.
Really not sure what I'm doing wrong :/