| Media cost share on late platform-data days | Media cost falling on days when that platform's own data was late divided by total media cost in the same period. Shows how much of the media figures on the KPI board and client reports arrived late or were incomplete when viewed.= Media cost on late platform-data days / Media cost | Ratio (%) |
|---|
| Media cost on late platform-data days | Total media cost of delivery rows falling on days when that platform's own report table (the table whose domain matches the platform name) had at least one load later than the freshness commitment. Figures for these days may have been viewed or sent to clients while incomplete and should be rechecked. | Currency |
|---|
| Departments viewing dashboards | Number of distinct departments with at least one dashboard view in the period. | Count |
|---|
| Average request lead time (days) | Average days from when a department submits a request to when the data team delivers it, for requests delivered in the period.= da_request_lead_days_total / Delivered requests | Number |
|---|
| Average run duration (minutes) | Average minutes from start to finish of successful runs in the period.= da_run_minutes_total / da_successful_runs | Number |
|---|
| Check pass rate | Passed checks divided by all data quality checks in the period.= (Data quality checks - Failed checks) / Data quality checks | Ratio (%) |
|---|
| Dashboard views | Total dashboard views by users across departments in the period. | Count |
|---|
| Delivered requests | Delivered requests with a delivery date in the period (by delivery date). | Count |
|---|
| Failed checks | Data quality checks with a standardized result of fail in the period. | Count |
|---|
| Failed runs | Pipeline runs with a standardized status of failed (including errors and timeouts), by start date. | Count |
|---|
| Freshness breaches | Successful runs where the gap since the previous successful load of the same table exceeds that table's freshness commitment (freshness_sla_hours). | Count |
|---|
| Pipeline runs | Data loading pipeline runs started in the period, including successful, failed and skipped runs. | Count |
|---|
| Data quality checks | Data quality checks run in the period (freshness, completeness, uniqueness, validity). | Count |
|---|
| Analysis requests | Analysis and report requests that departments submitted to the data team in the period (by submission date). | Count |
|---|
| Run success rate | Successful runs divided by runs with an outcome (successful plus failed). Skipped runs are excluded.= da_successful_runs / (da_successful_runs + Failed runs) | Ratio (%) |
|---|
| Client billings | Total billed to clients for media delivered (media cost plus the service fee per IO, capped at the budget), by delivery date. | Currency |
|---|
| Budget pacing | Media cost divided by the planned budget for the same period. 1 means on plan; above 1 means spending faster than planned.= Media cost / Planned media budget | Ratio (%) |
|---|
| Clicks | Total ad clicks reported by the platforms. | Count |
|---|
| Platform-reported conversion value | Total order value of the clients' customers as reported by the ad platforms themselves. Not the business's revenue. | Currency |
|---|
| Conversions | Total conversions (purchases, leads, app installs) reported by the platforms. | Count |
|---|
| Media cost | Total paid to ad platforms to buy impressions, by delivery date. | Currency |
|---|
| Cost per acquisition (CPA) | Media cost divided by conversions.= Media cost / Conversions | Currency |
|---|
| Click-through rate (CTR) | Clicks divided by impressions.= Clicks / Impressions | Ratio (%) |
|---|
| Media gross profit | Client billings minus media cost. Negative when media spend exceeds the billable amount.= Client billings - Media cost | Currency |
|---|
| Logged hours | Total staff hours logged against clients and campaigns. | Number |
|---|
| Impressions | Total ad impressions reported by the platforms. | Count |
|---|
| Media gross margin | Media gross profit divided by client billings.= (Client billings - Media cost) / Client billings | Ratio (%) |
|---|
| Planned media budget | Campaign media budget spread evenly over its flight days, summed over the period (only days that already have data). | Currency |
|---|
| Gross profit per hour | Media gross profit (the business's net revenue after paying the platforms) divided by logged hours.= (Client billings - Media cost) / Logged hours | Currency |
|---|
| Platform-reported ROAS | Platform-reported conversion value divided by media cost.= Platform-reported conversion value / Media cost | Number |
|---|