Key takeaways
- A useful KPI dashboard answers one question for one audience. Build separate views for executives, channel owners and clients.
- Keep each dashboard to 6 to 10 KPIs, each with a written definition, a single source and a target.
- Pull revenue from your store or CRM, not from ad platforms. Platforms each credit themselves.
- Below are eight ready-to-copy specs, from executive revenue to agency client reports.
- Databox has a free plan, Looker Studio (now called Data Studio) is free, and Google Sheets is free with a Google account. Pick the tool after you pick the KPIs.
What makes a KPI dashboard useful
Most dashboards fail because they show everything the connectors can pull, not the few numbers that drive a decision. Apply these rules first.
- One audience, one question. A CEO asks if revenue is on track. A media buyer asks which ad set to cut. Give them separate screens.
- Every KPI has a definition. Write the formula next to the chart. If two people can read a number two ways, it will cause an argument.
- Every KPI has a target or a comparison. A number with no target and no prior period is trivia.
- One source of truth per metric. Decide whether revenue comes from Shopify, the CRM or GA4, and stick to it.
- A review cadence. A dashboard nobody opens on a schedule is decoration.
If you are still choosing which metrics matter, start with our guide to marketing KPIs that matter, then come back to the templates.
8 KPI dashboard templates for marketing teams
Each template lists the audience, KPIs with definitions, sources, a chart per KPI, review cadence and one mistake to avoid. Definitions follow platform documentation, linked where used.
1. Executive weekly revenue dashboard
Who it is for: Founders and CMOs who need to know if this week is on track.
Data sources: Shopify or CRM for revenue, ad platforms for spend, GA4 for sessions, a targets sheet.
| KPI | Definition / formula | Source | Chart |
|---|---|---|---|
| Net revenue | Revenue after discounts and returns. Use the number finance trusts. | Shopify / CRM | Scorecard with change vs last week |
| Revenue vs target | Revenue to date / target to date. | Shopify / CRM + targets sheet | Bullet or progress bar |
| Total marketing spend | Sum of spend across all paid channels. | Google Ads, Meta Ads | Scorecard |
| MER (marketing efficiency ratio) | Total revenue / total marketing spend. | Calculated | Line chart, 12 weeks |
| New customers | First-time buyers, or new closed-won accounts for B2B. | Shopify / CRM | Column chart by week |
| Blended CAC | Total marketing spend / new customers. | Calculated | Line chart, 12 weeks |
| Site conversion rate | Orders (or leads) / sessions. | Shopify / GA4 | Line chart |
Review cadence: Weekly, every Monday, in a 15-minute meeting.
Common mistake: Adding up revenue that each ad platform reports. Every platform credits itself, so the total overstates real revenue. Use your store or CRM only.
2. Paid media dashboard (Google Ads + Meta)
Who it is for: Media buyers and the person who approves ad budgets.
Data sources: Google Ads and Meta Ads Manager, with GA4 or your backend as a cross-check.
| KPI | Definition / formula | Source | Chart |
|---|---|---|---|
| Spend | Cost for the period, split by platform and campaign. | Google Ads, Meta Ads | Stacked column by platform |
| Conversions | Count of the conversion actions you set as primary. | Google Ads, Meta Ads | Column chart |
| Cost per conversion (CPA) | Cost / conversions. | Calculated | Line chart |
| ROAS | Conversion value / cost. Google Ads shows this as the conversion value/cost column. | Google Ads, Meta Ads | Line chart vs target line |
| CTR | Clicks / impressions. | Google Ads, Meta Ads | Table by campaign |
| CPC | Cost / clicks. | Google Ads, Meta Ads | Table by campaign |
| Frequency (Meta) | Average times each account saw your ad. Meta calculates it as impressions divided by reach. | Meta Ads | Line chart by ad set |
Review cadence: Spend and pacing checked daily. Full review weekly.
Common mistake: Treating a Google conversion and a Meta conversion as the same thing. Each uses its own attribution and counting rules. Compare each platform with its own history and judge the total from your backend.
3. SEO dashboard (Search Console + GA4)
Who it is for: SEO leads, content teams and anyone asked whether organic is growing.
Data sources: Google Search Console for search visibility, GA4 for what visitors do after they land.
| KPI | Definition / formula | Source | Chart |
|---|---|---|---|
| Clicks | Clicks from Google Search to your site, as defined by Search Console. | Search Console | Line chart, 16 months |
| Impressions | Times a link to your site was seen (or potentially seen) in results. | Search Console | Line chart |
| CTR | Clicks / impressions. | Search Console | Table by page |
| Average position | Topmost position of your link, averaged across all queries. | Search Console | Table by query |
| Non-brand clicks share | Non-brand clicks / total clicks. Filter out brand queries with a regex. | Search Console | Stacked area |
| Organic engagement rate | Engaged sessions / sessions for Organic Search. GA4 counts a session as engaged if it lasts over 10 seconds, has a key event, or has 2+ page views. | GA4 | Scorecard |
| Organic key events | Count of key events from Organic Search sessions. | GA4 | Column chart by month |
Review cadence: Monthly review, with a quick weekly look for sudden drops.
Common mistake: Reading average position on its own. Because it is averaged across all queries, ranking for many new long-tail queries can pull the average down while clicks go up. Always show it next to clicks.
More on this in SEO reporting KPIs and essential GA4 reports.
4. Ecommerce dashboard (Shopify)
Who it is for: Store owners, ecommerce managers and the team running promotions.
Data sources: Shopify analytics, ad platforms for spend, and a cost sheet for product costs.
| KPI | Definition / formula | Source | Chart |
|---|---|---|---|
| Net sales | Sales with discounts and sales reversals factored in. See Shopify field definitions. | Shopify | Scorecard + line chart |
| Orders | Number of orders placed. | Shopify | Column chart by day |
| Average order value (AOV) | (Gross sales - discounts) / orders. | Shopify | Line chart |
| Conversion rate | Sessions that completed checkout / sessions. | Shopify | Line chart |
| Returning customer rate | Returning customers / customers. | Shopify | Line chart, monthly |
| Contribution after ads | Net sales - product costs - shipping - ad spend. | Shopify + cost sheet + ad platforms | Waterfall or column chart |
| Top products by net sales | Net sales grouped by product. | Shopify | Sorted bar chart |
Review cadence: Daily glance at sales and orders. Weekly review of margin and conversion.
Common mistake: Reporting total sales as revenue. Shopify's total sales includes taxes, shipping and fees, so it overstates what the business earned. Use net sales.
5. Email and retention dashboard (Klaviyo)
Who it is for: Retention and CRM marketers who run flows and campaigns.
Data sources: Klaviyo, with Shopify for repeat purchase context.
| KPI | Definition / formula | Source | Chart |
|---|---|---|---|
| Attributed revenue | Revenue Klaviyo attributes to messages within its attribution window. Split flows vs campaigns. See the Klaviyo analytics glossary. | Klaviyo | Stacked column |
| Revenue per recipient | Attributed revenue / people who received a message. | Klaviyo | Line chart |
| Click rate | People who clicked / people who received. | Klaviyo | Table by campaign |
| Placed order rate | Orders in the attribution window / unique recipients. | Klaviyo | Table by flow |
| Open rate | People who opened / recipients. Use as a directional signal. | Klaviyo | Table by campaign |
| Unsubscribe rate | Unsubscribes / recipients, per campaign. | Klaviyo | Line chart |
| Spam complaint rate | Spam complaints / recipients. | Klaviyo | Line chart with alert |
Review cadence: Weekly for campaigns. Monthly for flows and list health.
Common mistake: Calling attributed revenue incremental revenue. Some attributed buyers would have ordered anyway. Use holdout tests for the incremental number.
6. Lead gen and B2B pipeline dashboard
Who it is for: B2B marketers, sales leaders and service businesses selling through calls or demos.
Data sources: GA4 for form submissions, your CRM (HubSpot, Salesforce, Zoho) for stages and deal values, ad platforms for spend.
| KPI | Definition / formula | Source | Chart |
|---|---|---|---|
| Leads | Form fills, calls or demo requests, tracked in GA4 and the CRM. | GA4, CRM | Column chart by source |
| Lead-to-SQL rate | SQLs / leads. Write down your SQL definition first. | CRM | Line chart |
| Cost per SQL | Marketing spend / SQLs. | Ad platforms + CRM | Table by channel |
| Pipeline created | Total value of new opportunities opened in the period. | CRM | Column chart by month |
| Win rate | Deals won / (deals won + deals lost). | CRM | Scorecard |
| Sales cycle length | Average days from opportunity created to closed-won. | CRM | Line chart |
| Revenue won | Value of deals closed-won. | CRM | Scorecard vs target |
Review cadence: Weekly with sales. Monthly for channel budget decisions.
Common mistake: Optimizing ads to the lowest cost per lead. Cheap leads that never become SQLs look good at the top and empty at the bottom. Judge channels on cost per SQL and pipeline.
7. Local business dashboard
Who it is for: Clinics, restaurants, salons, home services and multi-location brands.
Data sources: Google Business Profile, GA4, and call tracking or a booking tool.
| KPI | Definition / formula | Source | Chart |
|---|---|---|---|
| Profile views | People who viewed your Business Profile on Search and Maps. See Google definitions. | Business Profile | Line chart, monthly |
| Calls | Clicks on the call button on your profile. | Business Profile | Column chart |
| Direction requests | People who asked for directions to your business. | Business Profile | Column chart |
| Website clicks | Clicks on the website link on your profile. | Business Profile | Column chart |
| Search terms | Terms people used when your profile appeared. | Business Profile | Table, top 20 |
| Reviews and average rating | New reviews in the period and current star rating. | Business Profile | Scorecards |
| Bookings or calls from site | Bookings and click-to-call as GA4 key events. | GA4 / booking tool | Column chart |
Review cadence: Monthly. Weekly only for review responses.
Common mistake: Checking search terms every week. Google updates that data monthly, with a delay of up to five days, so weekly swings tell you nothing.
8. Agency client report
Who it is for: Agencies and freelancers reporting to clients, and in-house teams reporting to leadership.
Data sources: Usually GA4, ad platforms, Search Console and the client's store or CRM.
| KPI | Definition / formula | Source | Chart |
|---|---|---|---|
| Primary goal vs target | The one number the client hired you to move, against the agreed target. | Store / CRM | Bullet chart |
| Budget pacing | Spend to date / (monthly budget x days elapsed / days in month). | Ad platforms | Gauge or progress bar |
| Revenue or leads from marketing | Results by channel, from the client's own system where possible. | Store / CRM / GA4 | Stacked column by channel |
| CPA or ROAS | Cost / conversions, or conversion value / cost. | Ad platforms | Line chart vs target |
| Organic clicks | Clicks from Google Search. | Search Console | Line chart |
| Key events by channel | GA4 key events grouped by default channel group. | GA4 | Table |
Review cadence: Monthly report and call. Weekly pacing note by email.
Common mistake: Sending 40 charts with no commentary. Put three sentences at the top: what happened, why, and what you will do next. The charts are evidence, not the message.
Building these in Databox, Looker Studio or Google Sheets
All eight templates work in any of these tools. Here is what each official page says today.
Databox
Databox has a free plan at $0 per month with 1 user, 3 data sources, 1 dashboard and a daily maximum sync frequency. Paid plans start with Analyst at $71 per month billed annually, which raises the sync frequency to hourly and adds API access. There is also an Agency plan starting at $79 per month billed annually, with client packs at $20 per month each. The free plan's 3 data sources are enough for one template, such as paid media.
Looker Studio (now Data Studio)
Google's documentation now says that Looker Studio is now called Data Studio. The product page says it is available at no charge for creators and report viewers, and that it can connect to more than 1,400 data sources, including Google Sheets, Google Ads, BigQuery and Google Analytics. The paid Pro version costs $9 per user per project per month. Scheduled email delivery sends the report as a PDF, at most once per day on the standard version and up to once per hour on Pro. It suits the SEO, GA4 and Google Ads templates, where Google's own connectors do the work.
Google Sheets
Google Sheets is free for anyone with a Google account. It suits the executive and agency templates, where you paste or import a handful of weekly numbers and need full control over formulas. Our marketing reporting template for Google Sheets gives you a starting structure.
For a side-by-side on the two dashboard tools, read Databox vs Looker Studio.
How to roll it out in a week
- Day 1: Pick one template and one owner. Start with the one tied to your biggest budget line.
- Day 2: Write definitions and targets. Fix one source per metric and add a target or comparison period.
- Day 3: Check tracking. Confirm GA4 key events, ad conversion actions and CRM stages fire correctly.
- Day 4: Connect sources and build. Build one chart per KPI using the chart types listed.
- Day 5: Reconcile. Compare totals with source platforms for last month. Fix filter, date or currency gaps.
- Day 6: Add commentary space. Add a text box at the top: what changed, why, next actions.
- Day 7: Run the first review. Note which KPIs nobody used and remove them.
FAQ
What is a KPI dashboard in marketing?
A single view of the few metrics tied to your marketing goals, each with a definition, a source and a target, built for one audience and reviewed on a set schedule.
How many KPIs should a marketing dashboard have?
Aim for 6 to 10. If you need more, you probably have two audiences and should split it into two dashboards.
Can I build a KPI dashboard in Databox for free?
Yes. Databox's free plan includes 1 user, 3 data sources and 1 dashboard, with data syncing at most daily. That is enough for a single template such as a paid media or SEO dashboard.
Is Looker Studio still free in 2026?
Yes. Google's product page says it is available at no charge for creators and viewers. Google now calls the product Data Studio. A paid Pro version adds team features and support at $9 per user per project per month.