in auto_sizing/targets.py [0:0]
def _make_desktop_targets(self, target: Dict[str, str], start_date: str = "") -> List[Segment]:
clients_daily = ConfigLoader.get_segment_data_source("clients_daily", "firefox_desktop")
clients_daily_sql = self._make_clients_daily_filter(target)
Segment_list = []
Segment_list.append(
Segment(
name="clients_daily_filter",
data_source=clients_daily,
select_expr=clients_daily_sql,
)
)
clients_last_seen = SegmentDataSource(
name="clients_last_seen",
from_expr="`moz-fx-data-shared-prod.telemetry.clients_last_seen`",
)
if target["user_type"] == "new":
Segment_list.append(
Segment(
name="clients_last_seen_filter",
data_source=clients_last_seen,
select_expr=f"COALESCE(MIN(first_seen_date) >= '{start_date}', TRUE)",
)
)
elif target["user_type"] == "existing":
Segment_list.append(
Segment(
name="clients_last_seen_filter",
data_source=clients_last_seen,
select_expr="""COALESCE(MIN(first_seen_date) <= '{first_day}', TRUE)