How to Build a Simple Marketing Dashboard in Google Sheets

A marketing dashboard template in Google Sheets is a three-tab workbook: one tab for raw data, one for calculations, and one for the scorecards and charts people actually read. Most people can build a working version in an afternoon using a handful of formulas, no add-ons, and a free Google account.

This guide walks through the full build: which KPIs belong in your KPI tracking sheet, the Google Sheets formulas for marketing that do most of the work, how to turn the file into a weekly marketing report, and when a Looker Studio alternative (or companion) makes sense. One point worth knowing up front: Google says Looker Studio went back to its original name, Data Studio, in April 2026, so you will see both names online.

What Is a Marketing Dashboard Template in Google Sheets?#

A marketing dashboard template in Google Sheets is a reusable spreadsheet that pulls campaign data into one place, calculates KPIs such as cost per acquisition and return on ad spend, and displays them as scorecards and charts. You paste or import new data each week, and everything else updates automatically.

The value is not the charts. It is the discipline of agreeing on a short list of numbers, defining them once, and looking at them on a regular schedule.

Which KPIs Belong in a KPI Tracking Sheet?#

Start with five to eight KPIs, each tied to a decision someone can actually make. More than that and the dashboard turns into wallpaper. The table below shows a practical starting set, with raw inputs on the left and calculated KPIs on the right.

Add one or two channel-specific metrics only if they change what you do, such as organic clicks for search or email click rate for newsletters. If any of these terms are unfamiliar, Search Savvy’s analytics and reporting glossary covers the vocabulary.

How Do You Build a Marketing Dashboard in Google Sheets?#

You build it in five steps: structure the data, add a week column, summarize with SUMIFS, calculate KPIs, then build the dashboard tab.

Step 1: Create Three Tabs#

Name them Data, Calc, and Dashboard. Keep each job separate. The Data tab holds only raw numbers, Calc holds formulas, and Dashboard holds what viewers see.

Step 2: Set Up a Flat Data Table#

On the Data tab, use one header row and one row per day per channel. A workable column order:

A Date | B Week Start | C Channel | D Campaign | E Impressions | F Clicks | G Sessions | H Conversions | I Spend | J Revenue

Resist merged cells, subtotals, and notes inside the table. Google’s own guidance for connecting Sheets to Data Studio asks for tabular data, a single header row, and one data type per column, so a clean table now keeps your options open later.

Step 3: Add a Week Column#

In B2, calculate the Monday of each date’s week:

=A2-WEEKDAY(A2,3)

Fill it down. Weekly reporting now needs no manual grouping.

Step 4: Summarize With SUMIFS#

On the Calc tab, list each week start in column A and each channel across the top. Then total any metric by week and channel with SUMIFS, which sums a range based on multiple criteria:

=SUMIFS(Data!H:H, Data!B:B, A2,Data!C:C,B1)

That returns conversions for the week in A2 and the channel named in B1. Copy it across for spend, clicks, and revenue.

Step 5: Calculate KPIs From Totals#

Compute each KPI from the summed totals, never by averaging daily rates. Averaging daily CTRs gives a day with 10 impressions the same weight as a day with 10,000, which distorts the result. Wrap ratios in IFERROR so empty weeks stay clean:

=IFERROR(Spend/Conversions, “”)

For week-over-week change, use =IFERROR((C3-C2)/C2, “”).

Which Google Sheets Formulas for Marketing Matter Most?#

A small set covers nearly every marketing dashboard. Google lists several of them as functions that are unique to Sheets, which is useful to know if you are coming from Excel.

Google documents these in its list of Sheets functions that differ from Excel. A top-five campaigns table for a chosen week looks like this, with the week start typed into cell B1 of the Dashboard tab:

=QUERY(Data!A:J, “select D, sum(H) where B = date ‘”&TEXT(B1,”yyyy-mm-dd”)&”‘ group by D order by sum(H) desc limit 5 label sum(H) ‘Conversions'”, 1)

For a compact trend beside each scorecard, point SPARKLINE at the last twelve weekly values: =SPARKLINE(Calc!C2:C13, {“charttype”,”column”}).

How Do You Design the Dashboard Tab?#

Design it for a reader with 30 seconds. Put scorecards across the top, trend charts in the middle, and detail tables at the bottom.

• Scorecards: Show the latest week’s value and its change against the prior week. Pull the latest row with INDEX and MATCH on the maximum week start.
• Charts: Use a line chart for trends over time and a column chart for channel comparisons. Avoid pie charts with more than three slices.
• Colour: Apply conditional formatting so improvements and declines are visible at a glance. Remember that a rising CPA is bad while a rising CTR is good.
• Controls: Add a data-validation dropdown for channel and reference it inside your SUMIFS formulas so viewers can filter without touching the formulas.

How Do You Turn It Into a Weekly Marketing Report?#

Refresh the data, read the numbers, then write three short comments above the scorecards: what changed, the likely reason, and what you will do next. The commentary is the part stakeholders value most, because they can read numbers anywhere.

A simple weekly routine:

1. Paste the previous week’s exports into the Data tab.
2. Check that the new rows have the right week start and no blanks.
3. Review scorecards and charts for anything unusual.
4. Write the three-line commentary.
5. Share the sheet as view-only or send a PDF.

If you report on social channels, Search Savvy’s social media analytics and performance reporting page outlines what that reporting typically covers.

Is Data Studio (Formerly Looker Studio) a Better Alternative?#

Not better, just different. Google’s documentation describes Data Studio as a no-cost tool with connectors for Google Analytics, Google Ads, Search Console, Google Sheets, and other sources, and notes that the product returned to its original name in April 2026.

The most practical setup is often both. Keep Sheets as the data layer, then connect it to Data Studio for presentation. One limit to plan for: a Sheets data source connects to a single worksheet, so give each dataset its own clean tab. Google’s Sheets connector documentation covers the details, including that Data Studio picks up new rows automatically when a report runs.

What Mistakes Should You Avoid?#

• Tracking too many KPIs. If nobody can name the decision a metric supports, remove it.
• Mixing grains. Keep one row per day per channel throughout, or sums will double count.
• Averaging ratios. Always calculate rates from totals.
• Hard-coding numbers inside formulas. Reference cells so updates flow through.
• Ignoring source differences. Ad platforms and analytics tools often report conversions differently. Label the source of every column.
• Skipping definitions. Add a small notes tab that defines each KPI, so two people never read “conversion” two ways.

The Bottom Line#

A simple marketing dashboard in Google Sheets comes down to a clean flat table, a week column, SUMIFS totals, ratio KPIs calculated from sums, and a dashboard tab built for a 30-second read. Start with five KPIs, run it for a month, and only then consider moving the presentation layer to Data Studio. If your KPIs include CPA and ROAS targets that need interpreting, Search Savvy’s performance marketing page explains that service area, and its free SEO tools can help with the search side of your reporting.

Frequently Asked Questions#

Can I build a marketing dashboard in Google Sheets for free?#

Yes. Sheets is included with a personal Google account, and every formula in this guide is built in. You only pay if you add third-party connector tools or Google’s Pro tier for Data Studio.

How do I automate a marketing dashboard in Google Sheets?#

You can use IMPORTRANGE to pull data from other spreadsheets, third-party connectors, or Google Apps Script. Many small teams start with a weekly paste, which takes minutes and avoids connector costs.

Which Google Sheets formulas are most useful for marketing reports?#

SUMIFS, IFERROR, QUERY, SPARKLINE, and IMPORTRANGE cover most needs. SUMIFS totals data, QUERY creates ranked tables, and IFERROR keeps empty periods from showing errors.

Is Looker Studio still called Looker Studio?#

Not according to Google. Its documentation says the product name returned to Data Studio in April 2026, and the old lookerstudio.google.com address redirects to the new domain. Existing reports do not need updating.

Can Data Studio read my Google Sheet?#

Yes. It has a Google Sheets connector, and each data source connects to one worksheet. Keep that worksheet tabular, with one header row and consistent data types in each column.

How many KPIs should a marketing dashboard show?#

Start with five to eight. Each should connect to a decision, such as shifting budget or fixing a landing page. Add more only when a specific question demands them.