Count distinct values a variable takes for a visitor

Avatar

Avatar
Boost 5
Level 2
guthier
Level 2

Likes

20 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile

Avatar
Boost 5
Level 2
guthier
Level 2

Likes

20 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile
guthier
Level 2

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

Avatar

Avatar
Give Back 10
Employee
justin_grover
Employee

Likes

15 likes

Total Posts

148 posts

Correct reply

5 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Ignite 1
View profile

Avatar
Give Back 10
Employee
justin_grover
Employee

Likes

15 likes

Total Posts

148 posts

Correct reply

5 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Ignite 1
View profile
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
Boost 5
Level 2
guthier
Level 2

Likes

20 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile

Avatar
Boost 5
Level 2
guthier
Level 2

Likes

20 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile
guthier
Level 2

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
Boost 5
Level 3
_jm_97660
Level 3

Likes

36 likes

Total Posts

36 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 3
_jm_97660
Level 3

Likes

36 likes

Total Posts

36 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
_jm_97660
Level 3

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
Boost 50
Level 5
dreisch-wiley
Level 5

Likes

101 likes

Total Posts

61 posts

Correct reply

1 solution
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile

Avatar
Boost 50
Level 5
dreisch-wiley
Level 5

Likes

101 likes

Total Posts

61 posts

Correct reply

1 solution
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile
dreisch-wiley
Level 5

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
Validate 1
Level 3
c_grant_aa
Level 3

Likes

21 likes

Total Posts

29 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 3
c_grant_aa
Level 3

Likes

21 likes

Total Posts

29 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
c_grant_aa
Level 3

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
Boost 50
Level 8
benjamingaines2
Level 8

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile

Avatar
Boost 50
Level 8
benjamingaines2
Level 8

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile
benjamingaines2
Level 8

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
Boost 50
Level 8
benjamingaines2
Level 8

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile

Avatar
Boost 50
Level 8
benjamingaines2
Level 8

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile
benjamingaines2
Level 8

25-09-2015

Avatar

Avatar
Validate 1
Level 3
c_grant_aa
Level 3

Likes

21 likes

Total Posts

29 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 3
c_grant_aa
Level 3

Likes

21 likes

Total Posts

29 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
c_grant_aa
Level 3

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
Boost 50
Level 8
benjamingaines2
Level 8

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile

Avatar
Boost 50
Level 8
benjamingaines2
Level 8

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile
benjamingaines2
Level 8

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
Boost 50
Level 8
benjamingaines2
Level 8

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile

Avatar
Boost 50
Level 8
benjamingaines2
Level 8

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile
benjamingaines2
Level 8

25-09-2015