Example of a Website Visitors Dashboard in Google Data Studio
I wanted to share a Google Data Studio report I created, that is designed as a dashboard that can be checked regularly to see how your website is performing relative to the previous month as well as the previous year.
How to Blend Data in Google Data Studio
In this post I'll give a basic overview of how to blend data in Google Data Studio. Blending data is a very useful feature that will help you combine different data sets for your dashboard.
Below I'll give a basic step by step example of how to combine two different data sources.
How to create Custom Regions in Google Data Studio using CASE statements
The CASE statement in Google Data Studio allows users to create new categories and dimensions.
"CASE statements let you create new fields that use conditional logic to determine the field values. CASE is most often used to create new categories or groupings of data." - Data Studio Help
How to create a Currency Conversion dashboard in Google Data Studio
To illustrate how the currency feature works, I will show how to use Google Sheets and Google Data Studio to create a currency dashboard.
Google Sheets has many useful functions. One of these is it's currency conversion formula that allows users to get a live conversion rate between different currencies.
How to integrate Typeform, Google Sheets and Google Data Studio
Below is a Typeform survey. Feel free to fill it in. The results of this survey are automatically sent to a Google sheet. They are then sent to a Google Data Studio report, which you will see if you scroll down.