Backup Universal Analytics: Three BEST ways to store your historical data
ฝัง
- เผยแพร่เมื่อ 27 มิ.ย. 2024
- Backup your Universal Analytics data so you can reference it in the future.
Looking for ways to grow your traffic? ►► Grab my FREE cheatsheet here at: leonkorteweg.com/cheatsheet
Universal Analytics has stopped collecting data. You probably already know that. But did you know that after july 2024 your data will disappear forever. Unless you export the data yourself. In this video I’m going to show you three ways to backup your Universal Analytics data.
Downloads:
- Free cheatsheet to grow your website traffic: leonkorteweg.com/cheatsheet
- Google Sheets configuration for Universal Analytics import: docs.google.com/spreadsheets/...
Chapter markers:
0:00 Introduction
1:28 Three ways to backup Universal Analytics
3:43 Import Universal Analytics to Matomo
8:05 What the Matomo reports look like
11:16 Export Universal Analytics to Google Sheets
17:04 How to use the UA archive in Looker Studio
19:57 Backup Universal Analytics to Funnel.io
23:01 Never export Users from Google Analytics
24:31 Exporting Bounce Rate, Conversion Rate or Avg. Session Duration
26:48 Close
#webanalytics #googleanalytics #universalanalytics #matomo #funnelio #backup #bouncerate #conversion
Looking for ways to grow your traffic? ►► Grab my FREE cheatsheet here at: leonkorteweg.com/cheatsheet
Hoi Leon, Heel erg bedankt!
Handig Leon, ik kan dit goed gebruiken.
Hey Leonie 😁 leuk om te horen!
Hello Leon! I really appreciate you making this video, I have shared your video with my whole team to use as reference while we are transferring data. I do have one question: Once the reports are moved into Looker Studio how do we know we did everything correctly? Could you possibly make a video on how to design a report from these data pulls? Thanks again for making this video!
I've browsed through several tutorials but yours was awesome and crystal clear. So now can we import this old data into Analytics 4? Thank you so much!
Thanks! And no, unfortunately not :(
Hi Leon! Thanks a lot for sharing this! So, just to have it as a backup, you will still recommend the paid version of Matomo?? 🤔
Hi Leon, Thanks for the amazing video!! Does exporting Users, Bounce Rate from GA4 has the same issues as mentioned in the video
Hey! Thanks for the comment 😎 yes, GA4 exports behave the same way
Hi Leon, thanks for this video! Super helpful! I have clients who use e-commerce, have you got a video/template on the best data to extract for them? Thank you!
Thanks! It depends on the wishes of my clients, but I usually add transactions and revenue to every table instead of goal conversions. And I make a seperate table with product performance. I don't know the names by heart but basically a table with products and the amount sold.
Thanks for the awesome tips, Leon! It really helps :D
But I wonder, do we need to manually save the data that we've exported?
I mean, currently, the Add-ons get data from UA in real time, but after July, the data in UA will disappear.
Do we have to download each Google Sheet one by one? Especially when we want to generate different date ranges.
Thanks! I appreciate your answer.
Although downloading the Google Sheet is perhaps a good idea as a backup. It is not strictly necessary for the import to work.
The addon won't do a realtime import or even daily import. We didn't set a scheduled run, so it imports your data only once. After that it won't override your data or anything like that.
This Matoma export all metric in Universal Analytics ?
Hi Leon, thanks for this helpful overview!
Is the Google Spreadsheet export a necessary step for storing UA data in Looker Studio, or will Looker Studio reports with UA source created now instead of Spreadsheets still be available after the UA shutdown?
Hey there! No if UA has stopped working, looker studio will not be able to retreive data from there after it is gone. You'll need to secure your data to a place that is future proof and linkable with Looker Studio to be able to use it there.
Dear Leon, is it possible to import your data to Matomo as you mentioned and then do an export from Matomo into CSV, Excel, whatever? I know that you can do those kinds of exports via GA but maybe Matomo's export is more advanced or this route may offer some other benefits?
I'm just getting started with using Matomo myself, so it's hard for me to answer the question. I believe you can do a trial, so perhaps you can just try it yourself?
Hey Leon! I'm running into Google Sheets cell limits when exporting longer periods for dimensions like Landing & Top Pages. I solved that by exporting the data in several batches. But... how do I combine those in Looker Studio? I've tried using a data blend, but that only gives me 1 of the date ranges. Any tips?
Hey Michiel 👊🏻 Blending in Looker Studio is not easy. I havent done what you're trying to do, but the coalesce() function has saved me a couple of times in similar situations. Here is a great video where I first found out about this function: th-cam.com/video/NwFjQky2Yz8/w-d-xo.html&ab_channel=TwoOctobers
@@LeonKorteweg COALESCE did the trick! Thanks!