How to get Google Optimize data through Google Analytics and Query Builder

If you are searching our connectors page for the  Google Optimize logo, you won't be able to find it. Google doesn't have an API available for this particular data source, so we had to get creative.

Using the  Google Analytics connector + the Query Builder, you can gain access to data from two Google Optimize metrics.

To get Google Optimize data from your linked Google Analytics account, follow these steps: 

From the main menu

1
  Navigate to the Query Builder section from the submenu of the Data Manager page. 
2
  Click on the "+New query" button in the top right of your screen. 

3
  Select your  Google Analytics data source.
4
  Choose the metric you would like to see via the Metric dropdown. 
5
  Choose either   Experiment ID and Variant from the dimensions dropdown list.

6
  Choose your desired Date Ranges, Compare With value, and Advanced Query Options. Run Query. 
7
   Make any necessary changes and  s ave the query.

From the Designer Tool:

1
  Open databoard in the Designer tool.
2
  Pull in a datablock. In the righthand properties panel, select  Google Analytics as the data source.
3
  Click on "+ Create custom metric" or "+New Custom Query" in the metric section of the properties panel.


5
  Inside the custom query window, choose Google Analytics as the data source.
6
 Choose the metric you would like to see via the Metric dropdown.
7
  Choose either  Experiment ID and Variant from the dimensions dropdown list.

8
  Choose your desired Date Ranges, Compare With value, and Advanced Query Options. Run Query. 
9
 Make any necessary changes and save the query.

Rename a Dimension:

You may notice that the data your custom query generates isn't in the correct format to be beneficial to someone viewing the report. For this reason, you may want to rename certain dimensions.

The best practice is to rename a dimension before you save the query. To rename a dimension,  click the "..." icon next to "Dimension" in the Data Preview, and then select "Rename dimensions." Whenever this dimension is identified, it will be replaced by your specified name. 

That's it! Your query is ready to be used in a databoard.

If you will have any additional questions, feel free to contact our support team.

Still need help? Contact Us Contact Us