HomeVideos

Creating a Google Analytics 4 Dashboard With AI in 5 Minutes

Now Playing

Creating a Google Analytics 4 Dashboard With AI in 5 Minutes

Transcript

166 segments

0:00

Google Analytics 4 is extremely hard to

0:02

build dashboards for. There's a massive

0:04

learning curve and understanding how to

0:06

get the data that you need out of Google

0:09

Analytics 4 to understand it can be a

0:11

huge lift. It can take a lot of time.

0:12

But AI is totally changing that. It's

0:14

making it where you can just prompt to

0:16

pull the information out of Google

0:18

Analytics 4 that you need. And in this

0:20

video, I'm going to show you how to make

0:21

a live dashboard about your Google

0:23

Analytics 4 data entirely with AI. All

0:26

right. So, the app that we're going to

0:27

be using today is this company called

0:29

graph.com. It's an AI dashboard builder

0:32

and it has all these data connectors

0:34

that you can use to get your data into

0:37

the application. So, once you sign up

0:39

for free, you're going to be dropped

0:40

into a app dashboard that looks like

0:43

this. And this is where you're going to

0:45

prompt to build the dashboard from. I'm

0:47

going to come back to that in just a

0:48

second. Before we do that, let's talk

0:50

about data sources. So you can connect

0:52

your data sources by going to the

0:54

settings page and connecting a data

0:56

source. And so for this one, it would be

0:57

Google Analytics 4. And once I've

0:59

connected that data source, I'm going to

1:01

see it in this select source. And I'm

1:02

going to go and now prompt build a

1:05

dashboard about this data and hit send

1:08

message. And immediately what it's going

1:10

to start doing is writing code to pull

1:13

in the information that it needs to

1:16

build out a dashboard of all of the most

1:18

relevant information that a Google

1:20

Analytics for dashboard should have. And

1:22

the best part about this is you don't

1:24

even have to learn how to use the

1:25

application. This is why it's so

1:27

powerful for data analytics. You just

1:29

have to be able to describe what you

1:31

want in plain English and then the

1:33

application is going to be smart enough

1:36

to go and pull in that information. So

1:38

it just completed its initial creation

1:40

of this dashboard. You can see all of

1:42

this code that's streaming in here. So

1:44

what's happening is it is writing the

1:46

code that's necessary to create the

1:48

interactive graphs that you need for

1:51

whatever data that it's pulling in. And

1:52

this dashboard is completely

1:54

customizable. I'm going to show you that

1:55

in a second. I can edit the position of

1:57

these, change the size, etc. And I can

2:00

also go and modify the dashboard by

2:03

prompting within the chat box. I can say

2:05

whatever I want here in this chat box. I

2:08

can select the different chart types

2:09

from bar, line, pi, table, etc. And it

2:12

did user by session over time. It's

2:15

looking at total sessions versus total

2:17

users. It also created a graph showing

2:19

new users by average session duration.

2:21

This is something that's really valuable

2:23

actually now that I'm looking at this

2:24

because I can see that the session

2:26

duration on average is increasing over

2:28

time which means that we're improving

2:30

the overall value of the pages the

2:33

application that the people are landing

2:35

on. And then we also have sessions by

2:36

referral source. So you can see direct

2:39

Twitter, Facebook, Google, email and we

2:42

have the top pages that people are going

2:44

to from a page view standpoint. So to

2:46

the homepage it's 10,000 page views. So,

2:48

it just made this out of the box, but

2:50

now I want to go and modify it. And so,

2:51

I can do that. I can say something like

2:54

make an area chart that shows me new

2:56

users over time. And I hit go. And it's

2:59

going to start rendering that graph

3:01

right below in the dashboard. And while

3:03

it's working on that graph, I can do

3:04

more things. I can ask it questions

3:06

like, how many people are getting to the

3:09

register page on mobile and on desktop?

3:12

I'm trying to understand if more people

3:15

are getting to the registered page on a

3:16

mobile phone or a desktop device. And I

3:19

can take that broad question and I can

3:21

ask that and it's going to go and create

3:23

a graph that's most likely to answer

3:26

that question for me. And while it's

3:27

working on that register page views

3:29

graph, I'm going to go and just do some

3:31

research and I'm going to ask AI what

3:33

are the most important things I should

3:35

have in my Google Analytics for

3:37

dashboard. And I'm just using this as a

3:39

way to get ideas of what should be

3:41

included in my dashboard. And I like

3:43

this just total users. Let's make a

3:44

scorecard of that. So I'm just going to

3:46

copy that and select the chart type as

3:49

scorecard. And then paste in users,

3:51

total number of users over time. So it

3:53

just is going to go generate that. And

3:55

let's read through some of these other

3:56

ones. Active users, new users, sessions.

3:59

I also want to track returning users.

4:01

Let's get that added in there as well.

4:03

But I want to make this a area chart.

4:05

So, I'm going to select area chart and

4:06

then paste that in. And it looks like

4:08

this one's having an error loading. So,

4:09

let's go see what's going on here. I'm

4:10

just going to go and ask it why aren't

4:13

you showing data? And what just happened

4:14

there is it just reasoned. It expected

4:17

the database schema to try to understand

4:19

it better. And it's now writing new code

4:20

to try to fix the query that it's trying

4:22

to execute. And then something else that

4:24

I found interesting in this is we're

4:25

driving traffic from one of the emails

4:27

that we send from. So, I'm going to take

4:29

that and I'm going to say graph sessions

4:32

by source. have this be a line graph

4:36

over time. And what I love about this is

4:39

that you can use the data in the

4:41

dashboard to help influence what other

4:43

graphs that you should make within the

4:45

dashboard. So as questions arise, you

4:47

can just answer those super quickly.

4:49

Now, let's go back to this one. It's

4:50

actually prompting us with the reasoning

4:52

behind why it can't move forward. So

4:54

let's see why. And when it gets stuck

4:56

like this, what I end up doing is

4:57

changing the t chart type into table and

5:00

then redescribing what I'm trying to

5:01

create. show me page views of the

5:04

forward slashregister page by device

5:07

type. And that's how you can really

5:08

easily use AI to build a dashboard for

5:10

your Google Analytics for data. AI is

5:13

going to totally change how we do data

5:14

analytics. It's basically it's basically

5:16

going to make it so that every person on

5:18

your team is going to be able to

5:20

understand the data and get insights

5:22

from that data. And if you want to sign

5:23

up for graph.com, click the link in the

5:25

description. You'll get a 14-day free

5:27

trial. And full transparency, I am one

5:29

of the co-founders of Graph. I want

5:31

whatever feedback that you have. We're

5:33

building this in public. You can comment

5:35

below any of the questions that you

5:36

have.

Interactive Summary

This video demonstrates how to use the AI-powered platform Graph.com to easily create and customize dashboards for Google Analytics 4 (GA4) data without needing complex coding skills. By using natural language prompts, users can generate various charts and tables, troubleshoot data queries, and gain insights, ultimately democratizing data analysis for team members.

Suggested questions

3 ready-made prompts