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
   

   View Slide

2. @danaditomaso
   There are two approaches
   to reporting.
   

   View Slide

3. @danaditomaso
   BIGQUERY
   SO HOT RIGHT NOW
   

   View Slide

4. @danaditomaso
   “You can do anything in BigQuery —
   make your reports be whatever you want!”
   

   View Slide

5. @danaditomaso
   @danaditomaso
   “OMG I just need a report plz!”
   

   View Slide

6. @danaditomaso
   

   View Slide

7. @danaditomaso
   @danaditomaso
   Maybe you aren’t comfortable
   in BigQuery.
   

   View Slide

8. @danaditomaso
   @danaditomaso
   Maybe you need to justify that
   Google Cloud credit card request.
   

   View Slide

9. @danaditomaso
   That doesn’t mean that advanced
   analysis isn’t for you.
   

   View Slide

10. @danaditomaso
    @danaditomaso
    Looker Studio is an accessible way
    to start combining data sets.
    

    View Slide

11. @danaditomaso
    All the data sources
    in this talk are free.
    

    View Slide

12. @danaditomaso
    @danaditomaso
    Warning:
    Don’t do this with BigQuery data
    sources, it’ll get expensive quickly.
    

    View Slide

13. @danaditomaso
    @danaditomaso
    Blending in Looker Studio is also a
    good proof-of-concept for BigQuery.
    

    View Slide

14. @danaditomaso
    Will it blend?
    

    View Slide

15. @danaditomaso
    @danaditomaso
    Tip:
    What will you use as your “key”,
    and does it match?
    

    View Slide

16. @danaditomaso
    @danaditomaso
    Visually compare the data you want
    to blend in separate tables.
    

    View Slide

17. @danaditomaso
    

    View Slide

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})',''), '\\?.+', '')
    

    View Slide

19. @danaditomaso
    Add trailing slashes to Landing Pages in GA4
    REGEXP_REPLACE(Landing page, r'([^/])$', '\\1/')
    

    View Slide

20. @danaditomaso
    

    View Slide

21. @danaditomaso
    @danaditomaso
    Tip:
    Rename your blended data
    source, tables, and fields.
    

    View Slide

22. @danaditomaso
    

    View Slide

23. @danaditomaso
    

    View Slide

24. @danaditomaso
    @danaditomaso
    Tip:
    Watch out for scopes!
    

    View Slide

25. @danaditomaso
    

    View Slide

26. @danaditomaso
    https://data.ga4spy.com/
    

    View Slide

27. @danaditomaso
    How well are organic
    and paid playing
    together?
    

    View Slide

28. @danaditomaso
    

    View Slide

29. @danaditomaso
    

    View Slide

30. @danaditomaso
    

    View Slide

31. @danaditomaso
    

    View Slide

32. @danaditomaso
    Where are you
    wasting money
    and/or effort?
    

    View Slide

33. @danaditomaso
    

    View Slide

34. @danaditomaso
    

    View Slide

35. @danaditomaso
    

    View Slide

36. @danaditomaso
    

    View Slide

37. @danaditomaso
    

    View Slide

38. @danaditomaso
    What is your
    marketing reach
    and efficiency?
    

    View Slide

39. @danaditomaso
    Efficiency = Conversions / Reach
    

    View Slide

40. @danaditomaso
    

    View Slide

41. @danaditomaso
    

    View Slide

42. @danaditomaso
    

    View Slide

43. @danaditomaso
    

    View Slide

44. @danaditomaso
    You didn’t set up
    GA4 a year ago,
    did you?
    

    View Slide

45. @danaditomaso
    https://kpplaybook.com/resources/how-to-blend-
    ua-and-ga4-data-with-looker-studio/
    

    View Slide

46. @danaditomaso
    @danaditomaso
    Those are just some
    of the possibilities!
    

    View Slide

47. @danaditomaso
    Get a free preview
    of our Analytics for
    Agencies course, plus
    a 20% discount!
    

    View Slide

48. @danaditomaso
    Thank You!
    kpplaybook.com/brightonseo2023
    Dana DiTomaso
    kpplaybook.com @danaditomaso
    

    View Slide