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.