Count distinct values a variable takes for a visitor

Avatar

Avatar

guthier

Avatar

guthier

guthier

08-07-2015

We have a number of different products and it is easy to count the number of product page views or visitors with X or more product page views. However, it would also be good to know how many visitors looked at multiple products. For this we would need a count distinct (product identifier) capability that isn't available yet.

Would such an addition be viable? And if not, what workaround could be recommended?

10 Comments (10 New)
10 Comments

Avatar

Avatar

justin_grover

Employee

Avatar

justin_grover

Employee

justin_grover
Employee

09-07-2015

You are right this is hard to do today. I can see how this would be helpful. We'll keep an eye on the number of votes.

 

Couple of questions.

* Are you trying to use this in a segment?

* How do you want to view this information?

Avatar

Avatar

guthier

Avatar

guthier

guthier

09-07-2015

What I have in mind is a metric like the eVar instances, only that it is based on the distinct value eVar instances. That would work in segments and reports likewise.

Avatar

Avatar

_jm_97660

Avatar

_jm_97660

_jm_97660

13-07-2015

Did you try implementing Event Serialization feature for each product view? Use productID as your unique_ID. This should give you the unique product counts

 

Here is the Adobe documentation for Event Serialization: http://bit.ly/1MqNXn5

Avatar

Avatar

dreisch-wiley

Avatar

dreisch-wiley

dreisch-wiley

29-07-2015

Hi _JM_,

 

Event serialization doesn't count at the visit level. So, we can't answer a relatively simpe question like "how many visits did we have where people looked at 2 products?" I've worked on several different products' implementations now, and this is continues to be a question of every team focused on the ways users engage.

 

We can't possibly fit session ID and the product ID in to the 8 characters upon which serialization happens.

 

Segmenting by instances of a product view event doesn't account for the fact that many will hit back to Google and then come back in while comparison shopping or the like. Or maybe they'll click a link for more info and back. 

Avatar

Avatar

c_grant_aa

Avatar

c_grant_aa

c_grant_aa

25-09-2015

I would love to have this.  In the past, have used full paths to get these counts - not a fun way to go about it.

Avatar

Avatar

benjamingaines2

Avatar

benjamingaines2

benjamingaines2

25-09-2015

I think this is actually available now, using the new calculated metrics features that we added in June. Try creating a metric defined either as Count Rows(), which does not take any arguments, or use the Count() function and set the argument to the relevant metric (Page Views, or Product Views, or etc.). You'll get back a number that is the same in each row, but it represents the total number of rows for the given dimension for the given date range. We use this pretty heavily ourselves to count true unique visitors (people) based on user login (in an eVar). 

 

You can also operate on that metric by including these functions in a more complex calculated metric. 

 

I'm going to tentatively mark this as "Implemented" but comment here if the solution I suggested doesn't work. 

Avatar

Avatar

benjamingaines2

Avatar

benjamingaines2

benjamingaines2

25-09-2015

Avatar

Avatar

c_grant_aa

Avatar

c_grant_aa

c_grant_aa

25-09-2015

Hi Ben, I looked at that but am not sure it's what I'm after.  To quote Danielle above:  "how many visits did we have where people looked at 2 [different] products?"

 

We'd want a histogram (# visits with only 1 product, # visits with 2 different products, etc).  Alternatively, a variable that can be the basis for a segment (a segment consisting of sessions where there were 3 or more different products viewed).

Avatar

Avatar

benjamingaines2

Avatar

benjamingaines2

benjamingaines2

25-09-2015

I saw that and I wasn't sure how tied to that use case the general idea was. But that makes sense. We are actually working on histograms; when we add them, they will be in Analysis Workspace only (just FYI). 

Avatar

Avatar

benjamingaines2

Avatar

benjamingaines2

benjamingaines2

25-09-2015