Skip to content

Dashboard templates

Media & advertising · Customer service

A digital advertising agency with a client service team (account managers on email, Zalo groups and hotline; reporting support on the request portal) handling creative revision requests, report requests, delivery complaints and invoices. Media P&L by client and campaign plus ticket volume, response speed, satisfaction and tickets per VND 1 bn of client billings by client and campaign.

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

For account and support teams at digital ad agencies handling creative change requests, report requests, delivery complaints and invoices over email, Zalo groups and hotline. The "Support by client" dashboard puts tickets next to each brand's media profit and loss, measured as support tickets per billion VND billed. The "Media overview" and "Delivery performance" dashboards show whether that client is profitable, and the two customer service dashboards track response time and CSAT. Needs client, campaign, daily delivery and ticket data.

Use this template to

  • Spot brands that take a lot of support effort on thin gross margin before contract renewal.
  • Track delivery complaints by campaign so the media buying team can act early.
  • Compare response speed across account teams and rebalance workload.

5 ready-made dashboards

Support by client

Campaign-linked requests and complaints by client and campaign, against billed amount, to see which brands need the most care.

  • Client tickets per VND 1 bn billings
  • Campaign-linked client tickets
  • CSAT (satisfaction rate)
  • Client billings
  • Tickets per billion VND billed by client
  • Campaign-linked tickets by category
  • Weekly campaign-linked tickets by client

Customer service

Ticket volume, response and resolution speed, and customer satisfaction by channel and category.

  • Support tickets
  • Average first response time (hours)
  • Resolution rate
  • CSAT (satisfaction rate)
  • Daily tickets by category
  • By contact channel
  • Tickets by category
  • First response by channel group
  • NPS
  • Call abandonment rate

CS agents

Productivity, speed and quality of handling for each customer service agent and team.

  • Resolved tickets
  • Tickets per agent per day
  • First contact resolution rate
  • Ticket reopen rate
  • Results by agent
  • CSAT by team
  • Weekly CSAT by team

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 campaign-linked client tickets change compared with last month?”
  • “What is driving client tickets per VND 1 bn billings this quarter?”
  • “Show call abandonment rate by month for the last six months.”
  • “Where is average first response time (hours) highest this month, and why?”

35 defined metrics

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

MetricDefinitionUnit
Campaign-linked client ticketsSupport tickets created in the period whose reference code matches an ad campaign; broken down by that campaign's client, client segment, campaign and campaign objective, and by ticket category.Count
Client tickets per VND 1 bn billingsCampaign-linked support tickets created in the period times 1 billion divided by media client billings in the same period. Shows which clients and campaigns need the most servicing relative to the revenue they bring.= Campaign-linked client tickets * 1000000000 / Client billingsNumber
Call abandonment rateCalls where the customer hung up before reaching an agent divided by all inbound calls.= cs_abandoned_calls / Inbound callsRatio (%)
Average first response time (hours)Average hours from when the customer created a ticket to the agent's first response, over tickets created in the period that have a response.= cs_first_response_hours_total / cs_responded_ticketsNumber
Average resolution time (hours)Average hours from creation to resolution for tickets resolved in the period.= cs_resolution_hours_total / Resolved ticketsNumber
Inbound callsCalls into the call center in the period, including calls abandoned by the customer.Count
CSAT (satisfaction rate)Share of surveys with a CSAT score of 4 or 5 on a 1-5 scale, among surveys with a valid CSAT score.= cs_csat_positive / Survey responsesRatio (%)
First contact resolution rateTickets resolved with a single contact and never reopened divided by tickets resolved in the period.= cs_fcr_tickets / Resolved ticketsRatio (%)
NPSNet Promoter Score = (promoters 9-10 minus detractors 0-6) x 100 / NPS responses. Scale -100 to 100.= cs_nps_points * 100 / cs_nps_responsesNumber
Ticket reopen rateTickets resolved in the period that were ever reopened divided by tickets resolved in the period.= cs_reopened_tickets / Resolved ticketsRatio (%)
Resolution rateTickets created in the period that are resolved divided by tickets created in the period.= cs_created_resolved / Support ticketsRatio (%)
Resolved ticketsTickets resolved in the period (by resolution date); status resolved or closed with a resolution timestamp.Count
Survey responsesPost-support surveys with a valid CSAT score (1-5), by customer response date.Count
Support ticketsSupport tickets created in the period (by creation date), any status.Count
Tickets per agent per dayTickets created in the period divided by agent working days with tickets.= Support tickets / cs_agent_daysNumber
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, cs_ticket

Add if you have it (unlocks more metrics)

insertion_order, timesheet, cs_agent, cs_survey, cs_call

Three steps to this dashboard

  1. 1

    Connect your data

    Upload an Excel file or connect a source with: client, campaign, delivery_daily, cs_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 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 · Customer service with your own data

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