$30 off During Our Annual Pro Sale. View Details »

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

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.

Dana DiTomaso

November 10, 2023
Tweet

More Decks by Dana DiTomaso

Other Decks in Marketing & SEO

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