{% set coverage_pct = ((summary.with_solutions_count / summary.active_count) * 100) if summary.active_count else 0 %}

Active Opportunities

!
Current backlog across the projects and rule types visible in this workspace.

{{ summary.active_count }}

{{ summary.with_solutions_count }} ready · {{ "%.0f"|format(coverage_pct) }}% coverage {% if summary.clearing_count > 0 %} · {{ summary.clearing_count }} {% if local_runtime_mode %}under evaluation{% else %}clearing{% endif %} {% endif %}

Query Cost

!
Latest visible cost basis for each row, using latest job data or dry-run baseline when available.

{{ summary.total_query_cost | format_usd }}

{% set query_breakdown = [] %} {% if summary.build_query_cost %} {% set _ = query_breakdown.append('Build ' ~ (summary.build_query_cost | format_usd)) %} {% endif %} {% if summary.consumption_query_cost %} {% set _ = query_breakdown.append('Consumption ' ~ (summary.consumption_query_cost | format_usd)) %} {% endif %} {% if summary.other_query_cost %} {% set _ = query_breakdown.append('Query ' ~ (summary.other_query_cost | format_usd)) %} {% endif %} {% if query_breakdown %} {{ query_breakdown | join(' · ') }} {% else %} Per run {% endif %}
{% if not local_runtime_mode %}

Estimated Savings

!
Estimated per-run savings for the visible rows, using the latest execution basis for each row.

{{ summary.total_possible_savings | format_usd }}

{% if running_solutions %} Updating as solutions finish {% elif summary.total_query_cost > 0 and summary.total_possible_savings > 0 %} {{ "%.0f" | format(summary.total_possible_savings | float / summary.total_query_cost | float * 100) }}% of visible query cost {% else %} Per run {% endif %}
{% endif %}

{% if local_runtime_mode %}Projected Savings{% else %}Verified Savings{% endif %}

!
{% if summary.verified_count > 0 %} Net post-merge savings confirmed by comparing actual BigQuery job costs before and after merge, minus solution generation overhead. {% else %} Net confirmed savings from solution dry-run comparisons, minus solution generation costs (LLM API overhead). {% endif %}
{% if summary.verified_count > 0 %}

{{ summary.verified_post_merge_savings | format_usd }}

{% else %}

{{ summary.total_savings | format_usd }}

{% endif %}
{% set savings_breakdown = [] %} {% if summary.build_possible_savings %} {% set _ = savings_breakdown.append('Build ' ~ (summary.build_possible_savings | format_usd)) %} {% endif %} {% if summary.consumption_possible_savings %} {% set _ = savings_breakdown.append('Consumption ' ~ (summary.consumption_possible_savings | format_usd)) %} {% endif %} {% if summary.other_possible_savings %} {% set _ = savings_breakdown.append('Query ' ~ (summary.other_possible_savings | format_usd)) %} {% endif %} {% if summary.verified_count > 0 or summary.collecting_count > 0 %} {{ summary.verified_count }} confirmed {% if summary.collecting_count > 0 %} · {{ summary.collecting_count }} collecting {% endif %} {% elif running_solutions %} Updating as solutions finish {% elif summary.total_query_cost > 0 and summary.total_savings > 0 %} {{ "%.0f" | format(summary.total_savings | float / summary.total_query_cost | float * 100) }}% of visible query cost {% else %} {% if savings_breakdown %} {{ savings_breakdown | join(' · ') }} {% else %} Dry-run {% endif %} {% endif %}
{# Clearing Savings Card — hidden in local mode; the single Projected Savings card above covers shadow-verified totals. #} {% if not local_runtime_mode %}

{% if local_runtime_mode %}Pending Verification Savings{% else %}Clearing Savings{% endif %}

!
{% if local_runtime_mode %} Expected savings from local changes that have been applied and are waiting for fresh warehouse evidence before confirmation. {% else %} Expected savings from opportunities currently in clearing state — fixes applied, waiting for cost data to settle before confirmation. {% endif %}

{{ summary.clearing_savings | default(0) | format_usd }}

{% if summary.clearing_count > 0 %} {{ summary.clearing_count }} {% if local_runtime_mode %}pending verification{% else %}settling{% endif %} {% else %} {% if local_runtime_mode %}no pending verification items{% else %}no clearing opportunities{% endif %} {% endif %}
{% endif %}