To know the links which got clicked by a recipient

Forum|Forum|3 years ago
October 21, 2022
5 replies
2356 views

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.

Best answer by ShineV_

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

yuhuisg

Community Advisor

Is this a question for Adobe Campaign Classic? You posted your message in this forum, but it doesn't sound like something that ACC does.

Y

yasmeenfatimaAuthor

Level 2

Yeah its for Adobe Campaign Classic

Ok, atleast may I know which schema and its field tell about the number of clicks by a recipient on a link.

yuhuisg

Community Advisor

Sorry, I'm not very familiar with ACC. But yes, I would expect that ACC can report on the number of clicks per link out-of-the-box already.

ParthaSarathy

Community Advisor

Hi @yasmeenfatima ,

You can find this in nms:trackingLogRcp schema, and the URL details in [url/@source]

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups

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

S

ShineV_

Level 4

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.