0

example

See image above. See how there are two links, but the link appears 4 times once with a LinkName (alias), once without. Now the link did appear in the email twice, once on an image, and once on text, but both times it had an alias, yet the alias did not track on one of them. Is it because the alias was exactly the same on both links? I have submitted a case to marketing cloud support about this, but in the meantime, I'm trying to find a way to remap the correct alias.

Is there a way with SQL to look for LinkName fields that are blank, then look at the left column to get the url, then search that same column for the same url, then fill in the LinkName column with the alias from the url that has it. (Hope that makes sense) I've provided a diagram below to help. enter image description here

  • Did you try to query Click Data View? help.salesforce.com/… – Chandan Apr 3 '18 at 23:44
  • Where did you get the image? Is this in click activity within email studio >tracking? – Tom Callahan Apr 4 '18 at 1:52
  • I need help writing the query mostly. I know about _click data view. This is an image of my data extension – garek007 Apr 4 '18 at 12:46
0

This is what I needed

SELECT n.LinkContent,
CASE WHEN LEN(n.LinkName)>0 THEN
    n.LinkName
ELSE
    n2.LinkName
END as LinkName
FROM [Newsletter Link Ranking Past month] n with (NOLOCK)
JOIN (
    SELECT LinkContent, LinkName
    FROM [Newsletter Link Ranking Past month] with (NOLOCK)
    WHERE LinkName IS NOT NULL
) n2 
ON n.LinkContent = n2.LinkContent

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.