Google Data Studio Tricks – Creating a New Calculated Field

Estimated Reading Time: 3 minutes

A few months back, Google rolled out Google Data Studio to lots of countries, including in the United Arab Emirates – That’s where I’m currently located :). It means that most of us will have access to Google Data Studio to build cool dashboards that can be used for any data visualization task that we might have.

This is the third in a series of posts about Google Data Studio tips and tricks that you might be helpful. Read our additional posts to learn more tips!

  1. Google Data Studio: Tips + Tricks #1
  2. Google Data Studio Quick Tips: Creating a Funnel Report
Data Studio Logo

Note: Logo is Property of Google Inc.

Create A New Calculated Field That Can Be Used As A New Dimension For Your Reports

Have you ever encountered a time where you need to create a new Dimension that you want to use as a drop down filter in Google Data Studio? If yes, please continue reading. This trick might help you.

There will be instances where you want to group markets (Countries) together. For example, let’s say you need a new dimension that you’ll be using in Data Studio called “Business Market”. Under this dimension, you group countries together based on the business’s requirements that are not applicable to other businesses.

Business Market Countries
 Europe  France, Italy, Germany, United Kingdom, Netherlands, and  Denmark
 Asia  China, Singapore, Philippines, Japan, and Hong Kong
 Middle East  United Arab Emirates, Bahrain, and Saudi Arabia
 United States  United States
 Canada  Canada
 Other Countries  The rest of the countries

Instead of creating a new Custom Dimension for the above requirements, Google Data Studio will let you create a New Calculated Field.

Let’s assume that you’re using Google Analytics as a Connector. Follow the steps below to create a new Custom Field in Google Data Studio.

1. In Google Data Studio, Navigate to “Resource” then click “Manage added data sources”.

step1

2. Select the Data source you’re using for the report. In this case, it’s the Google Analytics View called “1 Master View” then click “Edit”.

step2

3. Click the + button/icon (Create a new Calculated Field).

step3
4. Type in the Field Name “Business Market” and insert the formula that was created based on the Business requirement that can be found in the chart above. Then Click “Create Field”.
step4

Formula

This formula is created based on the business requirements. For more information about the calculated fields, kindly visit Google Support Docs.

CASE
WHEN Country IN (
“France” , “Italy” , “Germany” , “United Kingdom” , “Netherlands” , “Denmark”) THEN “Europe”
WHEN Country IN (
“China” , “Singapore” , “Philippines” , “Japan” , “Hong Kong”) THEN “Asia”
WHEN Country IN (
“United Arab Emirates” , “Bahrain” , “Saudi Arabia”) THEN “Middle East”
WHEN Country IN (
“United States”) THEN “United States”
WHEN Country IN (
“Canada”) THEN “Canada”
ELSE
“Other Countries”

New Field in Action

In Action

There you go. We’ve successfully created a new calculated field in Google Data Studio that you can use as a filter for your Dashboard.

I hope you enjoy this blog post. Until next time. Cheers!


Want to learn more tips and tricks for Google Data Studio? Contact your InfoTrust Consultant today!

Author

  • James Bryan Gonzales

    James is an Analytics Consultant at InfoTrust, a digital analytics consulting and technology company. James has experience in architecting and deployment of the latest and greatest Google Analytics enhanced tracking technology for eRetailers and CPG/FMCG in the world, across multiple languages and currencies. James loves all kinds of data collection and data visualization.

Facebook
Twitter
LinkedIn
Email
Originally Published: August 8, 2017

Subscribe To Our Newsletter

July 20, 2023
Originally published on August 8, 2017

Other Articles You Will Enjoy

Google Tag Best Practices for Google Analytics 4

Google Tag Best Practices for Google Analytics 4

After collaborating with several of my colleagues at InfoTrust including Bryan Lamb, Head of Capabilities, Corey Chapman, Senior Tag Management Engineer, Chinonso Emma-Ebere, Tech…

4-minute read
Is It Time to Upgrade? 4 Signs Your Organization Needs Google Analytics 4 360

Is It Time to Upgrade? 4 Signs Your Organization Needs Google Analytics 4 360

As VP of Partnerships at InfoTrust, I’ve had the opportunity to talk with hundreds of decision-makers about their interest in upgrading to Google Analytics…

4-minute read
Predictive Analytics in Google Analytics 4: How to Use Machine Learning to Forecast User Behavior and Outcomes

Predictive Analytics in Google Analytics 4: How to Use Machine Learning to Forecast User Behavior and Outcomes

Google Analytics 4 (GA4) is embracing the power of machine learning by incorporating predictive analytics within the platform so that you can use your…

7-minute read
Leveraging Attribution Models in Google Analytics 4 to Improve Your Marketing Strategy: Tips and Best Practices

Leveraging Attribution Models in Google Analytics 4 to Improve Your Marketing Strategy: Tips and Best Practices

In the dynamic landscape of digital marketing, understanding the customer journey is crucial for optimizing strategies and maximizing ROI. Google Analytics 4 (GA4) introduces…

5-minute read
Advanced Analysis Techniques in Google Analytics 4: How to Use AI-Powered Insights and Predictive Analytics for Effective Marketing

Advanced Analysis Techniques in Google Analytics 4: How to Use AI-Powered Insights and Predictive Analytics for Effective Marketing

AI-powered insights and predictive analytics are revolutionary tools reshaping the modern marketing landscape. These advanced analytics techniques, particularly prominent in Google Analytics 4 (GA4),…

8-minute read
Leveraging Custom Dimensions and Metrics in Google Analytics 4 for Content Performance Measurement: Best Practices and Real-World Examples

Leveraging Custom Dimensions and Metrics in Google Analytics 4 for Content Performance Measurement: Best Practices and Real-World Examples

In today’s digital landscape where content reigns supreme, understanding how your audience interacts with your content is paramount for success. For news and media…

5-minute read
How to Integrate Google Analytics 4 with BigQuery for Enhanced Data Analysis and Reporting

How to Integrate Google Analytics 4 with BigQuery for Enhanced Data Analysis and Reporting

Has your business found that its reporting needs require advanced analysis of your analytics data beyond what is practical in the Google Analytics 4…

4-minute read
How to Track User Engagement and Behavior on Your Website Using Google Analytics 4 Custom Metrics

How to Track User Engagement and Behavior on Your Website Using Google Analytics 4 Custom Metrics

Understanding how users engage with your website is crucial for improving user experience and achieving your business goals. Google Analytics 4 (GA4) offers a…

5-minute read
App Install Attribution in Google Analytics 4: What You Need to Know

App Install Attribution in Google Analytics 4: What You Need to Know

App install attribution in Google Analytics for Firebase (GA4) is a feature that helps you understand how users discover and install your app. It…

6-minute read

Get Your Assessment

Thank you! We will be in touch with your results soon.
{{ field.placeholder }}
{{ option.name }}

Talk To Us

Talk To Us

Receive Book Updates

Fill out this form to receive email announcements about Crawl, Walk, Run: Advancing Analytics Maturity with Google Marketing Platform. This includes pre-sale dates, official publishing dates, and more.

Search InfoTrust

Leave Us A Review

Leave a review and let us know how we’re doing. Only actual clients, please.