Skip to content

Dashboard templates

Media & advertising · Sales

A digital ad agency buying media for brand clients, with account managers selling campaign packages. Media P&L by client, campaign and platform plus opportunities, win rate, targets and new contracts versus billings.

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

For agency account managers selling campaign packages. The "New contracts and revenue" dashboard shows the book-to-bill ratio and the gap between the two numbers. The "Opportunities and quota" dashboard tracks opportunities, win rate, contract value and quota attainment, and the media and hours dashboards show whether signed clients are profitable. Needs client, campaign, daily delivery and sales opportunity data.

Use this template to

  • Know whether new contracts are enough to replace revenue that is running out.
  • Track which account managers hit quota.
  • Avoid signing more clients like the ones losing money.

5 ready-made dashboards

New contracts and revenue

Contract value closed by the sales team versus client billings for media delivered.

  • Won amount
  • Client billings
  • Book-to-bill ratio
  • Bookings minus billings
  • Monthly new bookings to revenue ratio
  • Monthly gap between new bookings and revenue
  • Closed value by account manager

Opportunities and quota

New opportunities, win rate, closed value and quota attainment of the sales team.

  • Won amount
  • Win rate
  • Open pipeline value
  • Average sales cycle (days)
  • Results by salesperson
  • Quota attainment by team
  • Win rate by opportunity source
  • Monthly closed value by region

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

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 book-to-bill ratio change compared with last month?”
  • “What is driving bookings minus billings this quarter?”
  • “Show average deal size by month for the last six months.”
  • “Where is average sales cycle (days) highest this month, and why?”

32 defined metrics

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

MetricDefinitionUnit
Book-to-bill ratioValue of contracts the sales team won in the period (by close date) divided by media client billings delivered in the same period. Above 1 means new bookings exceed delivered work and the backlog of work grows.= Won amount / Client billingsRatio (%)
Bookings minus billingsValue of contracts won in the period minus media client billings delivered in the period. Positive means the backlog of work grows; negative means older contracts are being burned down.= Won amount - Client billingsCurrency
Average deal sizeWon amount divided by the number of won opportunities.= Won amount / Won opportunitiesCurrency
Average sales cycle (days)Average days from creation to win for opportunities won in the period.= won_cycle_days_total / Won opportunitiesNumber
Lost opportunitiesNumber of opportunities lost, by close date.Count
New opportunitiesSales opportunities created in the period (by creation date), including open, won and lost ones.Count
Open pipeline valueTotal value of opportunities created in the period that are still open (neither won nor lost).Currency
Sales targetTotal sales targets of sales reps. Targets are set monthly and recorded on the first day of the month.Currency
Quota attainmentWon amount divided by sales target. Above 100% means the target is exceeded.= Won amount / Sales targetRatio (%)
Win rateWon opportunities divided by all closed opportunities (won plus lost) in the period. Open opportunities are excluded.= Won opportunities / (Won opportunities + Lost opportunities)Ratio (%)
Won amountTotal value of won opportunities, by close date.Currency
Won opportunitiesNumber of opportunities won, by close 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, opportunity

Add if you have it (unlocks more metrics)

insertion_order, timesheet, sales_rep, sales_target

Three steps to this dashboard

  1. 1

    Connect your data

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

  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 32 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 · Sales with your own data

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