When two segments are added in a report, is it resulting data displayed as 'AND' or 'OR' | Community
Skip to main content
rashmi_rao-1
rashmi_rao-1
May 11, 2017
Solved

When two segments are added in a report, is it resulting data displayed as 'AND' or 'OR'

  • May 11, 2017
  • 5 replies
  • 1840 views

When I add two or more segments by holding down the ctrl key on my keyboard on a data warehouse report, is the resulting data considering the segments as 'OR' or 'AND'. Segments are separated by commas in the report preview.  Please help!!

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 Lee_Clemmer

Well everywhere it's treated as "AND" so I would expect that to be the case in Data Warehouse. Just try it out on a small sample: if your result set decreases when adding additional segments, it's AND, otherwise OR. I would be shocked if it's OR though.

5 replies

L
Lee_ClemmerAccepted solution
Level 2
May 11, 2017

Well everywhere it's treated as "AND" so I would expect that to be the case in Data Warehouse. Just try it out on a small sample: if your result set decreases when adding additional segments, it's AND, otherwise OR. I would be shocked if it's OR though.

Hyder_Ziaee
Adobe Employee
Hyder_ZiaeeAdobe Employee
Adobe Employee
May 11, 2017

Hi Rashmi,

It is as Lee said, when more than one Segment is selected, the operator acting in between is AND.

-Hyder

rashmi_rao-1
rashmi_rao-1Author
May 11, 2017

Hi Lee and Hyder -

Per Lee's suggestion, I just ran a sample report and it seems like the answer to my question is - OR;

I have 2 segments, segment 1 - excludes internal IP addresses; segment 2 - excludes internal user emails;.  The report that I want is a list of users that don't have internal IP address OR do not have internal emails. That is the result that I got. Can you please verify that same happens when you run a report in data warehouse? Thanks! Remember: I am building the report using tools ---> Data warehouse and adding both those segments from the available segments.

rashmi_rao-1
rashmi_rao-1Author
May 11, 2017

Hi Hyder -

Thanks for the documentation link; can you please verify/confirm that it is behaving in the same way that is documented because I'm getting the opposite results =)

Thanks again!

*****

Per Lee's suggestion, I just ran a sample report and it seems like the answer to my question is - OR;

I have 2 segments, segment 1 - excludes internal IP addresses; segment 2 - excludes internal user emails;.  The report that I want is a list of users that don't have internal IP address OR do not have internal emails. That is the result that I got. Can you please verify that same happens when you run a report in data warehouse? Thanks! Remember: I am building the report using tools ---> Data warehouse and adding both those segments from the available segments.

 

https://marketing.adobe.com/resources/help/en_US/analytics/segment/seg_compatibility.html

Hyder_Ziaee
Adobe Employee
Hyder_ZiaeeAdobe Employee
Adobe Employee
May 16, 2017

HI Rashmi,

Can you share what your segments look like. 

A point to remember is that container exclusion and Does not equal/contain is not the same.

-Hyder

Terms & ConditionsAccessibility statement

Loading footer...