A stack of thick white ring binders full of pages on a white surface

Agencies

Our agency built our ad reports in Data Studio (Looker Studio). How do we keep them when we part ways?

By The Tofu team ·

Copy them into your own Data Studio account before the agency's access ends. Google lets an owner transfer a report "only within your domain," so an agency on its own Google Workspace can't hand reports to your company login. Get Editor access to each report and data source, copy the data sources and reconnect them with your own Google Ads and GA4 access, then copy the reports onto them. Charts left on the agency's credentials or its connector license (such as Supermetrics) stop once its access ends. CSV uploads can't be transferred, so ask for the files.

Ask Tofu next

Pick a question and Tofu Ads Agent answers it in chat.

As of November 2026.

Data Studio is the name Google brought back in April 2026 (it was Looker Studio before). Google says existing reports moved over "with no action on your part," so these steps fit reports built under either name.

Before you start

  • A company Google login to own the copies, plus a second person as Editor. Not a personal Gmail, and not a login the agency set up.
  • Your own access to the data. The Google Ads connector reaches "any one Google Ads account to which you have access," and copied Google Ads, Google Analytics and file data sources always need reconnecting. So get your accounts back first: see taking your Google Ads account back and getting GA4 and Tag Manager admin back.
  • A plan for LinkedIn and Meta data. Google's own connector list has no LinkedIn Ads or Meta connector, so those charts usually run on a third-party connector, often one the agency pays for. See cheaper alternatives to Supermetrics.
  • Time. Do it during the notice period, while the agency still has access. See normal exit terms in an agency contract.

Step 1: List every report and what feeds it

Ask the agency for the link to every report it built for you. Open each in edit mode and go to Resource > Manage added data sources. The first column shows whether each data source is embedded (created inside that report) or reusable (created from the home page). For each one, note:

  • The connector. Google's own (Google Ads, Google Analytics, Google Sheets) or a third party's.
  • The credentials. Open the data source and click Data credentials at the top. Owner's credentials use one person's login "to authorize access to the dataset," so viewers need no access of their own. Viewer's credentials make each viewer use their own.
  • Files and sheets. Any CSV upload, and any Google Sheet in the agency's Drive.

Step 2: Check whether a transfer is possible

A transfer keeps everything as it is, but it rarely works with an agency. Google's rule: "You can transfer ownership only within your domain." For Google Workspace and Cloud Identity users, that means someone in the same organization. A personal Google account can transfer only to another personal account.

Who owns the reportsWhat to do
A login on your company's domain (say, a company email you gave the agency's staff)Transfer them to your person
A login on the agency's domainCopy them (Steps 3 to 6)
A personal Gmail accountCopy them
The agency's Data Studio Pro organizationCopy them. Google says Pro content "belongs to an organization rather than to an individual user"

To transfer, the owner shares the asset with your person, clicks Share, opens the role drop-down next to them, clicks Make owner and confirms with Yes. Share a reusable data source from the data source itself, not from inside a report. The old owner can't take a transfer back. A transferred data source keeps the old owner's credentials for now, but Google says reports with unclaimed data sources "may stop working until the data sources are claimed." So your person opens Resource > Manage added data sources, clicks FIX IT next to each one marked "Ownership changed," and clicks RECONNECT.

Step 3: Get Editor access to every report and data source

Ask the agency to click Share on each report and each reusable data source and add your company login as Editor. Google lets you copy a reusable data source only if you own it or can edit it, and an owner can turn off copying for viewers.

Step 4: Copy each reusable data source onto your own access

Signed in with your company login:

  1. On the Data Studio home page, click Data Sources at the top, then the data source.
  2. Click Make a copy in the upper right, then COPY DATA SOURCE.
  3. Select your dataset, such as your own Google Ads account, and click RECONNECT.

Google says the copy keeps dimensions, metrics, calculated fields, field types and aggregations "whenever possible." If it still uses someone else's credentials, click UPDATE CREDENTIALS. If your dataset's fields differ, Data Studio lists them and GO TO FIELDS lets you fix them.

Third-party connectors follow their vendor's rules. Supermetrics' help (updated June 2026) says a new owner of its reports and data sources must be "assigned to a Supermetrics for Data Studio subscription." Without one, rebuild those charts on another connector.

Step 5: Take over the credentials of embedded data sources

A report copy brings its embedded data sources along, except one that uses owner's credentials you don't own. Charts based on it then "show an error asking you to fix the missing data source." Google says anyone who can edit a report can edit its embedded data sources, so while you're an Editor on the agency's report:

  1. Edit the report, open Resource > Manage added data sources, and edit the embedded data source.
  2. Click Data credentials at the top and select Make me the owner.

Your login needs its own access to the data underneath, such as the Google Ads account.

Step 6: Copy each report onto your data sources

  1. Open the report. In the top right, open the menu and click Make a copy.
  2. For each original data source, pick your copy from Step 4. Data sources not shared with you show as Unknown.
  3. Click CREATE REPORT.

Copying a report "does not create copies of its data sources," which is why Step 4 comes first.

Step 7: Check, share and close out

  • Compare numbers. Set your copy and the agency's report to the same dates and check every page's totals.
  • Rebuild CSV uploads. Google says "You can't transfer ownership of CSV file upload data sources to another user." Get the original files and upload them yourself.
  • Move sheets. Google Drive says work accounts "can only transfer ownership of files and folders to someone in your organization," so make your own copy of each sheet and point the data source at it.
  • Share your copies with at least two Editors on your team.
  • Agree in writing what happens to the agency's originals and the credentials it still holds.

Next time, have the agency build in reports your company owns, with the agency as Editor. For Data Studio Pro, the paid edition, Google recommends Team Workspaces so content stays reachable when people leave.

Common problems

ProblemWhy it happensFix
Make owner won't work for your company emailTransfers only work within the owner's domainCopy instead (Steps 3 to 6)
Make a copy is missingThe owner turned off copying for viewersAsk for Editor access
Charts in your copy show a missing data source errorAn embedded data source ran on the agency's credentialsDo Step 5 first, or point the chart at your own data source
You can't reconnect to Google AdsYour login can't see the account. Through a manager account, you need access to the manager and every sub-account you pickGet Admin on your Google Ads account first
Make me the owner isn't available to youGoogle lets Data Studio administrators control who can set data credentialsAsk your Google admin, or ask the agency to do it
A calculated field shows odd numbersGoogle warns calculated fields may return different results on a different datasetCheck each formula against your data
LinkedIn or Meta charts go blankThey ran on the agency's connector accountSet up your own connector or another data route
The reports disappearedOn the no-cost version, Google permanently deletes a deleted user's assets after 20 days unless an admin transfers themAsk the agency's admin to act within those 20 days

Sources

Let an agent build your next campaign.

Tofu Ads Agent reads your CRM, plans the funnel, builds the audience and creative, and stages full campaigns across LinkedIn, Google and Meta for your approval.