Create Segment for X+ article views per visitor, per month

Avatar

Avatar
Validate 1
Level 2
jenniferd532572
Level 2

Likes

9 likes

Total Posts

17 posts

Correct reply

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

Avatar
Validate 1
Level 2
jenniferd532572
Level 2

Likes

9 likes

Total Posts

17 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
jenniferd532572
Level 2

05-09-2018

I have been trying to create a segment for our site where we can see the number of users who have view 2+ articles, 5+ article and 10+ articles per month, but I can't get it working as expected.

First, to understand our data:

1. I have a custom metric tracking on article views (which I'm using in the segment)

2. I have a prop tracking the user id (using this for validation)

3. I have another prop tracking the article id (also using this for validation)

I created a segment that is set to Visitor Level, then said "article views" metric is greater than or equal to 2.

When I use this in my workspace, for "last month" and drill down into the data, and I use my visitor id and article id props, I can see that I have users that only have 1 article view in the selected month.

It appears that the segment is looking at all time values for the user (2+) and then showing me a list of those users that visited the site in my selected month....

As in, the segment is applied first (getting me a subset of users who have ever read 2 or more articles), then the date selection is applied after (shows me the users from the first subset that read an article within the selected date). So I get a lot of users where the custom metric shows 1 in my report.

As it stands, the data isn't returning what I need, as right now, the lifetime article views isn't important to me, I need to see X+ within the selected month.

Does anyone have any suggestions?

Thanks.

Replies

Avatar

Avatar
Validate 1
Level 2
Muralidharan_Ve
Level 2

Likes

9 likes

Total Posts

10 posts

Correct reply

4 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
Muralidharan_Ve
Level 2

Likes

9 likes

Total Posts

10 posts

Correct reply

4 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
Muralidharan_Ve
Level 2

06-09-2018

Hi,

Could you please try adding the required month as a time component to the Segment definition along with the Custom metric condition?

Please let me know if this works.

1565521_pastedImage_0.png

Regards,

Muralidharan

Avatar

Avatar
Validate 1
Level 2
jenniferd532572
Level 2

Likes

9 likes

Total Posts

17 posts

Correct reply

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

Avatar
Validate 1
Level 2
jenniferd532572
Level 2

Likes

9 likes

Total Posts

17 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
jenniferd532572
Level 2

06-09-2018

Thanks for the suggestion, but it also doesn't seem to be working....

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

13-09-2018

Right now there isn't an easy way to accomplish this, since Use Calculated metrics inside segments is currently not available. I'd recommend upvoting and commenting on that idea with your current use case/challenges so we can consider implementing it.

Avatar

Avatar
Validate 1
Level 2
jenniferd532572
Level 2

Likes

9 likes

Total Posts

17 posts

Correct reply

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

Avatar
Validate 1
Level 2
jenniferd532572
Level 2

Likes

9 likes

Total Posts

17 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
jenniferd532572
Level 2

18-09-2018

I'm not trying to use a calculated metric... I'm using a custom metric.... 

Right now, I've pretty much given up on the custom segment and am working with our DBA to create a DB report since nothing is working.

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

21-09-2018

The part that would be considered a calculated metric would be the number of articles per visitor. If you were able to put the segment criteria "article views divided by unique visitors" is greater than 10, you should be able to get this data without any issues.

Let us know if the DB report works out. It might also be helpful to the community if you were able to get the query they use to get the information you're looking for (if that's something your DBA would be willing to share).