How to backup Universal Analytics: Exporting data from Google Analytics and moving to GA4

Рет қаралды 53,965

Күн бұрын

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: kzfaq.info_c...

Пікірлер: 98

@bemisroachreed4108 Жыл бұрын

Followed along and went perfectly for me. Clear, concise, and not too fast; great presentation. Many thanks for an exceptional video.

@nufrankz 9 сағат бұрын

Thanks! Finally the last option that it worked for me. After trying lots of Python scripts, 15 minutes before the shutdown :( gracias desde Chile!

@nicholesmith8818 Жыл бұрын

This was the best, easiest-to-follow, and most concise tutorial I've ever watched.

@julienvzh Жыл бұрын

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!

@MichaelCox-jh1qr 7 ай бұрын

Appreciate the non-fluff straightforward approach. Was a great review for me. Thank you!

@studiooriley Жыл бұрын

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!

@LovesData Жыл бұрын

That’s great to hear. Thank you!

@LtownBrisbaneGirl Жыл бұрын

Thanks so much Benjamin! Explained so well 🙂

@papertowelsholder9110 Жыл бұрын

Benjamin! You are always saving my day my good friend!

@ashajames7431 4 ай бұрын

This was beyond helpful! Thank you so much!

@sintijakucic1998 Жыл бұрын

You made me love data! Awesome video!

@KirkVartan Жыл бұрын

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!

@jailbreakit2 4 ай бұрын

Amazing, exactly what I was looking for. I hope I can recreate this with my own data!

@roopchd11 Жыл бұрын

Super video and nicely explained. Followed along and was able to get the desired reports.

@LovesData Жыл бұрын

That’s great to hear!

@michellemartini-brown9279 26 күн бұрын

Oh my gosh. I feel so smart now. Thank you so much for this.

@abhi739 2 жыл бұрын

thank you for this wonderful explanation

@bemisroachreed4108 Жыл бұрын

I also had to change the Avg time on page metric aggregation from "sum" to "average". Worked for me YMMV

@yoannregis5342 Жыл бұрын

Thank you dear friend. All the best to you !

@GermanRodriguezqndq Жыл бұрын

great video, now lets start backing up all my GAU

@LovesData Жыл бұрын

Thanks! Glad you found it helpful.

@sofiaashford353 Жыл бұрын

This was an awesome tutorial! Would you mind going into what's capable within Big Query once you export the UA data? Thanks!

@IgniteWebDesign Жыл бұрын

Fantastically helpful... thanks!

@LovesData Жыл бұрын

You're welcome!

@AaronDwyer 4 ай бұрын

Good job. Very well presented

@hajaramarroy2373 Жыл бұрын

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!

@stuartreedsadventures 2 жыл бұрын

Great video. Do you have one of thee tutorials for exporting Audience Data instead of Behaviour. Thanks

@bobbywebster1527 2 жыл бұрын

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?

@JoHailey 10 ай бұрын

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?

@webenso 11 ай бұрын

Great video! Looks like the Google Analytics Chrome Extension is no longer listed in the Web Store. Any alternatives?

@loudevine7264 Жыл бұрын

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.

@aklein17 Жыл бұрын

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?

@hajaramarroy2373 Жыл бұрын

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?

@prakashchandrakumar2383 Жыл бұрын

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?

@arifurrahman2477 Жыл бұрын

Amazing video, is there any opportunity to import data from GA3 to GA4?

@michaelamar441 2 жыл бұрын

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?

@mosheyuval350 3 ай бұрын

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?

@MyJointPainorgau 13 күн бұрын

This is brilliant - is there a way to check and download a report for 'downloaded resources' from universal?

@kevindominicfeliciano9754 2 жыл бұрын

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?

@LovesData 2 жыл бұрын

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.

@gracevonn 9 ай бұрын

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

@matejnedorolik2548 Ай бұрын

epic video!

@cloggednose323 4 ай бұрын

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?

@hafisismail2688 2 жыл бұрын

So there's no direct way to export all the data from UA to GA4, right?

@michaeldross6621 8 ай бұрын

This is my question, why can't google just migrate the data for us automatically.

@tomasdavid1643 2 жыл бұрын

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.

@LovesData 2 жыл бұрын

Use the option that works for you 👍

@sinanagacik4589 2 жыл бұрын

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)

@LovesData 2 жыл бұрын

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.

@BestandTops Жыл бұрын

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

@villagepropertiessunriver Жыл бұрын

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?

@gracevonn 9 ай бұрын

Create a new field: SUM(Bounces) / SUM(Sessions) Format as percentage

@upyourseogame Жыл бұрын

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.

@cloggednose323 4 ай бұрын

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?

@user-qc4ng7po8c 8 ай бұрын

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

@nickymiller5086 8 ай бұрын

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 :)

@kaefa0139 8 ай бұрын

Can't install the Google Sheets add on because it's blocked by Google for trying to access personal info.

@LIFEHACKER-kc3bo 4 күн бұрын

What about adding multiple Spreadsheets to one report?

@ArturPakosch 2 ай бұрын

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?

@LovesData 2 ай бұрын

If you refresh the Looker Studio report after Universal Analytics has been shut down, you will likely end up with a blank report.

@matthewfrederick8720 2 жыл бұрын

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.”

@LovesData 2 жыл бұрын

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.

@amelianolte Жыл бұрын

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.

@lollots82 Жыл бұрын

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.

@bekordigital 10 ай бұрын

Does anyone have the link for the Bounce Rate data export?

@user-bd7th7zd1e 5 ай бұрын

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?

@kimberlylopez351 2 жыл бұрын

Does GA4 delete its content as well after a certain period of time? If so, how do we keep that information?

@lollots82 Жыл бұрын

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

@dump2839 Жыл бұрын

Is it possible to get all previous Universal Analytics data on GA4? If yes, please guide me through the process.

@anirudhphani Жыл бұрын

Hi Did you find the solution I was also looking out for the same

@TheAlliandris Жыл бұрын

@@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

@anirudhphani Жыл бұрын

@@TheAlliandris Thanks

@sca276 Жыл бұрын

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

@wonderingDoT 2 жыл бұрын

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.

@genevabrock7026 2 жыл бұрын

Same, the reported urls and pageviews don't match what's in UA when I run the report thru the GA Google Sheets extension

@loudevine7264 Жыл бұрын

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.

@anirudhphani Жыл бұрын

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?

@LovesData Жыл бұрын

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.

@michaeldross6621 8 ай бұрын

@@LovesData That's absurdly thoughtless for their customers.

@sangitarathod8663 10 күн бұрын

In video, its not mentioned how to move exported data to GA4. Can you please explain?

@LovesData 10 күн бұрын

Unfortunately, Google haven't provided this as an option. So you can't.

@ronaldobarreirinhas4770 2 жыл бұрын

❤

@LovesData 2 жыл бұрын

Glad you like it!

@utkarshrajput5871 5 ай бұрын

The UI has changed and the export option is not available

@user-nr4uz9xz1y Жыл бұрын

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

@LovesData Жыл бұрын

Unfortunately, there’s no option to import data from UA to GA4.

@user-nr4uz9xz1y Жыл бұрын

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

@LovesData Жыл бұрын

@@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

@bekordigital 10 ай бұрын

I followed this step by step but my average time on page isn't accurate. Anyone else has this problem?

@LovesData 10 ай бұрын

Is the data sampled?

@bekordigital 8 ай бұрын

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

@Leonardo-jv1ls Жыл бұрын

Thank you for the video. But this is not a Backup, it´s just a report backup. Not the data itself.

@LovesData Жыл бұрын

I agree, it would be great if there was a way to easily do a full backup.

@johnhsmckay Жыл бұрын

They have since removed the ability to export data. Those buttons no longer appear.

@LovesData Жыл бұрын

That’s not good! I’ll check it out.

@LovesData Жыл бұрын

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

@fmega2098 6 ай бұрын

Hi John, Make sure you are looking at UA date and not the GA4 under property and apps.