Google Data Studio Parameters explained with examples

Last Updated: June 3, 2022

What are Google Data Studio parameters?

Parameters provide user-supplied data to calculated fields and connectors in Google Data Studio reports.

Parameters allow you to interact with user-provided data. For example, you can create calculated fields that include input from your report users. Using parameters makes your reports more interactive since they update in real-time.

You can also use parameters to create report templates.

Parameters are similar to variables in programming languages and are used to pass user-defined dynamic values to the reports.

You can use parameters in the following ways:

  1. In calculated fields to display the results based on user-defined inputs.
  2. Send custom parameters back to a SQL query in a BigQuery data source.
  3. Pass custom parameters to community connectors like Google Ads, Facebook ads, etc.

How do parameters in Google Data Studio work?

Parameters can get their data in the following ways:

1. From a default value defined for the parameter in the settings.

Defalut Value

2. From the component properties panel while adding any component. You can specify parameter values at the bottom of the component’s DATA tab and edit default parameter values.

In reporting data

3. From a control placed on the report.

fro control

4. From the link to the report.


google data studio parameters url

Setting parameters via the report’s URL allows you to construct reports that can be configured programmatically. Data Studio report parameters and their corresponding values are passed in as URL encoded JSON strings appended to the report URL using the ‘params’ query parameter.

In this article, I will show you how to create parameters and use them in Google Data Studio.

We will be using Google Sheets as the data source for this tutorial. We will be calculating the Profitable ROAS for a list of products available in our Google Sheet.

The formula for Profitable ROAS is:

Profitable ROAS = Avg. Order Value / Maximum CPA

In this example, the Maximum CPA will be our parameter, and its input will be provided by the user.

Let’s go to Google Data Studio and follow the below steps to add the data source.

Step 1: Click on ‘Create’ and then click on ‘Data Source’:

google data studio parameters data studio create

Step 2: Select ‘Google Sheet’ from the available data sources:

google data studio parameters google sheet

Step 3: You will get a list of available Google Sheets that you have access to. Select the sheet you want to start with.

google data studio parameters google sheet1

Step 4: Click on the ‘Connect’ button in the upper right corner. It will connect the data source with the data source schema.

google data studio parameters google sheet2

You will see the below screen where you need to define the schemas. In our case, it is already defined – ‘Product Name’ as Text, ‘Average Order Value’ as Number.

google data studio parameters google sheet3

From the image, you can see that Google has added the record count metric, you don’t need to worry about this, and we will keep it as it is.

Creating a parameter

Step 5: In continuation from the above steps, click on ‘Add a parameter’ in the upper right corner:

google data studio parameters add parameter

Step 6: You will get a screen like below. Fill in the parameter name in the text box provided. Parameter ID is automatically updated here.

Defalut Value

Step 7: Parameters can have different data types, such as text, number (whole), number (decimal) and boolean. Since Maximum CPA in a number and that can be in decimals even, we will use number (decimal) as the data type:

decimal

Step 8: The next setting will require deciding the permitted value. The permitted value settings you see are based on the data type selected. In our case, we have selected the parameter data type as number, so we get the following options as the permitted value settings:

Any value: User can input any valid value

any value

List of values: User can select any value from the given list. You can add options by clicking on the ‘Add another value’ link.

add another value

Range: You can allow users to select the value between the range provided by selecting this option

google data studio parameters parameter value option 2

You also get the option to set a default value. In our case, we will go with the ‘Any value’ setting.

Step 9: Click on the ‘Save’ button on the bottom right-hand side to create your new parameter.

google data studio parameters save 1

Congratulations, you created your first parameter!

Step 10: Click on the ‘All fields’ link to go back to the data source schema editor:

all fields

You can now see the parameter we created in the schemas. If you want to edit the parameter setting, you can click on the ‘@’ button as below:

google data studio parameters edit parameter

Configuring parameters in calculated fields

Up until this point, we have created a parameter called ‘Maximum CPA’. To calculate Profitable ROAS, we will need to create a field in Data Studio using the calculation mechanism.

Follow the below steps to configure a field:

Step 11: Click on ‘Add a field’ in the upper right corner.

google data studio parameters add afield

Step 12: Give it a descriptive name such as ‘Profitable ROAS’:

google data studio parameters Profitable ROAS

In this section, we need to define the calculation pattern for the field. In our case, we are calculating Profitable ROAS, and its formula is as follows:

Profitable ROAS = Average Order Value ÷ Maximum CPA

So, let’s add this formula to the field.

Step 13: Hover on the fields section of the console and click on the ‘+’ button in front of ‘Average Order Value’.

google data studio parameters hover

Step 14: You will see now that ‘Average Order Value’ has been added to the formula tab. Now type the ‘/’ symbol after this and then add the ‘Maximum CPA’ field by clicking the ‘+’ button next to the field name to complete the formula:

google data studio parameters formula

We are using the custom parameter in a calculated field now.

Step 15: Click on ‘Save’ to add the calculated field to the data source schema.

google data studio parameters save 1

Step 16: Click on the ‘All fields’ link to go back to the data source schema editor.

You can now see that the ‘Profitable ROAS’ field has been added to the data source schema.

google data studio parameters schema

Configuring parameters in Google Data Studio reports

We have now created our parameter and the calculated field. Now let’s create a Data Studio report and use them.

Step 17: Click on the “Create report’ button:

google data studio parameters create report

A new window will open with a report canvas and table added to it like below. Give it a descriptive name.

google data studio parameters parameter demo

Step 18: The default table has metrics like product name and record count. Let’s remove the record count metric using the editor on the right-hand side:

google data studio parameters remove record count

Step 19: Add the required dimensions and metrics to the table by dragging them in. We will be adding Average Order Value, Maximum CPA and Profitable ROAS, as below:

google data studio parameters required metrics

You will see the table in the reporting canvas like below with 0 for Maximum CPA and ‘null’ for Profitable ROAS.

google data studio parameters null

This is because the Maximum CPA value will be provided by the user, and since its value is “0”, the Profitable ROAS is showing as a null value. We need to add a data control to this report in order to provide user input.

Step 20: Click on ‘Add a control’ and select ‘Drop-down list’ from the available menu.

google data studio parameters drop down

You can place it beside the table we created earlier.

Step 21: A data control acts as a filter over the data table. We can use this filter during run time to select a specific product. Just add ‘Product Name’ as a control field.

google data studio parameters control name

Step 22: Now, let’s add another control from the menu, this time an input box. This input box will be used to get the parameter value from the user.

google data studio parameters input

Step 23: By default, the input box will have an Average order value as the control field. Since it’s already available in our table, we will remove it and add Maximum CPA as the control field of the input box.

google data studio parameters input box 1

Step 24: Click on the ‘View’ button to see how the report looks and how it works.

google data studio parameters view

You will get a report view like below:

google data studio parameters report view

Step 25: Let’s enter a Maximum CPA value of 35 in the user input box and press enter.

Google Data Studio parameters

As you can see from the above image, each product has now got a user-defined maximum CPA value of 35, and the profitable ROAS is calculated automatically by Google Data Studio for each product.

Step 26: Now, if you want to assign a different maximum CPA value to each product, click on the product name drop-down list and select the product by clicking on ‘Only’.

google data studio parameters select product

Now you will see the data table only for the selected product (Sony-HDR-PJ410 Full HD) like below:

google data studio parameters 1 product

Step 27: Enter the maximum CPA for the selected product, let’s say 65, by deleting the current value of 35 and pressing ‘Enter’.

google data studio parameters product

You can see now that the new user-defined value of the maximum CPA parameter is assigned to the Sony-HDR-PJ410 Full HD product, and the profitable ROAS is calculated based on the input provided.

This is how you can use parameters in Google Data Studio and provide user-defined values to calculate the required metrics.

Frequently asked questions about parameters in Google Data Studio

What are Google Data Studio parameters?

Parameters provide user-supplied data to calculated fields and connectors in Google Data Studio reports.
Parameters allow you to interact with user-provided data.

For example, you can create calculated fields that include input from your report users. Using parameters makes your reports more interactive since they update in real-time.

Parameters are similar to variables in programming languages and are used to pass user-defined dynamic values to the reports.

Where can I use Google Data Studio parameters?

You can use parameters in the following ways:
#1 In calculated fields to display the results based on user-defined inputs.
#2 To send custom parameters back to a SQL query in a BigQuery data source.
#3 To pass custom parameters to community connectors like Google Ads, Facebook ads, etc.
#4 You can also use parameters to create report templates.

How do I set parameters via a report’s URL? 

Setting parameters via the report’s URL allows you to construct reports that can be configured programmatically. Data Studio report parameters and their corresponding values are passed in as URL encoded JSON strings appended to the report URL using the ‘params’ query parameter.

  1. Google Data Studio Alternative – Whatagraph
  2. Google Data Studio Number Formats / Data Types
  3. How to Change Language in Google Data Studio
  4. Google Data Studio Date Format and Time Explained
  5. Google Data Studio Tutorial with FREE PDF ebook
  6. Google Data Studio Functions, Formulas Tutorial
  7. How to work with the Boolean field in Google Data Studio
  8. Google Data Studio Page Navigation Tutorial
  9. Understanding Report Editor in Google Data Studio
  10. Best practices for creating a report in Google Data Studio
  11. How to share reports in Google Data Studio
  12. Seven methods to create a new report in Google Data Studio
  13. Google Data Studio Report Tutorial
  14. How to invite people to view or edit a report in Google Data Studio
  15. How to share the link of your report in Google Data Studio
  16. Schedule email delivery of a report in Google Data Studio
  17. How to download Data Studio report as PDF
  18. How to embed a Data Studio report on a website
  19. Guide to Data Types in Google Data Studio
  20. Image function in Google Data Studio
  21. Image Link data type in Google Data Studio
  22. Image data type in Google Data Studio
  23. Google Data Studio Geo Map – Latitude Longitude
  24. Why You Should Avoid Using Functions and Calculated Fields in Data Studio
  25. Google Data Studio Calculated Fields Tutorial
  26. Working with the Text data type in Google Data Studio
  27. The Data Set Configuration Error in Google Data Studio
  28. Data Source Fields in Google Data Studio – Tutorial
  29. Refresh data source schema fields in Google Data Studio
  30. Google Data Studio Data Sources – Tutorial
  31. Google Data Studio Dimension vs Metric
  32. How to filter by email in Google Data Studio
  33. Google Data Studio – Sharing Data Sources (aka data source schema)
  34. Field editing in reports – Google Data Studio
  35. Data Source Version History in Google Data Studio
  36. Community Visualization Access in Google Data Studio
  37. Understanding Data Source Credentials in Google Data Studio
  38. Understanding Data Freshness in Google Data Studio
  39. How to create and configure a data source in Google Data Studio
  40. Google Data Studio Aggregation Explained
  41. How to Edit a Calculated Field in Google Data Studio
  42. Formula Rejection in Google Data Studio
  43. Doing Basic Maths on Numeric Fields via Calculated Fields

Register for the FREE TRAINING...

"How to use Digital Analytics to generate floods of new Sales and Customers without spending years figuring everything out on your own."



Here’s what we’re going to cover in this training…

#1 Why digital analytics is the key to online business success.

​#2 The number 1 reason why most marketers are not able to scale their advertising and maximize sales.

#3 Why Google and Facebook ads don’t work for most businesses & how to make them work.

#4 ​Why you won’t get any competitive advantage in the marketplace just by knowing Google Analytics.

#5 The number 1 reason why conversion optimization is not working for your business.

#6 How to advertise on any marketing platform for FREE with an unlimited budget.

​#7 How to learn and master digital analytics and conversion optimization in record time.



   

My best selling books on Digital Analytics and Conversion Optimization

Maths and Stats for Web Analytics and Conversion Optimization
This expert guide will teach you how to leverage the knowledge of maths and statistics in order to accurately interpret data and take actions, which can quickly improve the bottom-line of your online business.

Master the Essentials of Email Marketing Analytics
This book focuses solely on the ‘analytics’ that power your email marketing optimization program and will help you dramatically reduce your cost per acquisition and increase marketing ROI by tracking the performance of the various KPIs and metrics used for email marketing.

Attribution Modelling in Google Analytics and BeyondSECOND EDITION OUT NOW!
Attribution modelling is the process of determining the most effective marketing channels for investment. This book has been written to help you implement attribution modelling. It will teach you how to leverage the knowledge of attribution modelling in order to allocate marketing budget and understand buying behaviour.

Attribution Modelling in Google Ads and Facebook
This book has been written to help you implement attribution modelling in Google Ads (Google AdWords) and Facebook. It will teach you, how to leverage the knowledge of attribution modelling in order to understand the customer purchasing journey and determine the most effective marketing channels for investment.

About the Author

Himanshu Sharma

  • Founder, OptimizeSmart.com
  • Over 15 years of experience in digital analytics and marketing
  • Author of four best-selling books on digital analytics and conversion optimization
  • Nominated for Digital Analytics Association Awards for Excellence
  • Runs one of the most popular blogs in the world on digital analytics
  • Consultant to countless small and big businesses over the decade
error: Alert: Content is protected !!