Reducing CAC to Improve LTV CAC Ratio

Download e-book -/>
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 class=

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 class=

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 class=

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 class=

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 class=

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 class=

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 class=

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 class=

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 class=

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 class=

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 class=

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 class=

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 class=

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

EasyInsights UI class=

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 class=

Table of Contents

Site Footer