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

rashmi_rao

11-05-2017

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!!

Accepted Solutions (1)

Accepted Solutions (1)

Lee_Clemmer

11-05-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.

Answers (4)

Answers (4)

hyderziaee

Employee

15-05-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

rashmi_rao

11-05-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 addressessegment 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

rashmi_rao

11-05-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.