topic Re: Challenge #62: Find the Duplicate Clicks in Weekly Challenges

Challenge #62: Find the Duplicate Clicks

JoeM — Tue, 13 Sep 2022 19:09:33 GMT

This solution to last week's challenge can be found HERE.

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)

Re: Challenge #62: Find the Duplicate Clicks

alex — Mon, 20 Mar 2017 11:24:38 GMT

not sure if I arrived early, but there was no workflow attached to your post.

Re: Challenge #62: Find the Duplicate Clicks

JoeM — Mon, 20 Mar 2017 12:03:46 GMT

@alex, the start file is now posted!

Re: Challenge #62: Find the Duplicate Clicks

MarqueeCrew — Mon, 20 Mar 2017 13:43:45 GMT

@JoeM,

I included a sort (to make sure that data is in time order). Your challenges almost make Monday's something to look forward to..

Cheers,
Mark

Re: Challenge #62: Find the Duplicate Clicks

alex — Mon, 20 Mar 2017 15:14:39 GMT

Looked for a way to do it differently than @MarqueeCrew, but couldn't. My workflow was the same as his.

Re: Challenge #62: Find the Duplicate Clicks

Balders — Mon, 20 Mar 2017 16:02:43 GMT

I went a longer way around on the date parsing but got there in the end. I also assumed the data was pre-sorted from eyeballing the data.

Nice short challenge.

Re: Challenge #62: Find the Duplicate Clicks

Max06270 — Mon, 20 Mar 2017 16:33:22 GMT

Hi guys, solution attached. this week was pretty straight forward, have a great week!

thank you

Re: Challenge #62: Find the Duplicate Clicks

JoeM — Mon, 20 Mar 2017 18:23:04 GMT

@MarqueeCrew... the critical word being "almost". ;)

Re: Challenge #62: Find the Duplicate Clicks

Inactive User — Mon, 20 Mar 2017 22:35:32 GMT

Fairly simple one I believe.

Re: Challenge #62: Find the Duplicate Clicks

vuddagiri1991 — Wed, 22 Mar 2017 16:33:12 GMT

Took a while to write the expression, but quite a simple one.

Re: Challenge #62: Find the Duplicate Clicks

Natasha — Sun, 26 Mar 2017 17:28:38 GMT

Finally I managed to complete the challenge with only one tool

Re: Challenge #62: Find the Duplicate Clicks

JoeM — Mon, 27 Mar 2017 14:58:08 GMT

The solution to this week's challenge has been posted!

Re: Challenge #62: Find the Duplicate Clicks

JoeM — Mon, 27 Mar 2017 15:04:45 GMT

@alex, although your workflow may be the same as @MarqueeCrew's, you should upload it so our system can recognize it as a solution so you can earn more badges!

Re: Challenge #62: Find the Duplicate Clicks

JoeM — Mon, 27 Mar 2017 15:16:03 GMT

One tip for a couple of our challengees for this past week, if you find yourself writing logic into your expression like '[IDFA]=[Row-1:IDFA]' or '[DeviceID]=[Row-1:DeviceID]', you are essentially writing in logic to detect when one distinct group stops and another starts. Although the logic is valid, I'm here to save you some time! You can select fields the 'Group by' to use to apply your logic. In this case, you can select DeviceID and IDFA to group by, and the expression you write will only evaluate each distinct DeviceID and IDFA grouping.

Re: Challenge #62: Find the Duplicate Clicks

Natasha — Mon, 27 Mar 2017 15:14:58 GMT

@JoeM,

I was just looking at your solution and discovered the "group by" field. Excited to learn something new even from such a relatively small challenge!

Re: Challenge #62: Find the Duplicate Clicks

alex — Mon, 27 Mar 2017 16:46:29 GMT

Here you go

Re: Challenge #62: Find the Duplicate Clicks

Coxta45 — Fri, 31 Mar 2017 18:10:27 GMT

Took me 4 tools. I know someone did better...

Re: Challenge #62: Find the Duplicate Clicks

toddhowl — Fri, 31 Mar 2017 18:11:30 GMT

Re: Challenge #62: Find the Duplicate Clicks

Coxta45 — Fri, 31 Mar 2017 18:16:16 GMT

@Natasha,

You may not want to assume that 1) event logs will already be in chronological order 2) sorted by device id and 3) also sorted by IDFA and 4) also sorted by event name - if more than one event type exists...

Re: Challenge #62: Find the Duplicate Clicks

Natasha — Fri, 31 Mar 2017 22:23:06 GMT

Coxta45,

You are right, thanks for pointing that out