Level 2

Solved

To know the links which got clicked by a recipient

Forum|Forum|3 years ago
October 21, 2022
5 replies
2359 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

Y

yasmeenfatimaAuthor

Level 2

Could u pls help me in forming the query for it?

I have to know the links that were clicked by a particular recipient. What conditions m i supposed to include in the query?

ParthaSarathy

Community Advisor

In Query you can select trackingLogRcp as targeting dimension,

In Filtering condition, You can select field from Recipient link

Example,

And in Complementary information - add data > Data linked to the filtering dimension > Data of the filtering dimension > Expand URL link and select source URL

Run your query, and you can see the links clicked by the recipient in display targets on query output transition.

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

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.