Solved

Look up a list of users by an event property value beyond 24hours

  • 11 January 2023
  • 1 reply
  • 130 views
A
Rank
Badge

Hi team, 

We have an event that contains the error type in its property. Think of the event being “on_error” and the property giving us the error code specifically. 

We need to create analytics and perform lookups of all users that experience the on_error event with specific property values. We want this in list form with the associated User ID’s, not a simple graph or view to spotlight how many occurrences happen. 

Is this possible? If so, how would we do this?

 

Thanks so much for the urgent help. 

icon

Best answer by Saish Redkar 12 January 2023, 07:09

View original

1 reply

Saish Redkar
Rank
Userlevel 7
Badge +10

Hey @adam12 

One way I can think of is to create an event segmentation chart and group by error code and user id for your desired time range. You can then export the csv of this chart ( the option above the breakdown table ). Here’s a demo chart -  https://analytics.amplitude.com/demo/chart/new/v5oevk4

Another approach would be a Data Table for the same grouping combination of properties.
Similar to this - https://analytics.amplitude.com/demo/chart/new/lv6j4la . This too can be exported and could serve as a better formatted list than the event seg chart csv export.

I think this is the closest result you can get for your user IDs and specific event property values to be in a list format.

Let me know if I have interpreted your use case correctly. Hope this helps.

 

Saish | Need additional Amplitude help ? Book me on topmate.io/saish_redkar

Reply


Terms & ConditionsCookie settings