Find the Duplicate Clicks
Shakti Dhar
![Shakti Dhar]()
Shakti Dhar
BI & Visualization Enthusiast | Business Intelligence Expert|| Crafting compelling data stories & dashboards that captivate & inform || Alteryx || Power BI || Tableau || SQL || Python
A website log tracks every click visitors are making on a particular link on the site in order to measure interest in the link.
However, web consumers are impatient and may click a link multiple times in short succession.
The goal of this exercise is to flag "duplicate clicks" that is defined as the event fire date happening within 30 seconds of the previous event fire date for the same user (IDFA) and device (DeviceID)