How To Again-Up And Report On Common Analytics Historic Knowledge With GA4?

As a product supervisor who has labored with a number of enterprise corporations, I personally imagine Google’s shift from Common Analytics (UA) to Google Analytics 4 (GA4) has been one of many worst I’ve ever seen. There are a number of the reason why…however listed below are the most important gaffs:

1. Historic Knowledge – Google Analytics Common was retired in July 2023, and you’ll solely entry your UA knowledge till July 1, 2024. After that date, your UA knowledge will probably be deleted. Poof… gone!
2. Historic Evaluation – None of your historic knowledge from UA is obtainable in GA4 by default. Whereas I perceive the methodology and knowledge construction for the 2 platforms have considerably modified, it’s merely unacceptable that corporations gained’t be capable to do easy month-over-month or month-over-year reporting with present knowledge and knowledge that was in UA by default.
3. GA4 Knowledge Retention – Many corporations don’t notice that GA4 launched with knowledge retention set to 2 months. You need to modify the info settings to 14 months manually. You must try this in each property you might have at the moment!
4. Knowledge Limitations – There are additionally limitations on the quantity of information that may be saved in GA4. For instance, there’s a restrict of fifty event-scoped customized dimensions and 50 event-scoped customized metrics per property.

Given these unbelievable roadblocks and limitations, there’s just one alternative that each firm must make to take care of historic knowledge and to have the ability to put it to use transferring ahead:

What To Do About Your Common Analytics Knowledge

If you want to have the ability to make the most of historic knowledge from UA, it’s important to:

1. Again up your UA knowledge.
2. Normalize the info to be used with GA4 knowledge.
3. Join it to a BI answer the place you’ll be able to simply question and report on the info.

If that sounds easy, it’s something BUT. I’m, once more, going to throw my opinion in right here. Whereas Google speaks largely on the GA4 launch as a response to regulatory points and privateness, I personally imagine they couldn’t stand that they’d a product that was vital to the common enterprise that Google made no revenue on. Positive, some enterprise corporations utilized Google 360 however the 5-digit licensing was not within the funds for many companies.

And transferring ahead, with GA4 solely having a most of 14 months of information, corporations will probably be compelled to include a database and reporting interface transferring ahead. Conveniently (sarcasm), Google’s BigQuery and Looker are prepared for corporations to undertake. And, after all, it will enable Google to monetize using GA4 transferring ahead.

To compound issues, we’re even seeing that GA4’s free interface has huge delays in exercise… whereas synchronized options to BigQuery are working in virtually real-time. Merely put… they need you to pay for Analytics transferring ahead… a technique or one other.

The GA4, BigQuery, and Looker Resolution

Whereas yow will discover different options, the native connectivity between GA4 and Google’s platforms is already there and can solely get stronger transferring ahead. It’s seemingly going to be the most effective answer… however let’s throw one other enormous roadblock in… how a lot will you spend on BigQuery and Looker for backing up, processing, and reporting on knowledge. Let’s first break down their pricing:

BigQuery Prices

BigQuery prices for each storage and processing.

• Storage: BigQuery prices a flat price of $0.02 per GB monthly for all saved knowledge. This consists of each energetic and inactive knowledge.
• Processing: BigQuery prices for the quantity of information that’s processed by your queries. This consists of the info that’s learn, scanned, and written. The processing prices are based mostly on the next components:
  • The quantity of information that’s processed
  • The kind of knowledge that’s processed
  • The complexity of the question

Looker Prices

Looker prices for the variety of customers, the quantity of information saved, and the variety of queries run.

• Customers: Looker prices a month-to-month charge for every person. The charge is predicated on the person’s position, corresponding to admin, editor, or viewer.
• Knowledge: Looker prices for the quantity of information saved in your Looker occasion. The charge is predicated on the scale of the info, the kind of knowledge, and the frequency of entry.
• Queries: Looker prices for the variety of queries run in your Looker occasion. The charge is predicated on the complexity of the question and the quantity of information processed.

So… How A lot Are You Going to Spend?

If your organization has no expertise in backing up, processing, and reporting on this knowledge using Google’s options, you would simply spend tens of hundreds of {dollars} on getting this built-in answer up and working. Why?

• You don’t want ALL your knowledge! You might solely want a fraction of your knowledge to research historic knowledge. Deliberate successfully, you’ll be able to again up abstract knowledge by a interval for channels, campaigns, occasions, and different components.
• You don’t must PROCESS all knowledge! In the event you plan successfully, you’ll be able to considerably reduce the prices that may come out of Looker for the reporting you want transferring ahead.

We advocate working with a consulting agency with the instruments and understanding of the info that may interview your small business and make sure the proper answer transferring ahead. We’d advocate doing that with an ongoing engagement slightly than a one-time push.

Why? As a result of each month you’re working inside these options, constructing studies, and processing knowledge, you threat driving up your prices with none return on funding.

Martech Zone’s sponsor, Highbridge, can help you along with your GA4 backup and reporting via their partnership with a number one Analytics agency and their answer. They developed a easy framework and course of to assist entrepreneurs, analysts, and enterprise homeowners make it simple to again up their Common Analytics knowledge.

Google has stated that they won’t create a Common Analytics backup answer after completely transferring everybody over to GA4. And due to this, corporations want methods to entry that outdated knowledge.

Tim Flint

Utilizing A Managed Service To Again Up Your UA Knowledge

This can be a managed service that makes it simple so that you can again up your GA knowledge. It’s a easy 3 step course of:

1. Decide what you wish to be backed up. Common Analytics has a lot knowledge; sadly, Google doesn’t make it simple to seize all of it. So select both predetermined studies that we offer, or work with our workforce to create customized studies to make sure you get each person, customized metric, customized dimension, occasion, and extra out of the system.
2. Decide the place you need it backed up. Select between Google Sheets, Excel, CSV, or – our favourite – BigQuery to ship your knowledge to. BigQuery is the only option for flexibility. Creating an infinite time sequence graph with UA & GA4 mixed makes it a lot simpler. Don’t know the best way to arrange BigQuery? Don’t fear. We’ll deal with that for you and offer you 100% management.
3. Decide the way you current your knowledge. The way you entry and discover this outdated knowledge is essential. Since this knowledge goes to be in complicated tables and never easy-to-use graphs, you might have a number of choices, together with connecting your knowledge on to Looker, which lets you discover and visualize knowledge. You can even make studies utilizing pivot tables in Excel, Google Sheets, or another visualizer you want.

A number of days in the past we have been working with a shopper and have been making an attempt to grasp why a sure time interval had been their most profitable. We needed to have the ability to replicate that success. If we don’t have a backup of that knowledge, we wouldn’t be capable to ask the purchasers deeper questions to assist us discover a answer to enhance their advertising and marketing.

Tim Flint

There are such a lot of the reason why corporations must again up their knowledge. And most revolve round guaranteeing that you just don’t make the identical errors twice. So right here is our listing of why you’ll want to get began on backing up that Common Analytics knowledge earlier than it’s too late.

Why it’s essential to maintain historic Google Analytics knowledge

• Your CEO will ask for historic knowledge to assist them make selections and take a look at tendencies. Historic knowledge is required that will help you perceive your advertising and marketing progress.
• Historic knowledge lets you perceive seasonality. For instance, wish to know if working that Mom’s Day sale is smart?
• Historic knowledge helps you already know the success or failure of previous exams so that you don’t need to take the identical take a look at twice or waste cash on failed tasks.
• Knowledge helps your workforce get onboarded extra simply and perceive web site historical past, saving invaluable coaching time.
• Historic knowledge helps your third-party companions, corresponding to businesses, shortly know what to do.
• Sturdy knowledge will help your analysts do higher analysis tasks and discover correlations that might be useful to your small business.

Backside line: What is going to you say when your CEO asks for historic knowledge to match when issues are going poorly? Will you might have the info? You solely have till July 1st of 2024. The method isn’t easy and we will help – schedule a free session with us at the moment!