Looker Studio styling to make your reports more actionable

Kyle will demonstrate simple and effective ways to make your Looker Studio more actionable. He'll provide hints and tips for data and action points when talking to clients, team members and heads of!

Transcript

1. Looker Studio Styling to make your reports more actionable Kyle Rushton McGregor KRM Digital Marketing Ltd Speakerdeck.com/username https://www.linkedin.com/in/kylerushtonmcgregor/
2. ➔ Data since 2020 ➔ Over 2000 trained ➔ Orkney Islands
8. Search Console Low Hanging Fruit
12. Percentage of Total
15. References and Trendlines
20. Highlights
23. Cut the Crap
24. Remove vanity metrics (bounce rate am I right?) Talk to them about what they want to see Talk in their terminology (Hotels - ADR, LOS etc) Less is more (especially for large Looker Studio reports)
25. Track that report
27. Algorithm Tracker
29. Video Overviews
32. Tell Me
35. Calculated Fields (are your friend)
37. CASE WHEN (Page="/en" OR Page="/de" OR Page="/es") THEN "Home" WHEN (REGEXP_MATCH(Page, '^/../shop/.*')) THEN "Webshop" WHEN (REGEXP_MATCH(Page, '^/../blog/.*')) THEN "Blog" WHEN (REGEXP_MATCH(Page, '(^/../company/.*|.*career.*)')) THEN "Company" ELSE "Other" END Source - https://measureschool.com/calculated-fields-data-studio/
38. REGEXP_REPLACE(Session source, '(?i)((l|m|lm|business)\\.)?facebook\\.com', 'facebook') Source - https://omisido.com/calculated-fields-in-google-data-studio
39. Funnels
42. Thank You https://speakerdeck.com/krmdigitaluk https://www.linkedin.com/in/kylerushtonmcgregor/
43. Link to Blog