Calculated Metrics at a Visit Level (Approx Count Distinct)

Avatar

Avatar

dbachota

Avatar

dbachota

dbachota

14-11-2018

It'd be handy to use this functionality to get an estimated count of unique search terms at a visit level.  I would then want to create segments based on approx number of unique search terms.  For example, visits where the user had one search term compared with visits where the user had approximately 5 unique search terms.

11 Comments (11 New)
11 Comments

Avatar

Avatar

jen_lasser

Moderator

Avatar

jen_lasser

Moderator

jen_lasser
Moderator

12-04-2019

You should be able to do this with the new distinct count segment operators: Segmentation on Distinct Dimension Counts - YouTube

Avatar

Avatar

dbachota

Avatar

dbachota

dbachota

12-04-2019

This is awesome!

Is there a way for the count distinct to ignore "unspecified" values?

My current solution is nested segmentation:

1731928_pastedImage_0.png

Any better methods?

Avatar

Avatar

jen_lasser

Moderator

Avatar

jen_lasser

Moderator

jen_lasser
Moderator

12-04-2019

It doesn't count unspecified values, since "unspecified" means there is no value. For example, in an eVar report, if you see unspecified, in-market, and out-of-market, the distinct count would be 2.

Avatar

Avatar

dbachota

Avatar

dbachota

dbachota

12-04-2019

Can you please verify this?  I looked at a visit of my own and it was in the "Visit contains 3 distinct count of Evar" segment.  I then broke it down by the Evar and saw Value 1, Value 2, and Unspecified.  It seems that "unspecified" is being counted as a distinct value in the logic.

Thank you!!

Avatar

Avatar

jen_lasser

Moderator

Avatar

jen_lasser

Moderator

jen_lasser
Moderator

12-04-2019

It looks like it is counting unspecified for eVars - we will get this fixed. Props, marketing channels, etc are fine though. Thanks for raising this!

Avatar

Avatar

jen_lasser

Moderator

Avatar

jen_lasser

Moderator

jen_lasser
Moderator

15-04-2019

dbachota​ - while we look into the best way to remove "unspecified", here is how you can build you segment to workaround the issue. This example is looking for 3 items to exist

Distinct Count workaround.jpg

Avatar

Avatar

dbachota

Avatar

dbachota

dbachota

22-07-2019

Hi Jen,

When this change is implemented, do you mind updating this thread so I can modify my segments?


thanks!

Avatar

Avatar

jen_lasser

Moderator

Avatar

jen_lasser

Moderator

jen_lasser
Moderator

24-07-2019

I will try to remember to update this thread. For sure though, we will put the update in our release notes. We don't have a scheduled release date for the "unspecified" improvement yet though.

Avatar

Avatar

timr98608316

Avatar

timr98608316

timr98608316

10-10-2019

Bump and a +1 for this - is there a fix planned for this yetjen.lasser​​?

tbh i think a huuuuuge number of people will just be making this mistake and not realising it counts unspecified - which will be very skewing, given it's usually by far the largest single value in any dimension.......not sure i would have been comfortable letting this one run in the wild with this bug for so long if i were you guys!

(P.S. When this feature works properly it's going to be AWESOME!!!  just keen to see it count properly.  )

Avatar

Avatar

jen_lasser

Moderator

Avatar

jen_lasser

Moderator

jen_lasser
Moderator

23-10-2019

Good news - this will be fixed Oct 30 (next week). Distinct Count will no longer count "unspecified" as 1.