Auction telemetry addendum: rollup correctness, breakdown dimensions, and dashboard spec

[jevansnyc]

Spec addendum sourced from 2026-07-30-auction-telemetry-addendum-dimensions-dashboard.md. Amends the parent auction-telemetry design (2026-06-22-auction-prebid-metrics-tinybird-grafana-design.md, shipped in #818).

Auction telemetry addendum: rollup correctness, breakdown dimensions, and dashboard specification

Date: 2026-07-30
Status: Draft for engineering review
Amends: 2026-06-22-auction-prebid-metrics-tinybird-grafana-design.md (shipped in #818)

Problem

The phase-1 pipeline shipped in #818 emits the right raw rows, but the layer
between auction_events_raw and Grafana loses information and the dashboard
does not answer the questions the design set out to answer.

A product review of the live dashboard (2026-07-30) found four classes of
problems:

1. Cross-panel inconsistency. The auction summary panel showed 3
   auction_api auctions total while provider health showed roughly 20,500
   provider calls per provider and seat yield showed 30,735 bids on the same
   source. Summary, provider, and bid rows for one auction are emitted in a
   single batch, so this ratio is structurally impossible in the raw data.
   Nothing on the dashboard surfaces the discrepancy; root cause is not yet
   confirmed (see Investigation below).
2. Silent row dropping in the materialized views. Three IS NOT NULL
   row filters in the MVs contradict the parent design's accounting rules and
   bias the aggregates:
   • auction_provider_stats_mv drops provider-call rows with null
     provider_response_time_ms. Launch errors and dispatch-abandoned calls
     legitimately have no latency, so provider error and abandonment counts
     undercount.
   • auction_bid_stats_mv drops bid rows with null price_cpm. The parent
     design states null-price bids still count as bids. A winning bid with a
     null raw price disappears entirely, so wins undercount.
   • auction_overview_mv drops summary rows with null total_time_ms. The
     builder currently always sets the field, but any future outcome that does
     not will vanish without trace.
3. Missing breakdown dimensions. country, region, and is_mobile are
   emitted on every raw row but are discarded by every rollup, so they are
   unqueryable from the dashboard and die with the 30-day raw TTL. Browser
   family is not emitted at all. A publisher customer has asked for breakdowns
   by device (mobile vs desktop), browser, country, and domain. Domain already
   exists in every rollup; the other three do not survive to the dashboard.
4. The dashboard shows endpoint dumps, not answers. No time series, no
   fill rate, no terminal_reason breakdown (85% of initial-navigation
   candidates were skipped with no visible reason), no sample counts, no
   freshness or quarantine panels (the quarantine pipe is a stub returning
   unconfigured), a win_rate label that reads as auction win rate but is
   bid win share, total_time_ms on initial navigation that reads as added
   latency but is time-to-collection, and CPM quantiles that ignore currency.
   The dashboard itself is hand-built and exists nowhere in the repo.

This addendum specifies the fixes, the new dimensional rollups, the small edge
change for browser signals, and a dashboard-as-code panel specification. The
directional, best-effort data contract from the parent design is unchanged.

Investigation: the auction_api summary gap

Before any schema work, confirm where completed auction_api summary rows are
lost. Run against the workspace:

SELECT auction_source, event_kind, terminal_status, count() AS rows,
       uniqExact(auction_id) AS auctions
FROM auction_events_raw
WHERE event_ts >= now() - INTERVAL 1 DAY
GROUP BY auction_source, event_kind, terminal_status
ORDER BY auction_source, event_kind

Interpretation:

• Raw has the summaries, rollup does not: the overview MV was deployed or
  redeployed after ingestion started (Tinybird MVs process only rows inserted
  after the MV exists) or rows fail an MV filter. Fix by repopulating the
  rollup from raw.
• Raw is missing the summaries: emission or delivery. Check the
  auction_events_raw quarantine table for rejected rows, then the batch size
  guard (tinybird.max_body_bytes drops whole batches, but provider rows
  arriving without summaries rules out whole-batch loss, which points back to
  per-row quarantine).
• Raw is fine and the rollup is fine: Grafana panel filters differ, most
  likely a publisher parameter. Note Use configured publisher domain for navigation-path auction requests #937 changed publisher_domain
  attribution for navigation paths after Add direct Tinybird auction telemetry #818, so auction_api rows can carry
  a different domain than navigation rows for the same site. Neither current
  table panel displays publisher_domain.

The reconciliation endpoint in this addendum makes this class of failure
self-announcing regardless of cause.

Decision summary

1. Fix the three MV null filters by moving null handling into conditional
   aggregate combinators. Rows are never dropped; nulls are excluded from
   quantiles only. Add explicit sample-count columns so panels can display n.
2. Keep the existing per-minute rollups for time series. Add a second family
   of hourly dimensional rollups carrying country, device_class,
   browser_family, and os_family for breakdown panels. Do not add these
   dimensions to the per-minute rollups; the cardinality product would slow
   every panel to serve a use case that does not need minute grain.
3. Emit two new coarse fields from the edge: browser_family and os_family.
   Both derive from signals DeviceSignals already computes or can compute
   from the UA without storing it. No raw UA, IP, or fingerprint value is
   emitted; the privacy posture of the parent design is unchanged.
4. Add currency to the bid rollups and endpoints. CPM quantiles are always
   computed and displayed per currency.
5. Replace the quarantine stub with the workspace quarantine source and add a
   raw-data reconciliation endpoint.
6. Ship the Grafana dashboard as provisioned JSON in the repo, with a panel
   specification (below) that every future change is reviewed against.
7. Rename or relabel misleading measures: win_rate becomes
   bid_win_share; total_time_ms for initial_navigation is labeled
   "time to collection" wherever displayed.

A. Edge changes (Rust)

New fields

Add to AuctionObservationContext and every emitted row:

field	type	values
browser_family	LowCardinality(String)	chrome / edge / safari / firefox / samsung / opera / other / unknown
os_family	LowCardinality(String)	windows / mac / ios / android / linux / other / unknown

• os_family is DeviceSignals.platform_class mapped to the bounded set,
  with unknown for None.
• browser_family is a new pure function in ec/device.rs beside
  parse_platform_class, an ordered allowlist match on the UA string. Order
  matters: Edg before Chrome, SamsungBrowser before Chrome, OPR
  before Chrome, Chrome/CriOS before Safari, Firefox/FxiOS before
  Safari. Anything matching none of the tokens is other; empty UA is
  unknown. The function returns an enum-backed &'static str, never a UA
  substring, so cardinality is bounded by construction.
• Both fields snapshot into the observation context at creation, same as
  is_mobile, so there is no re-parsing and no divergence between row kinds
  of one auction.

Privacy note: the parent design's guarantees hold. The new fields are coarse
classifications from an allowlist, not UA substrings, and are shared by very
large user populations. Existing tests asserting no raw UA serialization gain
cases for the new fields.

Unchanged

Emission lifecycle, batching, sink, and the fire-and-forget transport are
untouched by this addendum.

B. Tinybird: raw datasource migration

Add to auction_events_raw (additive, defaulted, so historical rows and
lagging edge versions remain valid):

`browser_family` LowCardinality(String) DEFAULT 'unknown',
`os_family` LowCardinality(String) DEFAULT 'unknown'

Rows from edge versions that predate the field arrive without the key and take
the default. No sorting-key change.

C. Tinybird: fixed per-minute materialized views

The three MVs are re-specified as follows. The pattern is identical in each:
the row-kind filter and dimension null guards remain in WHERE; measure null
guards move into combinators.

auction_overview_mv (replaces the total_time_ms IS NOT NULL filter):

SELECT
  toStartOfMinute(event_ts) AS minute,
  publisher_domain,
  auction_source,
  assumeNotNull(terminal_status) AS terminal_status,
  terminal_reason,
  countState() AS auctions,
  sumState(toUInt64(coalesce(slot_count, 0))) AS requested_slots,
  sumState(toUInt64(coalesce(winning_bid_count, 0))) AS winning_bids,
  countStateIf(total_time_ms IS NOT NULL) AS timed_auctions,
  quantilesStateIf(0.5, 0.95, 0.99)(coalesce(total_time_ms, 0), total_time_ms IS NOT NULL)
    AS total_time_quantiles
FROM auction_events_raw
WHERE event_kind = 'summary' AND terminal_status IS NOT NULL
GROUP BY minute, publisher_domain, auction_source, terminal_status, terminal_reason

auction_provider_stats_mv (replaces the provider_response_time_ms IS NOT NULL filter; abandoned and launch-error calls now count):

  countState() AS requests,
  ...existing status sums unchanged...,
  countStateIf(provider_response_time_ms IS NOT NULL) AS latency_samples,
  quantilesStateIf(0.5, 0.95, 0.99)(coalesce(provider_response_time_ms, 0),
    provider_response_time_ms IS NOT NULL) AS latency_quantiles
WHERE event_kind = 'provider_call' AND provider IS NOT NULL
  AND provider_role IS NOT NULL AND status IS NOT NULL

auction_bid_stats_mv (replaces the price_cpm IS NOT NULL filter; adds
currency; null-price bids and wins now count):

SELECT
  toStartOfMinute(event_ts) AS minute,
  publisher_domain,
  auction_source,
  assumeNotNull(provider) AS provider,
  assumeNotNull(seat) AS seat,
  coalesce(currency, 'unknown') AS currency,
  countState() AS bids,
  countStateIf(price_cpm IS NOT NULL) AS priced_bids,
  sumState(toUInt64(coalesce(is_win, 0) = 1)) AS wins,
  quantilesStateIf(0.5, 0.95, 0.99)(coalesce(price_cpm, 0),
    coalesce(is_win, 0) = 1 AND price_cpm IS NOT NULL) AS winning_cpm_quantiles
FROM auction_events_raw
WHERE event_kind = 'bid' AND provider IS NOT NULL AND seat IS NOT NULL
GROUP BY minute, publisher_domain, auction_source, provider, seat, currency

Rollup target datasources gain the corresponding columns (timed_auctions,
latency_samples, priced_bids, currency). currency joins the bid
rollup sorting key.

Migration note. Changing an MV or its target requires a rebuild of the
rollup; Tinybird materializations do not retroactively process existing rows.
Plan a repopulate from auction_events_raw (30-day retention bounds the
backfill) in the same deployment, and treat rollup history older than 30 days
as carrying the pre-fix bias. Endpoints must read the new sample-count columns
with countMerge.

D. Tinybird: hourly dimensional rollups

Three new materialized views and target datasources, mirroring the per-minute
family at hour grain with breakdown dimensions. device_class is derived once
in the MV: is_mobile 0 maps to desktop, 1 to mobile, 2 to unknown.

• auction_overview_dims_rollup: key (event_date, hour, publisher_domain, auction_source, terminal_status, country, device_class, browser_family, os_family); measures auctions, requested_slots, winning_bids.
  terminal_reason is deliberately excluded here; reason analysis stays on
  the per-minute rollup to keep this table's cardinality down.
• auction_provider_dims_rollup: key (event_date, hour, publisher_domain, auction_source, provider, country, device_class, browser_family); measures
  requests, successes, nobids, errors, timeouts, abandonments,
  latency_samples, latency_quantiles.
• auction_bid_dims_rollup: key (event_date, hour, publisher_domain, auction_source, provider, seat, currency, country, device_class, browser_family); measures bids, priced_bids, wins,
  winning_cpm_quantiles.

Retention 13 months, same as the per-minute family. Real-world cardinality is
sparse (only observed combinations materialize), and hour grain keeps the
worst case bounded. If a deployment still grows too large, drop os_family
from the overview key first; it is the least requested dimension.

Three new published endpoints (auction_dims, provider_dims, seat_dims)
expose them with the standard time-range, publisher, source, and
per-dimension filters. Grafana does grouping; the endpoints only filter and
merge.

E. Tinybird: health endpoints

• Quarantine. Replace the quarantine_counts stub with a query against
  the workspace quarantine companion (auction_events_raw_quarantine) or the
  Tinybird service data source for datasource operations, whichever the
  current Tinybird release documents, returning rows quarantined in the last
  24 hours plus the most recent quarantine error strings. The endpoint
  contract (datasource, quarantined_rows, checked_at, status) is unchanged, so
  the panel does not care which source backs it. Deployment smoke tests must
  assert status != 'unconfigured'.
• Reconciliation. New endpoint event_reconciliation over raw, last 24
  hours, per auction_source: uniqExact(auction_id) where
  event_kind = 'summary', the same where event_kind = 'provider_call', and
  their difference. Healthy is a difference of zero (allowing best-effort
  slack); the dashboard alerts visually when provider-call auctions exceed
  summary auctions by more than 2%. This turns the class of bug found in the
  2026-07-30 review into a red panel instead of a support escalation.

F. Grafana: dashboard as code

Add grafana/dashboards/auction-telemetry.json (provisioning-ready) plus a
README documenting the Infinity datasource and read-token setup. Hand-edited
dashboards are prohibited going forward; the JSON in the repo is the artifact
of record. Panel specification, top to bottom:

1. Health strip. Ingestion freshness lag per source, quarantined rows
   (24h), reconciliation delta per source, raw rows per minute. Static text:
   "Directional, best-effort analytics. Not for billing or reconciliation."
2. KPI row (completed auctions unless noted): auctions per minute by
   source (time series); completion rate; fill rate (winning bids over
   requested slots, completed only); abandonment rate; skipped share of
   candidates. Every rate shows its denominator as n.
3. Why auctions skip. Time series and table of terminal_reason for
   skipped and abandoned summaries. This panel exists because 85% of
   initial-navigation candidates were skipping with no visible cause.
4. Provider health. Error rate, no-bid rate, timeout count per provider
   (time series, sample counts); latency p50/p95 per provider from
   latency_samples-labeled quantiles. Abandonments plotted separately, not
   inside error rate.
5. Yield. Winning CPM p50/p95 by seat, one panel per currency, labeled
   "priced bids only"; bid_win_share by seat with its definition in the
   panel description; wins by seat over time.
6. Breakdowns (hourly rollups): fill rate, provider error rate, and
   winning CPM cut by country, device_class, browser_family, and
   publisher_domain. Template variables for each dimension.

Labeling rules, enforced in review: every rate and quantile panel displays its
sample count; total_time_ms for initial_navigation is always titled "time
to collection (includes origin race)"; no panel title uses the bare phrase
"win rate".

Testing

• Unit tests for parse_browser_family covering the ordered-token pitfalls
  (Edge, Samsung Internet, Opera, iOS Chrome/Firefox reporting as Safari
  lookalikes) and asserting the return set is closed.
• Fixture NDJSON gains rows with null provider_response_time_ms (launch
  error, abandoned), null price_cpm bids including a null-price win, and a
  non-USD currency. tb test cases assert these rows are counted, excluded
  from quantiles, and split by currency.
• A reconciliation fixture where provider-call auctions exceed summaries
  asserts the endpoint reports the delta.
• Privacy tests extend to the two new fields: values must be members of the
  closed sets, never UA substrings.
• Deployment smoke test asserts quarantine endpoint is configured and rollup
  repopulation ran (row counts in rebuilt rollups match a raw control query).

Rollout order

1. Run the investigation query; root-cause and fix the auction_api summary
   gap. Do not build on the pipeline before trusting it.
2. Deploy raw datasource additive columns, then edge emission of the new
   fields (order matters; unknown keys would otherwise quarantine).
3. Deploy fixed per-minute MVs and rollup schemas with repopulate.
4. Deploy dimensional rollups and new endpoints; backfill from the 30-day raw
   window so breakdown panels are not empty on day one.
5. Deploy the provisioned dashboard JSON; retire the hand-built dashboard.

Out of scope

Unchanged from the parent design: alerting rules, billing-grade delivery,
exactly-once semantics, per-creative analytics, currency conversion (CPMs are
reported per currency, not normalized), and ops access-log telemetry.

[jevansnyc]

Artifact bundle: Tinybird + Grafana (2026-07-30)

Reference implementation for this addendum, posted for review. Not yet landed in the repo — these overwrite tracked tinybird/ files and add a new grafana/ tree, so they should go in via PR once reviewed. Edge Rust work (parse_browser_family, context/row structs, tests) is a separate PR and is not in this bundle.

Key files inline in the comments below: the three fixed per-minute MVs, the health endpoints, and the dashboard JSON. Full set is 24 files (13 modify tracked files, 11 new).

---

Auction telemetry addendum bundle (2026-07-30)

Implements the 2026-07-30 addendum to
docs/superpowers/specs/2026-06-22-auction-prebid-metrics-tinybird-grafana-design.md.

Contents:

• tinybird/datasources/: full replacements for the four existing datasource
  files (raw + three per-minute rollups) and three new hourly dimensional
  rollups. Raw changes are additive (browser_family, os_family,
  defaulted).
• tinybird/pipes/: fixed per-minute MVs (no more silent row drops; null
  handling in combinators; sample-count columns), three new dims MVs, updated
  endpoints (scalar p50/p95/p99 columns, currency on seat yield,
  bid_win_share rename), real quarantine_counts, and new
  event_reconciliation.
• grafana/: provisioned dashboard JSON plus setup README.

NOT included (edge work, separate PR): Rust emission of browser_family and
os_family (parse_browser_family in ec/device.rs,
AuctionObservationContext, row structs, tests), fixture NDJSON updates, and
tb test cases per the addendum's Testing section.

Deploy order matters (addendum, Rollout section):

1. Root-cause the auction_api summary gap first (investigation query in the
   addendum; event_reconciliation.pipe here makes it permanent).
2. Raw datasource additive columns, then edge emission.
3. Fixed per-minute MVs and rollup schemas, with rollup repopulate (Tinybird
   MVs only process new inserts; 30-day raw window bounds backfill).
4. Dims rollups + endpoints, backfill from raw.
5. Dashboard JSON; retire the hand-built dashboard.

Verify before deploy: the auction_events_raw_quarantine table/column names
in quarantine_counts.pipe against the workspace's Tinybird release, and run
tb deploy --check on a branch.

[jevansnyc]

A. Correctness fixes — per-minute MVs

Null measure-guards moved out of WHERE into conditional combinators so rows are no longer silently dropped; explicit sample-count columns added.

tinybird/pipes/auction_overview_mv.pipe (modified)

DESCRIPTION >
  Materialized per-minute auction overview from summary rows.
  2026-07-30 addendum: no longer drops summary rows with null total_time_ms;
  null handling moved into conditional combinators. timed_auctions carries the
  quantile sample count.

NODE auction_overview_mv
SQL >
  SELECT
    toStartOfMinute(event_ts) AS minute,
    publisher_domain,
    auction_source,
    assumeNotNull(terminal_status) AS terminal_status,
    terminal_reason,
    countState() AS auctions,
    sumState(toUInt64(coalesce(slot_count, 0))) AS requested_slots,
    sumState(toUInt64(coalesce(winning_bid_count, 0))) AS winning_bids,
    sumState(toUInt64(total_time_ms IS NOT NULL)) AS timed_auctions,
    quantilesStateIf(0.5, 0.95, 0.99)(toUInt32(coalesce(total_time_ms, 0)), total_time_ms IS NOT NULL) AS total_time_quantiles
  FROM auction_events_raw
  WHERE event_kind = 'summary'
    AND terminal_status IS NOT NULL
  GROUP BY
    minute,
    publisher_domain,
    auction_source,
    terminal_status,
    terminal_reason

TYPE materialized
DATASOURCE auction_overview_rollup

tinybird/pipes/auction_provider_stats_mv.pipe (modified)

DESCRIPTION >
  Materialized per-minute provider-call health and latency rollup.
  2026-07-30 addendum: no longer drops calls with null latency (launch errors
  and abandoned calls now count in requests/errors/abandonments). Latency
  quantiles exclude null latencies via combinators; latency_samples carries
  the quantile sample count.

NODE auction_provider_stats_mv
SQL >
  SELECT
    toStartOfMinute(event_ts) AS minute,
    publisher_domain,
    auction_source,
    assumeNotNull(provider) AS provider,
    assumeNotNull(provider_role) AS provider_role,
    countState() AS requests,
    sumState(toUInt64(status = 'success')) AS successes,
    sumState(toUInt64(status = 'nobid')) AS nobids,
    sumState(toUInt64(status IN ('launch_error', 'parse_error', 'transport_error', 'http_status_error'))) AS errors,
    sumState(toUInt64(status = 'timeout')) AS timeouts,
    sumState(toUInt64(status = 'abandoned')) AS abandonments,
    sumState(toUInt64(coalesce(provider_bid_count, 0))) AS parsed_bids,
    sumState(toUInt64(provider_response_time_ms IS NOT NULL)) AS latency_samples,
    quantilesStateIf(0.5, 0.95, 0.99)(toUInt32(coalesce(provider_response_time_ms, 0)), provider_response_time_ms IS NOT NULL) AS latency_quantiles
  FROM auction_events_raw
  WHERE event_kind = 'provider_call'
    AND provider IS NOT NULL
    AND provider_role IS NOT NULL
    AND status IS NOT NULL
  GROUP BY
    minute,
    publisher_domain,
    auction_source,
    provider,
    provider_role

TYPE materialized
DATASOURCE auction_provider_stats_rollup

tinybird/pipes/auction_bid_stats_mv.pipe (modified)

DESCRIPTION >
  Materialized per-minute bid and canonical winner rollup.
  2026-07-30 addendum: no longer drops null-price bids (they count as bids and
  wins per the parent design); adds currency dimension and priced_bids. CPM
  quantiles remain priced winning bids only.

NODE auction_bid_stats_mv
SQL >
  SELECT
    toStartOfMinute(event_ts) AS minute,
    publisher_domain,
    auction_source,
    assumeNotNull(provider) AS provider,
    assumeNotNull(seat) AS seat,
    coalesce(currency, 'unknown') AS currency,
    countState() AS bids,
    sumState(toUInt64(price_cpm IS NOT NULL)) AS priced_bids,
    sumState(toUInt64(coalesce(is_win, 0) = 1)) AS wins,
    quantilesStateIf(0.5, 0.95, 0.99)(toFloat64(coalesce(price_cpm, 0)), coalesce(is_win, 0) = 1 AND price_cpm IS NOT NULL) AS winning_cpm_quantiles
  FROM auction_events_raw
  WHERE event_kind = 'bid'
    AND provider IS NOT NULL
    AND seat IS NOT NULL
  GROUP BY
    minute,
    publisher_domain,
    auction_source,
    provider,
    seat,
    currency

TYPE materialized
DATASOURCE auction_bid_stats_rollup

[jevansnyc]

E. Health endpoints

quarantine_counts replaced its unconfigured stub; event_reconciliation is new (summary vs provider_call auction counts per source, last 24h) so the auction_api gap self-announces.

tinybird/pipes/quarantine_counts.pipe (modified)

DESCRIPTION >
  Quarantine visibility for the dashboard health strip. Replaces the phase-1
  stub. Reads the Tinybird quarantine companion table for auction_events_raw.
  NOTE: verify the quarantine table name and error-column names against the
  workspace's Tinybird release before deploy; the endpoint contract
  (datasource, quarantined_rows, checked_at, status) must not change.

NODE endpoint
SQL >
  SELECT
    'auction_events_raw' AS datasource,
    count() AS quarantined_rows,
    max(insertion_date) AS latest_quarantine_ts,
    any(c__error) AS sample_error,
    now() AS checked_at,
    if(count() = 0, 'ok', 'quarantining') AS status
  FROM auction_events_raw_quarantine
  WHERE insertion_date >= now() - INTERVAL 1 DAY

TYPE endpoint

tinybird/pipes/event_reconciliation.pipe (new)

DESCRIPTION >
  Raw-data reconciliation endpoint for the dashboard health strip. New in the
  2026-07-30 addendum. Compares distinct auction ids seen on summary rows vs
  provider_call rows per source over the last 24 hours. provider-call auctions
  exceeding summary auctions means summaries are being lost (emission,
  delivery, quarantine, or rollup); the dashboard alerts above 2%.

NODE endpoint
SQL >
  SELECT
    auction_source,
    uniqExactIf(auction_id, event_kind = 'summary') AS summary_auctions,
    uniqExactIf(auction_id, event_kind = 'provider_call') AS provider_call_auctions,
    toInt64(provider_call_auctions) - toInt64(summary_auctions) AS missing_summaries,
    if(provider_call_auctions = 0, 0, greatest(0, toFloat64(provider_call_auctions - summary_auctions)) / provider_call_auctions) AS missing_summary_share
  FROM auction_events_raw
  WHERE event_ts >= now() - INTERVAL 1 DAY
    AND ({{String(publisher, '')}} = '' OR publisher_domain = {{String(publisher, '')}})
  GROUP BY auction_source
  ORDER BY missing_summary_share DESC

TYPE endpoint

[jevansnyc]

F. Grafana dashboard as code

Provisioning-ready dashboard JSON plus setup README. This is the artifact of record; hand-edited dashboards are prohibited going forward.

grafana/README.md (new)

Grafana dashboard for Trusted Server auction telemetry

This dashboard is the artifact of record. Do not hand-edit dashboards in the
Grafana UI without exporting the result back into this file in the same PR.

Setup

1. Install the Infinity datasource plugin (yesoreyeram-infinity-datasource).
2. Create an Infinity datasource pointed at your Tinybird regional API host
   (e.g. https://api.tinybird.co, region-specific). Set the base URL in the
   datasource so panel URLs can stay relative (/v0/pipes/...).
3. Put the Tinybird read token (scoped to the published pipes only, never
   the append or admin token) in the datasource's secure auth configuration
   (Bearer). Tokens never go in the dashboard JSON or template variables.
4. Import dashboards/auction-telemetry.json (or provision it via a
   dashboards provider) and select the Infinity datasource in the
   tinybird_ds variable.

Conventions

• Every rate/quantile panel names its sample-size field in the title or
  description (requests, latency_samples, timed_auctions, requested_slots).
• total_time_ms for initial_navigation is titled "time to collection"; it
  includes the origin race and is not added TTFB.
• The phrase "win rate" is banned from panel titles; the seat measure is
  bid_win_share.
• The health strip (freshness, quarantine, reconciliation) is the first row.
  If it is red, do not read the rest of the dashboard as truth.

Known follow-ups

• The partitionByValues and groupBy transformation field names assume the
  endpoint column names in tinybird/pipes/; if a pipe changes, re-export.
• Breakdown row uses hourly dims endpoints; add browser/device/country
  template variables wired to *_filter params if per-value filtering (not
  just grouping) is needed.

grafana/dashboards/auction-telemetry.json (new)

499-line dashboard JSON

{
  "__inputs": [],
  "title": "Trusted Server: Auction Telemetry (directional)",
  "uid": "ts-auction-telemetry",
  "tags": ["trusted-server", "auction-telemetry"],
  "timezone": "browser",
  "schemaVersion": 39,
  "version": 1,
  "editable": true,
  "graphTooltip": 1,
  "time": { "from": "now-6h", "to": "now" },
  "refresh": "1m",
  "templating": {
    "list": [
      {
        "name": "tinybird_ds",
        "label": "Tinybird (Infinity)",
        "type": "datasource",
        "query": "yesoreyeram-infinity-datasource"
      },
      {
        "name": "publisher",
        "label": "Publisher domain",
        "type": "textbox",
        "query": "",
        "current": { "text": "", "value": "" }
      },
      {
        "name": "source",
        "label": "Auction source",
        "type": "custom",
        "query": ", initial_navigation, spa_navigation, auction_api",
        "current": { "text": "", "value": "" }
      },
      {
        "name": "provider",
        "label": "Provider",
        "type": "textbox",
        "query": "",
        "current": { "text": "", "value": "" }
      }
    ]
  },
  "panels": [
    { "type": "row", "title": "Health: trust this window before reading anything below", "gridPos": { "h": 1, "w": 24, "x": 0, "y": 0 }, "id": 100, "collapsed": false },
    {
      "type": "stat",
      "title": "Ingestion freshness lag (worst source)",
      "id": 1,
      "gridPos": { "h": 5, "w": 4, "x": 0, "y": 1 },
      "datasource": { "type": "yesoreyeram-infinity-datasource", "uid": "${tinybird_ds}" },
      "targets": [
        {
          "refId": "A", "type": "json", "source": "url", "parser": "backend", "format": "table",
          "url": "/v0/pipes/ingestion_freshness.json",
          "url_options": { "method": "GET", "params": [ { "key": "publisher", "value": "$publisher" } ] },
          "root_selector": "data", "columns": []
        }
      ],
      "options": { "reduceOptions": { "calcs": ["max"], "fields": "/^freshness_lag_seconds$/" }, "colorMode": "background" },
      "fieldConfig": { "defaults": { "unit": "s", "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "yellow", "value": 300 }, { "color": "red", "value": 900 } ] } }, "overrides": [] }
    },
    {
      "type": "stat",
      "title": "Quarantined rows (24h)",
      "id": 2,
      "gridPos": { "h": 5, "w": 4, "x": 4, "y": 1 },
      "datasource": { "type": "yesoreyeram-infinity-datasource", "uid": "${tinybird_ds}" },
      "targets": [
        {
          "refId": "A", "type": "json", "source": "url", "parser": "backend", "format": "table",
          "url": "/v0/pipes/quarantine_counts.json",
          "url_options": { "method": "GET", "params": [] },
          "root_selector": "data", "columns": []
        }
      ],
      "options": { "reduceOptions": { "calcs": ["lastNotNull"], "fields": "/^quarantined_rows$/" }, "colorMode": "background" },
      "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 1 } ] } }, "overrides": [] }
    },
    {
      "type": "table",
      "title": "Reconciliation: summaries vs provider calls (24h, raw)",
      "description": "provider_call auctions exceeding summary auctions means summary rows are being lost (emission, delivery, quarantine, or rollup desync). Investigate anything above 2%.",
      "id": 3,
      "gridPos": { "h": 5, "w": 10, "x": 8, "y": 1 },
      "datasource": { "type": "yesoreyeram-infinity-datasource", "uid": "${tinybird_ds}" },
      "targets": [
        {
          "refId": "A", "type": "json", "source": "url", "parser": "backend", "format": "table",
          "url": "/v0/pipes/event_reconciliation.json",
          "url_options": { "method": "GET", "params": [ { "key": "publisher", "value": "$publisher" } ] },
          "root_selector": "data", "columns": []
        }
      ],
      "fieldConfig": {
        "defaults": {},
        "overrides": [
          {
            "matcher": { "id": "byName", "options": "missing_summary_share" },
            "properties": [
              { "id": "unit", "value": "percentunit" },
              { "id": "custom.cellOptions", "value": { "type": "color-background" } },
              { "id": "thresholds", "value": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 0.02 } ] } }
            ]
          }
        ]
      }
    },
    {
      "type": "text",
      "title": "",
      "id": 4,
      "gridPos": { "h": 5, "w": 6, "x": 18, "y": 1 },
      "options": { "mode": "markdown", "content": "**Directional, best-effort analytics.**\n\nFire-and-forget edge ingestion: rows can be lost or duplicated. Not for billing, reconciliation, or contractual reporting. Every rate and quantile panel shows its sample count. Compare like-for-like sources over long windows." }
    },
    { "type": "row", "title": "Auctions", "gridPos": { "h": 1, "w": 24, "x": 0, "y": 6 }, "id": 101, "collapsed": false },
    {
      "type": "timeseries",
      "title": "Auctions per minute by source and terminal status",
      "id": 5,
      "gridPos": { "h": 8, "w": 12, "x": 0, "y": 7 },
      "datasource": { "type": "yesoreyeram-infinity-datasource", "uid": "${tinybird_ds}" },
      "targets": [
        {
          "refId": "A", "type": "json", "source": "url", "parser": "backend", "format": "table",
          "url": "/v0/pipes/auction_summary.json",
          "url_options": { "method": "GET", "params": [
            { "key": "start", "value": "${__from:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "end", "value": "${__to:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "publisher", "value": "$publisher" },
            { "key": "source", "value": "$source" }
          ] },
          "root_selector": "data", "columns": []
        }
      ],
      "transformations": [
        { "id": "convertFieldType", "options": { "conversions": [ { "targetField": "minute", "destinationType": "time" } ] } },
        { "id": "organize", "options": { "includeByName": { "minute": true, "auction_source": true, "terminal_status": true, "auctions": true } } },
        { "id": "partitionByValues", "options": { "fields": ["auction_source", "terminal_status"], "keepFields": false } }
      ],
      "fieldConfig": { "defaults": { "custom": { "drawStyle": "line", "spanNulls": true } }, "overrides": [] }
    },
    {
      "type": "timeseries",
      "title": "Fill rate, completed auctions (winning bids / requested slots)",
      "description": "Sample size = requested_slots. Completed auctions only.",
      "id": 6,
      "gridPos": { "h": 8, "w": 12, "x": 12, "y": 7 },
      "datasource": { "type": "yesoreyeram-infinity-datasource", "uid": "${tinybird_ds}" },
      "targets": [
        {
          "refId": "A", "type": "json", "source": "url", "parser": "backend", "format": "table",
          "url": "/v0/pipes/auction_summary.json",
          "url_options": { "method": "GET", "params": [
            { "key": "start", "value": "${__from:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "end", "value": "${__to:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "publisher", "value": "$publisher" },
            { "key": "source", "value": "$source" }
          ] },
          "root_selector": "data", "columns": []
        }
      ],
      "transformations": [
        { "id": "filterByValue", "options": { "filters": [ { "fieldName": "terminal_status", "config": { "id": "equal", "options": { "value": "completed" } } } ], "type": "include", "match": "all" } },
        { "id": "convertFieldType", "options": { "conversions": [ { "targetField": "minute", "destinationType": "time" } ] } },
        { "id": "organize", "options": { "includeByName": { "minute": true, "auction_source": true, "fill_rate": true, "requested_slots": true } } },
        { "id": "partitionByValues", "options": { "fields": ["auction_source"], "keepFields": false } }
      ],
      "fieldConfig": { "defaults": { "unit": "percentunit", "max": 1, "custom": { "drawStyle": "line", "spanNulls": true } }, "overrides": [ { "matcher": { "id": "byRegexp", "options": ".*requested_slots.*" }, "properties": [ { "id": "unit", "value": "none" }, { "id": "custom.axisPlacement", "value": "right" } ] } ] }
    },
    {
      "type": "timeseries",
      "title": "Time to collection, completed (includes origin race; NOT added latency)",
      "description": "For initial_navigation this clock includes the origin response race and body streaming to the held </body>. Sample size = timed_auctions.",
      "id": 7,
      "gridPos": { "h": 8, "w": 12, "x": 0, "y": 15 },
      "datasource": { "type": "yesoreyeram-infinity-datasource", "uid": "${tinybird_ds}" },
      "targets": [
        {
          "refId": "A", "type": "json", "source": "url", "parser": "backend", "format": "table",
          "url": "/v0/pipes/auction_summary.json",
          "url_options": { "method": "GET", "params": [
            { "key": "start", "value": "${__from:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "end", "value": "${__to:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "publisher", "value": "$publisher" },
            { "key": "source", "value": "$source" }
          ] },
          "root_selector": "data", "columns": []
        }
      ],
      "transformations": [
        { "id": "filterByValue", "options": { "filters": [ { "fieldName": "terminal_status", "config": { "id": "equal", "options": { "value": "completed" } } } ], "type": "include", "match": "all" } },
        { "id": "convertFieldType", "options": { "conversions": [ { "targetField": "minute", "destinationType": "time" } ] } },
        { "id": "organize", "options": { "includeByName": { "minute": true, "auction_source": true, "total_time_ms_p50": true, "total_time_ms_p95": true } } },
        { "id": "partitionByValues", "options": { "fields": ["auction_source"], "keepFields": false } }
      ],
      "fieldConfig": { "defaults": { "unit": "ms", "custom": { "drawStyle": "line", "spanNulls": true } }, "overrides": [] }
    },
    {
      "type": "table",
      "title": "Why auctions skip or abandon (terminal_reason)",
      "id": 8,
      "gridPos": { "h": 8, "w": 12, "x": 12, "y": 15 },
      "datasource": { "type": "yesoreyeram-infinity-datasource", "uid": "${tinybird_ds}" },
      "targets": [
        {
          "refId": "A", "type": "json", "source": "url", "parser": "backend", "format": "table",
          "url": "/v0/pipes/auction_summary.json",
          "url_options": { "method": "GET", "params": [
            { "key": "start", "value": "${__from:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "end", "value": "${__to:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "publisher", "value": "$publisher" },
            { "key": "source", "value": "$source" }
          ] },
          "root_selector": "data", "columns": []
        }
      ],
      "transformations": [
        { "id": "filterByValue", "options": { "filters": [ { "fieldName": "terminal_status", "config": { "id": "regex", "options": { "value": "skipped|abandoned|execution_failed|dispatch_failed" } } } ], "type": "include", "match": "all" } },
        { "id": "groupBy", "options": { "fields": { "auction_source": { "operation": "groupby" }, "terminal_status": { "operation": "groupby" }, "terminal_reason": { "operation": "groupby" }, "auctions": { "operation": "aggregate", "aggregations": ["sum"] } } } },
        { "id": "sortBy", "options": { "sort": [ { "field": "auctions (sum)", "desc": true } ] } }
      ]
    },
    { "type": "row", "title": "Provider health", "gridPos": { "h": 1, "w": 24, "x": 0, "y": 23 }, "id": 102, "collapsed": false },
    {
      "type": "timeseries",
      "title": "Provider error rate (errors + timeouts / all calls)",
      "description": "Includes launch errors and calls with no latency. Sample size = requests.",
      "id": 9,
      "gridPos": { "h": 8, "w": 8, "x": 0, "y": 24 },
      "datasource": { "type": "yesoreyeram-infinity-datasource", "uid": "${tinybird_ds}" },
      "targets": [
        {
          "refId": "A", "type": "json", "source": "url", "parser": "backend", "format": "table",
          "url": "/v0/pipes/provider_health.json",
          "url_options": { "method": "GET", "params": [
            { "key": "start", "value": "${__from:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "end", "value": "${__to:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "publisher", "value": "$publisher" },
            { "key": "source", "value": "$source" },
            { "key": "provider_filter", "value": "$provider" }
          ] },
          "root_selector": "data", "columns": []
        }
      ],
      "transformations": [
        { "id": "convertFieldType", "options": { "conversions": [ { "targetField": "minute", "destinationType": "time" } ] } },
        { "id": "organize", "options": { "includeByName": { "minute": true, "provider": true, "auction_source": true, "error_rate": true } } },
        { "id": "partitionByValues", "options": { "fields": ["provider", "auction_source"], "keepFields": false } }
      ],
      "fieldConfig": { "defaults": { "unit": "percentunit", "custom": { "drawStyle": "line", "spanNulls": true } }, "overrides": [] }
    },
    {
      "type": "timeseries",
      "title": "Provider no-bid rate",
      "description": "Sample size = requests.",
      "id": 10,
      "gridPos": { "h": 8, "w": 8, "x": 8, "y": 24 },
      "datasource": { "type": "yesoreyeram-infinity-datasource", "uid": "${tinybird_ds}" },
      "targets": [
        {
          "refId": "A", "type": "json", "source": "url", "parser": "backend", "format": "table",
          "url": "/v0/pipes/provider_health.json",
          "url_options": { "method": "GET", "params": [
            { "key": "start", "value": "${__from:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "end", "value": "${__to:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "publisher", "value": "$publisher" },
            { "key": "source", "value": "$source" },
            { "key": "provider_filter", "value": "$provider" }
          ] },
          "root_selector": "data", "columns": []
        }
      ],
      "transformations": [
        { "id": "convertFieldType", "options": { "conversions": [ { "targetField": "minute", "destinationType": "time" } ] } },
        { "id": "organize", "options": { "includeByName": { "minute": true, "provider": true, "auction_source": true, "nobid_rate": true } } },
        { "id": "partitionByValues", "options": { "fields": ["provider", "auction_source"], "keepFields": false } }
      ],
      "fieldConfig": { "defaults": { "unit": "percentunit", "custom": { "drawStyle": "line", "spanNulls": true } }, "overrides": [] }
    },
    {
      "type": "timeseries",
      "title": "Provider latency p50 / p95 (n = latency_samples)",
      "id": 11,
      "gridPos": { "h": 8, "w": 8, "x": 16, "y": 24 },
      "datasource": { "type": "yesoreyeram-infinity-datasource", "uid": "${tinybird_ds}" },
      "targets": [
        {
          "refId": "A", "type": "json", "source": "url", "parser": "backend", "format": "table",
          "url": "/v0/pipes/provider_latency.json",
          "url_options": { "method": "GET", "params": [
            { "key": "start", "value": "${__from:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "end", "value": "${__to:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "publisher", "value": "$publisher" },
            { "key": "source", "value": "$source" },
            { "key": "provider_filter", "value": "$provider" }
          ] },
          "root_selector": "data", "columns": []
        }
      ],
      "transformations": [
        { "id": "convertFieldType", "options": { "conversions": [ { "targetField": "minute", "destinationType": "time" } ] } },
        { "id": "organize", "options": { "includeByName": { "minute": true, "provider": true, "latency_ms_p50": true, "latency_ms_p95": true } } },
        { "id": "partitionByValues", "options": { "fields": ["provider"], "keepFields": false } }
      ],
      "fieldConfig": { "defaults": { "unit": "ms", "custom": { "drawStyle": "line", "spanNulls": true } }, "overrides": [] }
    },
    {
      "type": "table",
      "title": "Provider health, window totals",
      "id": 12,
      "gridPos": { "h": 7, "w": 24, "x": 0, "y": 32 },
      "datasource": { "type": "yesoreyeram-infinity-datasource", "uid": "${tinybird_ds}" },
      "targets": [
        {
          "refId": "A", "type": "json", "source": "url", "parser": "backend", "format": "table",
          "url": "/v0/pipes/provider_health.json",
          "url_options": { "method": "GET", "params": [
            { "key": "start", "value": "${__from:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "end", "value": "${__to:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "publisher", "value": "$publisher" },
            { "key": "source", "value": "$source" },
            { "key": "provider_filter", "value": "$provider" }
          ] },
          "root_selector": "data", "columns": []
        }
      ],
      "transformations": [
        { "id": "groupBy", "options": { "fields": {
          "auction_source": { "operation": "groupby" },
          "provider": { "operation": "groupby" },
          "provider_role": { "operation": "groupby" },
          "requests": { "operation": "aggregate", "aggregations": ["sum"] },
          "successes": { "operation": "aggregate", "aggregations": ["sum"] },
          "nobids": { "operation": "aggregate", "aggregations": ["sum"] },
          "errors": { "operation": "aggregate", "aggregations": ["sum"] },
          "timeouts": { "operation": "aggregate", "aggregations": ["sum"] },
          "abandonments": { "operation": "aggregate", "aggregations": ["sum"] },
          "latency_samples": { "operation": "aggregate", "aggregations": ["sum"] }
        } } }
      ]
    },
    { "type": "row", "title": "Yield (directional; CPM = priced winning bids only, per currency)", "gridPos": { "h": 1, "w": 24, "x": 0, "y": 39 }, "id": 103, "collapsed": false },
    {
      "type": "table",
      "title": "Seat yield, window totals (bid_win_share = share of this seat's bids that won)",
      "id": 13,
      "gridPos": { "h": 8, "w": 14, "x": 0, "y": 40 },
      "datasource": { "type": "yesoreyeram-infinity-datasource", "uid": "${tinybird_ds}" },
      "targets": [
        {
          "refId": "A", "type": "json", "source": "url", "parser": "backend", "format": "table",
          "url": "/v0/pipes/seat_yield.json",
          "url_options": { "method": "GET", "params": [
            { "key": "start", "value": "${__from:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "end", "value": "${__to:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "publisher", "value": "$publisher" },
            { "key": "source", "value": "$source" },
            { "key": "provider_filter", "value": "$provider" }
          ] },
          "root_selector": "data", "columns": []
        }
      ],
      "transformations": [
        { "id": "groupBy", "options": { "fields": {
          "provider": { "operation": "groupby" },
          "seat": { "operation": "groupby" },
          "currency": { "operation": "groupby" },
          "bids": { "operation": "aggregate", "aggregations": ["sum"] },
          "priced_bids": { "operation": "aggregate", "aggregations": ["sum"] },
          "wins": { "operation": "aggregate", "aggregations": ["sum"] }
        } } },
        { "id": "sortBy", "options": { "sort": [ { "field": "wins (sum)", "desc": true } ] } }
      ]
    },
    {
      "type": "timeseries",
      "title": "Winning CPM p50 by seat and currency (priced wins only)",
      "id": 14,
      "gridPos": { "h": 8, "w": 10, "x": 14, "y": 40 },
      "datasource": { "type": "yesoreyeram-infinity-datasource", "uid": "${tinybird_ds}" },
      "targets": [
        {
          "refId": "A", "type": "json", "source": "url", "parser": "backend", "format": "table",
          "url": "/v0/pipes/seat_yield.json",
          "url_options": { "method": "GET", "params": [
            { "key": "start", "value": "${__from:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "end", "value": "${__to:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "publisher", "value": "$publisher" },
            { "key": "source", "value": "$source" },
            { "key": "provider_filter", "value": "$provider" }
          ] },
          "root_selector": "data", "columns": []
        }
      ],
      "transformations": [
        { "id": "convertFieldType", "options": { "conversions": [ { "targetField": "minute", "destinationType": "time" } ] } },
        { "id": "organize", "options": { "includeByName": { "minute": true, "seat": true, "currency": true, "winning_cpm_p50": true } } },
        { "id": "partitionByValues", "options": { "fields": ["seat", "currency"], "keepFields": false } }
      ],
      "fieldConfig": { "defaults": { "custom": { "drawStyle": "line", "spanNulls": true } }, "overrides": [] }
    },
    { "type": "row", "title": "Breakdowns (hourly rollups)", "gridPos": { "h": 1, "w": 24, "x": 0, "y": 48 }, "id": 104, "collapsed": false },
    {
      "type": "table",
      "title": "Completed auctions and fill by country",
      "id": 15,
      "gridPos": { "h": 8, "w": 8, "x": 0, "y": 49 },
      "datasource": { "type": "yesoreyeram-infinity-datasource", "uid": "${tinybird_ds}" },
      "targets": [
        {
          "refId": "A", "type": "json", "source": "url", "parser": "backend", "format": "table",
          "url": "/v0/pipes/auction_dims.json",
          "url_options": { "method": "GET", "params": [
            { "key": "start", "value": "${__from:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "end", "value": "${__to:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "publisher", "value": "$publisher" },
            { "key": "source", "value": "$source" }
          ] },
          "root_selector": "data", "columns": []
        }
      ],
      "transformations": [
        { "id": "filterByValue", "options": { "filters": [ { "fieldName": "terminal_status", "config": { "id": "equal", "options": { "value": "completed" } } } ], "type": "include", "match": "all" } },
        { "id": "groupBy", "options": { "fields": {
          "country": { "operation": "groupby" },
          "auctions": { "operation": "aggregate", "aggregations": ["sum"] },
          "requested_slots": { "operation": "aggregate", "aggregations": ["sum"] },
          "winning_bids": { "operation": "aggregate", "aggregations": ["sum"] }
        } } },
        { "id": "calculateField", "options": { "mode": "binary", "alias": "fill_rate", "binary": { "left": "winning_bids (sum)", "operator": "/", "right": "requested_slots (sum)" } } },
        { "id": "sortBy", "options": { "sort": [ { "field": "auctions (sum)", "desc": true } ] } }
      ],
      "fieldConfig": { "defaults": {}, "overrides": [ { "matcher": { "id": "byName", "options": "fill_rate" }, "properties": [ { "id": "unit", "value": "percentunit" } ] } ] }
    },
    {
      "type": "table",
      "title": "Completed auctions and fill by device",
      "id": 16,
      "gridPos": { "h": 8, "w": 8, "x": 8, "y": 49 },
      "datasource": { "type": "yesoreyeram-infinity-datasource", "uid": "${tinybird_ds}" },
      "targets": [
        {
          "refId": "A", "type": "json", "source": "url", "parser": "backend", "format": "table",
          "url": "/v0/pipes/auction_dims.json",
          "url_options": { "method": "GET", "params": [
            { "key": "start", "value": "${__from:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "end", "value": "${__to:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "publisher", "value": "$publisher" },
            { "key": "source", "value": "$source" }
          ] },
          "root_selector": "data", "columns": []
        }
      ],
      "transformations": [
        { "id": "filterByValue", "options": { "filters": [ { "fieldName": "terminal_status", "config": { "id": "equal", "options": { "value": "completed" } } } ], "type": "include", "match": "all" } },
        { "id": "groupBy", "options": { "fields": {
          "device_class": { "operation": "groupby" },
          "auctions": { "operation": "aggregate", "aggregations": ["sum"] },
          "requested_slots": { "operation": "aggregate", "aggregations": ["sum"] },
          "winning_bids": { "operation": "aggregate", "aggregations": ["sum"] }
        } } },
        { "id": "calculateField", "options": { "mode": "binary", "alias": "fill_rate", "binary": { "left": "winning_bids (sum)", "operator": "/", "right": "requested_slots (sum)" } } }
      ],
      "fieldConfig": { "defaults": {}, "overrides": [ { "matcher": { "id": "byName", "options": "fill_rate" }, "properties": [ { "id": "unit", "value": "percentunit" } ] } ] }
    },
    {
      "type": "table",
      "title": "Completed auctions and fill by browser",
      "id": 17,
      "gridPos": { "h": 8, "w": 8, "x": 16, "y": 49 },
      "datasource": { "type": "yesoreyeram-infinity-datasource", "uid": "${tinybird_ds}" },
      "targets": [
        {
          "refId": "A", "type": "json", "source": "url", "parser": "backend", "format": "table",
          "url": "/v0/pipes/auction_dims.json",
          "url_options": { "method": "GET", "params": [
            { "key": "start", "value": "${__from:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "end", "value": "${__to:date:YYYY-MM-DD HH:mm:ss}" },
            { "key": "publisher", "value": "$publisher" },
            { "key": "source", "value": "$source" }
          ] },
          "root_selector": "data", "columns": []
        }
      ],
      "transformations": [
        { "id": "filterByValue", "options": { "filters": [ { "fieldName": "terminal_status", "config": { "id": "equal", "options": { "value": "completed" } } } ], "type": "include", "match": "all" } },
        { "id": "groupBy", "options": { "fields": {
          "browser_family": { "operation": "groupby" },
          "auctions": { "operation": "aggregate", "aggregations": ["sum"] },
          "requested_slots": { "operation": "aggregate", "aggregations": ["sum"] },
          "winning_bids": { "operation": "aggregate", "aggregations": ["sum"] }
        } } },
        { "id": "calculateField", "options": { "mode": "binary", "alias": "fill_rate", "binary": { "left": "winning_bids (sum)", "operator": "/", "right": "requested_slots (sum)" } } }
      ],
      "fieldConfig": { "defaults": {}, "overrides": [ { "matcher": { "id": "byName", "options": "fill_rate" }, "properties": [ { "id": "unit", "value": "percentunit" } ] } ] }
    }
  ]
}

[jevansnyc]

Spec now open as a PR for line-by-line review

The addendum spec is up as #987 so engineering can comment inline on the design (docs-only, adds it to docs/superpowers/specs/ next to the parent #818 design).

• Review the spec / leave inline comments: Add auction telemetry addendum design spec #987
• Tinybird + Grafana artifact bundle: inline in the comments above; lands via its own PR once reviewed.
• Edge Rust (browser_family/os_family): separate follow-up PR.