Skip to content

Dashboard templates

Media & advertising · HR

Digital advertising agency with account, planning, media buying and creative teams. Media P&L by client, campaign and platform and hours by role, plus average headcount, terminations, payroll cost, overtime, recruiting and gross profit per employee.

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

For HR managers at agencies with account, planning, media buying and creative teams. The "Agency staff productivity" dashboard calculates billings per head and media gross profit per head, and the "Hours and contracts" dashboard shows which clients take the most hours. The "Headcount and attrition" and "Payroll cost and recruiting" dashboards track attrition, payroll cost, overtime and recruiting. Needs client, campaign, daily delivery and employee data.

Use this template to

  • Know media gross profit per head before deciding to hire more.
  • See which department works the most overtime and which clients cause it.
  • Track attrition by department to keep top people.

5 ready-made dashboards

Agency staff productivity

Media gross profit and billed amount against average headcount, payroll cost and hours by role.

  • Media gross profit per employee
  • Billings per employee
  • Average headcount
  • Payroll cost
  • Monthly media gross profit per employee
  • Client-billed hours by role
  • Attrition rate by department

Headcount and attrition

Average headcount, new hires, leavers and attrition rate by department.

  • Average headcount
  • New hires
  • Terminations
  • Turnover rate
  • Headcount movement by department
  • Attrition rate by department
  • Monthly leavers by department

Payroll cost and recruiting

Payroll, overtime, absence costs and recruiting effectiveness.

  • Payroll cost
  • Overtime hours
  • Absence rate
  • Offer acceptance rate
  • Monthly payroll cost by department
  • Weekly overtime hours by department
  • Recruiting by department

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

Hours and contracts

Staff hours, labor cost, gross profit per hour, profit after labor and new IO value signed.

  • Logged hours
  • Gross profit per hour
  • Profit after labor
  • New IO booked value
  • Hours and profit by client
  • Hours by role
  • New IO value signed by client

Ask Si as soon as the build finishes

  • “How did billings per employee change compared with last month?”
  • “What is driving media gross profit per employee this quarter?”
  • “Show absence days by month for the last six months.”
  • “Where is absence rate highest this month, and why?”

37 defined metrics

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

MetricDefinitionUnit
Billings per employeeClient billings for media delivered in the period divided by average headcount for the period. Measures the media volume each agency employee manages.= Client billings / Average headcountCurrency
Media gross profit per employeeMedia gross profit (client billings minus media cost) in the period divided by average headcount for the period. Measures how much gross profit from media buying each agency employee generates.= Media gross profit / Average headcountCurrency
Absence daysNumber of scheduled working days on which employees were absent (annual leave, sick leave, unpaid leave, other).Count
Absence rateAbsence days divided by scheduled working days.= Absence days / hr_scheduled_daysRatio (%)
ApplicantsNumber of candidates who applied in the period (by application date).Count
Average headcountAverage number of active employees per day in the period.= hr_headcount_days / hr_snapshot_daysNumber
Average monthly cost per employeePayroll cost divided by the number of payslips (one employee-month each).= Payroll cost / hr_payslipsCurrency
New hiresNumber of employees with a start date in the period.Count
Offer acceptance rateOffers accepted divided by offers sent in the period.= hr_offers_accepted / Job offers sentRatio (%)
Job offers sentNumber of candidates sent a job offer in the period (by offer date).Count
Overtime hoursTotal overtime hours recorded in timesheets.Number
Payroll costTotal employer cost of personnel: base salary, allowances, overtime pay and employer-paid insurance. Payroll is recorded monthly, on the first day of the month.Currency
TerminationsNumber of employees whose last working day falls in the period, both voluntary and involuntary.Count
Average time to hire (days)Average number of days from application to offer date for hired candidates, by offer date.= hr_hire_days_total / hr_offers_acceptedNumber
Turnover rateTerminations in the period divided by average headcount for the period.= Terminations / Average headcountRatio (%)
Voluntary terminationsNumber of employees who resigned, with their last working day in the period.Count
Voluntary turnover rateVoluntary terminations in the period divided by average headcount for the period.= Voluntary terminations / Average headcountRatio (%)
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, hr_employee

Add if you have it (unlocks more metrics)

insertion_order, timesheet, hr_payroll, hr_attendance, hr_candidate

Three steps to this dashboard

  1. 1

    Connect your data

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

  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 37 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 · HR with your own data

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