AI Data Analyst Built This Google Analytics + Facebook Ads Dashboard
180 segments
This AI app is an AI data analyst for
marketing and you can build marketing
dashboards and reports from all of your
marketing data in a single place. Hi,
I'm Cody Schneider. I'm the co-founder
of Graph. I've been doing digital
marketing for the last 10 years of my
career. And in this video, I'm going to
show you how AI is changing marketing
analytics and how it's going to be done.
So, today what we're going to do is
build this Google Analytics 4 dashboard.
So, it's going to show new users versus
total users over time. It's going to
show us page views by source. It's going
to show userto device breakdown. And
then we're also going to look at the day
of the week that we're getting the most
traffic to a specific URL. So now let's
go and build this. It's super easy. You
don't have to know how to do anything
from a data analytics perspective. You
just have to be able to prompt. So I'm
just going to go to the homepage and I'm
going to select the data source. So I'm
going to select Google Analytics 4.
Click this dashboard button and then I'm
just going to paste in this prompt. So
it's going to go and it's going to make
all of these charts at the same time
simultaneously. So I'm going to hit send
message. And so what's happening right
now is the AI agent is basically writing
an action plan to accomplish whatever
prompt you provide it. It's then going
to write the code to pull in the data
that it needs from the data warehouse
and then it's going to write the code to
configure the chart so it can actually
make that visualization. So graph is a
data pipeline, a data warehouse and also
the visualization tool. We also train
the agent to understand the underlying
data so that you don't have to have any
data literacy. You can just ask it broad
questions and it can go and generate the
outputs that you're looking for. So
right now you can see it's streaming in
all of that data. It's doing this in
parallel simultaneously. And in a moment
you're going to actually start to see
the visualizations come in. All right.
So all those charts just streamed in.
And now I can go and add new cards to
this dashboard that I want. So I'm going
to prompt it to say add a scorecard
showing total sessions. And then I'm
going to hit send. And so while that's
working in the background, I'm now going
to go into one of these charts and I'm
going to modify it. And so next what I
want to do is I want to go and change
this chart. I don't want it to be a line
graph. I want it to be a bar graph. So,
I'm going to say change this to a
stacked bar chart. And I'm going to hit
send message. And so, the AI understands
what it's done previously. It has all of
that in context. It understands the data
it's pulled in, the code it's written,
and the config it's made. So, it can
actually go and make that modification
for me. And this is all happening at the
same time. So, that change is stream
while it's also building that scorecard
in the background. And while that's
completing, let's add another chart to
this dashboard. And this time, I'm going
to ask a question. I'm going to say,
which day of the week has the most page
views on average for the register URL?
make a bar chart of this and then I'm
going to hit send message. And so this
question that I'm trying to answer of
like, hey, is there any seasonality
that's happening within the amount of
people that are getting to the register
page, which is typically a leading
indicator that people are signing up for
the application. I can now just get an
answer to that question with a
visualization. And again, this whole
dashboard is live. All of that data is
streaming in constantly in the
background. And I can bucket this by
daily, weekly, or monthly or change the
date period. So I can just do all time
as an example. Let's do year-to- date,
actually. and it will show that data for
me. All right. So the other thing that I
can do is make this into a sharable
link. So I can basically create the
share link, copy it, share it with my
team or with So the other thing that I
can do is make this into a sharable
link. So I can create the share link, I
can copy it, share it with my team or
send it to a client. And now it looks
like it just completed. So let's just
analyze what it just did here because
it's actually crazy when you break it
down. So, we just asked the question,
which day of the week am I getting the
most page views on average to the
register page? And why we would want to
know this is to see if there's any
seasonality in the time of the week that
people are getting deeper within the
funnel. So, let's break down what it did
here to actually pull this data out. So,
it basically went and found all of the
historic page view data, bucketed it by
each day of the week, and then did an
average for each of these bar charts.
That's what you're seeing here is the
that average. And then from this, I can
have the realization or the insight
that, oh, earlier in the week is when I
get people that are most receptive to go
deeper within the funnel. So when I'm
thinking about the days I should focus
on publishing content or whatever that
is, these are the days that I should be
publishing most. And this insight, I
could just share this directly with my
team. So I could save that as a PNG or
just copy it to a clipboard and drop
that into Slack. And then finally, the
dashboard that we just built only is
using a single data source, but I can
always go and add other data sources
whenever I want. For example, say I want
to add my Facebook ads to this data as
well. I just select that data source and
then I say make a scorecard showing
total spend. I hit send message and the
agent is going to add that data source
to this dashboard and it's also going to
add that card that I just prompted it to
create. And so with this I can make and
so with this I can make these composite
dashboards that has all of my data in a
single location. Gives me a bird's eye
view of my entire marketing stack so I
can understand what's going on. And on
the data source side things are
supported like Google Sheets, Google
Analytics 4, Shopify, Stripe, Google
Search Console, Air Table, Google Ads,
HubSpot, and we're just adding new ones
as people basically ask for them. So if
you don't see one here that you need, we
can typically get them out in about 24
to 48 hours. All right, so it just added
that total Facebook ad spend to my
dashboard. I'm going to rename this. I'm
going to say space ad spend. And that's
it for today. If you want a free trial
of Graph that has a value of about $500,
use the link below and I'll do a
personal discovery call with you to
build your first dashboard out with the
pl and I'll do a personal discovery call
with you to build out your first
dashboard or you can comment or you can
comment access below and I'll send you a
personalized link so you can go and test
out Graph. This is just a small taste of
how AI is going to change marketing
analytics.
Ask follow-up questions or revisit key timestamps.
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.
Videos recently processed by our community