Data Pipeline Audit

internal-media-with-cost

Exchange Rate Status

Platform Data Status

Cost Reconciliation

Unmapped Accounts - Top 10 by Cost

Exchange Rate Freshness

Latest exchange rate date for each currency pair needed by the pipeline
PairLatest Rate DateYesterdayDays BehindStatus

Platform Data Freshness

Latest data date available from each ad platform
PlatformLatest DateYesterdayDays BehindStatus

Cost & Revenue Reconciliation

Source platform totals vs final summary table (last 30 days)
PlatformSrc RowsFinal RowsRow DiffSrc CostFinal CostCost DiffDiff %Status

Unmapped Accounts

Accounts where brand code cannot join to client info - sorted by cost impact
PlatformAccountBrand CodeIssueRowsCostCost HKD

Exchange Rate Freshness

Is each currency pair rate updated to yesterday?

Platform Data Freshness

Is each platform's data current?

Cost Reconciliation

Source vs final cost comparison (last 30 days)

Unmapped Accounts

Accounts missing client mapping, by cost impact
Audit data refreshed daily at 04:00 UTC