Blog

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…’:

Copy a Google Data Studio report from the edit interface

  • If you can only view the report, click the copy icon (‘Make a copy of this report’):

Copy a Google Data Studio report from the view interface

You will end up with the “Copy this report” windows:

copy report windows

It’s where things get a bit more complicated. A Google Data Studio Dashboard is composed of two parts: the report and the data source. If you want to copy a Report, will need to attach a Source to it.

Adding a new data source

The main reason you need to add a new data source to a duplicated report is that Google Data Studio Reports are deeply linked to their Data sources. If you are copying a report without adding a similar Data source your copy will break and you will need to re-map all the metrics and dimensions with your widgets. You will also lose data source type settings, default aggregation settings, calculated fields etc…. You need to make sure that your original data source exactly matches your new data source.

After clicking “Copy Report” you will be redirected to the new copied report.

Final thoughts

When working on a Google Data Studio report, the work on visual and more visible elements takes as much time as the work on the data source. You might need to create calculated fields, specify aggregations, define Data types, etc… If you are copying a report, you need to keep in mind that you not only need to copy the reports itself but also the data source.

Related Articles

How to transfer google data studio ownership

Transferring Google Data Studio ownership is not as straightforward as it should. Firstly it is essential to understand that transferring ownership of a report is not the same as transferring…

How to share Google Data Studio Reports and Data Sources

A lot of people are confused about sharing and managing access with Google Data Studio. I think that most of the confusion comes from the fact that you can share…

Mistakes to avoid when blending data with Google Data Studio

The goal is this article is to highlight and explain some subtleties of Data Studio Data blending. I hope it will help my readers avoid and understand the most common…