Udemy

Platform

English

Language

Analytics & Automation

Category

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

Students

2.5 hours

Content

Feb 2021

Last Update
$94.99
Regular Price


What 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

Google Analytics reports in Google spreadsheets
Google Analytics reports in Google spreadsheets
Google Analytics reports in Google spreadsheets
Google Analytics reports in Google spreadsheets

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

M
Marin12 December 2020

Great course. Learned some interesting concepts and got some good ideas on how to use google sheets with google analytics.

V
Viola26 October 2020

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

StatusDateDiscount
Expired2/9/202195% OFF
Expired2/23/202195% OFF

3052048

Udemy ID

4/25/2020

Course created date

11/7/2020

Course Indexed date
Bot
Course Submitted by

Twitter
Telegram
Android PlayStore
Apple Appstore