Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Real Business 💩 - Analysis with Google Data Studio

Real Business 💩 - Analysis with Google Data Studio

This deck lays out the Framework we use at Two Octobers to perform analysis, create hypotheses, run tests, and then rinse and repeat.

I built it because I have seen firsthand while releasing https://branch.tools that marketers, by and large, struggle with deriving meaning from tabular data.

The deck shows the user how to:
-- 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

Noah Learner

August 01, 2022
Tweet

More Decks by Noah Learner

Other Decks in Marketing & SEO

Transcript

  1. [email protected]bers @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Real Business 💩
    Analysis with
    Google Data Studio

    View Slide

  2. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    We’re going deep
    into data analysis!

    View Slide

  3. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Which is the art of
    asking great questions
    and learning how to
    answer them.

    View Slide

  4. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    We struggle with data.

    View Slide

  5. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner

    View Slide

  6. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    The Two Octobers Framework:
    - Define the problem

    View Slide

  7. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    The Two Octobers Framework:
    - Define the problem
    - Identify the source of Truth

    View Slide

  8. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    The Two Octobers Framework:
    - Define the problem
    - Identify the source of Truth
    - Build /use data viz tools to explore data

    View Slide

  9. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    The Two Octobers Framework:
    - Define the problem
    - Identify the source of Truth
    - Build /use data viz tools to explore data
    - Extract insights

    View Slide

  10. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @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

    View Slide

  11. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @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

    View Slide

  12. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @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

    View Slide

  13. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Be Curious.

    View Slide

  14. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Define the Problem.

    View Slide

  15. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Define the Problem:
    - We are not hitting goal

    View Slide

  16. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Define the Problem:
    - We are not hitting goal
    - Why are we not hitting goal

    View Slide

  17. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Define the Problem:
    - We are not hitting goal
    - Why are we not hitting goal
    - Is it tied to brand

    View Slide

  18. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Define the Problem:
    - We are not hitting goal
    - Why are we not hitting goal
    - Is it tied to brand
    - A category?

    View Slide

  19. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Define the Problem:
    - We are not hitting goal
    - Why are we not hitting goal
    - Is it tied to brand
    - A category?
    - Location?

    View Slide

  20. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    ID Source of Truth.

    View Slide

  21. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    What data do we have
    access to?

    View Slide

  22. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    How can we aggregate it?

    View Slide

  23. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    What data do we have?
    - Google analytics

    View Slide

  24. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    What data do we have?
    - Google analytics
    - Point of sale

    View Slide

  25. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    What data do we have?
    - Google analytics
    - Point of sale
    - Google Search Console

    View Slide

  26. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Thinking through the Report:
    - Sales data over time (POS)

    View Slide

  27. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Data Structure
    ● How is it set up?
    ● What’s missing? How can I add it?

    View Slide

  28. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner

    View Slide

  29. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    I could:
    ● download data month by month
    ● add a date column so I can
    compare data over time

    View Slide

  30. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Thinking through the Report:
    - Sales data over time (POS)
    - GA data

    View Slide

  31. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Thinking through the Report:
    - Sales data over time (POS)
    - GA data
    - Crossfiltering🎊

    View Slide

  32. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Thinking through the Report:
    - Sales data over time (POS)
    - GA data
    - Crossfiltering 🎊
    - Need drill downs🎊

    View Slide

  33. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Thinking through the Report:
    - Sales data over time (POS)
    - GA data
    - Crossfiltering 🎊
    - Need drill downs 🎊
    - Conditional Formatting 🎊

    View Slide

  34. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Drill down by:
    - Brand
    - Category 1
    - Category 3
    - Category 5
    - SKU

    View Slide

  35. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Need GA data to Filter By:
    - New vs returning
    - Gender
    - Device
    - Channel
    - Directory (Calculated field 🎊)
    - Geo

    View Slide

  36. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Build the Dashboard.

    View Slide

  37. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner

    View Slide

  38. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Crossfiltering

    View Slide

  39. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Select a row in table.
    The other table
    filters to match.

    View Slide

  40. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Drill downs

    View Slide

  41. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Drill-downs allow
    you to drill down
    through dimensions
    to see data / make
    workflows.
    In this example,
    Brand is the default.

    View Slide

  42. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner

    View Slide

  43. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Glean Insights.

    View Slide

  44. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner

    View Slide

  45. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Trek, Santa Cruz + Electra
    were the problem

    View Slide

  46. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Happy Accidents...

    View Slide

  47. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Hypothesis.

    View Slide

  48. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Building content
    for these brands would
    grow traffic + revenues

    View Slide

  49. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Execute Test.

    View Slide

  50. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    We Built:
    Brand Guide
    for biggest
    brand

    View Slide

  51. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    We Built:
    Category
    Sub-category
    Internal linking

    View Slide

  52. [email protected]rs @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    ● Model-specific Pages
    ● Updated Meta

    View Slide

  53. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Track + Analyze
    Outcomes.

    View Slide

  54. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    # of branded queries in top 5:
    550 -> 920
    In position 1:
    133 -> 298

    View Slide

  55. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Clicks:
    17.6k -> 10.3k
    Impressions:
    594k -> 848K

    View Slide

  56. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    18% Revenue Growth YOY
    for 2 months of data

    View Slide

  57. [email protected] @noahlearner
    branch.tools #LocalU
    [email protected] @noahlearner
    Rinse + Repeat.

    View Slide