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

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

1 Answer 1

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .