Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Validate 1
Level 1
123481737310
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
123481737310
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
123481737310
Level 1

16-09-2018

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?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

536 likes

Total Posts

968 posts

Correct Reply

263 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

536 likes

Total Posts

968 posts

Correct Reply

263 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile
Andrey_Osadchuk
MVP

17-09-2018

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.

Answers (4)

Answers (4)

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

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.

Avatar

Avatar
Validate 1
Level 1
123481737310
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
123481737310
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
123481737310
Level 1

18-09-2018

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

Avatar

Avatar
Validate 1
Level 1
123481737310
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
123481737310
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
123481737310
Level 1

17-09-2018

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?1573245_pastedImage_0.png

Avatar

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

536 likes

Total Posts

968 posts

Correct Reply

263 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

536 likes

Total Posts

968 posts

Correct Reply

263 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile
Andrey_Osadchuk
MVP

17-09-2018

Can you share the segment criteria or its screenshot?