How do i write a query in workflow such that i get number of click that user has performed on the email sent via adobe campaign?

@ajit_tr ,
To retrieve the number of clicks that a user has performed on an email sent via Adobe Campaign, you can use the nms:trackingLogRcp schema in a workflow query activity, like -

select count(*) as Clicks
from nms:trackingLogRcp
where deliveryId = '<deliveryID>'
and linkLabel is not null
and targetMode = 'M'
and isProcessed = 1
and recipientId = '<recipientID>'

You will need to replace the <deliveryID> and <recipientID> placeholders with the appropriate values.

The query filters the tracking log records based on the following criteria:

• deliveryId: The ID of the delivery you want to retrieve the clicks for. Replace <deliveryID> with the actual delivery ID.
• linkLabel is not null: Filters only the tracking logs that have a non-null linkLabel, which means a link was clicked.
• targetMode = 'M': Filters only the tracking logs with a target mode of 'M', which means the click was performed on a link in an email.
• isProcessed = 1: Filters only the tracking logs that have been processed.
• recipientId: The ID of the recipient you want to retrieve the clicks for. Replace <recipientID> with the actual recipient ID.

Note that the tracking log records are only available for a limited time after the delivery is sent, so it is important to run this query soon after the delivery has been sent to ensure the tracking data is still available.

Hi @ajit_tr,

Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
Thanks!