How to Create a Pivot Table in Looker Studio

If you're trying to analyze data with multiple variables, a standard table in a report can quickly become cluttered and hard to read. Pivot tables solve this problem by summarizing large datasets into a condensed, multi-dimensional view, making it much easier to spot trends and compare performance across different segments. This tutorial will walk you through exactly how to create and customize a powerful pivot table right inside Looker Studio (formerly Google Data Studio).

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly is a Pivot Table in Looker Studio?

A pivot table is a data summarization tool that lets you reorganize and group data by rotating, or "pivoting," its dimensions in a table format. Think of it as a smart, interactive grid where your rows and columns can represent different categories from your dataset, and the cells show a calculated metric.

Unlike a standard table that just lists rows of data, a pivot table creates a cross-tabulation. For example, instead of a long list showing sales for every city, you could use a pivot table with Region as your rows and Product Category as your columns to quickly see the total sales for each category within each region.

Here’s why they’re so valuable:

• Summarize Complex Data: They condense thousands of rows into a clear, concise summary.
• Find Hidden Patterns: By cross-referencing two different variables (dimensions), you can uncover relationships you might otherwise miss. Are mobile users buying more of a certain product? Do specific ad campaigns perform better in certain countries? Pivot tables make these insights obvious.
• Interactive Analysis: In Looker Studio, your pivot tables are interactive, allowing for easy sorting, filtering, and drilling down into the data without having to rebuild the chart.

Preparing Your Data for a Pivot Table

Before you build your chart, it’s important to make sure your data source is structured correctly. Pivot tables work best with "tidy data," which means your data is organized in a simple tabular format where:

• Each row is a single observation (e.g., one sale, one website session).
• Each column is a specific variable (e.g., Date, Country, Revenue).

Looker Studio also needs to understand the type of data in each column. The two main types you'll use are:

• Dimensions: These are your categorical or descriptive fields. They are the things you want to group or pivot by, such as Campaign Name, Country, Device Category, or Product SKU.
• Metrics: These are your numerical, quantifiable fields that you can calculate. Think of things like Revenue, Sessions, Clicks, or Conversions.

If you’ve connected a standard data source like Google Analytics or Shopify, Looker Studio usually auto-detects these fields correctly. If you are using a Google Sheet, make sure your dimensions are formatted as text or dates and your metrics as numbers or currency.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Create a Pivot Table in Looker Studio: Step-by-Step

Let's build a pivot table that shows a breakdown of website sessions by both Country and Device Category, using data from a Google Analytics 4 property.

Step 1: Add a Pivot Table to Your Report

First, open a new or existing report in Looker Studio. From the main menu, navigate to Insert > Pivot Table. You can choose from two default styles: a standard pivot table or one with a pre-applied heatmap.

Click on the canvas where you want to place it. Looker Studio will add a placeholder pivot table, likely with some default dimensions and metrics from your chosen data source.

Step 2: Define Your Row and Column Dimensions

With the new pivot table selected, the Properties panel will appear on the right side of your screen. This is where you will configure everything. Under the "Setup" tab, you'll see sections for Row Dimension, Column Dimension, and Metric.

This is the core of the pivot table logic:

• Row Dimension: This field will define the vertical rows of your table. Items in this category will be listed down the left side.
• Column Dimension: This field will define the columns that run horizontally across the top of your table.

For our example, let's see which countries are driving traffic. Drag the Country field from the "Available Fields" list into the Row Dimension section. Then, to get a device breakdown, drag the Device Category field into the Column Dimension section.

Pro Tip: You can add both sub-dimensions to your rows and columns to create more granular views. For example, you could put Region and then City under the Row Dimension to see a hierarchical breakdown.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Add Your Metrics

Metrics are the numbers that will populate the cells where your rows and columns intersect. The pivot table needs a metric to summarize for each combination of dimensions.

In our example, we want to see the number of sessions.

Find the Sessions metric in your field list and drag it into the Metric section. Immediately, the pivot table on your canvas updates to show the total sessions for each country, broken down by desktop, mobile, and tablet users.

You can add multiple metrics if you like. For instance, you could also drag in Total Users or Engaged Sessions to see them alongside the session count.

Step 4: Configure Totals and Sorting

Pivot tables automatically calculate subtotals and a grand total, which is one of their most useful features.

In the "Setup" panel, scroll down to the customization checkboxes:

• Row Totals: Checked by default. This shows a "Grand Total" column at the end, summing up the metrics across all columns for each row.
• Column Totals: Also checked by default. This adds a "Grand Total" row at the bottom, summing the metrics in each column.

You can also control the sorting order here. By default, it might be sorted alphabetically by your row dimension. Click on "Row #1" sorting option and change it to the Sessions metric and select "Descending" to see your top-trafficked countries at the top of the table.

Step 5: Styling Your Pivot Table for Readability

A little bit of styling goes a long way. Click over to the Style tab in the Properties panel. Here, you can make your pivot table much easier to read at a glance:

• Apply a Heatmap: Under the "Table Colors" section, you can add conditional formatting. The easiest is a heatmap, which colors the background of metric cells based on their value. This instantly highlights high-performing and low-performing combinations.
• Adjust Fonts and Headers: You can change the font size, color, and background of both the headers and the table body to match your report's branding.
• Format Numbers: Under the primary metric's settings in the "Style" tab, you can change the number format. For example, if you were using Revenue as a metric, you could change the type to "Currency" and select your currency symbol.

Example Pivot Table Use Cases for Marketers

Now that you know how to build one, what are some practical ways to use pivot tables in your marketing reports?

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

1. Campaign Performance by Channel

Want to see if Facebook outperforms Google or if organic social is driving more conversions than email?

• Row Dimension: Campaign Name
• Column Dimension: Session Default Channel Group
• Metric: Conversions and Cost Per Conversion

This report quickly tells you which channels are most effective for each of your specific campaigns.

2. E-commerce Product Performance

Curious about which products are selling in which regions?

• Row Dimension: Item Name
• Column Dimension: Region
• Metric: Item Revenue

This helps you identify hot products in specific markets, guiding your inventory and advertising strategies.

3. SEO Keyword Performance Across Different Device Categories

Let’s say you wanted to understand which keywords are top performers based on whether a customer is browsing on mobile or desktop.

• Row Dimension: Search Term/Query
• Column Dimension: Device Category
• Metric: Impressions, Clicks

This view could easily show you that you're getting all your impressions from people who are researching products on mobile before buying later on a desktop.

Final Thoughts

As you’ve just learned, a pivot table is much easier to use in Looker Studio than most people think. Not only do they provide your stakeholders with clearer insights, but you also get quicker, more sophisticated reports rather than relying on cluttered data tables. By swapping your rows with columns, you now unlock a deeper understanding behind the performance trends powering your business.

But even after you become proficient, manually integrating your data sources like Salesforce or Facebook's Ads can be a challenge. That's why we built Graphed. With our tool, all our customers have to do is describe the report they need - "show revenue growth month by month" - and it creates all real-time dashboards for you, so you can make confident, data-backed decisions.