To know the links which got clicked by a recipient

13 replies
2345 views
Translate

I've been asked to find the schema and its field which will help me know which all links were clicked by a recipient.... I've been trying to find that out since quite a long time, but I'm unable to

Please help me by saying which schema and field it is

PS. I personally feel that the report that contains this data is 'URLs and Clicks' report which is based on the Delivery schema.... But still I can't seem to figure out the field..... Pls help me @adobecampaign, @yuhuisg, or anyone available right now!!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

S

ShineV_Accepted solution

Level 4

Hi @yasmeenfatima ,

The Email Opens, Clicks are basically tracked in the table called as Tracking logs (trackingLog), which has Date @logDate (mentions the date + time of the activity such as open or clicks). racking logs (trackingLog) which is further linked to the table url which will give you, Label @label (title of the link in the HTML that was clicked), Type @type (the type of action performed opens,email clicks on the url, etc..), Source URL @source (actual url that was clicked (eg : 123.com)).

You directly fetch these details from the schema or you can use a workflow and use a query that uses Tracking logs as Targeting and Filtering Dimension to get all the actions performed by a recipient or you can use a workflow and use a query that uses Recipient as Targeting and Tracking logs as Filtering Dimension to check the if Recipient has clicked on any particular links.

Thanks,

Shine v.v

_Manoj_Kumar_

New Participant

Hello @yasmeenfatima

You can identify this information from the trackingLogRcp schema. It is linked to the URL schema

Translate

Manoj Find me on LinkedIn

Y

yasmeenfatimaAuthor

Level 2

Thank You!

Translate

Shubham_Goyal__

Level 6

Hi @yasmeenfatima ,

The tracking information will be available in schema "nms:trackingLogRcp" (Adminisitration>Configuration>Data Schema) 🙂
In this schema data, you can further add @SourceUrl and @recipients, etc columns to get your desired info.

Br,

Shubham

Translate

Y

yasmeenfatimaAuthor

Level 2

Thank You!!

Translate

S

ShineV_Accepted solution

Level 4

Hi @yasmeenfatima ,

The Email Opens, Clicks are basically tracked in the table called as Tracking logs (trackingLog), which has Date @logDate (mentions the date + time of the activity such as open or clicks). racking logs (trackingLog) which is further linked to the table url which will give you, Label @label (title of the link in the HTML that was clicked), Type @type (the type of action performed opens,email clicks on the url, etc..), Source URL @source (actual url that was clicked (eg : 123.com)).

You directly fetch these details from the schema or you can use a workflow and use a query that uses Tracking logs as Targeting and Filtering Dimension to get all the actions performed by a recipient or you can use a workflow and use a query that uses Recipient as Targeting and Tracking logs as Filtering Dimension to check the if Recipient has clicked on any particular links.

Thanks,

Shine v.v

Translate