Media Summary Audit

Data quality monitoring across 12 ad platforms

Pipeline Health monitor_heart
—
Loading...
FX Rate Freshness currency_exchange
—
Loading...
Platform Freshness cloud_sync
—
Loading...
Unmapped Accounts link_off
—
Loading...

Pipeline Reconciliation

Last 30 days
Platform Source Rows Final Rows Row Diff Cost Diff % Status

Active Alerts

Loading...

Exchange Rate Status

Loading...
Currency Pair Days Behind Status

Pipeline Health

Row and cost reconciliation across all pipeline stages

Full Cost Reconciliation

Last 30 days
Platform Src Rows Final Rows Row Diff Src Cost Final Cost Cost Diff Diff % Status
Loading...

Cost Reconciliation

Source platform totals vs final summary table

Platform Cost Comparison

Last 30 days
Platform Src Rows Final Rows Src Cost Final Cost Cost Diff Diff % Status
Loading...

Unmapped Accounts

Accounts where brand code cannot join to client info

Unmapped Accounts by Cost Impact

Top 50
Platform Account Brand Code Issue Rows Cost Cost HKD
Loading...

Exchange Rates

Currency pair freshness for cost conversion

Exchange Rate Freshness

Currency Pair Latest Rate Date Yesterday Days Behind Status
Loading...

Platform Data Freshness

Platform Latest Date Yesterday Days Behind Status
Loading...

Interactive Charts

Embedded Superset dashboards

Exchange Rate Freshness

Is each currency pair rate updated?

Platform Data Freshness

Is each platform's data current?

Cost Reconciliation

Source vs final cost comparison

Unmapped Accounts

Accounts missing client mapping