Hi folks, how can I get the # of activities (events) a user has had in the product in a given day?
Best answer by jonathan
View originalHi folks, how can I get the # of activities (events) a user has had in the product in a given day?
Best answer by jonathan
View originalTo get the count per individual user, add a Group By, and choose either User ID, or Identity, or perhaps an Email property (as appropriate, and as suits your needs). Set your date range and bucket size, then run the query.
Alternatively, you can get the average count of activities per user by creating a Ratio graph with Count {Combo Event} as the numerator (the “top” query) and Count Unique {Combo Event} as the denominator (the “bottom” query). Set your date range and bucket size, then run the query.
if this doesn’t help, would you mind expanding on your use case?
thanks
I actually don’t have target activities in mind in this analysis, but rather I’m more interested in knowing how many things a user has done (e.g., how many clicks). Hoping to see a usage pattern of that user across his days in the product. For example, day 1 - 300 activities, day 2 - 500 activities, day 3 - 200 activities. From the general usage to see how sticky this user is.
Using the combo events is a good idea, but it’ll require me defining all possible events - this takes much time, and i’m just trying to get some quick insights, if that makes sense.
Thanks for clarifying
The queries I suggested in the previous post would still be useful with these two events: aggregating the Count by User ID, or Identity, or Email; or, a ratio of the Count over the user count (Count Unique).
If you wanted to include any Change event and/or Submit event, you can follow the above pattern (and even Combo the generic click/change/submit events to get a count of all autocaptured interactions).
thanks a ton
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.