To filter any CQL query by users in a segment: add the following expression to the where clause. Use the segment name as saved.

where|and segment(<segmentName>)

To filter a query by data NOT in the specific segment: precede the segment statement by "NOT".

where|and NOT segment(<segmentName>)

Filter by multiple segments: it is possible to slice a query using multiple segments connected by an "AND" logical operator. "NOT segment" can also be used, and can be combined with regular segment statements. Only results that belong to the intersection of all the segments will be shown.For example, the following would be a valid query:

SELECT user_id 
FROM cooladata 
WHERE date_range(last 7 days) 
AND NOT segment(segment_new_users) 
AND segment(segment_news.customer_type) 
AND (event_name="Login" OR user_type="new")

Notes:

• "OR" cannot be used on segments: To use an "OR" condition in conjunction with segments (on condition other than the segment statement), enclose it in brackets, with "And" operator. For example:

  SELECT user_id
  FROM cooladata
  WHERE date_range(last 7 days)
  AND NOT segment(segment_new_users)
  AND (is_new=1 OR user_type="new")

• Cohort and Funnel can only be segmented by "user_id": it is only possible to segment Cohort and Funnel queries by the "user_id" property (no need to declare it specifically).
• Cannot segment by property "event_name": the property "event_name" cannot be used when filtering by segment.

Example:

We'll use a segment "new_users" we created to see the activity of these users over time.

SELECT date(event_time_ts) AS day, count(distinct user_id) AS users
FROM cooladata
WHERE date_range(context) 
   AND slicers(context)
   AND segment(new_users)
GROUP BY day
ORDER BY day

where|and segment(<tableName>[.<propertyName>])

where|and NOT segment(<tableName>[.<propertyName>])

SELECT email
FROM cooladata
WHERE date_range(last 7 days)
   AND segment(churned_users.email)
GROUP BY email