Exporting Universal Analytics Data with GA Query Explorer

Google officially announced that on July 1, 2024, access to the Universal Analytics (GA3) user interface and API will be discontinued for all users, including those utilizing Google 360 properties. To address this, here’s a free and simple solution to archive your data, or easily export it to merge with data from GA4 or other sources.

How to Use Google Analytics Query Explorer for UA Data Export

This tool can be used for GA4 data as well, but this list focuses specifically on the UA Query Explorer. Here’s a step-by-step breakdown of how to use this powerful resource:

  1. Open Google Analytics Query Explorer at ga-dev-tools.google/query-explorer/
  2. Select Your Account and Property: Begin by signing into your Google account and select the specific account, property, and view that you want to work with. This sets the foundation for your setting up your data export queries.
  3. Set Query Parameters: The “Set query parameters” section is where most selections happen
    • Date range: This is where you select the date range for your query. You can use any of the following formats to select the dates
      • Calendar date, such as 2021-01-31
      • Relative date, such as today or yesterday
      • NdaysAgo value, such as 30daysAgo or 7daysAgo
    • Metrics: These are quantitative measurements that provide insights into different aspects of user interaction. You could run the query here to make sure that all of the metrics that you chose are compatible. (Examples- Pageviews, New Users, or Impressions)
    • Dimensions: These are the qualitative attributes that provide some context to your metrics. they answer questions like “How did users arrive at my site?” and “Where are my users located?”. (Examples: Source/Medium, Country or Region, and Device Category)
    • Filters (optional): Allow you to narrow down your data set to focus on specific subsets of information.
    • Segments (optional): Enable you to isolate specific groups of users or sessions within your data for more targeted analysis.
  4. Run Query: With your parameters in place, hit the “Run Query” button. The Query Explorer will generate a report of your specific data and list it at the bottom of the page
  5. Export: Once you have your report, you can export it as a TSV file. This way your data is stored outside of Google Analytics and the Query Explorer, and free for you to use in any way you need. Alternatively, you can copy the API Request URL to integrate the data into other applications.
  6. Repeat: Repeat the process above to archive all the metrics and dimensions that you may want to archive for future reference.

In a world where data reigns supreme, having the ability to archive your Universal Analytics data before it fades away is an opportunity you shouldn’t miss. There are many other ways to do this, 1) Exporting Individual Reports directly from UA, 2) Using the Google Analytics Reporting API, 3) Using one of the Google Sheets Add-Ons, 4) using Big Query (great for large data sets). Here’s a link for more info – https://support.google.com/analytics/answer/11583528#export.

While there are numerous paths available, the Google Analytics Query Explorer and related UA Dimensions & Metrics Explorer (available on the same site) will empower you to explore the UA data available and make it relatively easy to query and export the data to files you want to archive.


Can We Assist?
Expert Advice in Just a Few Clicks
Please enable JavaScript in your browser to complete this form.
Name
How Can We Help?