Storing how many url and url click for each sent email in Data Extension

Question

I would like to know if it is possible to store how many URL are they in each email sent and how many times each url has been clicked in Data Extension using maybe data view.

Answer 1

For the second part of your question, all needed data can be found in Click data view (vide MC dev documentation about that view), which can be accessed using Automation Studio SQL activity, and product of that activity can be stored in Data Extension.

If you know ID of email, that you have sent (which can be obtained from tracking panel or from the content builder - viewing message details), you can use that information to join Click and Job data view, and group it by e-mail and URL. Adding to this some aggregate SQL functions can give you SUM of clicks in each link, per email.

But there is one but, in before-mentioned Data View you can find only links that have been clicked. I don't know any convenient programmatic approach to list all links from email (clicked and non-clicked).