Google Data Studio Parameters explained with examples

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. 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.

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.
    google data studio parameters 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.
    google data studio parameters component
  3. From a control placed on the report.
    google data studio parameters 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 report URL using the ‘params’ query parameter.

In this article, I am going to 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 as input provided by the user.

Google Data Studio Tutorial PDF ebook (50+ Pages)Get the free PDF ebook on Google Data Studio (50+ Pages)

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 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 its already defined. ‘Product Name’ as Text, ‘Average Order Value’ as Number.

google data studio parameters google sheet3

From the image you can see that the record count metric has been added by Google, 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: The following screen will appear. Fill in the parameter name:

google data studio parameters parameter name

Step 7: Parameters can have different data types, such as text, number and boolean. Since Maximum CPA in a number we will use number as the data type:

google data studio parameters parameter data type

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

google data studio parameters parameter value option 1

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

google data studio parameters parameter value option

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 data source schema editor:

google data studio parameters all fields 2

You can now see the parameter we created in the schemas. If you want to edit the parameter setting, you can simply 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’. In order 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 ‘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 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 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 Average order value as the control field. Since its 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 actually looks and how it works.

google data studio parameters view

You will get 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 result

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, just 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 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 report URL using the ‘params’ query parameter.

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 !!