Skip to main content
Solved

Uniques for multiple events

  • October 26, 2021
  • 2 replies
  • 892 views

Forum|alt.badge.img

I want to measure the number of unique users per month who performed EITHER of several events. Do I just use 

UNIQUES(A)+UNIQUES(B)+UNIQUES(C)

or would that still hold duplicate users (counts per event and just adds, or deduplicate as well)?

Best answer by Saish Redkar

Hey @razf6,
Creating a custom event will be the ideal approach to measure the “number of unique users per month who performed EITHER of several events” use case. 

I believe that the formula approach of UNIQUES(A)+UNIQUES(B)+UNIQUES(C) will just perform pure arithmetic sum of the unique counts without any deduplication.

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

 

View original
Did this topic help you find an answer to your question?

2 replies

Saish Redkar
Expert
Forum|alt.badge.img+10
  • Expert
  • 1380 replies
  • Answer
  • October 26, 2021

Hey @razf6,
Creating a custom event will be the ideal approach to measure the “number of unique users per month who performed EITHER of several events” use case. 

I believe that the formula approach of UNIQUES(A)+UNIQUES(B)+UNIQUES(C) will just perform pure arithmetic sum of the unique counts without any deduplication.

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

 


Forum|alt.badge.img
  • Author
  • New Member
  • 1 reply
  • October 26, 2021

Yes, played with this some more after posing here, you are right (both as to the custom event approach, and as to the “pure arithmetic sum” my original solution does).

 

Thanks


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings