Backup Universal Analytics: Three BEST ways to store your historical data

Подписаться 2 тыс.

Просмотров 4,7 тыс.

50% 1

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

Опубликовано:

4 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 23

@LeonKorteweg 5 месяцев назад

Looking for ways to grow your traffic? ►► Grab my FREE cheatsheet here at: leonkorteweg.com/cheatsheet

@aarthidevaprasad 17 дней назад

Hoi Leon, Heel erg bedankt!

@leonievanderscheer9423 5 месяцев назад

Handig Leon, ik kan dit goed gebruiken.

@LeonKorteweg 5 месяцев назад

Hey Leonie 😁 leuk om te horen!

@ryaldo35 Месяц назад

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!

@dieguzki Месяц назад

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!

@LeonKorteweg 17 дней назад

Thanks! And no, unfortunately not :(

@user-xt6is2jz5o Месяц назад

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?? 🤔

@stephshackel 3 месяца назад

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!

@LeonKorteweg 3 месяца назад

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.

@PhirawatJeerapiwat 14 дней назад

This Matoma export all metric in Universal Analytics ?

@RohanIn647 5 месяцев назад

Hi Leon, Thanks for the amazing video!! Does exporting Users, Bounce Rate from GA4 has the same issues as mentioned in the video

@LeonKorteweg 5 месяцев назад

Hey! Thanks for the comment 😎 yes, GA4 exports behave the same way

@alexjeremi4838 3 месяца назад

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.

@LeonKorteweg 2 месяца назад

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.

@jenniferbezkorov 4 месяца назад

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?

@LeonKorteweg 4 месяца назад

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.

@reimerk2415 29 дней назад

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?

@LeonKorteweg 17 дней назад

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?

@michieldoetjes 5 месяцев назад

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?

@LeonKorteweg 5 месяцев назад

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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-NwFjQky2Yz8.html&ab_channel=TwoOctobers

@michieldoetjes 5 месяцев назад

@@LeonKorteweg COALESCE did the trick! Thanks!