Having trouble migrating from Universal Analytics to GA4? Lets make a smooth transition

A Comprehensive Guide to Customer Acquisition Costs

Looking for help?
< All Topics

How to create GA4 dashboards on Google Data Studio

To create a Google Analytics Dashboard on Datastudio using EasyInsights, follow these steps – 

STEP 1 : Log in to the EasyInsights Account and the screen below will appear. Select the workspace of choice. ( a new workspace can also be created by clicking the “New Workspace” button). For the purpose of this guide, we have created a new workspace by the name of Test.

EasyInsights UI 1

STEP 2 : On opening Test Workspace, the following screen appears which details the steps to build a dashboard. The first step is to create a Dataview. A dataview is a table that holds all the information which you want to transport from GA4 to Datastudio. Whenever data is updated in the GA4 account associated with EasyInsights, the dataview synced with that account also automatically updates. These changes are reflected in the Datastudio, all in real-time.. Click on the Get Started button to start the process of creating a dataview

EasyInsights UI 2

STEP 3 : A screen titled “Data Sources” will appear. We have to first add the data source whose information is to be presented via Datastudio. There is a “See All” option where a multitude of platforms are given. In this case, we will choose the Google Analytics 4 platform (GA4)

EasyInsights UI 3

STEP 4 : On clicking the GA4 button, you are directed to a new window. Here, choose an account to continue to EasyInsights. After an account is chosen and access is granted, EasyInsights will ask for additional access to the Google Account so that it can sync with GA4. Click on Continue

EasyInsights UI 4

STEP 5 : The screen shown below will appear where the properties of the GA4 account will be reflected in the platform section. Now click on add to workspace to the property whose dashboard is to be created. ( There exists an option to later remove that property from your workspace, should you want to)

EasyInsights UI 5

STEP 6 : Now that the Data Sources have been added, we click on the Continue to Data Explorer Button. Here we will choose the dimensions and metrics we want to present via Datastudio

STEP 7 : In the Data Explorer Screen, there is a drop down menu on Data Sources. When GA4 is selected,a Select the Columns menu will appear. Here, the relevant dimensions and metrics to be presented on datastudio, are chosen. Click on the run query button.

EasyInsights UI 6

STEP 8 : If the chosen dimensions and their metrics are compatible, then the query will run successfully and the screen below will appear. The table created here is your dataview. There’s also a download CSV option here to download the dataview.

EasyInsights UI 7

STEP 9 :  In order to proceed further, it is essential to save this dataview. Click on the Save Dataview button. The following pop-up appears where the name of the dataview is mentioned, and duration of the data to be fetched is specified. The dataview can be previewed to ensure correctness. Now click on the save dataview button. Dataview is created.

EasyInsights UI 8

STEP 10 : Now that the dataview is created, we are led to the Import in BI tool screen. Here EasyInsights provides the Google Datastudio by default (meaning, it is an activated destination by default). In the activated destination column, all the credentials will be mentioned. They will be required to create a conduit that transfers the dataview to Datastudio. Now select the dataview that is to be presented via Datastudio, and click on the Go to Datastudio button

EasyInsights UI 9

STEP 11 : If not logged in to the Datastudio account, the Datastudio login screen will appear. If already logged in, go to the create button on the left side and choose the Data Sources option as shown below

EasyInsights UI 10

STEP 12 : An Untitled Data Source screen will appear (it can be renamed). Now search for PostgreSQL in the Google Connectors and click on it. 

EasyInsights UI 11

STEP 13 : On clicking PostgreSQL, a database authentication screen will come up. Choose the Basic Option, and fill in the details already generated by EasyInsights in its Activated Destination (Datastudio) section. These details include – Hostname/IP, Database, Username, Password ( as given in the BI tool screen of EasyInsights in Step 10). Click to authenticate

EasyInsights UI 12

STEP 14 : A table option will appear next to Database Authentication. Select the table/dataview (in this case, Test1forGA4) and click on the connect button given on the top right corner. 

EasyInsights UI 13

STEP 15 : The screen shown below will now appear. Here, choose the Create Report option

EasyInsights UI 14

STEP 16 : In a new window, an untitled Datastudio report will be generated where the data source will be the information added via the dataview titled Test1forGA4. Now that the data is transferred, a presentation using Datastudio features can be created

EasyInsights UI 15

Table of Contents

Site Footer