# Google Analytics

## 1. Select Google Analytics Data Menu

Click '+' button next to 'Data Frames' and select 'Cloud Apps Data'.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oN0X39XzG_qmQv2-F%2Fimport-cloudapps.png?generation=1586795454579146\&alt=media)

Click Google Analytics

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oNBgnUkob8VwDeG_v%2Fgoogle-analytics-select.png?generation=1586795479357157\&alt=media)

## 2. OAuth Setting

Create a connection following [this instruction](https://blog.exploratory.io/how-to-setup-oauth-cloud-apps-connections-in-exploratory-a5c20d18e7c7).

## 3. Set Parameters

* Select Account, Property, and View from the dropdown menu.
* Set Period. You can select either of the followings:
  * From This Date
  * Today
  * Yesterday
  * This Week to Yesterday
  * This Month to Yesterday
  * This Year to Yesterday
  * Last Week to Yesterday
  * Last Month to Yesterday
  * Last Year to Yesterday
  * Last N Days
  * Last N Days (Exclude Today)
  * Last N Weeks
  * Last N Weeks (Exclude This Week)
  * Last N Months
  * Last N Months (Exclude This Month)
  * Last N Months (Exclude This Week)
  * Last N Months (Exclude Today)
  * Last N Quarters
  * Last N Quarters (Exclude This Quarter)
  * Last N Quarters (Exclude This Month)
  * Last N Quarters (Exclude This Week)
  * Last N Quarters (Exclude Today)
  * Last N Years
  * Last N Years (Exclude This Year)
  * Last N Years (Exclude This Quarter)
  * Last N Years (Exclude This Month)
  * Last N Years (Exclude This Week)
  * Last N Years (Exclude Today)
* Select Dimensions and Metrics from the List. You might want to take a look at [Query Parameter reference page](https://developers.google.com/analytics/devguides/reporting/core/v3/reference) for more detail on Dimension and Measures. Also, [Google Analytics Query Explorer tool page](https://ga-dev-tools.appspot.com/query-explorer/) is helpful for you to explore different parameters that Google Analytics support.
* Segments: You can select both Custom segments as well as predefined segments from list of values. For segments details, please refer[About Segments](https://support.google.com/analytics/answer/3123951) and [Core Reporting API - Segments](https://developers.google.com/analytics/devguides/reporting/core/v3/segments)

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oNBgwUVnfVd0x69oF%2Fgoogle-analytics-setting.png?generation=1586795479411749\&alt=media)

## 4. Preview and Import

Click 'Run' button to preview the data from Google Analytics. If it looks ok, then you can click 'Save' button to import the data into Exploratory.