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?
Solved! Go to Solution.
Views
Replies
Total Likes
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
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
@Jennifer_Dungan Sorry, just updated the screenshot.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
Thank you @Jennifer_Dungan
Views
Replies
Total Likes
Views
Likes
Replies
Views
Like
Replies