Skip to content

Dashboard templates

Media & advertising · IT

Digital advertising agency whose IT team runs ad accounts on the platforms, reporting tools and API sync, editing workstations and creative storage, email and office PCs. Media P&L by client, campaign and platform, plus incidents, SLA, failed changes, service availability and the estimated client billings affected when systems go down.

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

For agency IT teams running ad accounts, reporting tools, API syncs and creative storage. The "IT and media" dashboard estimates client billings affected by IT outages and IT tickets per billion VND of media spend. The "IT incidents and support" and "Availability and changes" dashboards cover availability, MTTR, SLA breaches and change failure rate. Needs client, campaign, daily delivery, IT service catalog and IT ticket data.

Use this template to

  • Know roughly how much client billing a reporting tool outage affects.
  • Track ad account availability by month.
  • Cut failed changes on the API sync tools.

5 ready-made dashboards

IT and media

Estimated client billings affected by IT service outages, and IT workload relative to media volume.

  • Estimated billings affected by IT outages
  • Share of billings affected by IT outages
  • IT tickets per VND 1 billion of media spend
  • Client billings
  • Affected client billings by service
  • Weekly affected client billings
  • Weekly IT tickets per VND 1 billion of media spend

IT incidents and support

Tickets, P1 incidents, response and resolution times, and SLA breach rate by service and resolver team.

  • Incidents
  • P1 incidents
  • Mean time to resolve (MTTR, hours)
  • SLA breach rate
  • By service
  • SLA breach rate by work type
  • Response time by resolver team
  • Weekly tickets

Availability and changes

Availability, outage time and change failure rate for each IT service.

  • Service availability
  • Outage minutes
  • Changes deployed
  • Change failure rate
  • Availability by service
  • Outage minutes by criticality
  • Weekly outage minutes

Media overview

Billed revenue, media cost, gross profit and budget pacing by client and client group.

  • Client billings
  • Media gross profit
  • Media gross margin
  • Budget pacing
  • Profit and loss by client
  • Gross profit by client group
  • Budget pacing by campaign
  • Weekly billed revenue

Delivery performance

Impressions, clicks, conversions and buying costs (CPM, CPC, CPA) by platform, campaign and campaign objective.

  • Impressions
  • Click-through rate (CTR)
  • Cost per click (CPC)
  • Cost per acquisition (CPA)
  • By ad platform
  • Monthly CPA by platform
  • By campaign
  • CTR by campaign objective

Ask Si as soon as the build finishes

  • “How did estimated billings affected by IT outages change compared with last month?”
  • “What is driving share of billings affected by IT outages this quarter?”
  • “Show IT tickets per VND 1 billion of media spend by month for the last six months.”
  • “Where is service availability highest this month, and why?”

36 defined metrics

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

MetricDefinitionUnit
Estimated billings affected by IT outagesFor each outage: outage minutes divided by 1,440, times client billings on the day the outage started, times the share of revenue that depends on that service. Summed over all outages in the period.Currency
Share of billings affected by IT outagesEstimated billings affected by IT outages divided by media client billings in the period.= Estimated billings affected by IT outages / Client billingsRatio (%)
IT tickets per VND 1 billion of media spendIT support tickets opened in the period times 1 billion divided by media cost paid to platforms in the same period; measures IT load relative to the media volume the agency runs.= IT support tickets * 1000000000 / Media costNumber
Service availabilityOne minus outage minutes divided by the service's planned operating minutes in the period.= 1 - Outage minutes / it_planned_minutesRatio (%)
Change failure rateFailed changes (failed or rolled back) divided by changes deployed in the period.= Failed changes / Changes deployedRatio (%)
Changes deployedNumber of IT changes deployed in the period, by deployment date.Count
Failed changesNumber of changes deployed in the period with a failed or rolled-back outcome.Count
Average first response time (hours)Average hours from ticket creation to first response, across all tickets opened in the period.= it_response_hours_total / IT support ticketsNumber
IncidentsNumber of incident-type tickets opened in the period, by open date.Count
Mean time to resolve (MTTR, hours)Average hours from open to resolution for incidents resolved in the period.= it_incident_hours_total / Resolved incidentsNumber
Outage minutesTotal minutes a service was down or disrupted, counted on the day the outage started.Number
P1 incidentsNumber of highest-priority incidents (P1, critical) opened in the period.Count
Resolved incidentsNumber of incidents resolved in the period, by resolution date.Count
SLA breach rateTickets breaching SLA divided by tickets opened in the period.= SLA breaches / IT support ticketsRatio (%)
SLA breachesTickets opened in the period that were resolved after the SLA deadline (resolution hours greater than the SLA target).Count
IT support ticketsNumber of IT support tickets (incidents and requests) opened in the period, by open date.Count
Client billingsTotal billed to clients for media delivered (media cost plus the service fee per IO, capped at the budget), by delivery date.Currency
New IO booked valueTotal value of insertion orders (IO) signed in the period, by signing date, excluding cancelled IOs.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
Profit after laborMedia gross profit minus labor cost from logged hours. Fixed costs such as office rent are not deducted.= Client billings - Media cost - Labor costCurrency
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
Cost per click (CPC)Media cost divided by clicks.= Media cost / ClicksCurrency
Cost per thousand impressions (CPM)Media cost per 1,000 impressions.= Media cost * 1000 / ImpressionsCurrency
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
Labor costLogged hours multiplied by the internal hourly rate for each role.Currency
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, it_service, it_ticket

Add if you have it (unlocks more metrics)

insertion_order, timesheet, it_change, it_outage

Three steps to this dashboard

  1. 1

    Connect your data

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

  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 5 dashboards and 36 metrics; ask Si anytime.

Data sources for this template

Connectors with a setup guide that feed the entities this template needs. Excel always works.

Related templates

Build Media & advertising · IT with your own data

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