- Access to the Google Analytics account
- Basic Google Analytics knowledge
- Regular usage of Google Analytics
- The will to learn 🙂
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