Skip to content

Dashboard templates

Retail · Customer service

A retailer selling via marketplaces, website and stores, with a customer service team answering marketplace chat, hotline and Facebook page. Channel P&L plus support ticket volume, response speed, satisfaction and tickets per 100 orders.

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

For customer service teams at multichannel shops handling marketplace chat, hotline and Facebook page. The "Orders and support" dashboard links tickets to orders, so you see support tickets per 100 orders and the share of order-related tickets by channel, not a ticket count floating on its own. The "Customer service" and "CS agents" dashboards cover first response time, resolution rate and CSAT, while the profit and loss, sales channel and product dashboards show whether more tickets come with more returns. Needs channel, product, order, order line and support ticket data.

Use this template to

  • See how much return tickets per 100 orders rise after a big sale, and on which channel.
  • Schedule marketplace chat shifts around the busiest ticket hours and the slowest channels.
  • Find products that generate many questions and fix their descriptions, images or usage guides.

8 ready-made dashboards

Orders and support

Order-linked tickets by sales channel against order count, to see which channels generate the most complaints.

  • Support tickets per 100 orders
  • Order-linked support tickets
  • Order-related ticket share
  • Valid orders
  • Tickets per 100 orders by marketplace
  • Weekly tickets per 100 orders
  • Daily tickets by category

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

Profit and loss overview

Actual revenue down to profit after marketplace fees, returns and ads.

  • Net revenue
  • Contribution margin
  • Net profit after fees and ads
  • Net margin
  • From revenue to profit
  • Weekly profit after fees by channel
  • Weekly orders by channel

Sales channels

Compare channels by revenue, fees, return rate, profit and margin.

  • Profit and loss by channel
  • Return rate by channel
  • Profit after fees and ads by channel
  • Cancellation rate by channel
  • Weekly net revenue

Products

SKUs ranked by profit; loss-making SKUs in red; COGS coverage shows which SKUs have no cost yet.

  • Profit by SKU (biggest losses first)
  • Gross profit after fees by category
  • Units sold by SKU
  • Monthly COGS by SKU

Advertising

Spend by platform and campaign, platform-reported ROAS, and the gap between reported and actual revenue by channel.

  • Ad spend
  • Blended ROAS
  • Platform-reported ROAS
  • Ad-reported vs actual revenue gap
  • Ad platform reported vs actual revenue by channel
  • Campaigns
  • Spend by ad platform
  • Monthly platform ROAS by campaign

Data health

Quality test results with row numbers in the Excel file; COGS coverage and unsettled fees.

  • COGS coverage
  • Provisional fee rate
  • Data quality checks
  • COGS coverage by SKU

Ask Si as soon as the build finishes

  • “How did order-related ticket share change compared with last month?”
  • “What is driving order-linked support tickets this quarter?”
  • “Show support tickets per 100 orders by month for the last six months.”
  • “Where is call abandonment rate highest this month, and why?”

37 defined metrics

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

MetricDefinitionUnit
Order-related ticket shareSupport tickets linked to an order divided by all support tickets created in the period.= Order-linked support tickets / Support ticketsRatio (%)
Order-linked support ticketsSupport tickets created in the period whose reference code matches an order; broken down by that order's sales channel.Count
Support tickets per 100 ordersOrder-linked support tickets divided by valid orders, times 100. Shows how many tickets there are for every 100 orders.= Order-linked support tickets * 100 / Valid ordersNumber
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
Ad spendTotal advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to.Currency
Average order valueLine revenue after discounts divided by valid orders.= line_net_total / Valid ordersCurrency
Cancellation rateCancelled orders divided by total orders.= cancelled_orders / all_ordersRatio (%)
Cost of goods soldQuantity times unit cost on the order date (half-open validity interval). SKUs without a cost count as 0; see COGS coverage. Returned lines do not reverse their COGS.Currency
COGS coverageShare of line revenue (after discounts) coming from SKUs that have a cost. Below 100% means the profit metrics are overstated.= line_net_with_cost / line_net_totalRatio (%)
Contribution marginNet revenue minus COGS, marketplace fees, payment fees, shipping and return costs (before advertising).= Net revenue - Cost of goods sold - Marketplace fees - Payment fees - Seller-paid shipping cost - Return costCurrency
GMV (gross merchandise value)Total quantity times unit price of the order lines in valid orders (before discounts, vouchers and refunds).Currency
Net marginProfit after fees and advertising divided by net revenue.= Net profit after fees and ads / Net revenueRatio (%)
Net profit after fees and adsNet revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spendCurrency
Net revenueLine value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here.Currency
Valid ordersOrders that were not cancelled (standard status other than cancelled).Count
Payment feesMarketplace transaction fees and payment gateway fees, allocated to lines by line revenue.Currency
Marketplace feesMarketplace commission and service fees, allocated to lines by line revenue.Currency
Ad-reported vs actual revenue gapAd-platform-reported revenue minus actual net revenue for the same channel and period. Positive means the platform reports more than reality.= ad_conversion_value - Net revenueCurrency
Provisional fee rateShare of fees (marketplace, payment, shipping) not yet settled, which may still change.= provisional_fees / (Marketplace fees + Payment fees + Seller-paid shipping cost)Ratio (%)
Return costReturn shipping cost borne by the shop. Does NOT include refunds to buyers (already deducted in net revenue).Currency
Return rateReturned orders divided by valid orders.= returned_orders / Valid ordersRatio (%)
Blended ROASActual net revenue divided by ad spend for the same channel and period.= Net revenue / Ad spendNumber
Platform-reported ROASAd-platform-reported revenue divided by ad spend.= ad_conversion_value / Ad spendNumber
Seller-paid shipping costOutbound shipping cost paid by the shop, allocated to lines by line revenue.Currency
Units soldTotal quantity of products in the order lines of valid orders.Count

Data you need

Required

channel, product, order, order_line, cs_ticket

Add if you have it (unlocks more metrics)

product_cost, customer, cost, return, ad_performance_daily, 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: channel, product, order, order_line, 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 8 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 Retail · Customer service with your own data

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