- 4
- 2 435
James King
เข้าร่วมเมื่อ 19 ต.ค. 2023
Helping ecommerce retail brands make better decisions with their marketing data.
Export your historic Google Universal Analytics eCommerce Data in 5 minutes
Your historic Google Universal Analytics data is being deleted - here’s how to save it in 5 minutes.
This week, Google Analytics users received an email reminder of the the upcoming deletion of UA data.
🤔 What does this mean?
From July 1st, you will no longer be able to access your historic Universal Analytics website data, losing your chance to see multi-year trends in your brand data (eg seasonality, historic channel and campaign performance etc)
But there’s a very simple 5 minute solution that Google recommends, that I walk through in the video and below.
⭐️ Here are the steps to export a historic daily report into Google Sheets, going back as far back as you need:
1️⃣ Open a new Google Sheet with the account you use Google Analytics on.
2️⃣ Go to Extensions - Add-ons - Get Add-ons
3️⃣ Find and install the Google Analytics extension
4️⃣ Go back to Extensions - Google Analytics - Create new report
5️⃣ Name your report eg Brand Daily UA metrics & choose the account / view
6️⃣ Select Metrics: Sessions, New Users, Bounces, Session duration, Transactions, Revenue and Dimensions: Date
7️⃣ Change start date to when UA data was first collected, and remove row limit
8️⃣ Go back to Extensions - Google Analytics - Run report and it will populate into the sheet
Now you have the historic data saved to review later, and to eg import into Looker Studio to see a YoY view alongside your GA4 data.
🙋♂️ What if I have a few brand accounts I need to do this for?
Just copy and paste the report column, change the View ID which you can find in Admin - View Settings, and press run.
🙋♀️ What other metrics should I save?
Other useful reports would be to add channel groupings by date, campaign performance, countries and mobile / desktop split. Google Analytics has also released a template for many common reports so you simply need to change the view ID and date, and refresh. You can find their template here: support.google.com/analytics/answer/13851096?sjid=9403697970530957504-AP#howto
💡One tip: Don't export users, conversion rate, bounce rate, avg session duration as these don’t sum when aggregating over different time periods. Instead, calculate them in Google sheets or Looker Studio (eg Bounce rate = bounces / sessions)
🏃 Do it now before you forget - it won’t be there after July!
#googleanalytics hashtag#ga4 hashtag#ecommerce
This week, Google Analytics users received an email reminder of the the upcoming deletion of UA data.
🤔 What does this mean?
From July 1st, you will no longer be able to access your historic Universal Analytics website data, losing your chance to see multi-year trends in your brand data (eg seasonality, historic channel and campaign performance etc)
But there’s a very simple 5 minute solution that Google recommends, that I walk through in the video and below.
⭐️ Here are the steps to export a historic daily report into Google Sheets, going back as far back as you need:
1️⃣ Open a new Google Sheet with the account you use Google Analytics on.
2️⃣ Go to Extensions - Add-ons - Get Add-ons
3️⃣ Find and install the Google Analytics extension
4️⃣ Go back to Extensions - Google Analytics - Create new report
5️⃣ Name your report eg Brand Daily UA metrics & choose the account / view
6️⃣ Select Metrics: Sessions, New Users, Bounces, Session duration, Transactions, Revenue and Dimensions: Date
7️⃣ Change start date to when UA data was first collected, and remove row limit
8️⃣ Go back to Extensions - Google Analytics - Run report and it will populate into the sheet
Now you have the historic data saved to review later, and to eg import into Looker Studio to see a YoY view alongside your GA4 data.
🙋♂️ What if I have a few brand accounts I need to do this for?
Just copy and paste the report column, change the View ID which you can find in Admin - View Settings, and press run.
🙋♀️ What other metrics should I save?
Other useful reports would be to add channel groupings by date, campaign performance, countries and mobile / desktop split. Google Analytics has also released a template for many common reports so you simply need to change the view ID and date, and refresh. You can find their template here: support.google.com/analytics/answer/13851096?sjid=9403697970530957504-AP#howto
💡One tip: Don't export users, conversion rate, bounce rate, avg session duration as these don’t sum when aggregating over different time periods. Instead, calculate them in Google sheets or Looker Studio (eg Bounce rate = bounces / sessions)
🏃 Do it now before you forget - it won’t be there after July!
#googleanalytics hashtag#ga4 hashtag#ecommerce
มุมมอง: 2 229
วีดีโอ
Google Analytics 4: eCommerce Clarity in less than 60 Minutes
มุมมอง 314 หลายเดือนก่อน
Google Analytics 4: eCommerce Clarity in less than 60 Minutes
Google Analytics 4: How to use Explorations to uncover actionable eCommerce insights
มุมมอง 294 หลายเดือนก่อน
Google Analytics 4: How to use Explorations to uncover actionable eCommerce insights
Shopify & GA4: The ultimate setup for 2024 success
มุมมอง 1475 หลายเดือนก่อน
"Why is my Google Analytics revenue not lining up with Shopify?” “Why am I seeing so much ‘unassigned’ traffic in GA when reviewing Black Friday?” “Should I trust GA4, Shopify or another solution now to answer my ecommerce questions?” If this is you, you’re not alone - it’s been a challenging year to stay updated with all the marketing landscape changes, which is impacting our ability to make c...
Hi James, thanks for the video, looks super easy, but unfortunately its giving bad request error 400 , when i try to download it.
I have more than 5000 raws and I get feil when I choose more than 10000 raws. What can I do?
what does it mean when it shows a Sample percentage of 50.83% under Contains Sampled Data-Yes .Please help
Brilliant, thank you
Welcome!
Thank you so much! found you just in the nick of time as my "countdown to doom" clock approached ZERO!
Great - yes Google like to lay on the pressure don't they 😆
Very helpful video and resources. Well done!
No problem glad all sorted!
The Google Analytics add-on for Google Sheets doesn't work anymore. It has been deprecated by Google.
It still works for this situation in exporting Universal Analytics data. Just one more week!
How do I know that my reports are already in GA4?
You can't import UA data into GA4 unfortunately. This video shows you how to save historic Google Analytics data (pre-2023) down to google sheets so you can look back at it.
Using Google Sheets has limitation that only reports are exported. It means you need to know all reports you will need later. Seems like painful process. Is there free way to export all UA data at once and create reports on demand later?
Unfortunately not. There are a few paid solutions that can import everything into BigQuery and recreate in a GA style dashboard (eg www.databloo.com/universal-analytics-backup/). But it needs some justification on how much you'll need to access it in that depth in future.
How can i get my view ID?
When you choose the view in the add-on it will generate it for you. Otherwise, you can go to UA Admin > View Settings and you'll find it there.
I'm hosting a webinar on this topic on May 30th 2024. To join, please register at www.linkedin.com/events/ga4essentialsforecommerce7196808885930786817/
Hi, so this stores the data permanently in Google Sheets? It's not an api that draws the data in and then will not work after 1 July?
Correct Dylan - with this tool it exports the data directly into Google Sheets, and once that's done, you've got the data forever. The important thing is to make sure you do it before 1 July.
This is great - thanks!
Welcome, glad it was helpful!
Thank you! All saved :)
No worries!