{"id":51798,"date":"2023-06-21T04:58:48","date_gmt":"2023-06-21T02:58:48","guid":{"rendered":"https:\/\/www.makingscience.com\/?p=51798"},"modified":"2023-06-21T04:58:48","modified_gmt":"2023-06-21T02:58:48","slug":"keep-your-google-universal-analytics-history-using-bigquery","status":"publish","type":"post","link":"https:\/\/www.makingscience.com\/us\/blog\/keep-your-google-universal-analytics-history-using-bigquery\/","title":{"rendered":"Keep Your Google Universal Analytics History Using BigQuery"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">GA4 is now the present of Analytics, emphasizing full implementation. But,<\/span> <b>what about the Universal Analytics work and data?<\/b> <span style=\"font-weight: 400;\">Both Google and we<\/span> <b>ensure you won&#8217;t lose your Universal Analytics historical data.<\/b><\/p>\n<p><span style=\"font-weight: 400;\">UA will sunset in July 2023, but Google allows data export till year-end. Also, the sunset for Universal Analytics 360 accounts is postponed to July 2024.<\/span><\/p>\n<h3><b>How to handle Universal Analytics data?<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">360 Users should<\/span>\u00a0<b>act promptly despite the extended sunset.<\/b> <span style=\"font-weight: 400;\">We at Making Science offer a solution to export and enhance data processing via <\/span><b>BigQuery, <\/b><span style=\"font-weight: 400;\">a pivotal tool in GA4. Linking both will elevate your digital asset data processing. This is applicable only for Universal Analytics 360 accounts.<\/span><\/p>\n<h3><b>What if I don&#8217;t have a 360 account? Can I still recover my Universal Analytics data?<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Non-360 account holders,<\/span> <b>there are solutions for accounts without BigQuery access.<\/b><span style=\"font-weight: 400;\"> At Making Science, we can assist with data export even without a Cloud account, as per these Google Support articles:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"color: #eb1073;\"><a style=\"color: #eb1073;\" href=\"https:\/\/support.google.com\/analytics\/answer\/1038573\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">Export and Share Reports<\/span><\/a><\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"color: #eb1073;\"><a style=\"color: #eb1073;\" href=\"https:\/\/developers.google.com\/analytics\/devguides\/reporting\/core\/v4?hl=es\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">Use Google Analytics Reporting API to Export Data<\/span><\/a><\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">For the 360 users, here&#8217;s our solution; BigQuery export.<\/span><\/p>\n<h3><b>Requirements for Data Export to BigQuery?<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Start by <\/span><b>creating a Cloud account<\/b><span style=\"font-weight: 400;\">, if you don&#8217;t have one. Don&#8217;t worry, <\/span><b>we can set it up for you.<\/b> <span style=\"font-weight: 400;\">To simplify the process, <\/span><b>we&#8217;ll handle all the necessary configuration on both platforms.<\/b> <span style=\"font-weight: 400;\">Be aware, in <\/span><b>BigQuery certain permissions and configurations need to be in place <\/b><span style=\"font-weight: 400;\">for Universal Analytics to send data to Cloud. This includes specific export settings. <\/span><b>Rest assured, we manage all.<\/b><br \/>\n<span style=\"font-weight: 400;\">This solution stands out as it <\/span><b>extracts all historical data<\/b><span style=\"font-weight: 400;\"> automatically, unlike other manual solutions. With BigQuery, you don&#8217;t need to select data or reports to export, as <\/span><b>all your Universal Analytics history will be stored in the cloud.<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Note, BigQuery charges for storage, but <\/span><b>these costs are manageable<\/b><span style=\"font-weight: 400;\">, given the significance of preserving Universal Analytics data.<\/span><\/p>\n<h3><b>How can I view my Universal Analytics data?<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">BigQuery&#8217;s role in digital analysis is growing, hence <\/span><b>Google now connects BigQuery with GA4 for free and 360 accounts.<\/b> <span style=\"font-weight: 400;\">This means <\/span><b>BigQuery unifies Universal Analytics history with GA4 data, displayed in a Looker Studio dashboard.<\/b> Check <a href=\"https:\/\/www.makingscience.com\/blog\/why-looker-studio-charts-data-not-loading-how-to-fix\/\">this<\/a> article <span style=\"color: #eb1073;\"><span style=\"font-weight: 400;\">for linking GA4 with BigQuery to generate Looker Studio reports, conserving quota.<\/span><\/span><\/p>\n<h3><b>Benefits of BigQuery Export?<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Let&#8217;s delve deeper into BigQuery export benefits:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><b>Preserve historical data:<\/b> Linking BigQuery with UA ensures all historical data remains intact.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><b>Data unification:<\/b> BigQuery&#8217;s GA4 connection allows combining historical and new GA4 data for improved comparison and comprehensive reports.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><b>Automated process:<\/b> Data export is fully automated, eliminating manual exports or other forms of automation.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><b>Enhanced data processing and visualization:<\/b> With BigQuery and Looker Studio, data processing and visualization surpass UA capabilities.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">At Making Science, we provide guidance and solutions for any challenges. Our proposed solution for the Universal Analytics sunset is BigQuery data export, which helps maintain, process, and visualize your data. <\/span><span style=\"font-weight: 400;\">Don&#8217;t hesitate to <\/span><span style=\"color: #eb1073;\"><a style=\"color: #eb1073;\" href=\"https:\/\/www.makingscience.es\/contacto\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">contact us<\/span><\/a><\/span><span style=\"font-weight: 400;\"> for assistance with this or any other issue. We&#8217;re here to help! <\/span><br \/>\nRemember, <b>prepare for the sunset\u2014don&#8217;t get caught unready!<\/b><\/p>\n","protected":false},"excerpt":{"rendered":"<p>GA4 is now the present of Analytics, emphasizing full implementation. But, what about the Universal Analytics work and data? Both Google and we ensure you won&#8217;t lose your Universal Analytics historical data. UA will sunset in July 2023, but Google allows data export till year-end. Also, the sunset for Universal Analytics 360 accounts is postponed [&hellip;]<\/p>\n","protected":false},"author":23,"featured_media":47815,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[200,550],"tags":[552,354,541,672,641],"class_list":["post-51798","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data","category-marketing-analytics","tag-bigquery-2","tag-ga4-2","tag-gmp","tag-google-marketing-platform-3","tag-universal-analytics-2"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.makingscience.com\/us\/wp-json\/wp\/v2\/posts\/51798","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.makingscience.com\/us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.makingscience.com\/us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.makingscience.com\/us\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/www.makingscience.com\/us\/wp-json\/wp\/v2\/comments?post=51798"}],"version-history":[{"count":0,"href":"https:\/\/www.makingscience.com\/us\/wp-json\/wp\/v2\/posts\/51798\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.makingscience.com\/us\/wp-json\/wp\/v2\/media\/47815"}],"wp:attachment":[{"href":"https:\/\/www.makingscience.com\/us\/wp-json\/wp\/v2\/media?parent=51798"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.makingscience.com\/us\/wp-json\/wp\/v2\/categories?post=51798"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.makingscience.com\/us\/wp-json\/wp\/v2\/tags?post=51798"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}