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

Avatar

Avatar

rashmi_rao

Avatar

rashmi_rao

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)

Avatar

Avatar

Lee_Clemmer

Avatar

Lee_Clemmer

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)

Avatar

Avatar

hyderziaee

Employee

Avatar

hyderziaee

Employee

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

Avatar

Avatar

rashmi_rao

Avatar

rashmi_rao

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

Avatar

Avatar

rashmi_rao

Avatar

rashmi_rao

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.

Avatar

Avatar

hyderziaee

Employee

Avatar

hyderziaee

Employee

hyderziaee
Employee

11-05-2017

Hi Rashmi,

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

-Hyder