Does Google Analytics Provide Raw Data?

Thinking you can download a simple spreadsheet of every single action a user takes on your website directly from your Google Analytics dashboard? It’s a common assumption, but the reality is a bit more complicated. While the standard reports in Google Analytics are powerful, they don't provide truly raw, unprocessed data. This article will explain what kind of data you're actually seeing, show you how to get access to your raw event data, and outline why it's worth the effort.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Type of Data Do You See in Standard Google Analytics Reports?

To understand the data in your dashboard, it helps to know how Google Analytics works. The process generally happens in three stages: data collection, data processing, and then data reporting.

1. Collection: When a user interacts with your site (like loading a page or clicking a button), the GA tracking code sends a "hit" to Google's servers. This is the closest thing to a raw piece of data. A single visit can generate many hits.
2. Processing: This is where Google works its magic. It takes those raw hits and organizes them into meaningful groups. It sorts hits into sessions (a single visit), and sessions are tied to users. It also enriches the data by adding details like location, device type, traffic source, and more.
3. Reporting: The charts and tables you see in the Google Analytics interface are the final output of this process. This final data is aggregated and processed, not raw.

Essentially, Google Analytics pre-packages your data to make it easy to understand. Instead of showing you a million individual pageview hits, it summarizes them for you and reports "You had 5,000 users and 8,000 sessions yesterday." This is incredibly useful for everyday analysis but comes with some limitations.

Key Data Concepts to Understand

• Hit-Level Data: The most granular level of data collected. Each hit is a single interaction, such as a pageview, an event (like a video play), or a transaction. This is the "raw ingredient."
• Session-Level Data: A group of hits from a single user during one visit. Data points like session duration or pages per session fall into this category.
• User-Level Data: Encompasses all sessions and hits associated with a specific user over time, often tracked by a client ID stored in a cookie.
• Aggregated Data: Summarized data where individual details are grouped together. For example, a report showing "2,500 users from the USA" is aggregated. You can't see the individual details of each of those 2,500 users in the standard report.

The main potential drawback of relying only on aggregated data is data sampling. On accounts with high traffic, Google Analytics may analyze a subset of your data to generate a report, rather than using all of it. This estimation can sometimes lead to inaccuracies when you're trying to do very detailed analysis. This is where accessing the raw data becomes crucial.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

The Keys to Unlocking Raw Data: Google Analytics 4 and BigQuery

For years, getting access to raw, hit-level data was a luxury reserved for enterprise customers using the expensive Google Analytics 360. That all changed with the introduction of Google Analytics 4.

GA4 was built from the ground up to provide deeper, more flexible analysis, and its best feature is the free, native integration with Google BigQuery. BigQuery is a serverless, highly scalable data warehouse provided by Google Cloud. By linking GA4 to BigQuery, you can export a continuous stream of your raw, unsampled, event-level data directly into a private, secure cloud environment that you control.

Why You Should Export GA4 Data to BigQuery

Setting this up might sound technical, but the benefits are immense for any business that takes its data seriously:

• Complete, Unsampled Data: This is the biggest win. The data in BigQuery is a complete log of all events - no sampling whatsoever. You can analyze every single interaction with 100% confidence in the data's accuracy.
• Data Ownership and Retention: The GA4 interface only holds on to detailed user-level data for a maximum of 14 months. Any data you export to BigQuery, you own forever. Your historical data will never be deleted.
• Combine Data from Other Sources: Want to see how your site traffic impacts customer support tickets or sales conversions? In BigQuery, you can merge your GA4 data with data from your CRM (like Salesforce), ad platforms (like Facebook Ads), or payment processors to get a complete view of the customer journey.
• Advanced, Custom Analysis: You can run sophisticated queries on your data that are impossible to perform within the GA4 interface. This allows you to answer very specific business questions, create custom attribution models, and understand complex user behavior paths.

How to Export Your GA4 Data to BigQuery: A Step-by-Step Guide

Getting your raw data flowing is surprisingly straightforward. Before you start, you'll need two things: Manager-level (or higher) access to the Google Analytics 4 property and owner access to a Google Cloud project.

Step 1: Create a Google Cloud Project

If you don’t already have one, head over to the Google Cloud Console and create a new project. Give it a clear name like "My-Website-Analytics". Remember that using BigQuery has associated costs, but Google provides a generous free tier that is often enough for small to medium-sized businesses to get started.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Enable the BigQuery API

Within your new Google Cloud project, navigate to the "APIs & Services" section and search for "BigQuery API". Ensure it is enabled for your project. More often than not, this is enabled by default when a project is created.

Step 3: Link GA4 and BigQuery

Now, go to your Google Analytics 4 property:

• Click on Admin in the bottom-left corner.
• In the Property column, find the Product Links section and click on BigQuery Links.
• Click the blue Link button.
• Click Choose a BigQuery project and select the cloud project you just created. Confirm your selection.

Step 4: Configure the Data Stream and Events

Next, you’ll configure the data transfer itself:

• Select the data stream(s) you want to export. For most, this will just be your main web stream.
• You can exclude specific events you don't need to reduce costs, but for a complete raw data set, it's best to leave this blank.
• Configure the frequency. You have two options, and it's best to enable both:

Once you’ve confirmed your settings, click Submit. Your link is now active!

Step 5: Verify the Data in BigQuery

It can take up to 24 hours for the first daily export to appear. To check, go back to your Google Cloud project, navigate to BigQuery, and you should see a new dataset named analytics_YOUR_PROPERTY_ID. Inside, you'll see tables named events_YYYYMMDD, which contain all your raw event data for that day.

I’ve Exported My Data… Now What?

Getting your data into BigQuery is a huge milestone, but it's only the first step. When you open one of those events_ tables, you'll see rows upon rows of raw data that isn't particularly user-friendly. Making sense of it usually requires one of the following approaches:

1. Learn SQL

The native language of databases like BigQuery is SQL (Structured Query Language). By writing queries, you can tell the database exactly how to aggregate, filter, join, and present the data you need. For example, to count the total users by country, you might write something like this:

SELECT
  geo.country,
  COUNT(DISTINCT user_pseudo_id) AS total_users
FROM
  `your-project-id.analytics_12345678.events_*`
GROUP BY
  1
ORDER BY
  2 DESC

Learning SQL gives you unmatched power and flexibility, but it comes with a steep learning curve and is traditionally the job of a data analyst.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

2. Connect a Business Intelligence Tool

Tools like Looker Studio (formerly Data Studio), Tableau, or Power BI can connect directly to your BigQuery data. These tools provide a visual, drag-and-drop interface to build charts and dashboards on top of your raw data. This is more approachable than writing SQL from scratch but still requires a solid understanding of data modeling principles to set up correctly.

Final Thoughts

So, does Google Analytics provide raw data? Not directly in its standard interface, which focuses on delivering processed and aggregated insights. To truly unlock your unprocessed, unsampled, event-level data, the method is to use the free integration between Google Analytics 4 and BigQuery. This allows you to own your historical data and perform the deep, custom analyses needed to find true competitive advantages.

Of course, exporting raw data to a warehouse like BigQuery introduces its own challenge: you now have to become an analyst, learning SQL or complex BI tools to make sense of it all. We built Graphed to remove this final, difficult step completely. Instead of struggling with queries and manual dashboard configurations, you can connect data sources like Google Analytics in just a few clicks and build real-time reports and dashboards simply by describing what you need in plain English. You get all the power of your raw data without any of the data science homework.