Kpiloom

Google Sheets Marketing Dashboard Templates

A marketing dashboard connects spend to leads and customers, so you know which channels pay back. Pick your industry below to see a live preview of the Google Sheets version.

Choose your industry

KPIs in every marketing dashboard

KPIWhat it tells youFormula
Website visitorsUnique people who visited the website.COUNT DISTINCT of users (from GA4)
LeadsPeople who shared contact details or enquired.COUNT of form fills, calls and chats
Cost per leadAverage spend to get one lead.Ad spend ÷ Leads
Conversion rateShare of visitors who became leads or buyers.Conversions ÷ Visitors
ROASRevenue earned for every 1 spent on ads.Ad revenue ÷ Ad spend
Customer acquisition costTotal sales and marketing cost to win one customer.(Sales + Marketing cost) ÷ New customers
Email open rateShare of delivered emails that were opened.Opens ÷ Delivered emails
Ad spendMoney spent on paid ads in the period.SUM of spend across ad platforms