Skip to main content

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

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.

 


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