Skip to main content

When the four-block formula uses fewer blocks

Among 213 pre-certification overall cells in the frozen snapshot, the formula used a subset of its blocks in 21.1% of cells. Treating cohort-median fills as absent gives a share of 62.4%.

Sample
213 pre-certification overall cells
Snapshot
Observed version
5.1.0
On this page

What this study cannot tell you

  • Block-C substance gap. The census computes effective weights without a Block-C substance fraction. Live composition may further scale Block C when scorable substance is incomplete; this census does not measure that gap.
  • Imputed presence. Raw presence treats a non-null block score as present. Measured presence demotes C/M when c_status / m_status is IMPUTED_COHORT_MEDIAN. Display fill is not the same as measurement. A block whose status is NULL counts as measured rather than demoted, so the measured share published here is the generous reading of our own coverage: the true share of cells not resting on four measured blocks is at least this high, never lower. It is not a count of imputations — a cell whose Block M is simply absent carries no cohort median and still counts here.
  • What is new here. That the composite renormalises over the blocks present, and that Block C and Block M can be filled from a cohort median, were already disclosed on the methodology and brand pages. This study adds no mechanism — it is the first count of how often each path actually runs. Read it as a coverage census, not as a disclosure.
  • Live-upsert / asOf. The package is a point-in-time scan stamped by asOf. Live upserts after that stamp are outside the artefact.
  • Headline vs published populations. This package records population: published, so every share on this page has a denominator of 213 pre-certification overall cells. 675 overall cells exist against 213 passed the historical publication filter. Each share applies only to its own denominator.
  • Cell-vs-brand. Counts are overall brand_scores cells (brand × vertical × geo), not distinct brands. A brand can contribute multiple cells.
  • First-party exemption. The census uses IndexFair's own score records. Published counts are aggregated across cells.

Method

Start with the nominal weights for A, B, C and M when Block M is present. When M is absent, start with the nominal three-block weights. Set each absent block’s weight to zero. Divide the weight of each present block by the sum of those weights.

Effective weight = included block weight ÷ sum of included weights

If the sum is zero, every effective weight is zero. The census counts any presence pattern other than A+B+C+M as renormalised. It calculates raw and measured presence separately on the same frozen population.

Census query (SQL)
SELECT
  bs.brand_id AS "brandId",
  bs.block_a_score::float8 AS "blockAScore",
  bs.block_b_score::float8 AS "blockBScore",
  bs.block_c_score::float8 AS "blockCScore",
  bs.block_m_score::float8 AS "blockMScore",
  bs.c_status AS "cStatus",
  bs.m_status AS "mStatus",
  bs.score_mode AS "scoreMode",
  bs.floor_clamped AS "floorClamped",
  v.code AS "verticalCode",
  c.code AS "countryCode",
  bs.methodology_version AS "methodologyVersion",
  bs.publishable AS "publishable",
  bs.confidence_label AS "confidenceLabel",
  bs.score::float8 AS "score",
  (
    bs.aspect_id IS NULL
    AND bs.confidence_label <> 'insufficient'
    AND bs.publishable = true
    AND bs.score IS NOT NULL
    AND EXISTS (
      SELECT 1
      FROM brand_jurisdictions bj
      WHERE bj.brand_id = bs.brand_id
        AND bj.vertical_id = bs.vertical_id
        AND (
          bs.country_id IS NULL
          OR bj.country_id = bs.country_id
        )
        AND bj.status = 'active'
        AND bj.lifecycle_status = 'active'
        AND bj.legal_status = 'licensed'
        AND bj.display_mode IN ('in_rating', 'info_only')
    )
  ) AS "isPublished"
FROM brand_scores bs
INNER JOIN verticals v ON v.id = bs.vertical_id
LEFT JOIN countries c ON c.id = bs.country_id
WHERE bs.aspect_id IS NULL

The verification receipt records the snapshot, file digests and byte lengths.

Findings

All shares below are taken over 213 pre-certification overall cells. Raw-presence renormalised share: 21.1%. Measured-presence renormalised share: 62.4%.

Calculation modes

KeyCells
absolute84
ruler129

Block C measurement status

KeyCells
IMPUTED_COHORT_MEDIAN65
MEASURED130
null18

Block M measurement status

KeyCells
IMPUTED_COHORT_MEDIAN68
MEASURED105
NOT_APPLICABLE2
null38
Counts and effective weights by market

Presence census — raw

Presencescore_modeVerticalGeoCellswAwBwCwM
A+BabsolutecasinoBR10.4670.53300
A+BabsolutecasinoPT10.4670.53300
A+B+CabsolutebettingAU90.3500.4000.2500
A+B+CabsolutebettingCA50.3500.4000.2500
A+B+CabsolutebettingDE50.3500.4000.2500
A+B+CabsolutebettingES70.3500.4000.2500
A+B+CabsolutebettingNL30.3500.4000.2500
A+B+CabsolutebettingPT10.3500.4000.2500
A+B+CabsolutecasinoBR20.3500.4000.2500
A+B+CabsoluteexchangeGB10.3500.4000.2500
A+B+CabsoluteexchangeUS10.3500.4000.2500
A+B+CrulercasinoGB20.3500.4000.2500
A+B+C+MabsolutebettingUS90.2450.2800.1750.300
A+B+C+MabsolutecasinoCA40.2450.2800.1750.300
A+B+C+MabsolutecasinoES80.2450.2800.1750.300
A+B+C+MabsolutecasinoNL80.2450.2800.1750.300
A+B+C+MabsolutecasinoPT10.2450.2800.1750.300
A+B+C+MabsoluteexchangeGB60.2450.2800.1750.300
A+B+C+MabsoluteexchangeUS50.2450.2800.1750.300
A+B+C+MrulerbettingGB400.2450.2800.1750.300
A+B+C+MrulercasinoDE180.2450.2800.1750.300
A+B+C+MrulercasinoGB500.2450.2800.1750.300
A+B+C+MrulercasinoUS190.2450.2800.1750.300
A+B+MabsolutecasinoCA10.2970.33900.364
A+B+MabsoluteexchangeGB10.2970.33900.364
A+B+MabsoluteexchangeUS10.2970.33900.364
B+CabsolutebettingCA200.6150.3850
B+C+MabsolutecasinoCA200.3710.2320.397

Presence census — measured

Presencescore_modeVerticalGeoCellswAwBwCwM
A+BabsolutebettingAU40.4670.53300
A+BabsolutebettingCA10.4670.53300
A+BabsolutebettingUS10.4670.53300
A+BabsolutecasinoBR10.4670.53300
A+BabsolutecasinoCA10.4670.53300
A+BabsolutecasinoES20.4670.53300
A+BabsolutecasinoNL30.4670.53300
A+BabsolutecasinoPT10.4670.53300
A+BrulerbettingGB100.4670.53300
A+BrulercasinoDE70.4670.53300
A+BrulercasinoGB140.4670.53300
A+BrulercasinoUS20.4670.53300
A+B+CabsolutebettingAU50.3500.4000.2500
A+B+CabsolutebettingCA40.3500.4000.2500
A+B+CabsolutebettingDE50.3500.4000.2500
A+B+CabsolutebettingES70.3500.4000.2500
A+B+CabsolutebettingNL30.3500.4000.2500
A+B+CabsolutebettingPT10.3500.4000.2500
A+B+CabsolutebettingUS20.3500.4000.2500
A+B+CabsolutecasinoBR20.3500.4000.2500
A+B+CabsolutecasinoCA10.3500.4000.2500
A+B+CabsolutecasinoES20.3500.4000.2500
A+B+CabsolutecasinoNL30.3500.4000.2500
A+B+CabsoluteexchangeGB10.3500.4000.2500
A+B+CabsoluteexchangeUS10.3500.4000.2500
A+B+CrulerbettingGB60.3500.4000.2500
A+B+CrulercasinoDE60.3500.4000.2500
A+B+CrulercasinoGB40.3500.4000.2500
A+B+CrulercasinoUS60.3500.4000.2500
A+B+C+MabsolutebettingUS60.2450.2800.1750.300
A+B+C+MabsolutecasinoCA30.2450.2800.1750.300
A+B+C+MabsolutecasinoES30.2450.2800.1750.300
A+B+C+MabsolutecasinoNL20.2450.2800.1750.300
A+B+C+MabsolutecasinoPT10.2450.2800.1750.300
A+B+C+MabsoluteexchangeGB60.2450.2800.1750.300
A+B+C+MabsoluteexchangeUS50.2450.2800.1750.300
A+B+C+MrulerbettingGB210.2450.2800.1750.300
A+B+C+MrulercasinoGB250.2450.2800.1750.300
A+B+C+MrulercasinoUS80.2450.2800.1750.300
A+B+MabsolutecasinoES10.2970.33900.364
A+B+MabsoluteexchangeGB10.2970.33900.364
A+B+MabsoluteexchangeUS10.2970.33900.364
A+B+MrulerbettingGB30.2970.33900.364
A+B+MrulercasinoDE50.2970.33900.364
A+B+MrulercasinoGB90.2970.33900.364
A+B+MrulercasinoUS30.2970.33900.364
B+CabsolutebettingCA200.6150.3850
B+C+MabsolutecasinoCA200.3710.2320.397

Denominators

  • Headline cell count: 675
  • Published cell count: 213
  • Distinct brand count (package stamp; brand ids never written into buckets): 112
  • Floor-clamped cells: 3
  • Population filter: published
  • Environment: production

Corrections

Factual corrections to this study (method, denominators, or a reproduced share that disagrees with the frozen package) are free and open to everyone. Contact IndexFair. Corrections do not change scoring formulas; they correct the research artefact.

The frozen output contains aggregate cell counts and effective weights. The disclosed SQL describes the input selection. The verification receipt identifies the exact artefacts used for the census.