Multiple segments in a Data Warehouse request | Community
Skip to main content
July 21, 2022
Solved

Multiple segments in a Data Warehouse request

  • July 21, 2022
  • 1 reply
  • 1540 views

When we select multiple segments in a data warehouse report (screenshot below), will the request consider "OR" condition between these segments to pull the data?

 

 

 

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 Jennifer_Dungan

Are you trying to apply "multiple" segments, or just the one segment as shown?

 

The data returned by this segment (assuming it works in Workspace) should work the same way in Data Warehouse.

 

However, in the "contains any of" I don't think you should have the comma (,) unless that comma is actually part of the text of the page name, and also wildcards like asterisk (*) aren't supported... 

 

I suspect the issue with Data Warehouse is that this segment is returning no values.

 

 

IF you are using a combination of 2 segments on a Data Warehouse pull they use "AND" logic... 

 

For instance, if I have a segment that is set to pull traffic from Mobile Devices, and another that is supposed to pull Known Users (i.e. logged in)... then using those two segments would return logged in users on mobile devices (the combination of both segments) . (not logged in OR mobile devices)

 

If I were to try to use two non-overlapping segments like "Mobile Devices" and "Desktop Devices" (my segments are looking at Hit level), it will result in no results, as no user can simultaneously be on a Mobile Device and a Desktop Device on the same Hit.

 

I hope this helps

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
July 21, 2022

Are you trying to apply "multiple" segments, or just the one segment as shown?

 

The data returned by this segment (assuming it works in Workspace) should work the same way in Data Warehouse.

 

However, in the "contains any of" I don't think you should have the comma (,) unless that comma is actually part of the text of the page name, and also wildcards like asterisk (*) aren't supported... 

 

I suspect the issue with Data Warehouse is that this segment is returning no values.

 

 

IF you are using a combination of 2 segments on a Data Warehouse pull they use "AND" logic... 

 

For instance, if I have a segment that is set to pull traffic from Mobile Devices, and another that is supposed to pull Known Users (i.e. logged in)... then using those two segments would return logged in users on mobile devices (the combination of both segments) . (not logged in OR mobile devices)

 

If I were to try to use two non-overlapping segments like "Mobile Devices" and "Desktop Devices" (my segments are looking at Hit level), it will result in no results, as no user can simultaneously be on a Mobile Device and a Desktop Device on the same Hit.

 

I hope this helps

krishkpnAuthor
July 22, 2022

@jennifer_dungan Sorry, just updated the screenshot.

Jennifer_Dungan
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
July 22, 2022

Ahh, no problem @krishkpn 

 

In this screenshot, it should be AND.

 

While I can't tell if your segments are hit, visit or visitor level, the two segments should be used together.. if you see some strange data, then maybe the way the segment is built could be causing some cross-over (visitor level is notorious for this).

 

If you are concerned about your numbers, you can use them in a Workspace and dig a little deeper into any oddities.