1

Links in my email contain aliases which I would like to query (for statistical purposes), in Email Studio > Tracking > Sends I can quite clearly see that the aliases are working as the link overview refers to the alias name instead of the URL itself.

When I query the _Click data view and store URL, LinkName and LinkContent, neither of these contain the alias value.

Can someone tell me how to correctly get this information?

This is the query I have been using:

select 
JobID
, SubscriberID
, SubscriberKey
, EventDate
, Domain
, URL
, LinkName
, LinkContent
from _Click
Improve this question
5

LinkName contains the alias value.

Update

Details about the LinkName are outlined on the Personalization String page in the official documentation -- in addition to the _Click data view page you referenced.

What you're doing is correct. As to why it's not showing, I'd start with reviewing the alias values in your email code. There are some limitations of using dynamic alias values.

Improve this answer
  • 2
    Can you add a bit of detail here? I know linking to documentation isn't always possible with MC, but you're basically just contradicting the OP here (they claim the field doesn't contain the alias). – Adrian Larson♦ Mar 12 '18 at 3:15
  • Yes, of course. It was a half-asleep answer from my couch. – Adam Spriggs Mar 12 '18 at 11:12
  • Hey @AdamSpriggs, the aliases I believe are set correctly as they are shown in the Link Overview page in my tracking instead of the full URL, it’s only when I expand the clicks on this link am I shown the URL. – Deployment Failure Mar 12 '18 at 15:24
  • The aliases are not dynamic, and are literal strings in our <a> tags – Deployment Failure Mar 12 '18 at 15:41
  • How you are you validating the missing alias values? Your query is looking at every click in the last 6 months. Wouldn't you want to look at a specific JobID? – Adam Spriggs Mar 12 '18 at 17:20

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.