Level 2

Solved

Segments not returning correct metric data in Workspace

Forum|Forum|7 years ago
September 25, 2018
17 replies
6728 views

Hi there,

Background to issue:

I have built two segments;

1. Users that have 31+ visits in the last 30 days and from USA

2. Users that have 1-30 visits in the last 30 days and from USA

Issue:

When in Workspace, I am trying to get the user ID's for each individual segment.

However, when I use the Visit metric and filter to the last 30 days, there are users that have visit counts outside the range of the specified segment.

For example, when I drag in the 31+ Segment, I can see that users who have less than 31 visits are also included. I thought the segment rules would have ensured that these people outside of the given range would be omitted? See screenshot below.

This was the case for both segments in Workspace i.e. The 1-30 Visits segment also returned results of people with over 30 visits in 30 days, which is not correct.

Can someone please advise? I have checked the Segment rules and they are set up correctly. The issue is in Workspace.

Thanks!

Kind regards,

Emmet

Analytics

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Urs_Boller

@emmetc2018 thanks for testing the segments, let me try to explain why you get higher or lower numbers...

lets start with the easy one: lower numbers. as I already explained, a user might log in not on the first visit, but on the 20th. that means, for visit 1-19 you don't have a UserID. but if the Visitor had a total of more than the lower condition, he will be in the segments since you are looking at the visitor and all his visits. and breaking down by UserID will just show the remaining numbers...

lets get to the other case: higher numbers. I assume that this is a visitor problem, maybe the user deleting the cookies. just an example: a user comes to your site for 40 visits (all with UserID), clears cookies and comes back again doing anothe bunch of visits. for Adobe Analytics this would mean "2 visitors" both matching your segment. and breaking down visits by UserID would show the total bisits of all visitors ... just drag in the visitor metric, I would bet it is above 1....

Knowing those cases I can't think of any segments who would solve your idea - at least it is not top of my mind. the problem is that your criteria is not based on visitors (or containers below), it is a global criteria.

last question: do you only need to see a number of how many UserID had a certain amount of visits or do you nead the specific UserIDs? If it's only the total number, there might be a solution with a calculated metric: "if visits greater that 30 and lower than 50 then 1 else 0". the row total in your table of UserID would be the number of UserIDs minus 1 (for "unspecified")

Urs_Boller

Community Advisor

I can think of several problems:

Problems with segment definition: can you share a screenshot how you defined the segments?
Problem with breakdown dimension: what is the "user id"? is it something that is set in every visit or just when the user logs in?
Problem with reporting timerange: what did you select as report "date range"?

don't know what the reason is without more information, but would bet for the "dimension"

E

emmetc2018Author

Level 2

urs.boller thanks for your post.

1.

I have screenshotted two segments below which I have used. One segment tries to specifically omit users with less than 31 visits, but still those users show up in the Workspace query (e.g. A user with 10 visits). Screenshots below;

2.

The User ID is when the user logs in.

3.

The date range was 'In the last 30 days'. Top right corner of the screenshot in my previous post.

Thanks,
Emmet

Segment with exclusion included;

Urs_Boller

Community Advisor

Hi emmetc2018

just a last question begore answering: what is your "UserID" -> Prop or eVar? if eVar, what expiry? and is it possible a user can come to your site without any login (so no UserID is set)?

Gigazelle

Adobe Employee

I'd recommend using a visit container for both the include and exclude containers. So it'd look something like this:

Visit container where

- Visit number is greater than 30

And

Exclude visit container where

- Visit container is less than or equal to 30

Right now your include container is visitor and the exclude container is hit. visit number is a visit-based dimension, so if you're able to use visit containers, you'll get the most accurate data.

Urs_Boller

Community Advisor

Gigazelle while your segment might be ok, the problem with the low visit number still exists. And as long as we don't get more information from emmetc2018 we can't say what is ok as segmentstion.

I think there might be a problem with the userID, since it is not set in every visit. If it's a eVar with maximum visit expiration, we would see a picture as shown in the original question: visitors with more than 30 visits, but only in 10 visits a userID is set (that means it only counts the visits where a user has logged in, in all other visits there hasn't been a login)

but this is just "best guess" - would be happy to help with more information...

Gigazelle

Adobe Employee

Hi Emmet, were you able to get this issue resolved? Let us know if there's anything we can do to help!

E

emmetc2018Author

Level 2

Re: Global Company ID? ursboller;

Yes, people can visit our site without logging in.

There is still an issue, as to get 31-99 visits in a month, people with higher visit numbers or lower vist numbers are included i.e.4 visits or 210 visits for example.

E

emmetc2018Author

Level 2

Gigazelle Can you please see above answer

E

emmetc2018Author

Level 2

Gigazelle,

I tried using the exclude container function in my segments, see screenshot.

When I run in workspace there is still the issue of people under 100 visits being included?