What is a Parameter in Looker Studio?

Parameters in Looker Studio are a powerful feature that can transform your static reports into dynamic, interactive dashboards. They put control directly into the hands of your audience, allowing them to explore data and conduct their own “what-if” analysis. This article breaks down what parameters are, walks through practical examples of when to use them, and gives you a step-by-step guide to setting them up.

Graphed

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.

Build Your First Agent

What Exactly Is a Parameter in Looker Studio?

Think of a parameter as a reusable container for a value that a report viewer can change. It doesn't come directly from your data source like a metric or dimension does. Instead, it’s a variable that you create, and its value is determined by user input. This input can then be used inside calculated fields, giving you a way to create flexible and interactive charts and tables.

At first glance, parameters might sound similar to filters. But they serve a very different purpose:

• A Filter shows or hides data that already exists. For example, a filter on “Country” lets you select "United States" to see only the rows where the country is the United States. You are simply narrowing down the existing dataset.
• A Parameter provides a value that can be used in a calculation. For example, a "Sales Tax Rate" parameter could hold a value like 8%, which you can then use in a calculated field like Price * Sales_Tax_Rate to dynamically calculate the tax amount based on what the user inputs. The original data source doesn't have a "sales tax" field - you're creating it on the fly with the parameter.

In short, filters help you see a slice of your existing data, while parameters let you model new possibilities and explore hypothetical scenarios with your data.

Why Are Parameters Useful? Practical Use Cases

Parameters open up a world of interactivity. They're not just a technical feature, they solve real-world reporting challenges by letting stakeholders answer their own follow-up questions without needing you to create dozens of variations of the same report.

AI Agents for Marketing

Crash Course

Graphed

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.

Download the PDF

Create 'What-If' Scenarios

One of the most valuable applications for parameters is for "what-if" analysis. This is perfect for forecasting, budget planning, or setting performance goals.

Example: Forecasting Future Sales

Imagine you have a report showing your current monthly sales figures. A stakeholder asks, "What would our projected annual revenue look like if we grow by 5%, 10%, or 15% next year?" Instead of creating three separate charts, you can build one interactive chart using a parameter.

1. Create a numerical parameter called "Projected Growth Rate %" that users can adjust, perhaps using a slider from 0 to 50.
2. Create a calculated field called "Projected Sales" with the formula: Total Sales * (1 + (Projected Growth Rate % / 100)).
3. Display both "Total Sales" and "Projected Sales" on a chart.

Now, when your manager or client moves the slider, the "Projected Sales" metric will update instantly, allowing them to visualize different growth scenarios in real time.

Set Dynamic Goals and KPIs

Performance tracking is rarely static. Sales targets, marketing goals, and operational KPIs often change. Parameters let you build dashboards where goals can be adjusted directly on the report.

Example: Tracking Progress Against a Monthly Target

Let's say a sales manager wants a dashboard to track their team's progress toward a monthly revenue target of $50,000. But what happens next month when the target is $55,000? Instead of editing the report every month, you can use a parameter.

1. Create a parameter called "Monthly Revenue Target" and set its default value to 50000. Use an input box control so the manager can type in a new number.
2. Create a scorecard to show current SUM(Revenue).
3. Create a bullet chart or gauge that visualizes SUM(Revenue) against the Monthly Revenue Target parameter. You can even create a calculated field like (SUM(Revenue) / Monthly Revenue Target) to show the percentage of the goal achieved.

This empowers the sales manager to update their own targets each month right on the dashboard, making the report a long-term, self-service tool.

Give Users Control Over Calculations

Sometimes, the logic within a calculated field needs to be flexible. Whether it's a commission rate, a shipping fee, or an assumed conversion rate, parameters can make these variables user-configurable.

Example: Calculating Customer Lifetime Value (LTV)

Calculating LTV often involves making assumptions about the customer's average lifespan or profit margin. These assumptions might be debated or need adjustment. You can use parameters to make them transparent and adjustable.

1. Create separate parameters like "Average Customer Lifespan (Months)" and "Average Profit Margin %".
2. Create a calculated field for your LTV formula that reference these parameters, such as Avg. Monthly Spend * Average Profit Margin % * Average Customer Lifespan (Months).

This allows your finance or strategy teams to model how changes in profit margin or customer retention would impact the overall LTV, fostering a deeper, more data-driven conversation.

Graphed

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.

Build Your First Agent

Enable Advanced Grouping and Filtering

You can use parameters with CASE statements to create dynamic segments or groups in your data that users can define themselves.

Example: Dynamic Customer Segmentation

You want to classify customers as "Small," "Medium," or "Large" based on their total purchase value, but the threshold for each category might change. A parameter can define these thresholds.

1. Create a parameter named "Medium Spender Threshold" with a default of $500.
2. Create a second one named "Large Spender Threshold" with a default of $2,000.
3. Create a new calculated dimension using a CASE statement:

CASE WHEN Total Sales < Medium Spender Threshold THEN "Small Spender" WHEN Total Sales >= Medium Spender Threshold AND Total Sales < Large Spender Threshold THEN "Medium Spender" WHEN Total Sales >= Large Spender Threshold THEN "Large Spender" ELSE "Other" END

Now, a marketing analyst can adjust the thresholds directly on the dashboard to see how many customers fall into each category, helping them better target their campaigns.

Step-by-Step Guide: How to Create a Parameter

Ready to build your first parameter? Let's walk through creating a "Sales Commission Rate" parameter to calculate potential commissions for a sales team.

Step 1: Add a New Parameter

From your report's edit mode, look at the Data panel on the right side of your screen. At the very bottom, below all your dimensions and metrics, click "Add a parameter." This will open the parameter creation panel at the bottom of the data panel.

Step 2: Configure the Parameter Settings

Now it's time to define how your parameter works. You'll see several configuration options:

• Parameter name: This is the user-friendly name that will appear in your data source fields. Let's call it Sales Commission Rate.
• Parameter ID: This is a unique identifier used to reference the parameter in formulas. Looker Studio automatically suggests one, and it's best to stick with it unless you have a good reason to change it.
• Data type: Choose what kind of data the parameter will hold (e.g., Number, Text, Boolean). For a commission rate, select Number (Decimal).
• Permitted values: This determines what users can input.
• Range values: Set the minimum to 0 and the maximum to 0.20 (for 0% to 20%).
• Default value: This is the value a parameter will have when the report is first loaded. Let's set it to 0.05 (5%).

AI Agents for Marketing

Crash Course

Graphed

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.

Download the PDF

Step 3: Make the Parameter Interactive for Users

The parameter now exists in your data source, but your users can't interact with it yet. You need to add a control to your report canvas.

1. In the top toolbar, go to Add a control.
2. Because we used a range, a Slider is the perfect control type. Select it and place it on your report canvas.
3. With the slider selected, look at its Setup panel on the right. In the "Control field" data box, remove the existing dimension and add the Sales Commission Rate parameter you just created.

Voila! The slider is now linked to your parameter. When a user moves it, the parameter's value updates.

Step 4: Use the Parameter in a Calculated Field

This is where the magic happens. A parameter on its own does nothing - you have to use it in a calculation. Let's create a "Total Commission" metric.

1. You can add a chart, like a table, and add a calculated field directly to it, or you can add one to the data source. Let's use a Table chart.
2. In your chart's Setup panel, click Add metric and then Create field.
3. Give your new field a name, like "Projected Commission."
4. In the formula box, write: SUM(Sales) * Sales Commission Rate. Looker Studio's auto-complete will help find your parameter ID.
5. Click Apply.

Your table will now have a "Projected Commission" column. As you adjust the slider you placed on the report, you'll see the commission values update in real-time, instantly reflecting your what-if calculation.

Final Thoughts

Parameters are your secret weapon for making Looker Studio reports truly valuable for your team or clients. By moving beyond static charts and giving users control to ask their own questions, you empower them to explore the data in a way that feels intuitive, leading to better insights and smarter decisions.

Ultimately, the goal of a great report is to make it easy to get answers. At Graphed we feel that building these complex, interactive reports shouldn't keep you from getting the insights you need. That's why we're building a new way to analyze your data where all you have to do is connect your data sources — like GA4, Shopify, or Facebook Ads — and ask questions in plain English. Instead of building parameters and calculated fields for hours, you can simply ask, "What was our top performing ad campaign last month?" or "Create a dashboard showing our sales pipeline from HubSpot this quarter" and get beautiful, live-updating dashboards in seconds.