Google Data Studio Reports

Learn how to build insightful reports from Google Analytics, Google Ads and Search Console data.

Last updated 2022-01-10 | 4.1

- How to create Digital Marketing reports in Google Data Studio
- Use data from Google Analytics
- Google Ads and Search Console
- Multi Chanel Data Import Workarounds

What you'll learn

How to create Digital Marketing reports in Google Data Studio
Use data from Google Analytics
Google Ads and Search Console
Multi Chanel Data Import Workarounds
Build A Real Report for your or client's website
Brand Vs Non-Brand Search Queries

* Requirements

* Digital Marketing Basic Knowledge Required

Description

This course will cover how to build an actual report that is used in a digital agency to highlight website's performance data to it's clients.  It will show you how to connect your data sources from Google Analytics, Google Ads and Search Console as well as the Supermetrics data plugin. Creation of the following reports will be covered within this course:

  • Traffic By Default Channel Group

  • Traffic Trends

  • Landing Page Performance

  • Device Category Performance

  • Browser Performance

  • Referral Traffic Information

  • Revenue By Location

  • Brand vs Non-Brand Search Queries

  • Top Organic Search Landing Pages

  • Google Ads Overview

  • Conversions By Type

  • Assisted Conversions

Furthermore, the course will go into depth about what insights you should be looking for in order to uncover the story behind the data and how to present this information to the client.

Who this course is for:

  • Digital Marketers who want to present data in a clear way

Course content

4 sections • 13 lectures

Traffic by Channels Preview 16:52

Traffic & Revenue Trends Preview 07:14

Landing Page Performance Preview 05:02

Device Performance Preview 08:36

Browser Performance Preview 02:43

Referrals Preview 05:08

Revenue By Location Preview 01:53

Brand vs Non-Brand Searches Preview 09:57

Here is the query that we will need to use in this lesson

CASE WHEN REGEXP_MATCH(Query, ".*brand name.*|.*brand nmae.*|.*brand variation.*") THEN "Brand" ELSE "Non-Brand" END

Top Organic Landing Pages Preview 01:43

Google Ads Overview Preview 05:29

Historical Monthly Performance & Conversion Types Preview 05:24

Assisted Conversions Preview 04:45

To get Supemetrics for 14 days for free, sign up here https://affiliate.supermetrics.com/1654.html