Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Create a Website Dashboard in Tableau

Cody Schneider••8 min read

Building a custom website dashboard in Tableau unlocks insights that are often hidden in the standard reports of Google Analytics. This guide will walk you through connecting your website data and building an interactive dashboard from scratch. We’ll cover everything from linking Google Analytics to creating essential charts that reveal your true website performance.

GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

Why Bother Building a Website Dashboard in Tableau?

You might be wondering, "Why not just use the reports inside Google Analytics?" While GA is powerful, its standard reports can be rigid. A Tableau dashboard offers three distinct advantages:

  • Complete Customization: You are in control. You decide which metrics matter most and how they are displayed, free from the constraints of GA's pre-built reports. You can focus on KPIs like leads, sales, or sign-ups, not just traffic volume.
  • Data Blending: This is Tableau's superpower. You can connect your website data to other crucial business data. For example, you can blend Google Analytics data with your Salesforce data to see which marketing channels generate the most valuable leads, or connect it to Shopify to see the entire path from ad click to purchase.
  • Interactivity and Exploration: A well-built Tableau dashboard is an analysis tool, not just a static report. You can create dynamic filters that let you drill down into a specific campaign, time period, or traffic source, allowing anyone on your team to answer their own questions without needing to be an analytics expert.

Getting Your Data into Tableau

Before you can build an amazing dashboard, you need to connect to your data source. Luckily, Tableau has a native connector for Google Analytics that makes this process straightforward.

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Step 1: Connect to Google Analytics

First, open Tableau Desktop and in the 'Connect' pane on the left, find the option 'To a Server' and select 'Google Analytics'.

You'll be prompted to sign in with your Google account. This process uses OAuth, which is a secure way to grant Tableau access to your Google Analytics data without sharing your password. Once you've authenticated, Tableau will present you with a configuration window to select:

  1. Account: Choose the primary GA account that holds your website data.
  2. Property: Select the specific website property (e.g., yourawesomewebsite.com).
  3. View: Choose the reporting view you want to analyze. Most businesses use an 'All Website Data' or 'Master' view.

Next, you’ll select the dimensions and measures you want to import. Don't worry about getting everything perfectly right at this stage, you can always go back and edit the connection later. Here are some essential fields to start with:

  • Dimensions: Date, Source / Medium, Campaign, Device Category, Country.
  • Measures: Users, Sessions, Pageviews, Bounces, Session Duration, Goal Completions.

Finally, click 'Connect', and Tableau will pull your website data into a new workbook, ready for you to start building.

Step 2: A Quick Look at Key Website Metrics

When you start looking at your data in Tableau, it helps to be clear on what a few key metrics mean:

  • Users vs. Sessions: A 'User' is an individual person who visits your site. A 'Session' is a single visit by that user. One user can have multiple sessions.
  • Source / Medium: This dimension is crucial for understanding where your traffic comes from. For example, 'google / organic' is traffic from Google search, while 'facebook.com / referral' is traffic from a link on Facebook.
  • Goal Completions & Conversion Rate: Before you begin, you should have goals (like form submissions or purchases) configured in Google Analytics. 'Goal Completions' is the raw count of these events, and 'Conversion Rate' tells you the percentage of sessions that resulted in a conversion. This metric ultimately shows if your traffic is effective.

Building Your Website Dashboard, One Chart at a Time

The best dashboards are composed of several well-designed charts, or "worksheets" in Tableau lingo. We’ll build a few essential components separately and then combine them into an interactive dashboard.

GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

Worksheet 1: The KPI Scorecard

Every dashboard needs the headline numbers right at the top. Let's create large summary text for Total Users, Sessions, and Conversions.

  1. Create a new worksheet and name it "Total Users."
  2. From your list of Measures, drag Users onto the 'Text' card in the Marks pane.
  3. Click on the 'Text' card to open the editor. Label the text by typing "Total Users" above the SUM(Users) placeholder and format it to be large and bold.
  4. Repeat these steps on new worksheets for "Total Sessions" and "Goal Completions." A separate sheet for each KPI gives you more control over formatting on the final dashboard.

Worksheet 2: Traffic Trend Over Time

Next, you need to see how your website traffic performs over time. A line chart is perfect for this.

  1. Create a new worksheet called "Sessions Over Time."
  2. Drag the Date dimension to the 'Columns' shelf. Right-click it and choose 'Week Number' or 'Month' for a smoother trend line. You can also leave it as 'Day' for more granular detail.
  3. Drag the Sessions measure to the 'Rows' shelf.
  4. Pro Tip: Drag the Source / Medium dimension to the 'Color' card. This breaks the single line into multiple colored lines, instantly showing you a performance comparison between your different traffic channels over time.

Worksheet 3: Top Traffic Channels

This worksheet answers the all-important question: "Where is my traffic actually coming from?" We'll use a simple bar chart.

  1. Create a worksheet named "Traffic by Channel."
  2. Drag Source / Medium to the 'Rows' shelf.
  3. Drag Sessions to the 'Columns' shelf. Tableau will generate a horizontal bar chart.
  4. Click the 'Sort' icon in the toolbar to automatically arrange your channels from most to least traffic.
  5. Go deeper: Raw traffic is good, but converting traffic is better. Drag Goal Conversion Rate to the 'Color' card. Now, your bars will be color-coded based on their conversion performance, helping you spot high-value sources that might have less volume.

Worksheet 4: Geographic Performance Map

Tableau makes creating geographic maps incredibly easy, which is great for understanding your global or national audience.

  1. Create a worksheet called "Users by Country."
  2. Tableau should automatically identify Country as a geographic field. Simply double-click it. Tableau will create a map and place dots on each country with data.
  3. Drag the Users measure onto both the 'Size' and 'Color' cards. Now, countries with more users will have larger and darker circles, making hot spots immediately visible.

Putting It All Together: Your Interactive Dashboard

Now that you have your individual worksheets, it's time to assemble them into a cohesive dashboard.

Step 1: Arrange Your Worksheets

Click the 'New Dashboard' icon at the bottom of the screen. You'll see a blank canvas and a list of your worksheets on the left.

  1. Drag a 'Horizontal' layout container to the top of your canvas. Into this container, drag your three KPI worksheets ("Total Users," "Total Sessions," and "Goal Completions"). This keeps them neatly aligned.
  2. Underneath the KPIs, drag your "Sessions Over Time" line chart. It should snap into place.
  3. Below the line chart, drag another 'Horizontal' container. Place your "Traffic by Channel" bar chart and "Users by Country" map side-by-side within this container.

Resize the elements as needed to create a clean, balanced layout.

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Step 2: Add Interactivity

This is where your dashboard goes from a static chart collection to a dynamic analysis tool.

  • Global Date Filter: Click on your "Sessions Over Time" chart on the dashboard. Click the small dropdown arrow on its border, go to 'Filters', and select your 'Date' filter. Now, go back to that filter's dropdown on the dashboard and select 'Apply to Worksheets' > 'All Using This Data Source'. Now, changing the date on this one filter will update every single chart on your dashboard.
  • Use as a Filter: Click on your "Traffic by Channel" bar chart. You'll see a small funnel icon in the upper-right corner that says 'Use as Filter'. Click it. Now, if you click on the bar for 'google / organic' in that chart, all the other charts on the dashboard - the KPIs, the trendline, the map - will instantly filter to show data only from organic Google traffic. This is a game-changer for quick, deep-dive analysis.

Final Thoughts

Building a website dashboard in Tableau gives you the freedom to analyze your website's performance in a way that aligns directly with your business goals. By connecting to your data, building customized charts, and combining them into an interactive display, you can uncover actionable insights that are nearly impossible to find in standard one-size-fits-all reports.

While mastering a tool like Tableau is an incredibly powerful skill, it requires a significant up-front investment in time and manual effort. For teams that need to move faster, we created Graphed. Our platform automates the entire process: connect your sources like Google Analytics, Shopify, or Facebook Ads in just a few clicks, then create entire dashboards by simply describing what you want in plain conversational language. Instead of spending hours learning to build charts and arrange layouts, you can get stunning, real-time dashboards in seconds, freeing you up to focus on the insights rather than the setup.

Related Articles