Skip to content

Dashboard templates

Media & advertising · Data & analytics

A digital advertising agency whose data team pulls delivery reports from the Meta, Google, TikTok and Zalo APIs, billing reconciliation and timesheets into the warehouse. A key KPI board (client billings, gross profit, margin, budget pacing, CTR, CPA, ROAS, gross profit per hour) plus pipeline reliability, data quality, analysis requests, dashboard usage and the share of media cost falling on days when that platform's own data was late.

Free plan with no time limit · No card required · Sample workspace ready in minutes

For agency data teams pulling delivery reports from ad platform APIs and reconciling client billings and hours. The "KPI board" dashboard shows billings, gross profit, margin, budget pacing, CTR, CPA, platform-reported ROAS, gross profit per hour, and media cost that falls on days when that platform's data is late. The "Data reliability" and "Requests and usage" dashboards track pipelines, quality tests and analysis requests. Needs client, campaign, daily delivery and pipeline run log data.

Use this template to

  • Know how much of a platform's media cost sits on late-data days before sending the client report.
  • Track weekly failures of each platform reporting pipeline.
  • Measure delivery time for analysis requests from account teams.

3 ready-made dashboards

KPI board

Key agency media metrics next to the reliability of the data pulled from ad platform APIs.

  • Client billings
  • Media gross profit
  • Media gross margin
  • Budget pacing
  • Click-through rate (CTR)
  • Cost per acquisition (CPA)
  • Platform-reported ROAS
  • Gross profit per hour
  • Media cost share on late platform-data days
  • Run success rate

Data reliability

Are pipelines running reliably, is data as fresh as promised, and how many quality checks pass.

  • Run success rate
  • Freshness breaches
  • Check pass rate
  • Average run duration (minutes)
  • By data table
  • Weekly failed runs by domain
  • Failed checks by type

Requests and usage

How many analysis requests departments send, how fast the data team delivers, and how often dashboards are viewed.

  • Analysis requests
  • Average request lead time (days)
  • Dashboard views
  • Departments viewing dashboards
  • By department
  • Views by dashboard
  • Weekly new analysis requests

Ask Si as soon as the build finishes

  • “How did media cost share on late platform-data days change compared with last month?”
  • “What is driving media cost on late platform-data days this quarter?”
  • “Show departments viewing dashboards by month for the last six months.”
  • “Where is average request lead time (days) highest this month, and why?”

30 defined metrics

Versioned definitions, shared by dashboards, Si, reports and MCP.

MetricDefinitionUnit
Media cost share on late platform-data daysMedia 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 costRatio (%)
Media cost on late platform-data daysTotal 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 dashboardsNumber 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 requestsNumber
Average run duration (minutes)Average minutes from start to finish of successful runs in the period.= da_run_minutes_total / da_successful_runsNumber
Check pass ratePassed checks divided by all data quality checks in the period.= (Data quality checks - Failed checks) / Data quality checksRatio (%)
Dashboard viewsTotal dashboard views by users across departments in the period.Count
Delivered requestsDelivered requests with a delivery date in the period (by delivery date).Count
Failed checksData quality checks with a standardized result of fail in the period.Count
Failed runsPipeline runs with a standardized status of failed (including errors and timeouts), by start date.Count
Freshness breachesSuccessful runs where the gap since the previous successful load of the same table exceeds that table's freshness commitment (freshness_sla_hours).Count
Pipeline runsData loading pipeline runs started in the period, including successful, failed and skipped runs.Count
Data quality checksData quality checks run in the period (freshness, completeness, uniqueness, validity).Count
Analysis requestsAnalysis and report requests that departments submitted to the data team in the period (by submission date).Count
Run success rateSuccessful runs divided by runs with an outcome (successful plus failed). Skipped runs are excluded.= da_successful_runs / (da_successful_runs + Failed runs)Ratio (%)
Client billingsTotal billed to clients for media delivered (media cost plus the service fee per IO, capped at the budget), by delivery date.Currency
Budget pacingMedia 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 budgetRatio (%)
ClicksTotal ad clicks reported by the platforms.Count
Platform-reported conversion valueTotal order value of the clients' customers as reported by the ad platforms themselves. Not the business's revenue.Currency
ConversionsTotal conversions (purchases, leads, app installs) reported by the platforms.Count
Media costTotal paid to ad platforms to buy impressions, by delivery date.Currency
Cost per acquisition (CPA)Media cost divided by conversions.= Media cost / ConversionsCurrency
Click-through rate (CTR)Clicks divided by impressions.= Clicks / ImpressionsRatio (%)
Media gross profitClient billings minus media cost. Negative when media spend exceeds the billable amount.= Client billings - Media costCurrency
Logged hoursTotal staff hours logged against clients and campaigns.Number
ImpressionsTotal ad impressions reported by the platforms.Count
Media gross marginMedia gross profit divided by client billings.= (Client billings - Media cost) / Client billingsRatio (%)
Planned media budgetCampaign media budget spread evenly over its flight days, summed over the period (only days that already have data).Currency
Gross profit per hourMedia gross profit (the business's net revenue after paying the platforms) divided by logged hours.= (Client billings - Media cost) / Logged hoursCurrency
Platform-reported ROASPlatform-reported conversion value divided by media cost.= Platform-reported conversion value / Media costNumber

Data you need

Required

client, campaign, delivery_daily, da_pipeline_run

Add if you have it (unlocks more metrics)

insertion_order, timesheet, da_dataset, da_quality_check, da_request, da_dashboard_view

Three steps to this dashboard

  1. 1

    Connect your data

    Upload an Excel file or connect a source with: client, campaign, delivery_daily, da_pipeline_run.

  2. 2

    Approve Si's proposal

    Si proposes how to read your tables and map them to the industry's standard model; you fix anything highlighted and approve.

  3. 3

    Dashboards and Q&A

    The build gives you 3 dashboards and 30 metrics; ask Si anytime.

Related templates

Build Media & advertising · Data & analytics with your own data

Free plan with no time limit · No card required · Sample workspace ready in minutes