Skip to content

Dashboard templates

Media & advertising · Marketing

Digital advertising agency buying media for brand clients and running its own marketing to win new brands (case studies, LinkedIn, conferences, webinars, client referrals). Media P&L by client, campaign and platform, plus the agency's marketing funnel: spend, leads, CPL, CAC and budget, against media gross profit and newly signed IO value.

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

For the agency's own marketing to win new brands: case studies, LinkedIn, events, webinars and referrals. The "Agency marketing" dashboard shows newly signed IO value per unit of marketing spend and agency marketing spend as a share of media gross profit. The "Campaigns and budget" and "Marketing funnel" dashboards track spend, leads, CPL and CAC, and the media dashboards show which clients the gross profit comes from. Needs client, campaign, daily delivery, daily marketing spend and lead data.

Use this template to

  • See which channel brings in new brands at the lowest cost.
  • Judge an event by the newly signed IO value that came with it.
  • Keep agency marketing spend within a set share of media gross profit.

5 ready-made dashboards

Agency marketing

The agency's own marketing spend versus media gross profit and newly signed IO value.

  • Marketing spend
  • Agency marketing spend to media gross profit
  • New IO booked value
  • New IO value per marketing spend
  • Monthly marketing spend to media gross profit
  • Monthly new IO value to marketing spend
  • CAC by marketing channel

Marketing funnel

Cost, leads, qualification rate, new customers and cost per new customer by channel and source.

  • Marketing spend
  • Leads
  • Cost per lead (CPL)
  • Customer acquisition cost (CAC)
  • Funnel by marketing channel
  • Lead qualification rate by source
  • Lead-to-customer rate by source
  • Weekly leads by channel

Campaigns and budget

Budget, cost, budget utilization and performance of each marketing campaign.

  • Budget utilization
  • New customer value to spend (marketing ROI)
  • New customers from marketing
  • Click-through rate (CTR)
  • Results by campaign
  • Budget utilization by campaign
  • Cost per new customer by channel
  • Weekly marketing cost by channel

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 new IO value per marketing spend change compared with last month?”
  • “What is driving agency marketing spend to media gross profit this quarter?”
  • “Show campaign budget by month for the last six months.”
  • “Where is budget utilization highest this month, and why?”

37 defined metrics

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

MetricDefinitionUnit
New IO value per marketing spendValue of advertising contracts (IOs) signed in the period, excluding cancelled IOs, divided by the agency's marketing cost in the same period. How much new contract value each unit of marketing spend brings in.= New IO booked value / Marketing spendNumber
Agency marketing spend to media gross profitThe agency's own marketing cost (to win new brands) divided by media gross profit in the same period. Shows how much of the gross profit from media buying is reinvested in marketing.= Marketing spend / Media gross profitRatio (%)
Campaign budgetTotal budget of campaigns starting in the period. The full campaign budget is recorded on its start date.Currency
Budget utilizationMarketing spend divided by campaign budget. Above 100% means over budget.= Marketing spend / Campaign budgetRatio (%)
Customer acquisition cost (CAC)Marketing spend divided by new customers (by conversion date).= Marketing spend / New customers from marketingCurrency
ClicksTotal clicks (or engagements that drive traffic) of campaigns by day.Count
Cost per lead (CPL)Marketing spend divided by leads created in the period.= Marketing spend / LeadsCurrency
Click-through rate (CTR)Clicks divided by impressions.= Clicks / ImpressionsRatio (%)
New customer first-order valueTotal value of the first transaction of leads converted in the period, by conversion date.Currency
ImpressionsTotal impressions (or reach) of campaigns by day.Count
Lead-to-customer rateLeads created in the period that have become customers divided by leads created in the period.= mkt_converted_leads / LeadsRatio (%)
LeadsNumber of leads (prospects) created in the period, by creation date.Count
MQL rateMarketing-qualified leads divided by leads created in the period.= Marketing-qualified leads (MQL) / LeadsRatio (%)
Marketing-qualified leads (MQL)Leads created in the period that passed marketing qualification (status MQL, SQL or converted to customer).Count
New customers from marketingLeads that became customers in the period, by conversion date. Converted leads with no conversion date fall in no period.Count
New customer value to spend (marketing ROI)New customer first-order value divided by marketing spend. Above 1 means first orders have covered the cost.= New customer first-order value / Marketing spendNumber
Marketing spendTotal cost of marketing campaigns by spend date.Currency
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, mkt_spend_daily, mkt_lead

Add if you have it (unlocks more metrics)

insertion_order, timesheet, mkt_campaign

Three steps to this dashboard

  1. 1

    Connect your data

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

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

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