Skip ahead >>
Google Data Studio parameters are one of the many interesting features in Google Data Studio that can help you customize your reports. The Data Studio parameters are used with data visualizations to make your reports even more engaging for the viewers. If you find yourself regularly making reports for your company, you will benefit from the Google Studio data parameters by adding interactivity to them.
Google Data Studio is one of the best free, cloud-based tools for data visualizations, and the parameters make things even easier. They can make your reports more customizable and more interactive with your data. If you are a beginner at Google Data Studio, make sure to use our article and learn how to create these parameters.
What are the Data Studio Parameters?
The Data Studio parameters work the same way as variables in programming languages. They allow you to interact with the data provided by the users and fetch data sets from different data sources. With parameters, you can collect data from links or calculated fields, and input them into your report. You can also use parameters to create custom report templates.
There is much more you can do with these parameters to add customizations and user engagement in your reports. Here are some ways to use the parameters in Google Data Studio:
- To display results from calculated fields
- To create custom queries
- To provide data to community connectors
How to create a Data Studio Parameter
Learning how to create parameters could be a bit challenging in the beginning. That is why we have made this post to simplify things for you. Before you create a new parameter, here are some terms you need to understand:
- Parameter ID: This unique number can help Google Data Studio to identify the parameter. It is set by default.
- Parameter Name: The actual name that refers to the new parameter.
- Permitted Values: These are the values that a user can input (for instance any value, a list of values or a range).
- Data Type: Much like variables, the type of a parameter can be text, number (whole or decimal) and boolean.
Now that you know the fields required to create a parameter, let’s take a look at how you can actually make a new parameter in Google Data Studio.
You can find the Data Studio parameters at the top right side of your data source schema.
Once you click on “Add a parameter” follow the below steps to complete this process:
- Step 1 – Enter the Parameter Name – i.e. Transactional Intent Keywords
- Step 2 – Select the Data Type for your parameter – i.e. Text
- Step 3 – Type the values for your parameter – for text values keep you can use a Regex to include all the values – i.e. .*(buy|purchase|order|free|coupon|deal|offer|cheap|price|pricing|discount).*
- Step 4 – Save the parameter
You can use the Data Studio parameters with different sources. When creating a parameter, you can specify the desired source for your data. These include the following:
- Default Value: You can set up a default value for the parameter to use in your reports. (as shown above)
- Chart Panel: Data Studio parameters can also be set by using the chart / component panel.
- Filter: You can add a filter control on your report to allow the viewers to change the values of the parameters.
- Report URL: By adding a link, you can fetch data from different online sources such as Facebook Ads.
Once you have successfully created the parameter, it will appear as a purple field in your data sources. This will make it easier for you to access your parameters when making customized reports.
How to use a parameter within a Calculated Field?
In terms of Data Studio, a calculated field is a formula that is placed on a data source and performs any arithmetic or other functions. By combining parameters with the calculated fields, you can make your reports even more interactive and dynamic.
You can use the calculated fields to extract the value of the parameter from an existing data source. You can also use the calculated fields to return the data as different data types such as numerical or text.
By using the calculated fields with the parameters in Data Studio, you can also gather data with the help of SQL queries or CASE statements. Calculated fields ensure that your reports can compute specific outcomes (i.e. a cost projection) based on the viewer output.
4 Data Studio Parameters Examples
Now that you know what the Data Studio parameters are, let’s take a look at how you can use these parameters.
- Grouping your brand and generic keywords: With the help of the parameters, you can group your branded and generic keywords. Here is how you can do this:
- Step 1 – Create a new parameter “Brand Terms” with your own terms using the following format: .*brand term 1.*|.*brand term 2.*
- Step 2 – Create a new field to group “Brand & Generic” using the below formula: CASE WHEN (REGEXP_MATCH(Query,Brand Terms)) THEN “Brand Keywords” ELSE “Generic Keywords” END
- Step 3 – Apply the new dimension to a new chart and use the new parameter as a filter to edit the brand terms
- Creating a forecast parameter:.
- Step 1: Extract data from different sources such as Google Analytics
- Step 2: Create a new parameter
- Step 3: Create a new calculated field
- Step 4: Add an input box in the Data Studio with a Control based Parameter
- Step 5: Create new charts with Sessions and the Sessions Forecast
- Step 6:Use the parameter to adjust the forecast value in the Data Studio report\
- Calculating the ROAS (return on ad spending) of your ads:
- Step 1 : Create a new data field and configure it to calculate ROAS
- Step 2: Add parameters to the data fields
- Step 3: Create an input box to your report and add revenue values to it to test it
- Creating a UTM builder on Data Studio:
- With the Data Studio parameters you can add UTM parameters to the campaign URLs. The generated URL will allow you to automatically update with the changes you make.