noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
Real Business ๐ฉ
Analysis with
Google Data Studio
Slide 2
Slide 2 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
Weโre going deep
into data analysis!
Slide 3
Slide 3 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
Which is the art of
asking great questions
and learning how to
answer them.
Slide 4
Slide 4 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
We struggle with data.
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
The Two Octobers Framework:
- Define the problem
Slide 7
Slide 7 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
The Two Octobers Framework:
- Define the problem
- Identify the source of Truth
Slide 8
Slide 8 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
The Two Octobers Framework:
- Define the problem
- Identify the source of Truth
- Build /use data viz tools to explore data
Slide 9
Slide 9 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
The Two Octobers Framework:
- Define the problem
- Identify the source of Truth
- Build /use data viz tools to explore data
- Extract insights
Slide 10
Slide 10 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
The Two Octobers Framework:
- Define the problem
- Identify the source of Truth
- Build/use data viz tools to explore data
- Extract insights
- Form hypothesis
Slide 11
Slide 11 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
The Two Octobers Framework:
- Define the problem
- Identify the source of Truth
- Build /use data viz tools to explore data
- Extract insights
- Form hypothesis
- Execute test
Slide 12
Slide 12 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
The Two Octobers Framework:
- Define the problem
- Identify the source of Truth
- Build /use data viz tools to explore data
- Extract insights
- Form hypothesis
- Execute test
- Track + continuously improve outcomes
Slide 13
Slide 13 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
Be Curious.
Slide 14
Slide 14 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
Define the Problem.
Slide 15
Slide 15 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
Define the Problem:
- We are not hitting goal
Slide 16
Slide 16 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
Define the Problem:
- We are not hitting goal
- Why are we not hitting goal
Slide 17
Slide 17 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
Define the Problem:
- We are not hitting goal
- Why are we not hitting goal
- Is it tied to brand
Slide 18
Slide 18 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
Define the Problem:
- We are not hitting goal
- Why are we not hitting goal
- Is it tied to brand
- A category?
Slide 19
Slide 19 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
Define the Problem:
- We are not hitting goal
- Why are we not hitting goal
- Is it tied to brand
- A category?
- Location?
Slide 20
Slide 20 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
ID Source of Truth.
Slide 21
Slide 21 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
What data do we have
access to?
Slide 22
Slide 22 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
How can we aggregate it?
Slide 23
Slide 23 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
What data do we have?
- Google analytics
Slide 24
Slide 24 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
What data do we have?
- Google analytics
- Point of sale
Slide 25
Slide 25 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
What data do we have?
- Google analytics
- Point of sale
- Google Search Console
Slide 26
Slide 26 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
Thinking through the Report:
- Sales data over time (POS)
Slide 27
Slide 27 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
Data Structure
โ How is it set up?
โ Whatโs missing? How can I add it?
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
I could:
โ download data month by month
โ add a date column so I can
compare data over time
Slide 30
Slide 30 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
Thinking through the Report:
- Sales data over time (POS)
- GA data
Slide 31
Slide 31 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
Thinking through the Report:
- Sales data over time (POS)
- GA data
- Crossfiltering๐
Slide 32
Slide 32 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
Thinking through the Report:
- Sales data over time (POS)
- GA data
- Crossfiltering ๐
- Need drill downs๐
Slide 33
Slide 33 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
Thinking through the Report:
- Sales data over time (POS)
- GA data
- Crossfiltering ๐
- Need drill downs ๐
- Conditional Formatting ๐
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
Need GA data to Filter By:
- New vs returning
- Gender
- Device
- Channel
- Directory (Calculated field ๐)
- Geo
Slide 36
Slide 36 text
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
Build the Dashboard.
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
Drill-downs allow
you to drill down
through dimensions
to see data / make
workflows.
In this example,
Brand is the default.
noah@twooctobers @noahlearner
branch.tools #LocalU
noah@twooctobers.com @noahlearner
# of branded queries in top 5:
550 -> 920
In position 1:
133 -> 298