Should my dataset use logical or physical storage billing?

-- Compare the two storage billing models per dataset, and price the
-- model each dataset is on today.
-- US multi-region list prices: logical $0.02/GiB active, $0.01 long-term;
-- physical $0.04/GiB active, $0.02 long-term. Substitute your region's rates.
-- active_physical_bytes already includes the time-travel bytes, so they are
-- not added a second time; fail-safe bytes are billed on top at the active
-- rate. A deleted table bills physical bytes until its time travel and
-- fail-safe windows end, and logical bytes not at all. Base tables only, as
-- in Google's own forecast: clones and snapshots report full-table sizes.
WITH models AS (
  SELECT
    table_schema,
    ROUND(SUM(IF(deleted, 0, active_logical_bytes))    / POW(1024, 3) * 0.02
        + SUM(IF(deleted, 0, long_term_logical_bytes)) / POW(1024, 3) * 0.01, 2) AS logical_model_usd,
    ROUND(SUM(active_physical_bytes + fail_safe_physical_bytes)
            / POW(1024, 3) * 0.04
        + SUM(long_term_physical_bytes) / POW(1024, 3) * 0.02, 2)  AS physical_model_usd,
    ROUND(SAFE_DIVIDE(
      SUM(IF(deleted, 0, total_logical_bytes)),
      SUM(IF(deleted, 0, total_physical_bytes - time_travel_physical_bytes))), 2)
                                                                   AS compression_ratio
  FROM `region-us`.INFORMATION_SCHEMA.TABLE_STORAGE
  WHERE table_type = 'BASE TABLE'
  GROUP BY table_schema
),
billing AS (
  -- A dataset with no storage_billing_model row bills logical bytes.
  SELECT
    schema_name                                                    AS table_schema,
    UPPER(REPLACE(option_value, '"', ''))                          AS billing_model
  FROM `region-us`.INFORMATION_SCHEMA.SCHEMATA_OPTIONS
  WHERE option_name = 'storage_billing_model'
)
SELECT
  m.table_schema,
  IFNULL(b.billing_model, 'LOGICAL')                               AS billing_model,
  IF(IFNULL(b.billing_model, 'LOGICAL') = 'PHYSICAL',
     m.physical_model_usd, m.logical_model_usd)                    AS cost_today_usd,
  m.logical_model_usd,
  m.physical_model_usd,
  m.compression_ratio
FROM models m
LEFT JOIN billing b USING (table_schema)
ORDER BY cost_today_usd DESC;