In Email Log V2, the Clicked Url and Clicked IP are now stored in a JSON field in the Link Clicked JSON and those values must be extracted from it. In Email Logs (Email Log V1), the “Clicked Url” is the last Clicked Url so this field will be updated as many times as the end user clicks it in an Email. Whereas in Email Log V2, the “Link Clicked Json” is appended with the Urls whenever the end user clicks a Url in an Email. Similar to Email Log V1 the new field in Email Log V2 will be updated, but the Json supports multiple Urls.

The issue is there is no function that allows us to extract all the records/fields from the Json. It would be great if we add a function in Data Designer (and maybe other areas of NXT) to extract all the data from the Json, i.e., url, clickedCount, ip, or a child object with discrete records/fields for the extracted Json values so they can be accessed directly.