@danaditomaso
Will It Blend?
Methods to level up your
reporting using Looker Studio
Dana DiTomaso
Kick Point Playbook
speakerdeck.com/danaditomaso
@danaditomaso
Slide 2
Slide 2 text
@danaditomaso
There are two approaches
to reporting.
Slide 3
Slide 3 text
@danaditomaso
BIGQUERY
SO HOT RIGHT NOW
Slide 4
Slide 4 text
@danaditomaso
“You can do anything in BigQuery —
make your reports be whatever you want!”
Slide 5
Slide 5 text
@danaditomaso
@danaditomaso
“OMG I just need a report plz!”
Slide 6
Slide 6 text
@danaditomaso
Slide 7
Slide 7 text
@danaditomaso
@danaditomaso
Maybe you aren’t comfortable
in BigQuery.
Slide 8
Slide 8 text
@danaditomaso
@danaditomaso
Maybe you need to justify that
Google Cloud credit card request.
Slide 9
Slide 9 text
@danaditomaso
That doesn’t mean that advanced
analysis isn’t for you.
Slide 10
Slide 10 text
@danaditomaso
@danaditomaso
Looker Studio is an accessible way
to start combining data sets.
Slide 11
Slide 11 text
@danaditomaso
All the data sources
in this talk are free.
Slide 12
Slide 12 text
@danaditomaso
@danaditomaso
Warning:
Don’t do this with BigQuery data
sources, it’ll get expensive quickly.
Slide 13
Slide 13 text
@danaditomaso
@danaditomaso
Blending in Looker Studio is also a
good proof-of-concept for BigQuery.
Slide 14
Slide 14 text
@danaditomaso
Will it blend?
Slide 15
Slide 15 text
@danaditomaso
@danaditomaso
Tip:
What will you use as your “key”,
and does it match?
Slide 16
Slide 16 text
@danaditomaso
@danaditomaso
Visually compare the data you want
to blend in separate tables.
Slide 17
Slide 17 text
@danaditomaso
Slide 18
Slide 18 text
@danaditomaso
Turn URLs in GSC to Page Paths (and remove UTMs)
REGEXP_REPLACE(REGEXP_REPLACE(Landing
Page,'(https?)://(w{3}.)?([a-z]+).([a-
z]{2,3})',''), '\\?.+', '')
Slide 19
Slide 19 text
@danaditomaso
Add trailing slashes to Landing Pages in GA4
REGEXP_REPLACE(Landing page, r'([^/])$', '\\1/')
Slide 20
Slide 20 text
@danaditomaso
Slide 21
Slide 21 text
@danaditomaso
@danaditomaso
Tip:
Rename your blended data
source, tables, and fields.
Slide 22
Slide 22 text
@danaditomaso
Slide 23
Slide 23 text
@danaditomaso
Slide 24
Slide 24 text
@danaditomaso
@danaditomaso
Tip:
Watch out for scopes!
Slide 25
Slide 25 text
@danaditomaso
Slide 26
Slide 26 text
@danaditomaso
https://data.ga4spy.com/
Slide 27
Slide 27 text
@danaditomaso
How well are organic
and paid playing
together?
Slide 28
Slide 28 text
@danaditomaso
Slide 29
Slide 29 text
@danaditomaso
Slide 30
Slide 30 text
@danaditomaso
Slide 31
Slide 31 text
@danaditomaso
Slide 32
Slide 32 text
@danaditomaso
Where are you
wasting money
and/or effort?
Slide 33
Slide 33 text
@danaditomaso
Slide 34
Slide 34 text
@danaditomaso
Slide 35
Slide 35 text
@danaditomaso
Slide 36
Slide 36 text
@danaditomaso
Slide 37
Slide 37 text
@danaditomaso
Slide 38
Slide 38 text
@danaditomaso
What is your
marketing reach
and efficiency?
Slide 39
Slide 39 text
@danaditomaso
Efficiency = Conversions / Reach
Slide 40
Slide 40 text
@danaditomaso
Slide 41
Slide 41 text
@danaditomaso
Slide 42
Slide 42 text
@danaditomaso
Slide 43
Slide 43 text
@danaditomaso
Slide 44
Slide 44 text
@danaditomaso
You didn’t set up
GA4 a year ago,
did you?