Google Analytics reports in Google spreadsheets
Learn how to extract the data from Google Analytics, manipulate it and build the reports in Google spreadsheets
4.93 (7 reviews)
127
Students2.5 hours
ContentFeb 2021
Last UpdateWhat you will 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
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.
Screenshots
Content
Report configuration
INTRO - Report configuration
Add-on installation
First report configuration
Manual report configuration
Sampling
Sort and order
Filters
Segments
Automation options
Hourly monitoring
INTRO - Hourly monitoring
Hourly monitoring configuration
Hourly monitoring report
Search-2-keyword
INTRO - Search-2-Keyword
Search-2-keyword configuration
Search-2-keyword report
Events on a page
INTRO - Events on a page
Events on a page configuration
Events on a page report
Monthly monitoring
INTRO - Monthly monitoring
Monthly monitoring configuration
Monthly monitoring report
Checkout steps performance
INTRO - Checkout steps performance
Checkout steps performance configuration
Checkout steps performance report
Devices ratio progress in time
INTRO - Devices ratio progress in time
Devices ratio configuration
Devices ratio report
Outage calculator
INTRO - Outage calculator
Outage calculator configuration
Outage calculator report
Sharing options and limits
INTRO - Sharing options and limits
Sharing options
Errors and limits
OUTRO
OUTRO
Reviews
Great course. Learned some interesting concepts and got some good ideas on how to use google sheets with google analytics.
So far so good - as always – Pavel is a great teacher and you can really see his knowledge gained in e-commerce business. Practical course with real-life advices every advanced online specialist could use.
Coupons
| Status | Date | Discount | ||
|---|---|---|---|---|
| Expired | 2/9/2021 | 95% OFF | ||
| Expired | 2/23/2021 | 95% OFF | ||
3052048
Udemy ID4/25/2020
Course created date11/7/2020
Course Indexed date
