cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Number of unique users

radek_jasinski
DynaMight Guru
DynaMight Guru

Hi,

I would like to get the number of unique users of monitored application by API? 

I have made a USQL:

SELECT count(DISTINCT ip) FROM usersession WHERE userType IS "REAL_USER" AND newUser = true

but unfortunately the option with IP address as unique element is not supported to create custom metrics (and it makes sense).

Does anyone have any ideas?

Regards,

Radek

Have a nice day!
4 REPLIES 4

Viachaslau
Advisor

You can get user ids distinct (set persistent cookies to reduce generation default user tags, if you can define User tag with email/user id from you system - it will more reliable)

Hi @Viachaslau 

I'm going to try this, but I think it's not a good option because I don't collect all user IDs because many users use adblock plugins in their browsers, etc.

Radek

Have a nice day!

Hey @radek_jasinski , did you manage to find a solution to your problem? If no, let us know, and we'll seek further assistance. If yes - would you like to share it with the Community maybe? 🙂

Hi @IzabelaRokita 

Unfortunately I have no official solution:(

Radek

Have a nice day!

Featured Posts