How to Duplicate a Looker Studio Report

Duplicating a Looker Studio (formerly Google Data Studio) report is one of the most common and powerful workflows for anyone managing dashboards. This process lets you create new client reports, experiment with designs, or build audience-specific views without starting from scratch every time. We’ll walk through how to copy reports you own, how to use public templates, and what to do when your data sources inevitably break.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Duplicate a Looker Studio Report?

Copying a report isn't just about saving a few clicks, it streamlines your entire analytics process. It’s a core skill that unlocks more efficient and organized reporting.

Here are the most common reasons to duplicate a report:

• Creating Templates for New Projects or Clients: Build a master dashboard once, then duplicate it for each new client or campaign. Just connect the new data source and you're ready to go, saving hours of work.
• Testing Changes Without Risk: Want to try a new chart type, rearrange the layout, or experiment with advanced formulas? Duplicate the original report to create a temporary "sandbox" version. If you mess something up, the live version remains untouched.
• Tailoring Reports for Different Audiences: Create multiple versions of a single report from the same data source. For example, you can create a high-level "Executive Summary" version for leadership and a highly detailed "Granular Deep Dive" for your marketing team.
• Backing Up Your Work: Before making significant edits to a critical, complex report, it’s always a good idea to create a duplicate as a quick backup.
• Using Templates from Other People: The Looker Studio Gallery and other online communities are filled with amazing-looking reports you can use. Duplicating is how you grab that template and connect it to your own data.

How to Duplicate a Report You Own

If you created the report or have edit access, the process of making a copy is straightforward. This is the simplest way to clone your work.

Step-by-Step Instructions

1. Navigate to Your Reports: Open the Looker Studio home page at lookerstudio.google.com. You will see a list of your reports.
2. Find the Report to Copy: Scroll through your dashboards until you locate the one you want to duplicate.
3. Click "More options": Hover over the report and click the three vertical dots (⋮) that appear on the right side of the row. A dropdown menu will appear.
4. Select "Make a copy": In the dropdown menu, click on the "Make a copy" option.

At this point, a new settings dialog box will open. This is the most important step in the process, as it relates to how your data will be handled in the new, copied report.

Managing Data Sources in Your Duplicated Report

After clicking "Make a copy," you’ll see a window that lets you manage your data sources. Here, you define what data your new report connects to. Looker Studio gives you the option to keep the original source or hook it up to a completely new one.

Let's break down the two main choices.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Option 1: Keeping the Original Data Source

This is the easiest path. If you just want an exact clone of your report for testing purposes or for creating different views (like an exec view vs. a team view), you can leave the settings as they are. The duplicated report will stay connected to the exact same data source as the original. Any data filters you apply in the new report won't affect the old one.

Just click the "Copy Report" button and you're done. Your new report, often titled "Copy of [Original Report Name]," will open up in edit mode.

Option 2: Connecting a New Data Source

This is the most common use case by far, especially when you are using a template for a new client or project. For instance, you might have a master "Google Analytics 4" template that you need to connect to a new client's GA4 property.

In the "Copy Report" settings window, you'll see an "Original Data Source" listed on the left and a "New Data Source" area on the right.

1. Select the new data source: Click the dropdown under "New Data Source." Looker Studio will show you a list of your available data sources. Choose the Google Sheet, GA4 Property, Google Ads Account, or other data source that you want to connect to this new report.
2. (Optional) Create a data source: If you haven't connected the data source you need yet, you can scroll to the bottom of the list and click "Create data source" to connect it on the fly.
3. Finish the duplication: Once you've selected your new data source(s), click "Copy Report".

A Critical Tip on Data Schemas

For a smooth transition, the structure (or "schema") of your new data source must be identical or very similar to the original one. This means the column names and data types (e.g., text, number, date) need to match.

If the original source had a column named "Profit" and your new one doesn't, any charts in the copied report that rely on the "Profit" metric will break, showing an "Invalid Metric" error. We'll cover fixing this below.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Duplicate a Report You Don't Own (e.g., from a Template or Shared Link)

Often, you’ll find a great report template online that someone else built and shares publicly via a link. While you won’t have edit access to their report, Looker Studio almost always allows you to make your own copy and connect your own data, as long as the original creator enabled this setting.

The process is almost identical to copying your own report, with one key difference.

Step-by-Step Instructions

1. Open the report: Open the Looker Studio report that was shared with you. You should be in "View" mode.
2. Find the "Make a copy" button: In the top-right corner of the menu bar, click the three vertical dots (⋮) icon.
3. Click "Make a copy".

The familiar data source settings box pops up. Since you don't have access to the original owner’s data sources, you are required to select your own. You cannot proceed without mapping their data source to one of your own.

Follow the steps from the previous section to select a compatible data source from your account, then click "Copy Report."

Troubleshooting Common Problems After Duplicating

Duplicating a report is usually a pain-free experience, but you might occasionally run into a few common issues, especially when switching to a new data source.

1. "Invalid Metric" or "Chart configuration is incomplete"

This is the most frequent issue. It happens when your new data source is missing a field that was used in the original report, or the field has a different name.

• The Cause: The schema mismatch discussed earlier. Your report is trying to find a column like campaign_cost but your new data source calls it advertising_spend.
• How to Fix It: You'll need to go chart by chart. Click on a broken chart. On the right-hand Setup panel, you will see a field highlighted in red labeled “Invalid metric” or “Invalid dimension.” Click on it and replace it with the correct, corresponding field from your new data source.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

2. Data Source Authentication Errors

Sometimes credentials expire or permissions need to be refreshed for the new source to work.

• The Cause: The connection to your data source has expired or has a problem.
• How to Fix It: Go to the menu bar and click Resource > Manage added data sources. Find the problematic data source in the list, click Edit, and then in the top left corner of the next screen, click the RECONNECT button. You may be prompted to re-authorize your account.

3. Data Blends Break

If the original report used blended data (combined data from two different sources), this adds a layer of complexity after duplication.

• The Cause: The blend configuration is still pointing to the original report’s data sources, and the join keys (the fields used to link the two sources) may not align in the new sources.
• How to Fix It: Go to Resource > Manage blends and edit the blend. For each separate source within the blend, make sure you remap it to your new data sources. Then, double-check that the "join conditions" are still valid for your newly connected tables.

Final Thoughts

Duplicating reports is a massive time-saver for anyone who spends time in Looker Studio. Once you master the workflow and understand the importance of matching data schemas, you can quickly build out entire reporting suites, test new ideas without fear, and leverage templates to avoid starting from a blank page. The key is just making sure your new data can map cleanly onto the old report's structure.

Of course, the manual process of creating templates, duplicating them, and fixing broken schema connections is one reason we built tools that automate this from the start. We found that data analysis got clogged by repetitive setup tasks instead of finding insights. With a tool like Graphed, you simply describe the dashboard you want to see - "Show me a dashboard of a client's Google Analytics performance comparing this month to last month" - and it generates the report instantly from your connected data. There’s no duplicating or manual reconnecting required, because each report is built on-demand with plain English and connected to the right data source from the start.