Segments not returning correct metric data in Workspace

ursboller​ Gigazelle​

I have tried using that exclusion also, but unfortunately the same issue arises i.e. User_ID's that are outside the specified parameters are being returned in Workspace, see screenshot below.

Hi emmetc2018​

Sorry I haven't written earlier, missed the conversation. But let's try to solve. I think you have two issues, I will explain step by step.

1) Segment definition:

If you want to see visitors who had more than 30 visits in a certain time range, you can not use the dimension "visit number", This is due to the fact that the counter starts with the very first visit regardless the time range you look at. just take an example: a user visited your site 100 times this year but only once last month, he would have a visit with a number above 100 for last month (within your segment), but only 1 visit when you look at the data for last month!

Therefore you need to change the segment als follow:

{(visitor) where (visits) higher or equal to (100)}

this should return all Visitors who had more than 99 visits in the date range you are looking at.

2) workspace data

the second problem occurs by reading the data. even when you apply the segment above to your table, you will see numbers below 100! this is due to the fact that it shows you a single ID and how many visits this visitor had AFTER he catched the ID.

let me give an example: a user came to your side 105 times (visits) the last month (thus matching the segment), but only logged in after the 56 visit. looking at the corresponding user ID would inly show the remainig visits AFTER the user catched the ID, your report would show something about 50 (and not the full 105 as you expected.

I hope those explanations help you solve your question. feel free to ask for more details or other help if needed.

Hi Emmet, are there any follow-up questions you'd like to ask? Were you able to get everything working?

Gigazelle​ ursboller​

Thanks for your explanation on this.

Using the above explanation, can we be certain when the segment is run in Workspace using a range (i.e. Between 30-99 visits in the last 30 days) that it is accurate?

For example when the above segment is run, values above and below that range are returned e.g. 120 visits and 10 visits in the last 30 days.

What is the explanation for this in this case?

Visit Number = Explained high count problem (Understood)

Cached ID = Explains low count problem (Understood), but only when I used incorrect segment.

When I apply correct segment, as outlined above in previous post, I still get user IDs with values outside the range specified? See screenshot below.

Can you please advise?

Thanks,
Emmet

Higher Visits than specified

Lower Visits than specified

ursboller​ Gigazelle​

Apologies for the delay in responding. Thanks for your clarification on this.

To answer your ending question;

"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?"

We would like to know both for reporting purposes.

1. The specific User ID's of people who meet the criteria e.g. Above 100 visits or between 30-99 visits last 30 day sor last 60 days etc.

&

2. A count of how many people visited over 30 times last month, or how many visited over 100 times last month/last 2,6,12 months etc.

With that being said, is there any way on Adobe to have a query/segment run that would have exact accurate results for the above requirements, or will there always be this inaccuracy?

Thanks,Emmet

Hi emmetc2018​

if you want the perfect numbers go to the IT and ask for a login log file. Analytics might loose some of your users due to provacy settings on their end. therefore you will most like miss some userIDs in your reporting anyway...

However, here are some ways to get close to the question you are looking for:

List of userID's with certain amount of visits

create a table with dimension "userID". vor the first col use a calc. metric like this:

"if (greater than: visits | static number 30) then 1 else 0"

the table will show you a list of all UserID's with a "1" as result if the userID had more than the desired amount of visits. it will respect the reporting timeframe, so set it to any date range you want.

unfortunatelly the table will also include those userIDs with less visits, but having a 0 (zero) as number. please upvote Allow Filtering report columns/metrics for Limits & Ranges  

and unfortunatelly you can create a segment based on the result. please upvote Use Calculated metrics inside segments  

total userIDs

having the table above just look at the column total which will show you the total of userID matching the criteria. this will include "unspecified" as well, so don't forget to count -1 before showing the number.

(add a new calc. metric with "column total of above metric - 1")

one last idea: use classification

maybe not the best way, but having the desired userID you could upload a classification on those userIDs (to indicate visit volume) and start creating segments based on this classification. it is not flexible, needs work for setup and maintenance but maybe a way to go....

last remark:

I never used it but maybe you can upload customer data based on the userID? maybe data from login logs? I hope Gigazelle​ can tell you if it's an option and give you a link (thanks!)