in auto_sizing/targets.py [0:0]
def _make_ios_targets(self, target: Dict[str, str], start_date: str) -> List[Segment]:
clients_daily = SegmentDataSource(
name="clients_daily",
from_expr="mozdata.org_mozilla_ios_firefox.baseline_clients_daily",
)
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,
)
)
if target["user_type"] == "new":
baseline_clients_first_seen = SegmentDataSource(
name="baseline_clients_first_seen",
from_expr="`moz-fx-data-shared-prod.org_mozilla_ios_firefox.baseline_clients_first_seen`", # noqa: E501
)
Segment_list.append(
Segment(
name="clients_last_seen_filter",
data_source=baseline_clients_first_seen,
select_expr=f"COALESCE(MIN(first_seen_date) >= '{start_date}', TRUE)",
)
)
elif target["user_type"] == "existing":
baseline_clients_last_seen = SegmentDataSource(
name="baseline_clients_last_seen",
from_expr="`moz-fx-data-shared-prod.org_mozilla_ios_firefox.baseline_clients_last_seen`", # noqa: E501
)
Segment_list.append(
Segment(
name="clients_last_seen_filter",
data_source=baseline_clients_last_seen,
select_expr="""COALESCE(MIN(first_seen_date) <= '{first_day}', TRUE)