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:
And the title field in the SalesForce report is:
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:
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 :/