Slide 1

Slide 1 text

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/

Slide 2

Slide 2 text

➔ Data since 2020 ➔ Over 2000 trained ➔ Orkney Islands

Slide 3

Slide 3 text

No content

Slide 4

Slide 4 text

No content

Slide 5

Slide 5 text

No content

Slide 6

Slide 6 text

No content

Slide 7

Slide 7 text

No content

Slide 8

Slide 8 text

Search Console Low Hanging Fruit

Slide 9

Slide 9 text

No content

Slide 10

Slide 10 text

No content

Slide 11

Slide 11 text

No content

Slide 12

Slide 12 text

Percentage of Total

Slide 13

Slide 13 text

No content

Slide 14

Slide 14 text

No content

Slide 15

Slide 15 text

References and Trendlines

Slide 16

Slide 16 text

No content

Slide 17

Slide 17 text

No content

Slide 18

Slide 18 text

No content

Slide 19

Slide 19 text

No content

Slide 20

Slide 20 text

Highlights

Slide 21

Slide 21 text

No content

Slide 22

Slide 22 text

No content

Slide 23

Slide 23 text

Cut the Crap

Slide 24

Slide 24 text

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)

Slide 25

Slide 25 text

Track that report

Slide 26

Slide 26 text

No content

Slide 27

Slide 27 text

Algorithm Tracker

Slide 28

Slide 28 text

No content

Slide 29

Slide 29 text

Video Overviews

Slide 30

Slide 30 text

No content

Slide 31

Slide 31 text

No content

Slide 32

Slide 32 text

Tell Me

Slide 33

Slide 33 text

No content

Slide 34

Slide 34 text

No content

Slide 35

Slide 35 text

Calculated Fields (are your friend)

Slide 36

Slide 36 text

No content

Slide 37

Slide 37 text

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/

Slide 38

Slide 38 text

REGEXP_REPLACE(Session source, '(?i)((l|m|lm|business)\\.)?facebook\\.com', 'facebook') Source - https://omisido.com/calculated-fields-in-google-data-studio

Slide 39

Slide 39 text

Funnels

Slide 40

Slide 40 text

No content

Slide 41

Slide 41 text

No content

Slide 42

Slide 42 text

Thank You https://speakerdeck.com/krmdigitaluk https://www.linkedin.com/in/kylerushtonmcgregor/

Slide 43

Slide 43 text

Link to Blog