How to Migrate Your Experiment Data Before the GO Sunset: With Convert’s 27-Second Data Migration Tool (& 8 Other Options)

Dionysia Kontotasiou
April 17, 2023 ·
Export Experiment Data from Google Optimize with Convert’s Migration Tool

As Google Optimize’s sunset approaches, testers everywhere are faced with the weighty task of preserving their precious experiment data. But, the success of this endeavor will hinge on the thought and care put into the data migration process.

In this article, I’m covering 9 tried-and-true methods for exporting your Google Optimize (GO) data, ensuring that your hard-earned testing knowledge is safeguarded.

Option 1: The 27-Second Google Optimize Data Migration Tool by Convert

Out of all the options presented in this article, this is the only one that gives you the import feature. So, if you’re looking to transfer your data into a new tool, Option #1 is the way to go.

Installing and using the Convert Experiences Tools Chrome Extension that comes with a GO Data Migration Tool is the fastest way to export GO data.

This extension helps you optimize your experience development, testing, and debugging through some key features:

  1. Shows you detailed logging of experiences’ activity on your website pages.
  2. Downloads the experience snippet directly from the Convert app servers which eliminates the delay of experience updates in the CDN server. Otherwise, you have to wait up to 5 minutes for the updates to be reflected on your web pages.
  3. X-frame-security-header-options removed to allow you to see more sites in the Visual Editor.
  4. Chrome SameSite strict cookies are modified for the white-listed sites so you can see iframes and other parts of your website in the Visual Editor.
  5. Imports your GO experiences into your Convert account.

First, install the extension into your Chrome browser. After it is installed and enabled, you will see a Convert icon in the toolbar. To turn on the extension, click on it and toggle the switch from OFF to ON.

Select the 3-dot icon and the option to “Import your Google Optimize data” will be visible:

Start Importing GO Experiment Data.

Click on the “Import Google Optimize Data” option and then on the “Get Started” button:

Give Permission to Data Migration Tool

You need to be logged into both platforms (Google Optimize +, otherwise the import cannot be started.

Data Migration Tool Displays Log In Status

Click the “Extract Google Optimize Data” button:

Extract Google Optimize Data

Select your destination Convert account.

Choose Convert Project to Extract To
Work with Multiple Convert Accounts

You will notice that it’s not possible to select the Convert demo account (that comes by default with all Convert accounts) as this is including experiences of different types (A/A, A/B, Split URL) and statuses (Scheduled, Paused, Active, Draft, etc).

This project is a read-only project and meant for you to test, explore and discover more about Convert Experiences and its features:

Read-only Demo Project

Select the destination Convert project where you would like to import your GO experiences. Ideally, you can create a new project that will be solely used for the GO imported tests:

Select the destination Convert project

Then, select the experiences from the GO accounts that you want to import:

Select GO Accounts to Export Data From
Choose Specific Experiments

For privacy and security reasons, you need to confirm the data migration that is going to happen by clicking the “Import data” button:

Confirm Data Migration

Once the GO data is imported, you will notice a green Completed tag next to the experiences:

Data Migration Complete

And you will be able to view them in your Convert Experiences tab:

View GO Imported Experiments In Convert

Navigate to the Change History tab to see all the changes that took place:

Convert's Change History Reflects Migration

Open the Visual Editor and see that both visual changes and code changes are present:

Visual Editor Reflects Changes

The entire process is done in less than 30 seconds. 

Now you can pick up where you’d left off! Continue iterating on the changes made to the variants and test like you were never disrupted. 

You now have access to all Experiments, their data, variations and their settings.

Option 2: CSV Download

From here on out, we’ll explore export options. Starting with the most common and straightforward one, exporting your GO data for analysis as a CSV file.

CSV Download option in Google Optimize

After your experiment is complete, click the download icon, then choose between two options:

  • Optimize report: gives you a GO analysis of your variants
  • Analytics data: is available for each of your variations, broken down by day.
CSV Download options in Google Optimize

Here’s what your data export will look like:

CSV data export Google Optimize

Option 3: Google Analytics (GA) Custom Reports

In that same Reporting tab, select the “View in Analytics” option (next to “Download”) to view your Optimize data in your Google Analytics account. 

In the Behavior section, select the “Experiments” report. The Experiments report itself does not include export functionality, unlike many other GA reports. Below, I’ll explain a possible workaround.

Google Analytics Experiments Custom Report

Google Optimize will add three new Custom Dimensions to your Google Analytics reports when you set up an integration between the two tools.

  1. Experiment name: This is the name of your experiment in GO.
  2. Experiment ID: Your experiment’s GO ID. This is available on the GO experiment detail page.
  3. Variant: A variant is identified by its code number. For example, “0” represents “Control”, “1” represents “Variant 1”, “2” represents “Variant 2”, etc.

By using the above custom dimensions, you can export raw GO data from the GA Custom Reports instead of using the GA Behavior Experiments report. 

All that’s left to do is add these dimensions, metrics, and filters to your newly created custom report:

Google Analytics Experiments Report Dimensions Metrics

After selecting your custom report, you can export the data from it in various formats by clicking the export option.

Google Analytics Experiments Custom Report Export

The custom reports panel allows you to add up to five dimensions, as well as add or delete metrics based on your needs.

Google Analytics Experiments Custom Report Panel

Option 4: Free Google Analytics Add-on for Google Sheets

The free GA add-on in Google Sheets can also be used to export your GO data.

Let’s show you how. 

Start by creating a new Google Sheet, into which you will import all the data from your CRO tests.

Check that Google Sheets has the GA Add-on installed before you begin the import. If you don’t have it, installing it is simple; just go to Extensions, choose “Get add-ons” from the Add-ons drop-down menu, search for it online, or go to this page.

Free Google Analytics Add-on Google Sheets

Once it’s installed, create a report:

Create new GA report Google Sheets

A modal window will appear on the right side of the screen. This is where you name your report, select the account, property, or view from which you want to obtain your data, and then select the metrics and dimensions you want.

Create new GA report Google Sheets sidebar

Name the report according to your testing use case.

Choose the appropriate account, property, and view of the GA account that is linked to your GO CRO test data. 

The next step is to select your metrics. 

For example, I’m mostly interested in the conversion rate of my CRO experiments, so I search for “Goal Conversion Rate”. If your GO experiment has multiple objectives, you can choose a single goal, such as “goal 3”.

The next step is to set up your dimensions.

“ExperimentID” and “Variant” are the two dimensions you need. 

ExperimentIDs originate from GO, and they allow you to focus your GA Sheets report on just your experiment. You may view data from your GO experiment for both the “control” and the “variant” in the “variant” dimension.

Create new GA report Google Sheets configuration options

Finally, click on Create Report:

Create new GA report Google Sheets example

You should now have an empty report template with the parameters you chose.

In order to narrow your report down to only one experiment, you’ll need to find the ID for the particular test in your GO account.

Google Optimize experiment ID

Now, let’s return to your report template in Google Sheets.

In the Filters cell, type the following to narrow the filter to just your experiment:


This will restrict your report to only displaying data for the specified experiment ID.

GA report Google Sheets filters

You can now run your report by clicking “Run Reports” in the Google Analytics add-on menu bar.

GA report Google Sheets run report

When everything goes smoothly, you’ll see “1 report completed successfully”.

GA report Google Sheets report status popup

The sheet should now have a new tab with your GO data.

GA report Google Sheets report sample

Option 5: Paid Add-ons for Google Sheets

Similar to pulling data from Optimize into Google Sheets using the free GA add-on, a paid third-party add-on like Supermetrics or Two Minutes Report can be used instead.

The first step is to add the third-party add-on to Google Sheets. Let’s start with Supermetrics.

Open Google Sheets → Extensions → Get add-ons and search for either Supermetrics or Two Minute Reports:

Google Sheets Get Add-ons
Google Workspace Marketplace Supermetrics

Click to install the add-on:

Google Workspace Marketplace Two Minute Reports

Upon installation, you will see it on the add-ons list in the Extensions menu:

Google Sheets Extensions Menu

Launch the Supermetrics sidebar by clicking on Add-ons → Supermetrics → Launch. By using the sidebar, you can control what data is pulled into Google Sheets:

Google Sheets Extensions Supermetrics Sidebar

Select “create new query ”. As a data source, select Google Analytics, and as a view, select the GA view or property you want data from (this must be the GA property linked to your GO data).

Google Sheets Extensions Supermetrics Create query
GA property in GO

Once that is done, run the queries you want using the correct metrics and dimensions. Your report can include any metrics you like, such as users, goal conversion rates, bounce rates, etc.

Supermetrics build query: metrics

You must choose the Experiment ID and Experiment Variant associated with your GO tests as dimensions.

Supermetrics build query: dimensions

Once you have built your query, click to get the data into a table:

Supermetrics run query
Export of GO data by Supermetrics

The same process can be followed to connect Two Minute Reports to your Google Sheets and pull your GO data:

Two Minutes Report query

Option 6: Google Analytics API

Exporting your GO data is also possible through the GA Reporting API. 

The main benefit of using the GA Reporting API is that it allows you to connect applications to GA that might not have direct integration possibilities.

There is only one drawback: it is slightly more difficult.

Installing the API code and connecting it to your business apps would essentially require the assistance of your tech team. The type of application and the base programming language you are going to use also affect the appropriate syntax for using the APIs and exporting raw data.

All programming languages, however, require a Google Cloud project, service account, and API keys, which can be created as follows:

Service Account under Google Cloud
Service Account Details
Service Account API Keys

Once you have all that, follow any of the tutorials listed below to connect to the GA Reporting API and retrieve your GO information:

Option 7: Databox Query Builder

GO data can also be retrieved and exported via the Databox Query Builder (note: you must be on a Databox plan.

In Databox, go to Metrics → Query Builder:

Databox Query Builder

Select GA as the data source for a new custom metric:

Databox Query Builder Source Google Analytics

Then select your metrics and dimensions:

Databox Query Builder GA metrics dimensions

To access your GO data, experiment IDs or variants need to be added as dimensions.

Databox Query Builder GA experiment IDs

You can preview your GO data once you have set up the custom metric:

Databox Query Builder GA data preview

And add it to your Databoard:

Databox Query Builder Add to Databoard

Or download it:

Databox Query Builder Download

Option 8: BigQuery Export 

You can use Google BigQuery to export raw data using its built-in interface if your business is one of the few that uses Google Analytics 360, the enterprise version of GA. When you export data using BigQuery, there are no data restrictions. However, since the tool organizes data using SQL, it will require some technical know-how use.

With BigQuery, you can export raw data in one of two ways:

  • Daily data export, where BigQuery creates three files with data from the current day and one file with all of the prior day’s data from GA.
  • Continuous exports every 10 to 15 minutes.

Although it is the simplest method, it is also the most expensive approach to exporting raw data from GA. You must be an active paying customer to use Google Analytics 360 and BigQuery.

Option 9: Amazon Appflow

Last but not least, if you are an AWS user, check out this tutorial. It tells you everything you need to know about extracting GA data with Amazon AppFlow and storing it in Amazon S3, so you can query it with Athena.


Which Option Should You Pick?

With nine different ways to move your data, you are well-equipped to make the transition to a Google Optimize alternative.

While all of them will allow you to export your data, Option 1 stands out as a full migration solution that not only exports but also imports data into the Convert app.

Remember, a successful data migration process is key to maintaining the integrity of your testing insights and maximizing the impact of your experimentation efforts.

Recommended Resource:
Originally published April 17, 2023 - Updated May 08, 2024
Mobile reading? Scan this QR code and take this blog with you, wherever you go.
Dionysia Kontotasiou
Dionysia Kontotasiou Convert's Head of Integration and Privacy, helping customers with technical queries.
Carmen Apostu
Carmen Apostu In her role as Head of Content at Convert, Carmen is dedicated to delivering top-notch content that people can’t help but read through. Connect with Carmen on LinkedIn for any inquiries or requests.

Start Your 15-Day Free Trial Right Now.
No Credit Card Required

You can always change your preferences later.
You're Almost Done.
I manage a marketing team
I manage a tech team
I research and/or hypothesize experiments
I code & QA experiments
Convert is committed to protecting your privacy.

Important. Please Read.

  • Check your inbox for the password to Convert’s trial account.
  • Log in using the link provided in that email.

This sign up flow is built for maximum security. You’re worth it!