Is there a way to mimic the functionality of an exclude container, without using the exclude function? | Community
Skip to main content
123481737310
New Participant
Sep 17, 2018 2:36 AM UTC
Solved

Is there a way to mimic the functionality of an exclude container, without using the exclude function?

Is there a way to mimic the functionality of an exclude container, without using the exclude function? I have a segment that I would like to use when exporting via data warehouse, however, the segment uses an exclude container at the visitor level, which Adobe analytics is not letting me use in the data warehouse manager? Is there a way to produce a segment that does not use exclude, but produces the same results?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Andrey_Osadchuk
Andrey_OsadchukAccepted solution
Level 10
Sep 17, 2018 11:09 PM UTC

Try the following replacements:
1. exclude "is less than 1" >>> include "is greater than 0"

2. exclude "is greater than 0" >>> include "is less than 1"

Consider using "exists" and "does not exist" instead if the values can't be negative numbers.

View reply

5 replies

Gigazelle
Gigazelle
Employee
Sep 22, 2018 12:17 AM UTC

I think Andrey's solutions are going to be your best bet, given the limitations imposed. If you're able to work in Ad Hoc Analysis or Analysis Workspace to get this data, that might be more ideal since then you won't have to adhere to the segmentation architecture that data warehouse follows.

Translate
123481737310Author
New Participant
Sep 18, 2018 2:11 PM UTC

Thank you so much for your response! The metrics I am using cannot be below 0, so When trying to change Evar 1 to does not exisit and the rest in the exclude container to exist the metrics did not match up. However, when I did the opposite changing Evar 1 to does exist and the rest to does not exist  a few lf my metrics did match. would you possibly have any other recommendations as to how I can make all metrics uniform? Thanks again for your help

Translate
Andrey_Osadchuk
Andrey_OsadchukAccepted solution
Level 10
Sep 17, 2018 11:09 PM UTC

Try the following replacements:
1. exclude "is less than 1" >>> include "is greater than 0"

2. exclude "is greater than 0" >>> include "is less than 1"

Consider using "exists" and "does not exist" instead if the values can't be negative numbers.

Translate
123481737310Author
New Participant
Sep 17, 2018 2:29 PM UTC

I would like to replicate the same results if this segment without using the exclude container as the DW does not let you use exclude, is that possible?

Translate
Andrey_Osadchuk
Andrey_Osadchuk
Level 10
Sep 17, 2018 12:34 PM UTC

Can you share the segment criteria or its screenshot?

Translate
Terms & ConditionsAccessibility statement

Loading footer...