How to backup Universal Analytics: Exporting data from Google Analytics and moving to GA4
Вставка
- Опубліковано 3 чер 2024
- Want to export your Google Analytics data? Or backup your Universal Analytics reports? In this video, you will learn about the different ways you can export and backup your data from Google Analytics. And we will also answer the question - Can you import historical data into GA4? Okay, let's get started!
YOUR EXTRA RESOURCES:
○ Connect to BigQuery using Supermetrics (affiliate) - lovesdata.co/49hG6Q
○ Connect to BigQuery using Dataslayer (affiliate) - lovesdata.co/c25h6t
○ Getting started with GA4 - • Google Analytics 4 (GA...
○ GA4 Mini-Course (paid) - www.lovesdata.com/courses/goo...
○ GA4 Complete Course (paid) - www.lovesdata.com/courses/goo...
My email updates: www.lovesdata.com/email-newsl...
My courses: www.lovesdata.com/courses
My book: amzn.to/2FTQ8SX
SAY HELLO!
○ My blog - www.lovesdata.com/blog-welcome
○ Contact me - www.lovesdata.com/contact-us
TOOLS I USE AND RECOMMEND:
○ Email platform - lovesdata.co/zrLd7
○ Course platform - lovesdata.co/2Zzfq
○ Data connector - lovesdata.co/oOWkI
Subscribe for more videos: ua-cam.com/users/subscription_c...
Followed along and went perfectly for me. Clear, concise, and not too fast; great presentation. Many thanks for an exceptional video.
This was the best, easiest-to-follow, and most concise tutorial I've ever watched.
Great video ! People thinks that GA4 is an update of the Universal Analytics, but it's actually a full new way of measuring website performance.
Getting the chance to export relevant data to be used and compared in the future is fundamental. I assume 95% of business owners can do this with a spreadsheet, there are no reasons for most of them to use Big Query.
Nevertheless, the days of Google with turn of UA, a huge amount of people will be stressed. Thank you very much for this very well explained video!
Appreciate the non-fluff straightforward approach. Was a great review for me. Thank you!
Thanks for putting this together. I appreciate the detailed example with page views, but is there a more robust way to grab "all" data off go UA to archive? I am not exactly sure what data to grab, so I would prefer to grab whatever is there. Are there other standards reports to download or ways to grab all the data? Thanks again!
This was beyond helpful! Thank you so much!
Benjamin! You are always saving my day my good friend!
Thanks so much Benjamin! Explained so well 🙂
You made me love data! Awesome video!
Thank you so much for this video. It's the clearest and most helpful I've found, and I've been watching similar videos all day!
That’s great to hear. Thank you!
Amazing, exactly what I was looking for. I hope I can recreate this with my own data!
thank you for this wonderful explanation
Awesome tutorial! Quick question that I'm struggling with. Do you have to create new Google Sheet and run the GA Analytics extension report for each date range you pull? For example, I have a lot of data so I did the 1st example of Jan-June and then wanted to run it again for July-December. I was hoping to do all these in the same Google Sheet by just doing "Create New Report." When I do, it creates a new column in the Report Configuration for the 2nd date range. I thought I could delete the original column, then click Run Report (but now I get "Run Reports) and when it tries to run it gives me the following error "ScriptError: This action would increase the number of cells in the workbook above the limit of 10000000 cells." and doesn't update any of the data in a new tab?
Thank you dear friend. All the best to you !
Super video and nicely explained. Followed along and was able to get the desired reports.
That’s great to hear!
This was an awesome tutorial! Would you mind going into what's capable within Big Query once you export the UA data?
Thanks!
Good job. Very well presented
Great video! Looks like the Google Analytics Chrome Extension is no longer listed in the Web Store. Any alternatives?
Great video Benjamin! Super helpful. I have 1 question as the data I got is slightly different from GA universal. The sample % is 95%. Is this the reason I have a discrepancy with GA Universal? If so, how can we have 100% accuracy? Thank you so much!
I also had to change the Avg time on page metric aggregation from "sum" to "average". Worked for me YMMV
Fantastically helpful... thanks!
You're welcome!
Great video. Do you have one of thee tutorials for exporting Audience Data instead of Behaviour. Thanks
Hi Benjamin, thank you very much for this clear explanation. As my data is larger than 100k lines, I now have more than one Google sheet. You mentioned combining multiple sheets in Google Data Studio/Looker Studio is possible. Do you have a video that shows how this is done, please?
Great Info!! Thanks for this.
Could you please help me to understand this?
Let's assume I connected GA with Bigquery On the 1st of August 2022. Can we see data from August 2021 in GCP? Or can I export my last 3 years' data?
great video, now lets start backing up all my GAU
Thanks! Glad you found it helpful.
Hi Benjamin I followed the tutorial exactly but I have URLs that look like codes rather than page URLs. Benjamin, please can you advise - I am trying to get this done for the small charity I work for in the next month! Thanks so much - aside from this problem, thank you for sharing these easy to follow tutorials.
Hi thank you - how would you recommend saving Google Analytics Universal Data that span over 10 years? is it BigQuery, and if so - what connector is recommended for export?
Amazing video, is there any opportunity to import data from GA3 to GA4?
Hi, I am curious as to why you choose the Behavior Report in downloading the report instead of other Reports like the Acquisition>Source/Medium or the Channels?
Great video, thanks Benjamin! Quick question…I’m pulling pretty large data sets (5+ years by day) so we can preserve our historical data and I’m constantly running into sampling issues. Are there any tools that can pull the Google Analytics data without using sampled data?
Hi @aklein17, Hope you found a way to overcome the sampling issue. The data I got is slightly different from GA universal. The sample % is 95%. Is there anything we can do to have 100% accuracy without sampling?
This is awesome! Will try the Google Sheet option. I bet there are or will be some new services to save these analytics data that will disappear in 1 year? This doesn't look too difficult to do but I'm pretty sure 90% of the companies don't have time for this... BigQuery is the solution?
Love your video! I have a question though. Is there a way for data of any previous versions of GA (GA1-GA3) to be imported to GA4? Or backing up the data in Google Sheets is the only method we can currently consider?
Unfortunately, there is no way to import data from Universal Analytics into GA4. So backing up your data by exporting it (using any method you like) is the only option.
One way is to export and backup GA3 data, then stitch it together with GA4 data (either in BigQuery or Sheets) and then visualize that using Looker Studio
if I made an error, is it possible to edit the Google Sheets? say I wanted to add the secondary dimension "date", is it possible to edit the google sheets?
i found an issue with my outbound link click, when i click into it, then universal analytics tag open which i dont have in my GTM. i do have right now is GA4
@loves data I'm trying this now and when it comes to creating the add-on, I repeatedly get a "This app is blocked This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access." This used to work. Is there a work around or a replacement for it?
Hi Benjamin, I have a question, for example a client is using GA for 5 years. Can we import all these years of data? how about data retention setting which is usually 26 months (I know that it doesnt affect standard reports but when we import 5 years of data, would this be possible since data retention date is set as 26 months)
Hi Sinan, I have properties with data back to around 2007, so you should be fine. Data retention is for unaggregated and user identifiable data. The biggest issue you’ll face is sampling, so you may need to break your import into certain blocks of data ranges depending on the metrics and dimensions you are requesting.
You mentioned creating a future video on how to re-create Bounce Rate in Data Studio. If you have that video, can you link it?
Create a new field: SUM(Bounces) / SUM(Sessions)
Format as percentage
Looking to just get everything out, not a report by report method. I don't know what I'm going to need in the future and by what segments I want to filter by, etc. HELP! I'm really worried that I'm just going to lose all sorts of future insights just because I don't know every way to export the data to have that down the road.
Help! I'm getting a security warning when trying to install the Google Analytics Add On in Sheets. WHY is it blocking its own product, WHY? Any work around that you know of would be greatly appreciated :)
Nice video but I get an error when I try to install the add-on. It says: This app is blocked
This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access. Is this add-on still supported?
epic video!
Does anyone have the link for the Bounce Rate data export?
Hi Benjamin, I need assistance in exporting all my Google Ads data. I tried but only get the main Campaign data and not the detailed data in the data sheets.
this video is about Google Analytics (GA). The reason for the video is that GA will be discontinued in July. Google Ads aren't going anywhere.
Exporting to Google Sheet seems weird and would hit limits pretty soon. I would definitely recommend complete GA3 export to BigQuery (due to native connection with Google Data Studio) or other database.
Use the option that works for you 👍
So there's no direct way to export all the data from UA to GA4, right?
This is my question, why can't google just migrate the data for us automatically.
Can't install the Google Sheets add on because it's blocked by Google for trying to access personal info.
Any reason you export the Data to Google Sheets first and then into looker Studio and not just use the connector in Data/Looker Studi and build what you need there?
If you refresh the Looker Studio report after Universal Analytics has been shut down, you will likely end up with a blank report.
Hi Benjamin, I tried doing this and have a couple of questions...
1. Does it not work if you do not have perfectly 100,000 rows? (I have 69,000)
2. My page URL links are not showing as the right URL name and I'm seeing URL link names I have never seen before or really long ones. Could I have missed a step?
3. My pageviews don't seem to be correct or match with the universal analytics data when I followed all your steps to exporting everything in Google Sheets & Google Studio.
Any help/advice is greatly appreciated! Thank you.
Same, the reported urls and pageviews don't match what's in UA when I run the report thru the GA Google Sheets extension
I'm glad you said this - I followed the tutorial exactly but the same thing - i have URLs that look like codes rather than page URLs. Benjamin, please can you advise - I am trying to get this done for the small charity I work for in the next month! Thanks so much - aside from this problem, thank you for sharing these easy to follow tutorials.
I upgraded my UA property to GA4, however all history data is missing in the newly created GA4 property. Is there a way to export UA history data into GA4?
Unfortunately, no. Google’s upgrade process really just creates a GA4 property in parallel to your UA property. You’re starting from scratch. No historical data from UA is available in GA4.
@@LovesData That's absurdly thoughtless for their customers.
Is it possible to get all previous Universal Analytics data on GA4? If yes, please guide me through the process.
Hi Did you find the solution I was also looking out for the same
@@anirudhphani It is not possible to import UA data to GA4, the measurement is different, GA4 is a completely new system, not "compatible" with GA UA
@@TheAlliandris Thanks
@@TheAlliandris Is there a way to export data from GA4 into a similar structure as the Universal Analytics data in this demo to generate reports from both systems using data studio?
Does GA4 delete its content as well after a certain period of time? If so, how do we keep that information?
2 months by default but you can change the setting to 14 months. Either way retention isn't great and ideally you'll want to stream your data to BigQuery. for now it's still free to do so
Wouldn’t the Google Sheets Google Analytics add-on also cease to work when the UA API is discontinued?
In their announcement they stated “After this future date, you’ll no longer be able to see your Universal Analytics reports in the Analytics interface or access your Universal Analytics data via the API.”
Yes, that’s why you need to backup before 1 July 2023. And by importing data into Google Sheets it will continue to be available after that date.
The UI has changed and the export option is not available
❤
Glad you like it!
HI,
Bilal Here
This video was uploaded 1 year ago, so I thought Now we can import our UA data in GA4. Is this possible? if Yes then can you please let me know about it and guide me or give me your best suggestions.....
thank you
Unfortunately, there’s no option to import data from UA to GA4.
@@LovesData
then we can show the "import data" option in the admin section in GA4. Can you please let me know what is that and how can we use it?
@@user-nr4uz9xz1y it’s pretty much the same as the option in UA. Most commonly used for importing 3rd party ad costs and extending ecommerce reports. See support.google.com/analytics/answer/10071301
I followed this step by step but my average time on page isn't accurate. Anyone else has this problem?
Is the data sampled?
sorry for my delay. Is there a why I can show you? It's sampled. Even when I move it to show in time numerals it is way messed up. @@LovesData DId you ever make the video to add bounce rates?
Thanks for all the help
Thank you for the video. But this is not a Backup, it´s just a report backup. Not the data itself.
I agree, it would be great if there was a way to easily do a full backup.
They have since removed the ability to export data. Those buttons no longer appear.
That’s not good! I’ll check it out.
I've just checked, and I'm still seeing the export options in my Universal Analytics properties. Maybe try a different browser or disable your browser extensions to see if that helps?!?
Hi John, Make sure you are looking at UA date and not the GA4 under property and apps.
Google should automatically migrate this data from UA to GA4. I have years of data, this is riduculous.