Digital Acquisition Report Infographic With Google Data Studio

*Disclaimer: For this video I have used data from the Google Merchandise Online Store Google Analytics which is publicly available!

Google Data Studio has many options to style and make your reports pretty. I have been experimenting building infographics with Google Data Studio and I came up with some really great looking visuals.

In this video I create a digital acquisition report for a website to show performance by digital marketing channel. I got inspired by an available infographic template in Venngage, which is a great data visualization tool.

It was super easy to recreate a similar style infographic with Google Data Studio and in this video I show some important features like:

– how to select multiple widgets
– how to group widgets
– how to create new filters
– how to use background shapes and color

What I came up with is a very colorful report.
If you look at it from a data storytelling perspective it is a little difficult to digest and to focus your audience attention.
But as an unusual style report that looks like an infographic I think it is pretty cool.

Digital Acquisition Report Infographic With Google Data Studio

Hope you enjoy it and get inspired to create your own infographic in Google Data Studio.

How to Build Tables in Google Data Studio

Google Data Studio offers the abillity to build pretty tables with a lot of options to highlight your most insightful data.

In this video I will build a table with two dimensions and two metrics. I will show how to use bars or a heatmap in one of your metric columns to highlight the highest value. In this example we look at a table with landing pages per channel, sessions and eCommerce conversion rate for each landing page. The table will be sorted by highest number of sessions and I will implement a heatmap on the eCommerce conversion rate column to highlight the page with the highest conversion rate.

Also in this video you will see the new data panel which was very recently released by Google Data Studio. This new panel makes easier and faster to change or add new dimensions and metrics to your widgets.

If you are just starting with Google Data Studio check out my detailed Google Data Studio guide

Also check out my Google Data Studio examples of an Organic traffic dashboard and an eCommerce dashboard

Google Data Studio Examples

I recently published two videos with Google Data Studio examples of an organic traffic dashboard and an eCommerce dashboard. These videos show all the main features of the Google Data Studio to build any type of report.

Google Data Studio Examples

These Google Data Studio examples use Google Analytics as a data source and demonstrate how to add scorecards and backgrounds, apply styling, apply a heatmap to a column in your tables, and many other features of Google Data Studio to help you start building your own dashboard

Google Data Studio Examples – Organic Traffic Dashboard

This dashboard is an example of a monthly report on Organic search performance with a fixed date range of last month.

Google Data Studio Examples – eCommerce Dashboard

This dashboard is an example of an eCommerce performance dashboard with a data control option to let your client or manager select their own desired date range.

If you are just starting with Google Data Studio, I have written a detailed Google Data Studio Guide to get you started.

Create a Combo Chart in Google Data Studio

*Disclaimer: For this video I have used data from the Google Merchandise Store Google Analytics which is publicly available.

A combination chart visualizes data for several metrics to help you compare. In this video I show you how to create a combo chart in Google Data Studio. I am creating a trend chart for sessions, unique purchases, product adds to cart and revenue for a period of 13 months. In this video I also show how to style a chart and choose different colors for each metric.

If you are just starting with Google Data Studio, I have written a detailed Google Data Studio Guide to get you started.

Recreate Moz Stacked Bar Chart with Google Data Studio and Google Sheets

In this video I show you how to use Google Sheets as a data source in Google Data Studio. Using data that has been saved in a Google Sheet I build a stacked bar chart in Google Data Studio to show a month by month trend of organic rankings and visibility. I have taken the data from Moz from one of my campaigns that I am running. The stacked bar chart that I am building in Google Data Studio is the same as the stacked bar chart that Moz uses to show ranking and visibility trend.
Continue reading “Recreate Moz Stacked Bar Chart with Google Data Studio and Google Sheets”