What Are Looker Studio Calculated Fields?

Looker Studio (formerly Google Data Studio) calculated fields let you create entirely new metrics and dimensions on the fly, directly within your reports. This powerful feature allows you to go beyond the standard fields your data source provides, enabling custom calculations, data cleaning, and deeper analysis. This article breaks down exactly what calculated fields are, why they're so valuable, and how to create them, complete with practical examples you can use today.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What is a Looker Studio Calculated Field?

Think of a calculated field as a formula in a spreadsheet cell - it takes existing data, applies some logic or a mathematical operation, and creates a new piece of information. The key difference is that this happens inside Looker Studio, not in your original data source like Google Sheets or Google Analytics.

You can create two types of calculated fields:

• Calculated Dimensions: These are fields that you use to group or categorize your data. They are typically text-based or date-based. For example, you might create a calculated dimension to group messy campaign names into clean, standardized categories like "Brand," "Non-Brand," and "Discovery."
• Calculated Metrics: These are fields that contain a number - a count or a measurement. They answer questions of "how much" or "how many." You’d create a calculated metric to find your eCommerce conversion rate, cost per click (CPC), or average order value.

The beauty of this is that it doesn’t alter or modify your original data set. It simply creates a new, virtual column within Looker Studio that you can use for your charts and tables, giving you incredible flexibility without needing developer or database admin help.

Why You Should Be Using Calculated Fields

Calculated fields are more than just a convenient tool, they fundamentally change how you can work with your data in Looker Studio. They bridge the gap between the raw data you have and the specific insights you need.

Enrich Your Data Without Changing the Source

Perhaps the most significant benefit is the ability to add new information without touching the original spreadsheet or database. Many marketers and analysts don’t have permission to edit primary data sources, or it’s simply too risky. Calculated fields provide a safe sandbox to create exactly what you need for your report - whether that’s a new KPI or a filtered dimension - all within the Looker Studio interface.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Create and Track Custom KPIs

Your data sources often provide foundational metrics like Sessions, Cost, and Conversions, but not the key performance indicators (KPIs) you actually track your business with. With calculated fields, you can easily create these essential metrics:

• Return on Ad Spend (ROAS): SUM(Revenue) / SUM(Cost)
• Conversion Rate: SUM(Conversions) / SUM(Sessions)
• Average Order Value (AOV): SUM(Revenue) / SUM(Transactions)

Standardize and Clean Up Messy Data

Data is rarely perfect. Campaign names can have inconsistencies (e.g., "FB," "facebook," "Facebook"), and source/medium data can be fragmented. Calculated fields, particularly with the CASE function, allow you to group a variety of different values under a single, clean label. This tidies up your reports and makes them far easier for stakeholders to understand.

Perform Quick Calculations and Analysis

Instead of exporting data to a spreadsheet to calculate a simple ratio or combine two text fields, you can do it instantly in Looker Studio. This keeps your analysis workflow fast and fluid, allowing you to answer follow-up questions from your data without ever leaving your dashboard.

How to Create a Calculated Field: A Step-by-Step Guide

You can add a calculated field in two main places: at the data source level or directly on a specific chart. The one you choose depends on how and where you plan to use the new field.

• At the Data Source Level: Add the field here if you want it to be available for any chart in your report that uses this data source. This is the best option for reusability. You need edit access to the data source to do this.
• At the Chart Level: Add the field here if you only need it for one specific chart or table. This is perfect for quick, one-off calculations and doesn't require "editor" access to the data source itself.

The process for both is nearly identical. For this example, we’ll create one at the data source level.

Step 1: Open Your Data Source Editor

In the Looker Studio menu, navigate to Resource > Manage added data sources. Find the data source you want to modify and click “Edit.”

Step 2: Add a New Field

In the top left of the data source view, you'll see a blue button that says “+ ADD A FIELD.” Click it.

Step 3: Build Your Formula

This opens the formula editor. Here's a quick walkthrough of the interface:

• Field Name: Give your new field a clear and descriptive name. Avoid generic names like "CalcField1." Instead, use names like "Cost Per Acquisition" or "Clean Campaign Grouping."
• Field ID: Looker Studio will generate this automatically from your field name. You can generally leave it as is.
• Formula Box: This is where you’ll type your formula. You can type the names of existing fields and functions, and an auto-complete list will pop up to help you.
• Available Fields List: On the right, you can see a list of all fields in your data source in case you forget a name. You can search this list and click a field to add it to your formula.

As you write your formula, Looker Studio will give you real-time feedback. If your formula is syntactically correct, you’ll see a green checkmark below the formula box. If there are errors, it will turn red and give you a hint about what’s wrong.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 4: Set the Data Type

After your formula is valid, one of the most important steps is to tell Looker Studio what kind of data your field contains. Go to the Type dropdown and select the correct option. A few common examples:

• For a conversion rate, choose Number > Percent.
• For an average cost, choose Number > Currency and select your currency.
• For a grouped text dimension, choose Text.

Don’t skip this! The data type settings control how your data is displayed and aggregated in charts.

Step 5: Save Your Field

Once you’re happy with the name, formula, and data type, click "Save" in the bottom right corner. Then, click “Done” in the top right to exit the data source editor. Your new calculated field will now be available in the data panel like any other field, ready to be dragged into your charts and tables.

5 Practical Examples of Calculated Fields

Theory is great, but let's see how these formulas work in the real world. Here are five examples you can adapt for your own reports.

1. Create Custom Channel Groupings with a CASE Statement

Go beyond GA4's default channel groups and create your own. This is extremely useful for combining paid and organic efforts or for grouping branded vs. non-branded campaigns. The CASE statement is perfect for this "if-then" logic.

CASE
  WHEN REGEXP_MATCH(Campaign, ".*Brand.*") THEN "Branded Search"
  WHEN REGEXP_MATCH(Campaign, ".*Non-Brand.*") AND REGEXP_MATCH(Source / Medium, "google / cpc") THEN "Non-Branded Search"
  WHEN REGEXP_MATCH(Source / Medium, "(?i)facebook|instagram") THEN "Paid Social"
  WHEN REGEXP_MATCH(Source / Medium, ".*organic.*") THEN "Organic"
  ELSE "Other"
END

2. Calculate a Session-to-Lead Conversion Rate

While some platforms provide conversion rates out of the box, you often need to calculate specific funnel rates. If you have "Sessions" and "Lead Form Submissions" (or another conversion event) as metrics, you can easily calculate their ratio.

SUM(Lead Form Submissions) / SUM(Sessions)

Remember to set the Type to Number > Percent for proper display.

3. Combine Fields for More Descriptive Labels

Sometimes a single dimension isn't descriptive enough. If you're analyzing ad performance, combining the campaign and ad set name can give you much more context in a table. The CONCAT function joins text fields together.

CONCAT(Campaign, " > ", Ad Set)

This will create a new dimension that looks like this: "Fall Sale Campaign > Dog Owners US," which is far more readable in a report.

Graphed

Still Building Reports Manually?

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

Watch the Demo

4. Capitalize Inconsistent Text Fields

Event names, city names, or any user-inputted data might come through with inconsistent capitalization (e.g., "new york," "New York," "NEW YORK"). Use the UPPER or LOWER function to standardize them for cleaner grouping.

UPPER(City)

Now all entries will be treated as "NEW YORK," allowing you to aggregate them correctly.

5. Calculate Time Between Dates

Need to know the average time it takes for a lead to become a customer? If you have fields for "Lead Creation Date" and "First Purchase Date," you can use DATETIME_DIFF to calculate the duration.

DATETIME_DIFF(First Purchase Date, Lead Creation Date, DAY)

This calculates the difference in days. You can also use "WEEK," "MONTH," or "YEAR" to change the unit of time returned.

Final Thoughts

Calculated fields are an essential skill for anyone serious about building meaningful dashboards in Looker Studio. They unlock a level of customization that allows you to move from simply showing data to creating tailored insights that drive business decisions. By mastering a few key functions like CASE, SUM, and CONCAT, you can transform generic reports into powerful, purpose-built analytical tools.

Even with helpful features like calculated fields, building detailed reports by combining data from different marketing and sales platforms can be a manual, time-consuming process. We built Graphed because we believe getting answers from your data shouldn't require learning formula syntax or spending hours configuring charts. Graphed is an AI data analyst that connects to all your platforms - like Google Analytics, Facebook Ads, Shopify, and Salesforce - and lets you build dashboards and reports using simple, natural language. Instead of writing formulas, you can just ask, "Show me my return on ad spend by campaign for the last 30 days," and get an interactive dashboard instantly, giving you back hours of your week.