Category Blog
How to start with Supermetrics : the complete beginner's guide
What is Supermetrics? Supermetrics is a reporting automation tool. It can pull data from a lot of sources (Facebook, Twitter, Google Ads, Google Analytics, etc…) and imports them into a Spreadsheet, a data visualization tool like Google Data Studio and a database like BigQuery. Once you have all your data imported, you can easily visualize them and/or perform specific calculations. The importation can be fully automated. This article is mostly about Supermetrics for Google Sheets.
How to show the “Last 6 months” in a line chart with Google Data Studio.
When working with Google Data Studio client regularly asked me to display line chart showing data for the last six months. Even if the request seems pretty reasonable, it is not so easy to answer it. However there is nothing impossible with the help of a google spreadsheet and some formula. The problem with showing the last 6 months data in Google Data Studio Looking at the built-in date range selector in Google Data Studio you have everything… last 14 days, last 30 days, this quarter, last quarter, This years, last years, yesterday, last month, this week, last week… but nothing like last 6 months or even last 3 months…
How to create a bar chart in Google Data Studio without dimensions… the case of Google Analytics Goals.
Google Data Studio is a great tool however some limitation can be incredibly frustrating. Things can get quickly complicated even for what it seems to be a most straightforward, apparent request. I recently found myself in a situation where a client wanted to have Google Analytics goals displayed in a simple bar chart using Google Data Studio. My client wanted something like this : [caption id=“attachment_571” align=“alignnone” width=“420”] Expected visualization (Bar Chart + Google Analytics goals)[/caption]
How to duplicate a Google Data Studio Reports
You might want to copy a Google Data Studio report for at least two reasons: Copying a report you don’t own and want to use. Like for example a report from the Google Data Studio Report Gallery. Copying a report to create a Master Template you want to reuse as a base for future reports. There are two ways you can copy a report: If you can access the edit interface go to ‘File’ > ‘Make a copy…’:
5 tips and formula to blend data in Google Spreadsheet
You have a spreadsheet full of data. It’s messy and you don’t really know how to merge and organize all this. In this blog post, I will give you a quick overview of the best tips and formula blend data in Google Spreadsheet. If you have read my article about using Supermetrics these tips and formulas will be definitively useful. I hope it will lead my readers to the path for more efficiency.