Will it blend? Methods to level up your reporting using Looker Studio

You can use Looker Studio to present data from a single source... but why would you stop there?

Blending is one of the most useful features in Looker Studio, but it can feel a bit intimidating, especially when your data sets aren't quite speaking the same language.

In this talk, Dana will give you some of her most useful Looker Studio functions that make blending a breeze, plus example blends that you can start using right away to help you make better marketing decisions.

Transcript

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