Skip to content

Dashboard templates

Media & advertising · Operations

A digital ad agency that produces content for clients: it buys shoots and post-production editing hours from outsourced studios, production materials, props and printed POSM, and hands creative deliverables to clients. Media P&L by client, campaign and platform plus supplier on-time rate, inventory, stockouts, on-time handover and production cost versus client billings.

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

For agency content production teams buying shoots, outsourced editing hours, props and POSM. The "Content production and profit" dashboard shows content production spend over client billings and profit after hours and production spend. The "Purchasing and inventory" and "Warehouse deliveries" dashboards track supplier on-time delivery, stockout days and on-time handover. Needs client, campaign, daily delivery, purchase order and purchase order line data.

Use this template to

  • See which clients eat up their margin through heavy content production spend.
  • Book shoot packages ahead when stockout days rise.
  • Track on-time handover of creative deliverables.

5 ready-made dashboards

Content production and profit

Content production spend (outsourcing, materials, props, POSM) next to client billings and profit, plus on-time creative delivery.

  • Production cost to billings ratio
  • Contribution after labor and production costs
  • Received goods value
  • On-time delivery rate
  • Monthly production spend to client billings
  • Monthly profit after labor hours and production spend
  • Purchase order value by item group
  • On-time handover by warehouse

Purchasing and inventory

Purchase orders, supplier on-time and in-full delivery, lead time, average inventory and stockouts.

  • Purchase order value
  • Supplier on-time rate
  • Average inventory value
  • Stockout item-days
  • Results by supplier
  • Average inventory by item group
  • Stockout days by item group
  • Weekly average inventory by warehouse

Warehouse deliveries

Deliveries, on-time and failed delivery rates by warehouse and carrier.

  • Shipments
  • On-time delivery rate
  • Failed delivery rate
  • Failed shipments
  • Delivery results by warehouse
  • Failed delivery rate by carrier
  • Weekly failed delivery rate by warehouse

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 contribution after labor and production costs change compared with last month?”
  • “What is driving production cost to billings ratio this quarter?”
  • “Show average inventory value by month for the last six months.”
  • “Where is average supplier lead time (days) highest this month, and why?”

35 defined metrics

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

MetricDefinitionUnit
Contribution after labor and production costsClient billings minus media cost, labor cost from logged hours and the value of production goods received in the period (shoots, outsourced editing hours, materials, props, POSM). The agency's remaining profit after paying platforms, people and content production.= Client billings - Media cost - Labor cost - Received goods valueCurrency
Production cost to billings ratioValue of goods received in the period (shoots, outsourced editing hours, production materials, props, POSM, by receipt date) divided by media client billings in the same period. Shows how much of each unit of billings goes to content production.= Received goods value / Client billingsRatio (%)
Average inventory valueAverage end-of-day inventory value in the period = sum of snapshot values divided by the number of days with a snapshot.= ops_inventory_value_total / ops_snapshot_daysCurrency
Average supplier lead time (days)Average days from order to receipt for purchase orders received in the period.= ops_lead_days_total / Received purchase ordersNumber
Failed delivery rateFailed or returned shipments divided by all outbound shipments in the period.= Failed shipments / ShipmentsRatio (%)
Failed shipmentsOutbound shipments in the period that failed delivery or were returned to the warehouse.Count
On-time delivery rateOn-time deliveries divided by all outbound shipments in the period (by ship date).= ops_on_time_deliveries / ShipmentsRatio (%)
Purchase ordersPurchase orders placed in the period (by order date), excluding cancelled orders.Count
Purchase order valueTotal ordered value (ordered quantity times unit price) of purchase orders placed in the period, excluding cancelled orders.Currency
Received purchase ordersPurchase orders received in the period (by receipt date), including partial receipts.Count
Received goods valueTotal received quantity times unit price for purchase orders received in the period (by receipt date).Currency
ShipmentsOutbound shipments from the warehouse in the period (by ship date), any outcome.Count
Stockout item-daysInventory snapshots with zero (or negative) quantity in the period: each item out of stock at one warehouse on one day counts as 1.Count
Supplier fill rateReceived value divided by ordered value of purchase orders received in the period. 100% means delivered in full; lower means the supplier short-shipped.= Received goods value / ops_closed_po_valueRatio (%)
Supplier on-time rateOn-time PO receipts divided by received purchase orders in the period (by receipt date).= ops_on_time_receipts / Received purchase ordersRatio (%)
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, ops_purchase_order, ops_purchase_order_line

Add if you have it (unlocks more metrics)

insertion_order, timesheet, ops_supplier, ops_item, ops_inventory_snapshot, ops_shipment

Three steps to this dashboard

  1. 1

    Connect your data

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

  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 35 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 · Operations with your own data

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