Hi There,
We just set up Amplitude for our product. I want to analyze the number of unique users come into our product per month.
I use the event, Session Started, and the UNIQUE (A) formula 👇🏻. But the sum of the monthly unique users who triggered this event is greater than the total number of accounts in our database, which cannot be possible.
Did I set up the formula and the analysis wrong?
Best answer by Loc Tran
View original
+5
Hi Joanna,
There may be a difference in how your database tracks unique users and how Amplitude tracks unique users. Amplitude employs a solution using a combination of device IDs, user IDs, and Amplitude IDs. This article explains how that process works, and the roles each of these properties plays in it.
I suggest trying “Any Event” in the uniques metric view to see if the sum of uniques is closer to the total number of users you have. Perhaps users can fire an event that is not in a session and it causes a discrepancy between monthly active users.
Here’s another resource that might help with the data discrepancy.
Amplitude | Data discrepancy checklist
Let me know if this helps!
Best,
Loc
For example i want to see unique users who have performed any event, other than login or forget password. Is there a way to achieve that?
+10
Hi
You can filter on the Event Name property as shown here.
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.