Siavash Kanani (Ahmad)
Siavash Kanani (Ahmad)
  • 216
  • 1 146 203
How to Export and Backup Universal Analytics data into BigQuery and Google Sheets
All customers will lose access to the Universal Analytics interface and API starting on July 1, 2024.
There is no automatic migration of the historical data to Google Analytics 4, and there’s no "Download All" button either.
If you want to retain access to your historical data for any purpose: analysis, continuous reporting of KPIs, or to adhere to your org’s retention policy, you need to work for it: Find a way extract and store your data before it becomes inaccessible!
Join me and Ameet Wadhwani from Analytics Canvas in this free workshop and Q&A as we navigate the essential steps to backup UA data before the API and interface become inaccessible on July 1, 2024.
00:00 Introduction and Workshop Setup
01:43 Understanding the Urgency: Universal Analytics Shutdown
03:13 Interactive Q&A Session: Preparing for the Backup
08:31 Deep Dive into Backup Solutions and Options
29:30 Exploring Third-Party Backup Solutions
36:32 Introduction to OzCanvas: Enhancing Your Data Management
36:47 Preview and Features of OzCanvas
37:04 Interactive Q&A Session: Addressing User Queries
37:37 Deep Dive into Analogs Canvas: A Comprehensive Guide
39:00 Customizing Your Data Backup with Analogs Canvas
41:33 Understanding Data Housing and Export Options
48:51 Finalizing and Pricing Your Data Backup
53:38 Leveraging BigQuery for Data Storage and Analysis
53:43 Exclusive Offer and Closing Remarks
54:09 Interactive Q&A: Addressing Final Queries
📅 Workshop Highlights:
This workshop is free to attend.
While Ameet will demo the UA Backup solution from Analytics Canvas (siavak.co/ac20), other free and paid solutions and their pros and cons will be discussed as well to help you make a well informed decision.
The Final Countdown:
Understand the timeline until Universal Analytics shuts down and what it means for accessing your data.
Backup Solutions Explored:
Discover a range of options and tools from free and DIY options like Google’s offerings to the sophisticated paid services like the UA Backup Utility from Analytics Canvas, complete with a Looker Studio dashboard for your backed up data.
Expert Demonstration:
Special guest Ameet Wadhwani from Analytics Canvas will showcase how their UA Backup Utility can extract and store your historical data effectively and will answer your burning questions on the subject.
This workshop is tailored for marketers, analysts, or business owners who are reliant on retaining access to and leveraging their historical UA data.
🤔 I’m curious:
Do you think historical data from UA is worth saving?
Do you see any value in preserving past analytics in a post-UA world?
Want to become a Looker Studio expert? Join Looker Studio Masterclass:
lookerstud.io/masterclass
🔔 Subscribe and turn on notifications so you don't miss the future lessons!
มุมมอง: 2 081

วีดีโอ

Looker Studio Tip - Blending and Filtering Multiple Ad Accounts (Advanced)
มุมมอง 4.9K11 หลายเดือนก่อน
Reserve Your Live Seat in Looker Studio Masterclass 2024 Edition: lookerstud.io/masterclass 📩 lookerstudio.tips → Receive my weekly Looker Studio tips. 💬 lookerstudio.community → Get help with Looker Studio. 🔔 Subscribe and turn on notifications so you don't miss the future lessons!
Looker Studio Tip - The Curios Case of Google Search Console
มุมมอง 2Kปีที่แล้ว
Reserve Your Live Seat in Looker Studio Masterclass 2024 Edition: lookerstud.io/masterclass 📩 lookerstudio.tips → Receive my weekly Looker Studio tips. 💬 lookerstudio.community → Get help with Looker Studio. 🔔 Subscribe and turn on notifications so you don't miss the future lessons!
Looker Studio Tips: Time Series Intervals
มุมมอง 2.7Kปีที่แล้ว
Reserve Your Live Seat in Looker Studio Masterclass 2024 Edition: lookerstud.io/masterclass 📩 lookerstudio.tips → Receive my weekly Looker Studio tips. 💬 lookerstudio.community → Get help with Looker Studio. 🔔 Subscribe and turn on notifications so you don't miss the future lessons! 00:00 Introduction to Time Series Intervals in Looker Studio 00:27 Understanding Time Series Charts 01:00 Explori...
Looker Studio Tips: Bands & Vertical Reference Lines
มุมมอง 3.2Kปีที่แล้ว
Reserve Your Live Seat in Looker Studio Masterclass 2024 Edition: lookerstud.io/masterclass 📩 lookerstudio.tips → Receive my weekly Looker Studio tips. 💬 lookerstudio.community → Get help with Looker Studio. 🔔 Subscribe and turn on notifications so you don't miss the future videos! 00:00 Introduction to Bands and vertical Reference Lines in Looker Studio 00:27 Vertical Reference Lines 02:28 Ena...
17.15. Creating Scheduled Queries in BigQuery
มุมมอง 3.6Kปีที่แล้ว
Reserve Your Live Seat in Looker Studio Masterclass 2024 Edition: lookerstud.io/masterclass In this tutorial, I'll show you how to supercharge your Looker Studio reports with scheduled queries in BigQuery. We'll dive into setting up and configuring these queries to run at preset intervals, caching the results for faster access. By connecting Looker Studio to the scheduled query instead of a reg...
17.14. Creating Views in BigQuery
มุมมอง 4.5Kปีที่แล้ว
Reserve Your Live Seat in Looker Studio Masterclass 2024 Edition: lookerstud.io/masterclass In this tutorial, I'll walk you through the process of creating views in BigQuery and demonstrate how to use them in Looker Studio. We'll explore the differences between views and tables, learn why views provide live data while tables offer faster performance, and discuss some strategies for balancing th...
17.13. Saving Queries in BigQuery and Connecting to Looker Studio
มุมมอง 2.3Kปีที่แล้ว
Reserve Your Live Seat in Looker Studio Masterclass 2024 Edition: lookerstud.io/masterclass In this advanced tutorial, I'll show you how to save query results in BigQuery and connect them to Looker Studio for powerful visualizations. We'll explore different methods for saving query results, create a new table in BigQuery, and connect Looker Studio to our data source. I'll also explain the benef...
17.12. Calculating Keyword Ranking in BigQuery SQL
มุมมอง 728ปีที่แล้ว
Reserve Your Live Seat in Looker Studio Masterclass 2024 Edition: lookerstud.io/masterclass In this tutorial, I'm going to teach you how to calculate the value each keyword brings to your website per thousand impressions using BigQuery SQL in Looker Studio. You'll learn how to create a calculation, sort your results by value, and save your query for future analysis. *Looker Studio Masterclass C...
17.11. Calculating Percent Share of Total in BigQuery SQL
มุมมอง 1.6Kปีที่แล้ว
Reserve Your Live Seat in Looker Studio Masterclass 2024 Edition: lookerstud.io/masterclass In this tutorial, I'll guide you through the process of calculating the percent share of total using BigQuery SQL. We'll explore a scenario where multiple queries send traffic to a single landing page and figure out how to calculate the share of each keyword. I'll show you how to add new columns for summ...
17.10. SQL Left Join in BigQuery
มุมมอง 1.3Kปีที่แล้ว
Reserve Your Live Seat in Looker Studio Masterclass 2024 Edition: lookerstud.io/masterclass In this tutorial, I'll walk you through the process of joining Google Search Console and Google Analytics data in BigQuery using SQL. We'll create clean versions of both tables using common table expressions and then join them based on their landing pages. Along the way, we'll troubleshoot a few unexpect...
17.9. Data Modeling in BigQuery
มุมมอง 3.7Kปีที่แล้ว
Reserve Your Live Seat in Looker Studio Masterclass 2024 Edition: lookerstud.io/masterclass In this tutorial, I'll guide you through the process of data modeling in BigQuery using Google Search Console and Google Analytics data. We'll clean up and standardize our datasets to prepare them for joining. By the end, you'll have a solid understanding of how to merge your data sources and analyze the...
17.8. Writing SQL Queries in BigQuery
มุมมอง 1.4Kปีที่แล้ว
Reserve Your Live Seat in Looker Studio Masterclass 2024 Edition: lookerstud.io/masterclass In this tutorial, I'll walk you through the process of writing SQL in BigQuery and demonstrate the key differences between native and external tables when working with Looker Studio. I will show you how to use the split tab view to efficiently write queries side by side and explain why native tables offe...
17.7. External Tables in BigQuery
มุมมอง 2.3Kปีที่แล้ว
Reserve Your Live Seat in Looker Studio Masterclass 2024 Edition: lookerstud.io/masterclass In this tutorial, I'll guide you through the process of connecting a Google Sheet to BigQuery as an external table. We'll explore how to create the table, define the source and destination, and correctly set up headers. I'll also demonstrate how to delete and recreate tables if needed. You'll learn the k...
17.6. Table Schema in BigQuery
มุมมอง 3.7Kปีที่แล้ว
Reserve Your Live Seat in Looker Studio Masterclass 2024 Edition: lookerstud.io/masterclass In this tutorial, I'll walk you through the ins and outs of table schemas in BigQuery and Looker Studio. You'll learn what a schema is, how to define it when importing data, and how to verify your table schema using the Schema, Details, and Preview tabs. By the end of this lesson, you'll be well-equipped...
17.5. Brining a Google Sheet into BigQuery
มุมมอง 1.5Kปีที่แล้ว
17.5. Brining a Google Sheet into BigQuery
17.4. SQL Workspace in BigQuery
มุมมอง 1.2Kปีที่แล้ว
17.4. SQL Workspace in BigQuery
17.3. Getting Data Into BigQuery
มุมมอง 1.1Kปีที่แล้ว
17.3. Getting Data Into BigQuery
17.2. Planning the BigQuery Data Pipeline for Looker Studio
มุมมอง 1.3Kปีที่แล้ว
17.2. Planning the BigQuery Data Pipeline for Looker Studio
17.1. BigQuery LIVE Hands-on Workshop
มุมมอง 2.1Kปีที่แล้ว
17.1. BigQuery LIVE Hands-on Workshop
16.18. Discussion: BigQuery and BigQuery ML Use Cases
มุมมอง 1Kปีที่แล้ว
16.18. Discussion: BigQuery and BigQuery ML Use Cases
16.17. Location Exploration Case Study with BigQuery and Looker Studio
มุมมอง 1Kปีที่แล้ว
16.17. Location Exploration Case Study with BigQuery and Looker Studio
16.16. BigQuery and Looker Studio Case Study: Store Inventory Capacity Outlook
มุมมอง 1.2Kปีที่แล้ว
16.16. BigQuery and Looker Studio Case Study: Store Inventory Capacity Outlook
16.15. RFM Segmentation with BigQuery ML & Looker Studio
มุมมอง 2.1Kปีที่แล้ว
16.15. RFM Segmentation with BigQuery ML & Looker Studio
16.14. BigQuery & Looker Studio Case Study: Labor Performance
มุมมอง 1.5Kปีที่แล้ว
16.14. BigQuery & Looker Studio Case Study: Labor Performance
16.13. BigQuery & Looker Studio Case Study: Affiliate Performance Dashboard
มุมมอง 1.7Kปีที่แล้ว
16.13. BigQuery & Looker Studio Case Study: Affiliate Performance Dashboard
16.12. Connecting Looker Studio to BigQuery
มุมมอง 2.1Kปีที่แล้ว
16.12. Connecting Looker Studio to BigQuery
16.11. Working with Data in BigQuery with SQL - Looker Studio Masterclass - Full Advanced Course
มุมมอง 1.8Kปีที่แล้ว
16.11. Working with Data in BigQuery with SQL - Looker Studio Masterclass - Full Advanced Course
16.10. Importing Marketing Data into BigQuery - Looker Studio Masterclass - Advanced Course
มุมมอง 1.6Kปีที่แล้ว
16.10. Importing Marketing Data into BigQuery - Looker Studio Masterclass - Advanced Course
16.9. Importing Google Analytics Data to BigQuery - Looker Studio Masterclass - Advanced Course
มุมมอง 2.1Kปีที่แล้ว
16.9. Importing Google Analytics Data to BigQuery - Looker Studio Masterclass - Advanced Course

ความคิดเห็น

  • @johnbridges6731
    @johnbridges6731 16 ชั่วโมงที่ผ่านมา

    Not sure if you're still monitorting this but what if I wanted to show Users per state side bar chart but also include YoY comparison next to each Dimension?

  • @samniengpollong7841
    @samniengpollong7841 3 วันที่ผ่านมา

    I'm happy to find this solution... Thank you so much🙏🏼🙏🏼

  • @lhodeniz
    @lhodeniz 4 วันที่ผ่านมา

    got it after watching 2-3 times hehehe

  • @lhodeniz
    @lhodeniz 4 วันที่ผ่านมา

    12:48 not clear what's happening here

  • @deltatee9050
    @deltatee9050 4 วันที่ผ่านมา

    That was really good debugging. Helped me understand the tool under the hood

  • @DakshaTelang
    @DakshaTelang 9 วันที่ผ่านมา

    This was extremely helpful. Thank you!

    • @siavashkanani
      @siavashkanani 6 วันที่ผ่านมา

      Glad it was helpful!

  • @serhiikovchenko1595
    @serhiikovchenko1595 12 วันที่ผ่านมา

    Man, you saved me

  • @lhodeniz
    @lhodeniz 12 วันที่ผ่านมา

    Thanks. so confusing in adding the filter control for the end table.

    • @siavashkanani
      @siavashkanani 6 วันที่ผ่านมา

      Yes, it’s a bit tricky!

  • @chaim6768
    @chaim6768 14 วันที่ผ่านมา

    How can I make a reusable data source embedded?

    • @siavashkanani
      @siavashkanani 6 วันที่ผ่านมา

      It’s not possible unfortunately.

  • @lhodeniz
    @lhodeniz 14 วันที่ผ่านมา

    مرسی احمد جان!

  • @lhodeniz
    @lhodeniz 14 วันที่ผ่านมา

    so great! I appreciate your work! Thank you for these tutorial videos.

    • @siavashkanani
      @siavashkanani 6 วันที่ผ่านมา

      You're very welcome!

  • @lhodeniz
    @lhodeniz 15 วันที่ผ่านมา

    2:04 amazing!

  • @lhodeniz
    @lhodeniz 15 วันที่ผ่านมา

    nice works from Siavash. Thank you

  • @chaim6768
    @chaim6768 20 วันที่ผ่านมา

    @siavashkanani What to do about null in the grand total row of a table when using blended data?

  • @kerochi
    @kerochi 23 วันที่ผ่านมา

    This is probably the best explanation I’ve seen ❤

    • @siavashkanani
      @siavashkanani 6 วันที่ผ่านมา

      I’m glad you found it helpful!

  • @MUHAMMADAFIFRIDHUANBINZAILANSH
    @MUHAMMADAFIFRIDHUANBINZAILANSH 23 วันที่ผ่านมา

    good so interesting mf

    • @siavashkanani
      @siavashkanani 6 วันที่ผ่านมา

      Glad you think so!

  • @tupelogoods
    @tupelogoods 26 วันที่ผ่านมา

    When I try to create a new Date Field it does not give me the option to create one with DATE. It is greyed out / disabled. It only allows TEXT, GEO, OR URL. How do I fix?

    • @siavashkanani
      @siavashkanani 6 วันที่ผ่านมา

      When you save the formula and it returns a date, it will become available.

  • @voiceinside
    @voiceinside 26 วันที่ผ่านมา

    This course is incredible. Thanks for posting.

  • @mustafayuksel8811
    @mustafayuksel8811 28 วันที่ผ่านมา

    you are the man, thx for saving me

    • @siavashkanani
      @siavashkanani 6 วันที่ผ่านมา

      Glad it helped!

  • @sebastianpiema9773
    @sebastianpiema9773 หลายเดือนก่อน

    Why is not possible to have date range comparison in a bar chart?

    • @siavashkanani
      @siavashkanani 6 วันที่ผ่านมา

      It can be done with blended data, until Google makes it possible

  • @anajmeddin3639
    @anajmeddin3639 หลายเดือนก่อน

    is it possible to filter the blended table, and exclude null values?

    • @siavashkanani
      @siavashkanani 6 วันที่ผ่านมา

      Yes, should be possible

  • @anajmeddin3639
    @anajmeddin3639 หลายเดือนก่อน

    very useful. thanks

    • @siavashkanani
      @siavashkanani 6 วันที่ผ่านมา

      Glad it was helpful!

  • @vascovasconcelos1783
    @vascovasconcelos1783 หลายเดือนก่อน

    Thank you, this was outstanding, would never get there. I usually am able to blend them but I never used to add filters because of this

    • @siavashkanani
      @siavashkanani 6 วันที่ผ่านมา

      Glad I could help!

  • @RahulKadge-en4ik
    @RahulKadge-en4ik หลายเดือนก่อน

    Hi Sir, Is it possible for you to create videos with backend of Google ads or SA360. It will be very helpful. Learnt a lot form your videos

  • @alvaroalvesdesousa7477
    @alvaroalvesdesousa7477 หลายเดือนก่อน

    Excellent. Thank you so much!

    • @siavashkanani
      @siavashkanani 6 วันที่ผ่านมา

      You're very welcome!

  • @GiorgosEvripidou-q7y
    @GiorgosEvripidou-q7y หลายเดือนก่อน

    so we connect all the dv1 together , all the dv0 together right ?

  • @XavierWallach
    @XavierWallach หลายเดือนก่อน

    Any chance you could share the link to the usage report template here? 🙂

  • @RahulSingh1-j9g
    @RahulSingh1-j9g หลายเดือนก่อน

    I want to know how to calculate the Yesterday Spend in Looker Studio. Can anyone help?

  • @AkshitGothwal-u6d
    @AkshitGothwal-u6d หลายเดือนก่อน

    How can you create an extract where you can import aggregated values as calculation, not extracted numbers. Example- I have some ratio values which are calculated as = sum(col A) / sum(col B). Such are extracted as final numbers not aggregated calculations.

    • @siavashkanani
      @siavashkanani 6 วันที่ผ่านมา

      Extract always extracts numbers, not formulas. You can extract A and B and write the formula afterwards

  • @manggnorora
    @manggnorora หลายเดือนก่อน

    At last, I finished the playlist today! It was an awesome playlist super helpful! Thank you!

    • @siavashkanani
      @siavashkanani 6 วันที่ผ่านมา

      Congrats! 🎉 Glad it was helpful!

  • @renenieuwmans
    @renenieuwmans หลายเดือนก่อน

    Am I right that this does not work with week numbers?

  • @Sankofa906
    @Sankofa906 หลายเดือนก่อน

    without the google sheet he's using how would I calculate COG ?

  • @WaqasAhmad-fg8yq
    @WaqasAhmad-fg8yq หลายเดือนก่อน

    2 Years in the industry & in 10 mins you changed my whole design method, WOW

  • @stephenbugden1270
    @stephenbugden1270 หลายเดือนก่อน

    Hello Siavash, Is it possible to embed the same report on multiple websites and somehow allow each instance to indicate which Google Analytics account to use? It's just that I'm planning to provide the same analytics summary on multiple websites and would prefer not to have to update them all when I make changes. Hope that makes sense. Wasn't sure where to put this question but thought parameters might be needed in the iFrame.

  • @lakhdariamine6794
    @lakhdariamine6794 หลายเดือนก่อน

    Hello is it possible to automate this by terraform ?

  • @mohammadmirzaei6638
    @mohammadmirzaei6638 หลายเดือนก่อน

    Hello, I have a date series chart, in which when the dimension is in Date data type it shows the metric for every date correctly, but when i change the dimension data type to Date Month it only shows the numbers for 3 months and returns metric's value as 0 for other months. I want to aggregate the data in the chart monthly and it doesn't work. Can anyone help please?

  • @ver1ssim0
    @ver1ssim0 หลายเดือนก่อน

    great tip

  • @LosAngeles0594
    @LosAngeles0594 หลายเดือนก่อน

    Thank you so much!!!!

  • @juaorpo
    @juaorpo หลายเดือนก่อน

    This is great info, thanks. However I am find trouble as my report uses 2 blended data sources (as I need to filter by email). 1. If both fields in the 2 blends are named the same, will the filter act over both blends. I am having trouble with this actually. Are blends considered the same "origin" 2. How can we create bridge fields in blends, I dont´see the option as in your video. I can add fields within the charts or in the blend screen but none of this show me the field ID. Any ideas? It is great your video anyway, hoping I can use it with blended data.

  • @CesarGarcíaÁlvarez-x5z
    @CesarGarcíaÁlvarez-x5z 2 หลายเดือนก่อน

    Could we see the structure of the table along with some 5 rows as an example to see how it is structured? I would like to know where this data is taken from?

  • @siwabuk
    @siwabuk 2 หลายเดือนก่อน

    Is there any chance we can show the current filter / control selection on the dashbord please ?

  • @anabarbosa9360
    @anabarbosa9360 2 หลายเดือนก่อน

    Didn't work for me!!

  • @ZakirNotes
    @ZakirNotes 2 หลายเดือนก่อน

    Very helpful love you boss

  • @spryte4371
    @spryte4371 2 หลายเดือนก่อน

    this genuinely just changed my life holy shit i love u thank you for your teachings

    • @siavashkanani
      @siavashkanani 6 วันที่ผ่านมา

      Glad it helped!

  • @DanielDavidTan
    @DanielDavidTan 2 หลายเดือนก่อน

    Can't I embed a hyperlink inside an image? I keep trying hyperlink(url, image url) won't work

    • @DanielDavidTan
      @DanielDavidTan 2 หลายเดือนก่อน

      update: I tried nesting image function in hyperlink hyperlink(url,image(image url)) still wont show. the formula isn't being flagged as I write it but it won't display anything.

  • @damithkodithuwakku2018
    @damithkodithuwakku2018 2 หลายเดือนก่อน

    Grt

  • @KarimMasarweh
    @KarimMasarweh 2 หลายเดือนก่อน

    So I understand there is no way to make the filters apply only in "one direction" of the hierarchy. Is that right?

  • @Elishea36
    @Elishea36 2 หลายเดือนก่อน

    Hello! This is not 100% related, but I want to filter out 3 dates from a chart in Looker. Is this possible? Thanks for your awesome videos :)

  • @jessicas4640
    @jessicas4640 2 หลายเดือนก่อน

    Hi I have a question about the data extract connector. Is there a limit to how much data can be pulled in? I'm running into a failure error when adding 10-15 dimensions and trying to have a 12 month date range.

    • @siavashkanani
      @siavashkanani 2 หลายเดือนก่อน

      The limit is 100MB of data, but 10 to 15 is a LOT of dimensions. Think about it that with adding each new dimension, you're multiplying (breaking down) each rows of data by the number of values in that dimension.

    • @jessicas4640
      @jessicas4640 2 หลายเดือนก่อน

      @@siavashkanani Thanks for the info! Is over 10 dimensions in a report even using the direct GA source too much? I've been experiencing quota /service errors suddenly on reports that were previously functioning fine.

  • @FranckPARIENTIfranck
    @FranckPARIENTIfranck 2 หลายเดือนก่อน

    Hi, thanks for your videos. On looker studio how to combine several data source from different google ads accounts for get one columns with the data of the URLs of the all the google ads accounts ? If possible use source of Google ads and not google sheet Regards

    • @siavashkanani
      @siavashkanani 2 หลายเดือนก่อน

      With data blending you can merge up to five Ad accounts.

    • @FranckPARIENTIfranck
      @FranckPARIENTIfranck 2 หลายเดือนก่อน

      @@siavashkanani thanks for get one columns with the data of the URLs of 5 google ads accounts ?