Skip to main content
Data Runs Deep Menu

Main navigation

  • Home
  • Who We Are
    • Careers
    • What We're Up To
    • What We Believe In
  • What We Do
  • Google Marketing Platform
    • Analytics 360
    • Tag Manager 360
    • Attribution 360
    • Salesforce and GA360
    • Data Studio
    • Optimize
  • Google Cloud Platform
    • Google BigQuery
      • Google BigQuery Training
      • Google Analytics Integration
  • Consulting
    • Strategy
    • Implementation
      • Google Analytics Audit
      • Google Tag Manager Audit
      • Enhanced Ecommerce Implementation
      • Google Tag Manager
    • Analysis
      • Google Data Studio
        • Google Data Studio Case Study - Mona
      • UX Analysis
  • Training
    • Google Analytics Courses
    • Advanced Google Analytics Training
    • Google Tag Manager Training
    • Google Analytics 360 Training
  • Partnerships
  • Conductrics
  • Blog
  • Contact

Visualising Scroll Depth Data with Pivot Tables & Data Studio

Pivot Table
By: Alex Reddie
Posted in
  • Data Studio
  • Scroll Depth
  • Pivot Table
Article Date
September 26, 2018

Pivot tables are my preferred method of presenting scroll depth, due to them being easy to create and the most effective way of reporting insights.

Pivot tables offer us the ability to visualise scroll depth data of every page with a grand total of your website. Whereas, when using scorecards and bar charts we are limited to visualising the grand total of scroll of depth data across your website.

So forget bar charts and scorecards. Think Pivot Table Minimal Effort Maximum Insights!

If you've gotten this far and realised you don't have scroll depth tracking then read my other blog Adding Scroll Depth Tracking with Google Tag Manager to learn how.

Lets get started with a new Data Studio dashboard, and add ourselves a Pivot Table to show Scroll Depth tracking. 

Step 1: Select the Pivot Table option from the insert tab.

 

Step 2: Set your Row Dimension to Page, Column Dimension to Event Label and your Metric to Unique Events.

 

Step 3: Add a filter where the Event Category is equal to your GTM tag Scroll Depth.

 

Step 4: Go to the style option of your pivot table and add a Heat Map to your Metric #1 with the colour green.

 

Output:

 

Now you have an easy-to-read pivot table that represents the scroll depth of every page on your website. It’s perfect for websites with blog posts or articles, as scroll depth allows for further insights into user behaviour. This pivot table allows you to see poor performing pages and show areas where user experience can be improved.

Congratulations! You’ve learned to visualised scroll depth data in the most efficient way.

Get in touch

To find out more, call us on 1300 737 885, email us on hello@datarunsdeep.com.au or complete a quick contact form.

Get in touch

Talk to us: 1300 737 885

08:30 - 16:30, Monday to Friday. We love to chat

Visit us, we’re at:

Level 8, 313 Little Collins Street Melbourne, VIC 3000

Sign Up For Our Newsletter

Digital Analytics Week In Review: the week's 5 top analytics posts from around the web, totally free, nearly every Friday

Aesop
Movember logo
Honda
Spotify
Mona
Country Road Logo
Zoos Victoria

Footer

  • Home
    • Who We Are
      • What We Do
      • What We're Up To
      • Careers
      • Contact
  • Training
    • Google Analytics Training Courses
    • Advanced Google Analytics Training
    • Google Tag Manager Training
  • Consulting
    • Analysis
    • Implementation
    • Strategy
    • Google Analytics Audit
    • Google Tag Manager Audit
  • Google Cloud Partner
  • Google Marketing Platform Sales Partner
  • Bitcoin accepted here
  • Twitter
  • LinkedIn
  • Google Plus
  • Blog RSS feed
Copyright © 2009-2019 Data Runs Deep Pty Ltd. All Rights Reserved. Google Analytics is a trademark of Google Inc.
Website by Marin Sekesan