How to Create a Digital Marketing Dashboard in Tableau
Creating a single dashboard to track all your marketing efforts can feel like a huge challenge, but it's one of the best ways to understand what's actually working. This guide walks you through the process of building a powerful digital marketing dashboard in Tableau, from planning your layout to connecting your data and visualizing your key metrics.
First, Why Build a Marketing Dashboard in Tableau?
Your marketing data is probably scattered across a dozen different platforms: Google Analytics for website traffic, Google and Facebook for ad performance, Shopify for sales, HubSpot for leads, and so on. A Tableau dashboard pulls all this disconnected data into one place, giving you a single source of truth for your performance.
This centralized view helps you:
Track KPIs in Real-Time: Stop waiting for weekly reports. See how your campaigns are performing right now and make faster, smarter decisions.
Spot Trends and Opportunities: Quickly identify which channels are driving the most value and which ones are underperforming. Is that new campaign actually driving sales, or just clicks?
Tell a Cohesive Story: Connect the dots between different marketing stages. See how a visitor from a Facebook ad eventually becomes a lead in Salesforce and a customer in Shopify.
Building a dashboard forces you to think critically about what metrics truly matter, turning raw data into actionable insights for growing your business.
Step 1: Plan Your Dashboard Before You Build Anything
Jumping straight into Tableau without a plan is a recipe for a cluttered, confusing dashboard. Great dashboards are carefully planned and designed to answer specific questions. A few minutes of planning will save you hours of rebuilding later.
Define Your Goals and Audience
Who is this dashboard for, and what do they need to know? A dashboard for a C-suite executive will look very different from one for a paid media specialist.
For an executive: Focus on high-level, business-impact metrics. They want a bird's-eye view. Think overall Return on Ad Spend (ROAS), Customer Acquisition Cost (CAC), and contributed revenue by channel.
For a marketing manager: They need more detail to manage the team and budget. Include things like performance by channel, campaign-level results, and progress toward monthly goals.
For a channel specialist (e.g., PPC Manager): They need granular data to optimize specific campaigns. Include metrics like click-through rate (CTR), cost per click (CPC), and conversion rates for individual ad sets or keywords.
Identify Your Key Performance Indicators (KPIs)
Once you know your audience, list the KPIs they care about most. Don't try to track everything, focus on the metrics that directly reflect your marketing objectives.
Here are some examples:
Overall Traffic: Website sessions, new vs. returning users, bounce rate.
Paid Media (Google & Facebook Ads): Spend, impressions, clicks, CTR, CPL (cost per lead), conversions, ROAS.
Organic Search (SEO): Organic sessions, top landing pages, keyword rankings (data often from a separate tool like SEMrush or Ahrefs).
E-commerce (Shopify): Revenue, transactions, average order value (AOV), conversion rate.
Lead Generation (Salesforce/HubSpot): Leads, marketing qualified leads (MQLs), MQL-to-customer conversion rate, cost per lead.
Sketch a Quick Wireframe
You don't need fancy design software. Just grab a pen and paper (or a simple tool like a whiteboard online) and sketch a rough layout. This helps you think about visual hierarchy and data flow.
Top-Left Corner is Prime Real Estate: Put your most important summary KPIs here, like total spend, total revenue, and overall ROAS. People naturally look here first.
Use a Logical Flow: Arrange your charts to tell a story. Start with a high-level overview, then drill down into channel performance, and finally show campaign-level details.
Choose the Right Chart Types:
Line charts are excellent for tracking trends over time.
Bar charts are perfect for comparing performance across categories (like channels or campaigns).
Big Number (KPI) cards are great for high-level summary metrics.
Tables are useful for displaying granular, detailed information like individual campaign performance.
The important idea for this step is that now you know what your "finish line" looks like so you have a visual goal for completion that is truly effective for what your company is trying to achieve.
Step 2: Connect to Your Marketing Data Sources
With your plan in hand, it's time to get your data into Tableau. Marketers typically have two main paths for this: native connectors or spreadsheet-based workarounds.
Using Tableau's Built-In Connectors
Tableau offers native connectors for many popular marketing platforms, making it relatively straightforward to pull in your data. In Tableau Desktop, you’ll find these under the "Connect -> To a Server" menu.
Popular connectors for marketing include:
Google Analytics: Perfect for website traffic and behavior data.
Google Ads: For your paid search campaign performance.
Google Drive/Sheets: Invaluable when other platforms don't have a direct connector.
Salesforce: Essential for connecting marketing efforts to sales pipeline data.
The process usually involves an easy and secure authentication process (OAuth), where you'll sign in to your marketing app - similar to creating an account on a regular website - to grant Tableau permission to access its data.
When There's No Direct Connector: The CSV/Spreadsheet Method
What about data from Facebook Ads, TikTok Ads, or your email platform? Many apps don't have a native Tableau connector. For these, the tried-and-true method is to download your data as a CSV and connect to it through Google Sheets or Excel.
The workflow looks like this:
Export a Report: Go into the ad platform (e.g., Facebook Ads Manager) and create a report with the metrics you need (spend, clicks, conversions) for your desired time frame. Be sure to select "Campaign name" as a dimension.
Download as CSV: Export that report.
Upload to Google Sheets: Upload the CSV files into a Google Sheets folder. This allows Tableau to access the data from a live connection rather than a static disconnected and local file on your computer.
Connect in Tableau: Connect Tableau to the corresponding Google Sheet.
This method is tedious and requires you to manually refresh the export and upload regularly, but it works when a direct connection isn't available. Consistency is key here, make sure your column names and report formats are identical each time you export.
Step 3: Building the Visualizations (Worksheets)
In Tableau, you build individual charts on 'Worksheets' and then assemble them on a 'Dashboard.' Let’s create a few essential charts for our digital marketing dashboard.
Worksheet 1: High-Level KPI Cards
These big numbers give you an at-a-glance view of performance.
Open a new Worksheet.
From your Google Ads data source, drag the "Spend" measure onto the "Text" card in the Marks pane.
Right-click the Text icon on the "Marks" card and edit the font to make it feel big and important.
Drag the "Clicks" field as another measure on a separate sheet just like we did with Spend to create a Clicks card. Do this as many times as feels necessary to complete your original sketch from the first step.
Format the text to a larger font and center it. Label the sheet "Spend", "Clicks", etc. accordingly.
Let's make three - one for Total Spend, one for Total Clicks, and one for Total Revenue if we are trying to do e-commerce. You can then do a simple calculated field to figure out our CPA by taking the total spend and dividing that by clicks. Easy!
Worksheet 2: Spend by Channel Bar Chart
This visual helps you see how your budget is allocated.
Start another new Worksheet.
Let’s say you’ve combined your data sources. Drag your 'Channel name' dimension to the "Columns" shelf.
Drag the "Spend" variable to the "Rows" shelf. Tableau will generate a bar chart. Now you can analyze which source of traffic has the best metrics and double down on what is working well.
Drag 'Spend' again, but this time to the "Color" card on the Marks pane. Edit the colors so smaller amounts of spend are red, going to a dark green for the most spend traffic sources.
Name the worksheet "Spend by Channel."
Worksheet 3: Revenue Trend Line Chart
A time-series chart is essential for tracking progress.
Open a new Worksheet.
From your primary transaction data source (like Shopify or Google Analytics), drag the 'Date' dimension to "Columns”. Right-click on it and choose "Month" or "Week" to set the granularity.
Drag the Revenue and Spend onto the "Rows" shelf and right-click it, make sure to select dual axes from the dropdown menu. Now Revenue overlays right on top of your Spend so things can be put into context. Tableau will change that measure into a continuous line chart, which is exactly what we're going for in this example.
Label this worksheet "Revenue vs. Spend Over Time."
Step 4: Assembling and Adding Interactivity to Your Dashboard
Now, let's combine your worksheets into a single, cohesive view.
Click the new Dashboard button on the bottom menu bar which shows a grid icon.
From the list of sheets on the left, let's drag your KPI cards onto the dashboard canvas at the top.
Drag the 'Spend by Channel' chart below your header of KPI big numbers that we created.
Drag "Revenue vs. Spend Over Time" next to or below that so that all sheets populate on a single screen without having to scroll. Tableau is like a free-form Tetris puzzle. We can play until everything is perfect!
The best part of Tableau is "interactivity" - a fancy way of describing "filtering". Select a sheet (like the bar chart) and click the small "Use as Filter" funnel icon in the upper-right area of our floating controls. Doing this will allow you, and anyone you share the dashboard with, to click any of the dimensions and have our numbers dynamically change based on selection without needing to know a single thing that's going on on the "backend" we just built from the previous steps.
Final Thoughts
Building a digital marketing dashboard in Tableau takes planning and patience, but it's an incredibly powerful way to centralize your data and unlock actionable insights. The key is to start simple by focusing on your goals, connecting a few key data sources, building basic charts, and then assembling them into a clean, interactive dashboard.
While Tableau is an amazing tool for those who have the time to learn it, we know the setup can be a major hurdle. The process of exporting CSVs, managing data connections, and figuring out the right charts can feel like a full-time job. At Graphed, we've automated this entire process. You simply connect your marketing and sales platforms and create live-updating dashboards by simply describing what you want your report to do in plain English in the same amount of time it would take to read this brief paragraph. If you want results in seconds instead of hours, give Graphed a try and let our AI analyst do all the busy work for you so you can have more time back to actually work on what's driving business results.