HomeVideos

AI Data Analyst Built This Google Analytics + Facebook Ads Dashboard

Now Playing

AI Data Analyst Built This Google Analytics + Facebook Ads Dashboard

Transcript

180 segments

0:00

This AI app is an AI data analyst for

0:02

marketing and you can build marketing

0:04

dashboards and reports from all of your

0:06

marketing data in a single place. Hi,

0:08

I'm Cody Schneider. I'm the co-founder

0:09

of Graph. I've been doing digital

0:11

marketing for the last 10 years of my

0:13

career. And in this video, I'm going to

0:14

show you how AI is changing marketing

0:16

analytics and how it's going to be done.

0:18

So, today what we're going to do is

0:19

build this Google Analytics 4 dashboard.

0:21

So, it's going to show new users versus

0:23

total users over time. It's going to

0:25

show us page views by source. It's going

0:27

to show userto device breakdown. And

0:29

then we're also going to look at the day

0:30

of the week that we're getting the most

0:31

traffic to a specific URL. So now let's

0:34

go and build this. It's super easy. You

0:35

don't have to know how to do anything

0:37

from a data analytics perspective. You

0:39

just have to be able to prompt. So I'm

0:40

just going to go to the homepage and I'm

0:41

going to select the data source. So I'm

0:43

going to select Google Analytics 4.

0:44

Click this dashboard button and then I'm

0:46

just going to paste in this prompt. So

0:47

it's going to go and it's going to make

0:48

all of these charts at the same time

0:50

simultaneously. So I'm going to hit send

0:52

message. And so what's happening right

0:54

now is the AI agent is basically writing

0:56

an action plan to accomplish whatever

0:58

prompt you provide it. It's then going

1:00

to write the code to pull in the data

1:01

that it needs from the data warehouse

1:03

and then it's going to write the code to

1:05

configure the chart so it can actually

1:06

make that visualization. So graph is a

1:08

data pipeline, a data warehouse and also

1:11

the visualization tool. We also train

1:13

the agent to understand the underlying

1:15

data so that you don't have to have any

1:16

data literacy. You can just ask it broad

1:18

questions and it can go and generate the

1:20

outputs that you're looking for. So

1:22

right now you can see it's streaming in

1:24

all of that data. It's doing this in

1:25

parallel simultaneously. And in a moment

1:27

you're going to actually start to see

1:28

the visualizations come in. All right.

1:30

So all those charts just streamed in.

1:32

And now I can go and add new cards to

1:34

this dashboard that I want. So I'm going

1:35

to prompt it to say add a scorecard

1:37

showing total sessions. And then I'm

1:39

going to hit send. And so while that's

1:41

working in the background, I'm now going

1:42

to go into one of these charts and I'm

1:44

going to modify it. And so next what I

1:45

want to do is I want to go and change

1:47

this chart. I don't want it to be a line

1:48

graph. I want it to be a bar graph. So,

1:50

I'm going to say change this to a

1:51

stacked bar chart. And I'm going to hit

1:53

send message. And so, the AI understands

1:55

what it's done previously. It has all of

1:57

that in context. It understands the data

1:59

it's pulled in, the code it's written,

2:00

and the config it's made. So, it can

2:02

actually go and make that modification

2:03

for me. And this is all happening at the

2:05

same time. So, that change is stream

2:07

while it's also building that scorecard

2:09

in the background. And while that's

2:10

completing, let's add another chart to

2:12

this dashboard. And this time, I'm going

2:13

to ask a question. I'm going to say,

2:14

which day of the week has the most page

2:16

views on average for the register URL?

2:19

make a bar chart of this and then I'm

2:21

going to hit send message. And so this

2:22

question that I'm trying to answer of

2:23

like, hey, is there any seasonality

2:25

that's happening within the amount of

2:27

people that are getting to the register

2:28

page, which is typically a leading

2:30

indicator that people are signing up for

2:32

the application. I can now just get an

2:33

answer to that question with a

2:34

visualization. And again, this whole

2:36

dashboard is live. All of that data is

2:38

streaming in constantly in the

2:40

background. And I can bucket this by

2:41

daily, weekly, or monthly or change the

2:43

date period. So I can just do all time

2:45

as an example. Let's do year-to- date,

2:47

actually. and it will show that data for

2:49

me. All right. So the other thing that I

2:50

can do is make this into a sharable

2:52

link. So I can basically create the

2:54

share link, copy it, share it with my

2:56

team or with So the other thing that I

2:58

can do is make this into a sharable

3:00

link. So I can create the share link, I

3:02

can copy it, share it with my team or

3:04

send it to a client. And now it looks

3:05

like it just completed. So let's just

3:07

analyze what it just did here because

3:08

it's actually crazy when you break it

3:10

down. So, we just asked the question,

3:12

which day of the week am I getting the

3:14

most page views on average to the

3:16

register page? And why we would want to

3:18

know this is to see if there's any

3:19

seasonality in the time of the week that

3:21

people are getting deeper within the

3:22

funnel. So, let's break down what it did

3:24

here to actually pull this data out. So,

3:26

it basically went and found all of the

3:28

historic page view data, bucketed it by

3:31

each day of the week, and then did an

3:32

average for each of these bar charts.

3:34

That's what you're seeing here is the

3:35

that average. And then from this, I can

3:37

have the realization or the insight

3:38

that, oh, earlier in the week is when I

3:41

get people that are most receptive to go

3:42

deeper within the funnel. So when I'm

3:44

thinking about the days I should focus

3:45

on publishing content or whatever that

3:47

is, these are the days that I should be

3:49

publishing most. And this insight, I

3:51

could just share this directly with my

3:52

team. So I could save that as a PNG or

3:54

just copy it to a clipboard and drop

3:56

that into Slack. And then finally, the

3:58

dashboard that we just built only is

4:00

using a single data source, but I can

4:03

always go and add other data sources

4:05

whenever I want. For example, say I want

4:07

to add my Facebook ads to this data as

4:09

well. I just select that data source and

4:11

then I say make a scorecard showing

4:13

total spend. I hit send message and the

4:15

agent is going to add that data source

4:17

to this dashboard and it's also going to

4:19

add that card that I just prompted it to

4:21

create. And so with this I can make and

4:23

so with this I can make these composite

4:24

dashboards that has all of my data in a

4:26

single location. Gives me a bird's eye

4:28

view of my entire marketing stack so I

4:30

can understand what's going on. And on

4:32

the data source side things are

4:33

supported like Google Sheets, Google

4:35

Analytics 4, Shopify, Stripe, Google

4:37

Search Console, Air Table, Google Ads,

4:39

HubSpot, and we're just adding new ones

4:41

as people basically ask for them. So if

4:43

you don't see one here that you need, we

4:45

can typically get them out in about 24

4:46

to 48 hours. All right, so it just added

4:48

that total Facebook ad spend to my

4:50

dashboard. I'm going to rename this. I'm

4:52

going to say space ad spend. And that's

4:54

it for today. If you want a free trial

4:56

of Graph that has a value of about $500,

4:59

use the link below and I'll do a

5:01

personal discovery call with you to

5:02

build your first dashboard out with the

5:04

pl and I'll do a personal discovery call

5:06

with you to build out your first

5:07

dashboard or you can comment or you can

5:09

comment access below and I'll send you a

5:11

personalized link so you can go and test

5:13

out Graph. This is just a small taste of

5:15

how AI is going to change marketing

5:17

analytics.

Interactive Summary

This video introduces Graph, an AI-powered marketing analytics tool that allows users to build comprehensive dashboards and generate reports through natural language prompts, eliminating the need for traditional data literacy. The presenter demonstrates how to connect data sources like Google Analytics 4, create visualizations, modify charts, and derive actionable insights from the data, all while the AI agent manages the underlying code and data pipeline. The platform supports multiple integrations, including Facebook Ads, Shopify, and more, enabling a unified view of a marketing stack.

Suggested questions

3 ready-made prompts