Number of unique users

[radek_jasinski]

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

[Viachaslau]

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)

[radek_jasinski]

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

[IzabelaRokita]

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? 🙂

[radek_jasinski]

Hi @IzabelaRokita 

Unfortunately I have no official solution:(

Radek