Querying User Actions: Identifying Multiple Actions in One Day

·Oct 28, 2024 08:56 AM·

How can I check the users who have done a particular action multiple times in a single day ? Its bit tricky to put that condition of 'multiple times' within a 'single day' . can you help ?

26 comments

· Sorted by Oldest

Andrew S.
·
·
Have you tried this:
Andrew S.
·
·
Andrew S.
·
·
if you take out the breakdown, you can see all users on a particular date who rated >1x on any given day
Andrew S.
·
·
And if you change it to bars, you can do stacked breakdowns to see more groupings of the users, like
Andrew S.
·
·
Andrew S.
·
·
and maybe, if you are going to look at bars, you need to stack filters up top.
Andrew S.
·
·
so frequency of rated products > 1 AND distinct count of days = 1. So that would be users who rated > 1x on a single day.
Nadeesha E.
·
·
this is helpful and thanks so much for the quick feed back
Nadeesha E.
·
·
Andrew S. I always appreciate you detailed elaboration on the solutions. I have a small follow up question. Im trying to get this 'time' attribute for the aggregate property per user metric and im unable to get it from my data.
Nadeesha E.
·
·
My metrics looks like this , similar to yours. when I go through 'select event' under aggregate Property per user ,
Nadeesha E.
·
·
im not given the choice to select an event property , and it is given only the event labels only.
Nadeesha E.
·
·
how did u select time(day ) there ?
Andrew S.
·
·
In your lexicon, do you see, under Event Properties, $time?
Andrew S.
·
·
Time is an Event Property, not an event itself. So you select your event (like in my case it is Rate a Product) and then aggregate the property or breakdown on the property, being the Time property on the event.
Nadeesha E.
·
·
yes , I can see that under event property