Confused about why you can’t find your old Universal Analytics (UA) traffic data inside your new Google Analytics 4 property? It's a common and completely valid point of frustration. The short answer is you can't directly "add" or merge your historical UA data into GA4, as they are fundamentally different systems. This article will explain exactly why that is and walk you through the practical, real-world methods for combining your past and present analytics data so you can get a complete picture of your performance.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Can't You Just Merge UA and GA4?

The core reason you can't simply import old data is that UA and GA4 measure activity in completely different ways. It’s not just a product update, it’s a total re-architecture of how Google understands user behavior.

• Universal Analytics used a session-based model. It organized everything around sessions (a group of user interactions within a given time frame) and pageviews. Metrics like bounce rate and pages per session were central to this model.
• Google Analytics 4 uses an event-based model. It treats everything - from a page view to a purchase to a scroll - as an event. This model provides a far more flexible and user-centric view of the customer journey, especially across websites and apps.

Think of it like trying to combine a movie script (UA), which describes scenes in order, with a collection of raw camera footage from every angle. You can't just drop the script into the middle of the footage. They're telling the same story but in a fundamentally different language. Because the measurement models are incompatible, there's no "import historical data" button to press.

3 Ways to "Combine" Your Historical UA and Current GA4 Data

Even though you can’t merge the raw data, you absolutely need your historical context for long-term trend analysis, especially for year-over-year reporting. The transition to GA4 shouldn't mean flying blind without your past performance data. Here are the most effective ways to reunite them for analysis.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 1: Manual Export from Universal Analytics

As of July 1, 2023, Universal Analytics properties stopped processing new data. For a while, you could still access your historical reports, but Google is shutting off access to the UA interface entirely. If you haven't already, your top priority should be to export the data you need immediately before it's gone for good.

This method focuses on manually exporting summarized reports as CSVs or Google Sheets files. You won't get the raw, granular data, but you'll have the key trends locked down.

Step-by-Step Guide to Exporting UA Reports:

1. Log Into Google Analytics: Head to your Analytics account and select your old Universal Analytics property (the one with the "UA-" ID).
2. Navigate to a Key Report: Start with the reports you check most often. Good examples include:

• Acquisition > All Traffic > Source/Medium (to see where your traffic came from)
• Audience > Overview (for top-level user and session trends)
• Behavior > Site Content > All Pages (to see your most popular pages)
• Conversions > Goals > Overview (for historical conversion data)

1. Set Your Date Range: Set the calendar to the maximum possible time range you need. To safely capture year-over-year data, you might want to pull full calendar years (e.g., Jan 1, 2022 - Dec 31, 2022). Pro-tip: If your site has a lot of traffic, you may see a yellow shield icon indicating the report is based on sampled data. To get more accurate numbers, export your data in smaller chunks, like by quarter or month.
2. Select "Show Rows" to View More Data: At the bottom-right of the report table, change the "Show rows" dropdown to the highest possible value (e.g., 5000) to get as much data in one export as possible.
3. Click the "Export" Button: In the top-right corner of the screen, you'll see an "Export" option. Click it.
4. Choose Your Format: You can export to Google Sheets, Excel (XLSX), or CSV. For simple analysis, Google Sheets is often the easiest choice.

Repeat this process for every single report you value. Yes, it's tedious work, but this is the simplest way to preserve your most important metrics. You should end up with a Google Drive folder containing separate spreadsheets for your historical traffic sources, landing pages, goal completions, and more.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 2: Combine and Visualize Data in a Spreadsheet

Once you have your folders full of historical UA exports, the next step is to combine them with your current GA4 data to get a continuous view. Let's walk through a common example: creating a year-over-year monthly session comparison.

Step 1: Export Matching Data from GA4

Go to your GA4 property and pull the equivalent report. For traffic that would be Reports > Acquisition > Traffic acquisition. Export this data for your current time period into its own Google Sheet.

Step 2: Create a "Master" Spreadsheet

Create a brand new Google Sheet. This will be your workshop.

• Create a tab called "UA Data." Copy and paste the exported data from your historical UA traffic spreadsheet into this tab.
• Create another tab called "GA4 Data." Copy and paste the exported data from your current GA4 traffic spreadsheet here.
• Create a final tab called "YoY Dashboard." This is where you'll build your unified view.

Step 3: Structure Your Comparison Table

In your "YoY Dashboard" tab, set up a simple table with columns like:

| Month | 2022 Sessions (UA) | 2023 Sessions | % Change |

Step 4: Use Formulas to Pull It All Together

This is where spreadsheet skills come in. You'll need to use formulas like SUMIF or VLOOKUP to pull the relevant numbers from your data tabs into this summary table. For example, to get all sessions from January 2022 from your "UA Data" tab, your formula might look something like this:

=SUMIF('UA Data'!A:A, "January", 'UA Data'!B:B)

(This assumes Column A in your UA Data tab has the month and Column B has the sessions.)

You'll do the same for your GA4 data, populate your table, and then you can select this table to create a line chart showing your session trend over two years. This helps you finally bridge the data gap.

The Reality Check of this Method

While possible, this manual approach is extremely time-consuming and fragile. A single error in a formula can throw off your entire analysis. Furthermore, metrics aren't a perfect 1:1 match. A "session" in UA is calculated slightly differently than in GA4, so you are comparing similar, but not identical, data points. It’s a good-enough solution for spotting major trends, but it's not perfectly precise.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 3: Blend Your Data in a BI Tool (Like Looker Studio)

For a more robust and scalable solution, you can use a free business intelligence tool like Looker Studio (formerly Google Data Studio) to connect to your different data sources and visualize them in a single dashboard.

This method avoids the manual copy-pasting and fragile formulas of the spreadsheet approach.

How It Works:

1. Use Google Sheets as a Middle-Ground: Export your key UA reports into organized Google Sheets, just like in Method 1. This gives Looker Studio a stable, clean data source to connect to.
2. Connect Your Data Sources in Looker Studio: Create a new report in Looker Studio. Use the "Add data" option to connect to both of your data sources:
3. Blend the Data: This is the key step. Add charts for your UA and GA4 data to your report canvas. Then, select both charts, right-click, and choose "Blend data." Looker Studio will ask for a "join key" - a shared dimension to link the two datasets. For time series analysis, the 'Date' dimension is the obvious choice.
4. Build a Unified Visualization: Once your data is blended, you can create a single timeline chart showing performance over time. It can display your UA session data up to its end date and seamlessly continue with GA4 session data right after. This gives you that clean, continuous trend line you've been looking for.

This approach requires more setup and a bit of a learning curve, but the result is a dynamic dashboard that is far easier to manage over the long term than dozens of spreadsheets.

Final Thoughts

Directly adding Universal Analytics history to GA4 isn't possible due to their different measurement frameworks. However, you can reclaim your historical context by exporting your legacy reports and combining them with current data in tools like spreadsheets or Looker Studio, which allows for powerful year-over-year analysis and long-term trend spotting.

We know that manually exporting CSVs and fighting with data-blending tools is exactly the kind of tedious reporting work that steals time away from strategy. For this reason, we designed Graphed to be the simplest way to unify all your data without the drudgery. You just connect your GA4, plus any legacy data you’ve stored in Google Sheets, and all your other marketing platforms from Shopify to Facebook Ads. Then, you can just ask in plain English, "Show me a line chart of monthly sessions comparing UA data from 2022 to GA4 data in 2023." Our AI builds the live, interactive dashboard for you in seconds - no exports, complex formulas, or BI tool configuration necessary. Ultimately, this gets you the answers you need in less time than it takes to even find the right export button.