RDX — What I Found, What I Need

What I Found

Sony has a GraphQL federation platform called RDX that connects every backend system across SME. Release data, workability scores, clearance records, DSP partner info, catalog metadata — it's all queryable from one place. It's live. It's accessible. Nobody at RCA is using it.

What Works Right Now

I confirmed these in the staging environment — real queries, real schema:

Capability	What It Returns	Status
Release Workability	All 9 KPI scores, alert thresholds, per-release breakdown	Works
DSP Catalog (SCUBA)	Spotify/Apple/Deezer — ISRCs, popularity, genres, followers	Works
Partner Delivery	Per-DSP pitch dates, lead times, week-one forecasts	Schema ✓
Clearance Records	Sample clearance + master clearance by ISRC	Needs Prod
RCA-Only Filter	Filter all queries to RCA releases only (label key E009)	Needs Prod

Why This Matters

I pulled the workability export on Sunday. Across all 113 scheduled releases:

100%

SAA is "Unknown" on every single release. SAMP is Unknown on every release. Agreements is "Required" on every release. DSN Received is blank on every release. Not most — all 113.

The data to fill these gaps likely already exists upstream in Sony's clearance and repertoire systems. RDX can reach it. Nobody at RCA is reading it. That's what Campaign Ops fixes.

What I Need from You

Two things. Neither requires budget or new headcount.

The Ask

Greenlight Brian Lynch to provision RDX production access via the Azure Functions proxy he's already building. Staging confirmed the queries work — production will have the actual data. I just need you as the named sponsor so IT moves on it. → You + Brian Lynch

15 minutes on a call this week so I can walk you through the workability snapshot and the three queries I want to run first in production. I'll show you exactly what "Unknown" looks like today and what it could look like with RDX feeding it. → You + Me

What This Unlocks

Pre-meeting workability scan

Before Active Projects, surface every release that's At Risk — without anyone opening Runway.

Clearance gap detection

Compare clearance API data against Runway's "Unknown" fields. Flag when data exists upstream but nobody's surfaced it.

Artist Insights automation

Replace manual Spotify/Apple data pulls for Crawley's decks with a single query.

DSP delivery tracking

Per-partner lead times and pitch statuses derived from real data — not manually tracked.

We don't need to build the pipes. Sony already built them. We need someone to read the water and translate it into action. That's Campaign Ops. The queries are written, the schema is confirmed, the proof point is sitting in the export. I just need production access to make it real.

RDX: What I Found, What I Need