Marketing Campaign Dashboard in Excel

Build an interactive Excel dashboard to track marketing campaign KPIs.

Introduction

30 Second Summary

Marketing teams run campaigns across multiple channels every day. Knowing which ones are delivering results and which are burning through budget usually means digging through rows of raw data or waiting on expensive analytics tools.

In this project, you will build an interactive marketing campaign dashboard in Excel that answers three questions at a glance: Are we on budget? Which channel drives the best ROI? Which campaigns are underperforming?

What You'll Build

A single-workbook dashboard that lets you explore campaign performance across channels, campaign types, and time periods using PivotTables, PivotCharts, Slicers, and a Timeline.

By the end of this project, you'll have:

  • A structured campaign dataset formatted as an Excel Table that automatically expands when new data is added.
  • Three PivotCharts (bar, line, and column) with connected Slicers and a Timeline that filter all data simultaneously.
  • KPI summary cards with conditional formatting that visually flag underperforming campaigns using traffic-light colour coding.
  • Secret Mission: Add a Budget vs. Spend comparison chart and a Top 5 / Bottom 5 campaigns view for deeper analysis.

Are there any prerequisites?

Basic familiarity with Excel is helpful. You should be comfortable opening files, entering data into cells, and navigating between sheet tabs. No formulas or PivotTable experience is needed.

Set Up Your Workbook and Sample Data

Every great dashboard starts with clean, well-structured data. Before you can build charts and filters, you need a reliable dataset to power them.

In this step, you will create a new Excel workbook, enter 30 rows of sample marketing campaign data, and format it as an Excel Table. This structured table becomes the foundation for every PivotTable and chart you build in later steps.

In this step, get ready to:
  • Create and save a new workbook with a dedicated Data sheet.
  • Enter column headers and 30 rows of sample campaign data.
  • Convert the data range to a named Excel Table.
Create and save your workbook
  • In Excel, click Blank workbook to create a new file.
  • Press Ctrl+S (Windows) or Cmd+S (macOS) to save the file.
  • Name the file MarketingDashboard.xlsx and save it to your Desktop.
  • Right-click the Sheet1 tab at the bottom of the screen.
  • Select Rename, type Data, and press Enter.

Why rename the sheet tab?

You will add a separate Dashboard sheet later. Naming sheets clearly keeps your workbook organized and makes it obvious where your raw data lives versus where your visuals live.

You should now see a single sheet tab labelled Data at the bottom of your workbook.

Enter the column headers and sample data

Your dataset tracks marketing campaigns across multiple channels and types. Each row represents one campaign with its budget, spend, and performance metrics.

  • Click cell A1 on your Data sheet.
  • Type the following 12 headers across row 1, one per cell from A1 to L1:
Campaign_ID | Campaign_Name | Campaign_Type | Channel | Start_Date | End_Date | Budget | Spend | Impressions | Clicks | Conversions | Revenue

Speed up header entry

Type a header in a cell, then press the Tab key to move to the next cell in the same row. This is faster than clicking each cell individually.

  • Starting in row 2, enter the 30 rows of sample campaign data shown below. Each row goes in cells A through L:
C001 | Spring Brand Awareness    | Awareness     | Google Ads | 1/15/2024 | 2/15/2024 | 5000 | 4800 | 250000 | 3750 | 45  | 6750
C002 | Q1 Email Newsletter        | Consideration | Email      | 1/1/2024  | 3/31/2024 | 2000 | 1850 | 50000  | 5000 | 120 | 9600
C003 | LinkedIn Thought Leadership | Awareness     | LinkedIn   | 1/10/2024 | 2/28/2024 | 3000 | 2900 | 80000  | 1600 | 20  | 3200
C004 | Meta Retargeting           | Conversion    | Meta Ads   | 1/20/2024 | 2/20/2024 | 4000 | 3950 | 150000 | 6000 | 180 | 14400
C005 | Google Search Product       | Conversion    | Google Ads | 2/1/2024  | 2/28/2024 | 6000 | 5800 | 120000 | 7200 | 210 | 21000
C006 | Spring Sale Email           | Conversion    | Email      | 2/14/2024 | 2/28/2024 | 1500 | 1400 | 45000  | 6750 | 200 | 16000
C007 | Meta Lookalike             | Consideration | Meta Ads   | 2/1/2024  | 3/15/2024 | 3500 | 3400 | 180000 | 4500 | 90  | 7200
C008 | LinkedIn Lead Gen          | Conversion    | LinkedIn   | 2/15/2024 | 3/15/2024 | 4500 | 4200 | 60000  | 1800 | 55  | 8250
C009 | YouTube Pre-roll            | Awareness     | Google Ads | 3/1/2024  | 3/31/2024 | 7000 | 6800 | 400000 | 4000 | 30  | 3600
C010 | Meta Brand Video           | Awareness     | Meta Ads   | 3/1/2024  | 3/31/2024 | 5500 | 5200 | 320000 | 6400 | 50  | 5000
C011 | Email Win-back             | Consideration | Email      | 3/15/2024 | 4/15/2024 | 1000 | 950  | 30000  | 3600 | 85  | 5100
C012 | Google Display             | Awareness     | Google Ads | 3/1/2024  | 4/30/2024 | 4000 | 3800 | 500000 | 5000 | 35  | 3500
C013 | LinkedIn Webinar Promo     | Consideration | LinkedIn   | 3/20/2024 | 4/10/2024 | 2500 | 2400 | 45000  | 1350 | 40  | 4800
C014 | Meta Carousel Ads          | Consideration | Meta Ads   | 4/1/2024  | 4/30/2024 | 3000 | 2850 | 200000 | 5000 | 100 | 8000
C015 | Spring Product Launch       | Conversion    | Google Ads | 4/1/2024  | 4/30/2024 | 8000 | 7600 | 180000 | 9000 | 250 | 30000
C016 | Email Product Announce     | Conversion    | Email      | 4/1/2024  | 4/15/2024 | 1200 | 1100 | 40000  | 6000 | 150 | 12000
C017 | LinkedIn Sponsored Content | Awareness     | LinkedIn   | 4/15/2024 | 5/15/2024 | 3500 | 3300 | 70000  | 1400 | 18  | 2700
C018 | Meta Stories Campaign      | Awareness     | Meta Ads   | 4/15/2024 | 5/15/2024 | 2500 | 2400 | 280000 | 5600 | 40  | 3200
C019 | Google Shopping Ads        | Conversion    | Google Ads | 5/1/2024  | 5/31/2024 | 5500 | 5200 | 100000 | 8000 | 220 | 22000
C020 | Summer Email Series        | Consideration | Email      | 5/1/2024  | 6/30/2024 | 1800 | 1700 | 55000  | 5500 | 110 | 8800
C021 | LinkedIn Account-Based     | Conversion    | LinkedIn   | 5/1/2024  | 5/31/2024 | 5000 | 4700 | 35000  | 1050 | 45  | 9000
C022 | Meta App Install           | Conversion    | Meta Ads   | 5/15/2024 | 6/15/2024 | 4000 | 3800 | 250000 | 7500 | 175 | 10500
C023 | Google Performance Max     | Consideration | Google Ads | 5/15/2024 | 6/30/2024 | 6500 | 6200 | 350000 | 7000 | 130 | 11700
C024 | Email Cart Abandonment     | Conversion    | Email      | 6/1/2024  | 6/30/2024 | 800  | 750  | 20000  | 4000 | 180 | 14400
C025 | Meta Engagement            | Awareness     | Meta Ads   | 6/1/2024  | 6/30/2024 | 2000 | 1900 | 300000 | 9000 | 55  | 3300
C026 | LinkedIn InMail Campaign   | Consideration | LinkedIn   | 6/1/2024  | 6/30/2024 | 3000 | 2800 | 25000  | 750  | 30  | 4500
C027 | Google Brand Search        | Awareness     | Google Ads | 6/15/2024 | 7/15/2024 | 3000 | 2850 | 150000 | 6000 | 60  | 6000
C028 | Summer Sale Blast          | Conversion    | Email      | 6/15/2024 | 6/30/2024 | 1500 | 1400 | 48000  | 7200 | 210 | 18900
C029 | Meta Advantage Plus        | Conversion    | Meta Ads   | 6/15/2024 | 7/15/2024 | 5000 | 4800 | 220000 | 8800 | 200 | 18000
C030 | Google Discovery Ads       | Consideration | Google Ads | 6/1/2024  | 7/31/2024 | 4500 | 4300 | 280000 | 5600 | 95  | 7600

What does this data represent?

Each row is one marketing campaign. The columns capture its identity (ID, name, type, channel), timing (start and end dates), budget allocation (budget and actual spend), and performance outcomes (impressions, clicks, conversions, revenue).

The data spans January to July 2024 across four channels: Google Ads, Meta Ads, Email, and LinkedIn. Three campaign types (Awareness, Consideration, Conversion) represent different stages of the marketing funnel.

Entering dates in Excel

Type dates as 1/15/2024 or 15/1/2024 depending on your region. Excel will recognise and format them as date values automatically. If a date shows as a number, right-click the cell, select Format Cells, and choose Date.

  • After entering all 30 rows, press Ctrl+S (Windows) or Cmd+S (macOS) to save.
  • Verify your data by checking that cell A31 contains C030 and cell L31 contains 7600.

Data looks misaligned?

Make sure each value goes in its own cell. If an entire row ended up in one cell, you may have pasted with commas instead of tabbing between cells. Select the cell, delete it, and re-enter each value in its own column.

If dates display as plain numbers (like 45307), right-click the date cells, select Format Cells, choose Date, and click OK.

Help me fix my campaign data entry in Excel.

Convert your data to an Excel Table

An Excel Table is more than formatting. It gives your data automatic filtering, structured references for formulas, and auto-expansion when you add new rows.

  • Click any cell inside your data (for example, cell A1).
  • Press Ctrl+T (Windows) or Cmd+T (macOS).
  • In the Create Table dialog, confirm that My table has headers is checked.
  • Click OK.

Your data now has banded row colours and filter arrows in the header row.

  • Click any cell in the table to reveal the Table Design tab in the ribbon.
  • On the far left of the Table Design tab, find the Table Name box (it will show something like Table1).
  • Highlight the existing name, type CampaignData, and press Enter.

Why name the table?

Naming your table CampaignData makes formulas and PivotTable references human-readable. Instead of cryptic range references like $A$1:$L$31, you can write CampaignData[Revenue] to reference the Revenue column. Excel also auto-expands the table when you add rows, so PivotTables built on this table always include the latest data.

  • Save your file with Ctrl+S (Windows) or Cmd+S (macOS).
  • Confirm the table name stuck by clicking any cell in your data and checking that the Table Name box on the Table Design tab shows CampaignData.

Don't see the Table Design tab?

The Table Design tab only appears when a cell inside the table is selected. Click any cell within your data range (between A1 and L31) and the tab will appear in the ribbon.

If you see Table Tools above a Design tab instead, that is the same thing. Older versions of Excel label it differently.

Help me find the Table Design tab to rename my table.

✔️ Awesome, I've got everything!

Great. Double check you have saved your file, then move on to the next step.

ⓧ I'd like to double check the full data

Your Data sheet should have 12 headers in row 1 and 30 rows of data (rows 2 through 31). The table should be named CampaignData. Here is a summary to check against:

  • Column A (Campaign_ID): values from C001 to C030.
  • Column C (Campaign_Type): only three values. Awareness, Consideration, or Conversion.
  • Column D (Channel): only four values. Google Ads, Meta Ads, Email, or LinkedIn.
  • Column G (Budget): values range from 800 to 8000.
  • Column L (Revenue): values range from 2700 to 30000.
  • Total row count: 31 (1 header row + 30 data rows).

Your structured dataset is ready. Next up, you will turn this raw data into a PivotTable that summarises campaign performance by channel.

Create Your First PivotTable

Your campaign data is clean, structured, and ready to be analysed. Now you need a way to summarise 30 rows of numbers into a view that answers a real question: which marketing channel delivers the best return?

A PivotTable lets you drag fields into rows and columns to instantly aggregate your data without writing complex formulas. In this step you will create your first PivotTable, summarise revenue and spend by channel, and calculate ROI for each channel.

In this step, get ready to:
  • Insert a PivotTable on a new Dashboard sheet.
  • Build a Channel Performance summary showing revenue and spend.
  • Add an ROI calculation to compare channel efficiency.
Insert a PivotTable

PivotTables need a data source and a destination. You will point Excel at your CampaignData table and place the PivotTable on a brand-new sheet called Dashboard.

  • Switch to the Data sheet tab at the bottom of your workbook.
  • Click any cell inside the CampaignData table (for example, cell A2).
  • Go to the Insert tab on the ribbon.
  • Click PivotTable.
  • In the dialog that appears, confirm the Table/Range shows CampaignData.
  • Select New Worksheet and click OK.
  • Right-click the new sheet tab at the bottom and select Rename.
  • Type Dashboard and press Enter.

You should see an empty PivotTable placeholder on the left and the PivotTable Fields pane on the right listing all 12 columns from your data.

What is a PivotTable?

A PivotTable takes a flat list of records and lets you group, summarise, and rearrange them by dragging field names into four areas: Filters, Rows, Columns, and Values.

Instead of writing SUMIF formulas for every combination of channel and metric, the PivotTable does the aggregation for you automatically.

Don't see the PivotTable Fields pane?

Click any cell inside the PivotTable placeholder. The pane only appears when a PivotTable cell is selected.

If it still does not appear, go to PivotTable Analyze > Field List on the ribbon to toggle it on.

Help me find the PivotTable Fields pane in Excel.

Build a Channel Performance summary

With the empty PivotTable selected, you will drag fields into the correct areas to see total revenue and spend grouped by marketing channel.

  • In the PivotTable Fields pane, find Channel in the field list.
  • Drag Channel down to the Rows area at the bottom of the pane.
  • Find Revenue in the field list and drag it to the Values area.
  • Find Spend in the field list and drag it to the Values area as well.

Your PivotTable now shows each channel (Email, Google Ads, LinkedIn, Meta Ads) as a row, with Sum of Revenue and Sum of Spend as columns.

Why does it say Sum of Revenue?

When you drag a numeric field into the Values area, Excel automatically applies the SUM function. It adds up all revenue values that match each channel. This is the default aggregation for numeric data in PivotTables.

Seeing Count instead of Sum?

If your Revenue or Spend column shows "Count" instead of "Sum", it means Excel detected some non-numeric or blank cells in that column.

Right-click any value in the PivotTable, select Summarize Values By, and choose Sum.

Help me fix my PivotTable showing Count instead of Sum.

Add a calculated ROI column

The PivotTable shows raw totals, but stakeholders want to know efficiency. ROI (Return on Investment) tells you how much revenue each dollar of spend generates.

  • Click a cell in the column immediately to the right of your PivotTable's last value column (for example, if Spend ends in column C, click cell D3).
  • Type a header label ROI in the cell above (D2 or whichever row holds your column headers).
  • In the first data row next to your first channel, enter the following formula:
=(C4-B4)/B4

What does this formula do?

This calculates ROI as (Revenue - Spend) / Spend. A result of 1.5 means you earned $1.50 back for every $1 spent. The cell references point to the Sum of Revenue and Sum of Spend values that the PivotTable generated for each channel.

Adjust the cell references if your PivotTable layout places Revenue and Spend in different columns. The pattern is always =(Revenue cell - Spend cell) / Spend cell.

  • Press Enter to confirm the formula.
  • Select the cell containing the formula, then copy it down for each channel row (select the cell, drag the fill handle down, or press Ctrl+D after selecting the range).
  • Select all the ROI cells you just filled.
  • Go to Home > Number Format dropdown (the box that likely says "General") and select Percentage.

Your Dashboard sheet now shows each channel's total revenue, total spend, and ROI as a percentage.

Why use a manual formula instead of a calculated field?

Excel's calculated fields operate on the sum of values before division, which works fine here. However, for a first PivotTable project, placing the formula in an adjacent cell keeps things visible and easy to debug. You can see exactly which cells the formula references.

Seeing a division error?

A #DIV/0! error means the Spend cell is empty or zero. Check that your formula points to the correct Sum of Spend cell for that row.

If the ROI values look extremely large or small, confirm you are dividing by the Spend cell (not the Revenue cell).

Help me fix my ROI formula in the PivotTable.

You now have a working PivotTable that answers "which channel earns the most revenue?" at a glance. Next, you will turn these numbers into visual charts so patterns jump off the screen.

Add PivotCharts for Visual Insights

Your PivotTable already reveals which channels generate the most revenue and spend. But scanning rows of numbers takes effort, especially when you want to spot patterns at a glance.

PivotCharts turn your PivotTable data into visual charts that update automatically when filtered. In this step, you'll create three charts that make campaign performance instantly visible across channels, time periods, and campaign types.

In this step, get ready to:
  • Create a Clustered Column chart comparing revenue and spend by channel.
  • Build a Line chart showing monthly click and conversion trends.
  • Add a Clustered Bar chart breaking down performance by campaign type.
Create a Clustered Column chart for Channel Revenue vs. Spend

A column chart is the best way to compare discrete categories side by side. You'll turn your existing channel PivotTable into a visual comparison of revenue and spend.

  • Click any cell inside PivotTable1 on your Dashboard sheet.
  • Click the PivotTable Analyze tab in the ribbon.
  • Click PivotChart in the ribbon.
  • In the Insert Chart dialog, select Clustered Column and click OK.
  • Resize the chart by dragging its corner handles.
  • Drag the chart to position it in the upper-left area of your Dashboard sheet.

What is a PivotChart?

A PivotChart is a chart directly connected to a PivotTable. When you filter or rearrange the PivotTable, the chart updates automatically to reflect the new data.

This means you never need to manually rebuild charts when your data changes. The chart and table stay in sync at all times.

You should now see a column chart on your Dashboard sheet with coloured bars for Revenue and Spend, grouped by each channel (Google Ads, Meta Ads, Email, LinkedIn).

Don't see the PivotChart option?

Make sure you clicked inside the PivotTable first. The PivotTable Analyze tab only appears when a PivotTable cell is selected.

If you're using an older version of Excel, look for the Analyze or Options tab instead.

help me find the PivotChart button in my version of Excel

Create a second PivotTable and Line chart for monthly trends

Time-based trends reveal whether your campaigns are improving or declining over the months. You'll create a separate PivotTable for this because it needs a different row structure (dates instead of channels).

  • Click any cell in your CampaignData table on the Data sheet.
  • Go to Insert > PivotTable.
  • In the dialog, select Existing Worksheet.
  • Click the Location field, then switch to your Dashboard sheet and click a cell below your first chart (around row 20).
  • Click OK.
  • In the PivotTable Fields pane, drag Start_Date to Rows.
  • Excel will automatically group the dates by month (in Excel 2016 and later).
  • Drag Clicks to Values.
  • Drag Conversions to Values.
  • Click any cell in this new PivotTable.
  • Go to PivotTable Analyze > PivotChart.
  • Select Line as the chart type and click OK.
  • Drag the Line chart to position it to the right of your first Clustered Column chart.

Why did Excel auto-group the dates?

Excel 2016 and later automatically groups date fields by months, quarters, and years when they're added to a PivotTable. This saves you from manually grouping each time.

If your dates did not auto-group, right-click any date cell in the PivotTable, select Group, and choose Months.

You should see a line chart with two lines tracking Clicks and Conversions across months. The lines should show clear trends over time.

Seeing individual dates instead of months?

If automatic date grouping is disabled in your Excel settings, right-click any date in the PivotTable Rows area and select Group. Choose Months and click OK.

Also check that your Start_Date column contains actual date values (not text). If dates were entered as text, Excel cannot group them.

help me group my PivotTable dates by month

Create a third PivotTable and Bar chart for Campaign Type breakdown

Your final chart compares how different campaign types (Awareness, Consideration, Conversion) perform in terms of conversions and revenue.

  • Click any cell in the CampaignData table on the Data sheet.
  • Go to Insert > PivotTable.
  • Select Existing Worksheet and click a cell on the Dashboard sheet below your existing charts (around row 35).
  • Click OK.
  • In the PivotTable Fields pane, drag Campaign_Type to Rows.
  • Drag Conversions to Values.
  • Drag Revenue to Values.
  • Click any cell in this new PivotTable.
  • Go to PivotTable Analyze > PivotChart.
  • Select Clustered Bar and click OK.
  • Position this chart below the other two charts on your Dashboard sheet.

Why a bar chart instead of a column chart?

Bar charts (horizontal) work well when you have category labels that are longer text strings. Campaign type names like "Awareness" and "Consideration" read more clearly on horizontal bars than squeezed under vertical columns.

You should see a horizontal bar chart showing Conversions and Revenue side by side for each campaign type (Awareness, Consideration, Conversion).

Save your workbook by pressing Ctrl+S.

Chart looks empty or shows wrong data?

Make sure you clicked inside the correct PivotTable before inserting the chart. If you accidentally clicked into PivotTable1, the chart will show channel data instead of campaign type data.

Check that Campaign_Type is in the Rows area and both Conversions and Revenue are in the Values area of the PivotTable Fields pane.

help me fix my PivotChart that shows the wrong data

Your dashboard is taking shape with three distinct visual perspectives on your campaign data. Next up, you'll add Slicers and a Timeline that let you filter all these charts simultaneously with a single click.

Add Slicers and a Timeline for Interactivity

Your dashboard now has three PivotCharts that visualise campaign data from different angles. But right now, filtering data means manually adjusting each PivotTable separately.

In this step, you'll add Slicers and a Timeline that let you filter all three charts at once with a single click. This is what transforms static charts into a truly interactive dashboard.

In this step, get ready to:
  • Insert Slicers for Channel and Campaign Type.
  • Connect Slicers to all three PivotTables so they filter everything at once.
  • Add a Timeline for date-based filtering across all charts.
Insert slicers for Channel and Campaign Type

Slicers are visual filter buttons that display the unique values from a field as clickable options. You'll create two slicers that let anyone filter your dashboard without touching the PivotTable fields pane.

  • Click any cell inside your first PivotTable (the Channel/Revenue/Spend table) on your Dashboard sheet.
  • Go to the PivotTable Analyze tab in the ribbon.
  • Click Insert Slicer.
  • In the dialog that appears, check Channel and Campaign_Type.
  • Click OK.
  • Two slicer panels appear on your sheet. Drag them to the top-right area of the Dashboard sheet so they don't overlap your charts.

You should see two rectangular panels on your Dashboard. One shows channel names (Google Ads, Meta Ads, Email, LinkedIn). The other shows campaign types (Awareness, Consideration, Conversion).

What are Slicers?

Slicers display each unique value from a data field as a clickable button. When you click a button, the connected PivotTable filters instantly to show only that value's data.

They're the backbone of interactive Excel dashboards. Instead of digging through filter dropdowns, anyone viewing your dashboard can explore the data with one click.

Don't see the Insert Slicer option?

Make sure you clicked inside a PivotTable cell first. The PivotTable Analyze tab only appears when a PivotTable is selected. If you're clicking in a chart or a blank cell, the tab won't show.

Help me find the Insert Slicer option in Excel.

Connect slicers to all PivotTables

By default, a slicer only filters the PivotTable it was created from. Your dashboard has three PivotTables, so you need to connect each slicer to all three using Report Connections.

  • Click the Channel slicer to select it.
  • Go to the Slicer tab in the ribbon.
  • Click Report Connections.
  • In the dialog, check all three PivotTables so the slicer controls everything.
  • Click OK.
  • Now click the Campaign_Type slicer to select it.
  • Repeat the connection: go to Slicer tab > Report Connections, check all three PivotTables, and click OK.

Test your slicers. Click any channel name in the Channel slicer (like "Google Ads"). All three charts should update to show only Google Ads data. Click the clear filter icon in the slicer's top-right corner to remove the filter.

Why connect slicers manually?

Slicers are only auto-connected to the PivotTable they were created from. Without Report Connections, clicking "Google Ads" would filter one chart but leave the other two showing all channels.

Report Connections only works between PivotTables that share the same data source. Since all three of your PivotTables pull from the CampaignData table, they can all be connected to the same slicer.

Slicers not filtering all charts?

Make sure you checked all three PivotTables in Report Connections for BOTH slicers. If a PivotTable doesn't appear in the dialog, it may be using a different data source. All PivotTables must reference the same CampaignData table.

Help me troubleshoot my slicer connections.

Add a Timeline for date filtering

A Timeline works like a slicer but is designed specifically for date fields. It lets you filter by Years, Quarters, Months, or Days using a visual time slider.

  • Click any cell in PivotTable2 (the one that uses Start_Date in Rows).
  • Go to the PivotTable Analyze tab.
  • Click Insert Timeline.
  • In the dialog, select Start_Date and click OK.
  • Drag the Timeline to the top of the Dashboard sheet, above your charts.

Now connect the Timeline to all three PivotTables so it filters the entire dashboard.

  • Click the Timeline to select it.
  • Go to the Timeline tab (labelled Options in some Excel versions) in the ribbon.
  • Click Report Connections.
  • Check all three PivotTables and click OK.
  • In the upper-right corner of the Timeline control, click the dropdown and select Months.

Your Timeline should now display months. Click or drag across month labels to filter your data to a specific time range. All three charts update simultaneously.

What does a Timeline add over a regular Slicer?

A regular slicer would show each individual date as a separate button. A Timeline understands that dates are sequential and groups them into meaningful periods (Days, Months, Quarters, Years).

It also lets you select a continuous range by dragging, which is much faster than clicking individual dates one by one.

Timeline not appearing in the Insert options?

The Insert Timeline option only appears when you click inside a PivotTable that contains a date field. Make sure you clicked inside PivotTable2 (the one with Start_Date in Rows) before looking for the option.

Also confirm that the Start_Date column in your Data sheet is formatted as actual dates, not plain text. Excel needs to recognise the values as dates for the Timeline to work.

Help me get the Timeline working in my Excel dashboard.

Your dashboard is now fully interactive. Anyone can filter by channel, campaign type, and date range with a single click. Next up, you'll add KPI summary cards and conditional formatting to highlight performance at a glance.

Add KPI Cards and Conditional Formatting

Your dashboard now filters every chart in real time when you click a Slicer or drag the Timeline. That's powerful for exploration, but executives want instant answers without clicking anything.

KPI cards give stakeholders headline numbers at a glance. Conditional Formatting adds a traffic-light colour signal so underperforming campaigns jump off the screen without requiring any interaction.

In this step, get ready to:
  • Create 4 KPI summary cells with formulas that calculate Total Revenue, Total Spend, Average CTR, and Average ROI.
  • Apply conditional formatting rules that flag CTR and ROI performance with green, amber, and red fills.
  • Polish the dashboard layout by hiding gridlines, adding a title, and sizing charts to fit one screen.
Create KPI summary cells

Your dashboard currently starts with charts. You need a row of headline numbers above them so the most important metrics are visible the moment someone opens the file.

  • Switch to the Dashboard sheet if you are not already on it.
  • Move your charts and Slicers down so rows 1 through 3 are empty. Select all charts and slicers (click the first, then hold Ctrl and click each remaining item), then drag them down a few rows.
  • In cell B1, type the label Total Revenue.
  • In cell D1, type Total Spend.
  • In cell F1, type Average CTR.
  • In cell H1, type Average ROI.
  • Enter the KPI formulas in the cells directly below each label by typing the following into each cell:
B2: =SUM(CampaignData[Revenue])
D2: =SUM(CampaignData[Spend])
F2: =SUM(CampaignData[Clicks])/SUM(CampaignData[Impressions])
H2: =(SUM(CampaignData[Revenue])-SUM(CampaignData[Spend]))/SUM(CampaignData[Spend])

What do these formulas do?

Each formula uses a structured table reference (CampaignData[ColumnName]) to pull values directly from your data table. This means the formulas always include the full dataset, regardless of how your PivotTables are filtered.

  • Total Revenue sums every value in the Revenue column.
  • Total Spend sums every value in the Spend column.
  • Average CTR divides total clicks by total impressions to get the overall click-through rate.
  • Average ROI calculates return on investment: how much revenue each dollar of spend generated, minus the original dollar.
  • Format cells B2 and D2 as currency. Select both cells, then go to Home > Number Format dropdown > Currency.
  • Format cells F2 and H2 as percentages. Select both cells, then choose Percentage from the same dropdown.

You should now see a currency value in the Total Revenue and Total Spend cells, and a percentage in the Average CTR and Average ROI cells.

Seeing a #REF! or #NAME? error?

  • Make sure you spelled CampaignData exactly as you named your table in Step 1 (case-sensitive). You can check the table name by clicking any cell in the Data sheet and looking at the Table Design tab on the ribbon.
  • Check that column names inside the square brackets match your headers exactly, including underscores ([Revenue], not [revenue]).
  • If you see 0% for CTR or ROI, your data cells might be empty. Switch to the Data sheet and confirm that the Impressions, Clicks, and Revenue columns have numeric values.

Still stuck? Help me fix my KPI formula error in Excel.

Apply conditional formatting to flag performance

Raw percentages force the viewer to interpret whether a number is good or bad. Traffic-light colours remove that mental effort.

  • Click cell F2 (your Average CTR value).
  • Go to Home > Conditional Formatting > New Rule.
  • Select Format only cells that contain.
  • Set the first dropdown to Cell Value, the second dropdown to greater than or equal to, and type 0.03 in the value field.
  • Click Format, go to the Fill tab, select a green colour, and click OK twice.
  • Create a second rule on the same cell. Go to Home > Conditional Formatting > New Rule again.
  • Set the dropdown to between, type 0.01 in the first value field and 0.03 in the second.
  • Click Format, choose an amber or yellow fill, and click OK twice.
  • Create a third rule on the same cell. Set the dropdown to less than and type 0.01.
  • Click Format, choose a red fill, and click OK twice.

Why these threshold values?

The conditional formatting dialog works with the cell's underlying value, not the displayed text. Your CTR cell shows a percentage like 3%, but the underlying value is 0.03. A CTR of 3% or higher signals strong engagement, 1-3% is average, and below 1% needs attention.

  • Now click cell H2 (your Average ROI value) and repeat the process with these thresholds:
  • Green fill: Cell Value greater than or equal to 2 (this means 200% ROI or higher).
  • Amber fill: Cell Value between 0 and 2.
  • Red fill: Cell Value less than 0 (negative ROI means campaigns are losing money).

Your CTR cell and ROI cell should each show a coloured background that matches the current value. Green means healthy, amber means acceptable, red means action needed.

Not seeing any colour fill?

  • Open Home > Conditional Formatting > Manage Rules and make sure the rules are listed for the correct cell reference.
  • Check that your rules are in the correct priority order. The green rule (highest threshold) should be at the top of the list. If the "between" rule is first, it may match before the "greater than" rule gets a chance.
  • Confirm your cell is formatted as Percentage but that you typed the underlying decimal value (0.03, not 3) in the rule.

Need more help? Help me troubleshoot conditional formatting colours not appearing.

Polish the dashboard layout

A clean layout helps the viewer focus on the data instead of Excel's interface chrome.

  • Go to the View tab on the ribbon.
  • Uncheck Gridlines to hide the cell grid.
  • Uncheck Headings to hide the row numbers and column letters.
  • Select cell A1.
  • Type Marketing Campaign Dashboard and press Enter.
  • Select cell A1 again, then hold Shift and click cell I1 to select a range across the top.
  • Go to Home > Merge & Center to merge the cells into one wide title bar.
  • With the merged cell still selected, set the font size to 16 or 18 using the font size box on the Home tab.
  • Click the Bold button (or press Ctrl+B) to bold the title.
  • Resize your charts so they do not overlap each other or the Slicers. Click a chart edge and drag the corner handles to adjust.
  • Position the charts so the entire dashboard fits on one screen without scrolling.
  • Press Ctrl+S to save your workbook.

Your dashboard should now look like a polished report. The title sits at the top, KPI cards with colour coding sit below it, and the charts fill the remaining space without overlap.

Charts overlapping or off-screen?

  • Hold Alt while dragging a chart to snap it to cell borders for cleaner alignment.
  • If a chart is too large, click it once, then drag a corner handle inward. Avoid dragging the side handles because that stretches the chart without keeping its proportions.
  • Press Ctrl+End to jump to the last used cell. If it lands far below your charts, you may have stray data. Delete any empty rows below your content.

Still having layout issues? Help me arrange my Excel dashboard so everything fits on one screen.

Secret mission

Add a Budget vs. Spend Comparison and a Top/Bottom Campaigns View

Your dashboard shows the big picture, but stakeholders always ask two follow-up questions: Which campaigns overspent their budget? And which campaigns are our best and worst performers? In this bonus challenge, you'll build both views and connect them to your existing Slicers.

Clean Up Your Resources

Clean Up Your Resources

Decide whether to keep your resources running, pause them to come back later, or delete them entirely.

This project runs entirely locally in Excel, so there are no ongoing costs or cloud resources to worry about.

Resources you used:

  • MarketingDashboard.xlsx file (contains your Data sheet, Dashboard sheet, and any Deep Dive sheet).

Keep everything running

No action needed. Choose this if you're still actively building or want to revisit the dashboard later.

  • Your MarketingDashboard.xlsx file stays on your computer wherever you saved it.
  • You can reopen and edit it anytime in Excel.
  • There are no running processes or services to maintain.

Pause - I'll come back to this later

Since this is a local Excel file, pausing is the same as keeping. There are no running processes to stop.

  • Make sure you have saved your MarketingDashboard.xlsx file.
  • Note the folder location so you can find it when you come back.

Delete - I don't want to use this again

Remove all project files from your computer.

  • Close MarketingDashboard.xlsx if it is open in Excel.
  • Navigate to the folder where you saved the file.
  • Delete MarketingDashboard.xlsx by right-clicking the file and selecting Delete (Windows) or Move to Trash (macOS).
  • Empty your Recycle Bin (Windows) or Trash (macOS) to permanently remove the file.

Nice Work!

Nice Work!

Nice work! You have built a fully interactive marketing campaign dashboard in Excel from scratch.

You've learned how to:

  • Built a structured campaign dataset as a proper Excel Table with automatic expansion, then created multiple PivotTables and PivotCharts that update dynamically when filtered.
  • Connected Slicers and a Timeline to filter all charts simultaneously with one click.
  • Applied conditional formatting to create KPI traffic-light indicators that flag underperforming campaigns instantly.
  • Secret Mission: Added a Budget vs. Spend comparison chart and Top 5 / Bottom 5 campaign views for deeper analysis.

Ready to quiz yourself?