To know the links which got clicked by a recipient

[yasmeenfatima]

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!!

[yuhuisg]

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.

[yasmeenfatima]

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]

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]

Hi @yasmeenfatima ,

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

[ShineVv0823 · Accepted solution]

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

[ShineVv0823]

[yasmeenfatima]

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]

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.

[yasmeenfatima]

Thank You Sooo Much!

[Shubham_Goyal__]

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

[yasmeenfatima]

Thank You!!

[_Manoj_Kumar_]

Hello @yasmeenfatima 

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

[yasmeenfatima]

Thank You!