Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Google Analytics reports in Google spreadsheets
Rating: 4.6 out of 5(33 ratings)
463 students

Google Analytics reports in Google spreadsheets

Learn how to extract the data from Google Analytics, manipulate it and build the reports in Google spreadsheets
Created byPavel Brecik
Last updated 1/2022
English

What you'll learn

  • How to build reports based on Google Analytics data in Google spreadsheets from scratch
  • Google Analytics data automation in spreadsheets
  • How to access Google Analytics data outside GA interface
  • You'll get access to 7 practical dashboards you can instantly start using
  • Joining the data impossible to join in Google Analytics interface
  • How to save time and avoid repetitive manual reporting

Course content

10 sections • 34 lectures • 2h 28m total length

  • INTRO - Report configuration0:59

    Install the Google Analytics add-on in minutes, then configure reports in Google spreadsheets using either the clickable interface or manual dimensions and metrics, with sorting, filtering, and segments, plus automation.

  • Add-on installation3:00

    Install the Google Analytics add-on in a new Google Sheets document to pull analytics data. Authorize your account and use the add-ons menu to start extracting data.

  • First report configuration5:46
  • Manual report configuration5:28
  • Sampling5:57
  • Sort and order4:48
  • Filters3:04
  • Segments5:11
  • Automation options3:03

    Learn to automate Google Analytics reports in Google spreadsheets by scheduling automatic updates: hourly, daily, weekly, or monthly, with configurable times and data freshness.

Requirements

  • Access to the Google Analytics account
  • Basic Google Analytics knowledge
  • Regular usage of Google Analytics
  • The will to learn :)

Description

The goal of this course is to show you how easy it is to extract the data from Google Analytics into Google spreadsheet and automate the reporting. We'll start from the very basics and go through 7 practical dashboards, which will show you the possibilities of how to work with Google Analytics data in spreadsheets. 

You'll learn how to create monthly and hourly website monitoring, how to see the checkout steps flow in time, how to match data from internal search engine and bidding keywords, etc.

Who this course is for:

  • Everyone who is regularly creating Google Analytics reports
  • GA users who spend more than 1 hour a week by manually creating a report from Google Analytics data

Report abuse