{"id":859,"date":"2023-05-08T00:54:12","date_gmt":"2023-05-08T04:54:12","guid":{"rendered":"https:\/\/measurebit.com\/?page_id=859"},"modified":"2023-06-02T13:06:17","modified_gmt":"2023-06-02T17:06:17","slug":"export-ua-to-bigquery-1","status":"publish","type":"page","link":"https:\/\/measurebit.com\/lp\/export-ua-to-bigquery-1\/","title":{"rendered":"You\u2019re Trying to Navigate the Choppy Waters of GA4, Then You See This:"},"content":{"rendered":"<p><span><img decoding=\"async\" alt=\"\" data-id=\"904\" width=\"915\" data-init-width=\"1024\" height=\"535\" data-init-height=\"535\" title=\"GA4 Countdown\" loading=\"lazy\" src=\"https:\/\/measurebit.com\/wp-content\/uploads\/GA4-Countdown-1-1024x535.png\" data-width=\"915\" style=\"\"><\/span><\/p>\n<p dir=\"ltr\">It\u2019s Friday, 30th of June and, in 22 hours the \u2018Universal Analytics\u2019 lights will be dimmed. Sunset. Gone.&nbsp;<\/p>\n<p dir=\"ltr\">If it\u2019s your first time on this page, then you\u2019re in luck.<\/p>\n<ul>\n<li dir=\"ltr\">\n<p dir=\"ltr\">You\u2019ve probably seen the slack posts. You\u2019ve also seen the tweets:<\/p>\n<\/li>\n<\/ul>\n<p><span><img decoding=\"async\" alt=\"\" data-id=\"906\" width=\"861\" data-init-width=\"986\" height=\"360\" data-init-height=\"360\" title=\"fotor_2023-5-23_1_14_3\" loading=\"lazy\" src=\"https:\/\/measurebit.com\/wp-content\/uploads\/fotor_2023-5-23_1_14_3.png\" data-width=\"861\" style=\"\"><\/span><\/p>\n<ul>\n<li dir=\"ltr\">You\u2019ve also heard that one friend describe his bumpy ride\u2026\u201cSwitching to GA4 feels like trying to change the wheels on a bike while riding it downhill\u201d<\/li>\n<li dir=\"ltr\">But instead of feeling annoyed, instead of getting stuck, you\u2019re here looking for\u2026<\/li>\n<\/ul>\n<h2 dir=\"ltr\" style=\"text-align: center;\">The Simplest Way to SafeguardYour Valuable Universal Analytics (UA) Data<\/h2>\n<p dir=\"ltr\">Wynne Pirini here, and I suspect we have one thing in common:<\/p>\n<p>I despise having to go DIY Manual Mode and be <strong>stuck in a data export\/import\/cleanup loop<\/strong> \u2013 unless I have to.&nbsp;<span><img decoding=\"async\" alt=\"\" data-id=\"909\" width=\"874\" data-init-width=\"1024\" height=\"452\" data-init-height=\"452\" title=\"fotor_2023-5-23_10_52_17\" loading=\"lazy\" src=\"https:\/\/measurebit.com\/wp-content\/uploads\/fotor_2023-5-23_10_52_17-1024x452.png\" data-width=\"874\" style=\"\"><\/span><\/p>\n<ul>\n<li dir=\"ltr\">Scouring each analytics property&nbsp;<\/li>\n<li dir=\"ltr\">Flawlessly clicking through every report view and storing your data in Google Sheets or CSV.&nbsp;<\/li>\n<li dir=\"ltr\">Then, a few weeks later, when you need your data the most&#8230; It won&#8217;t load because there&#8217;s too much. Tools like Excel and Sheets hit a snag with high data volumes.&nbsp;<\/li>\n<\/ul>\n<p dir=\"ltr\">I can\u2019t imagine repeating this mind-numbing task and neither should you.&nbsp;<\/p>\n<p dir=\"ltr\"><strong><span style=\"background-color: rgb(255, 255, 0);\">That\u2019s why I prepared a simple Cheat Sheet for backing up your UA data.<\/span> <\/strong><\/p>\n<p dir=\"ltr\">No fluff. Just the essential steps to keep your past data at hand for:&nbsp;<\/p>\n<ul>\n<li dir=\"ltr\">Detailed analysis<\/li>\n<li dir=\"ltr\">Historical trend comparisons against GA4, or\u2026&nbsp;<\/li>\n<li dir=\"ltr\">To glean any performance insights that catch your eye<\/li>\n<\/ul>\n<h3 style=\"text-align: center;\">10-Steps to Get Your Data Out of Universal Analytics<\/h3>\n<ol>\n<li>Sign up for a <a href=\"https:\/\/cloud.google.com\/free\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\">Google Cloud (GCP) account<\/a> and receive $300 free credits<\/li>\n<li>Create a GCP project<\/li>\n<li>Attach a billing account to the GCP project<\/li>\n<li>Create a GCP service account for using with Airbyte<\/li>\n<li>Create a storage bucket in GCP for assisting in the data transfer process<\/li>\n<li>Enable BigQuery in GCP (it&#8217;s not enabled by default)<\/li>\n<li>Sign-up for a <a href=\"https:\/\/airbyte.com\/\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\">14-day trial of Airbyte<\/a> and receive 400 free credits (worth $1000), so you can test-drive Airbyte properly\u2026 and so you can transfer your Universal Analytics data!<\/li>\n<li>Add BigQuery as a destination in Airbyte. Alternatively, you can send your data to a number of other popular destinations including Snowflake, Redshift, Google Sheets, CSV file, S3 bucket, Firestore, MongoDB, MySQL, Postgres and more<\/li>\n<li>Choose Universal Analytics as a data source<\/li>\n<li>Connect the Universal Analytics source to the BigQuery destination and hit the &#8220;sync&#8221; button. Depending on the amount of data, it could take between a few minutes to a few hours.<\/li>\n<\/ol>\n<p>Hope you found this useful!<\/p>\n<p>If you need more guidance, I&#8217;ve put together a course with 12 straight-to-the-point video lessons, with not a single word wasted.<\/p>\n<p>Perfect for busy execs.<\/p>\n<p><span><a href=\"https:\/\/cart.measurebit.com\/ua2bq\/?utm_content=ebook-cover\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" alt=\"\" data-id=\"892\" width=\"368\" data-init-width=\"500\" height=\"707\" data-init-height=\"707\" title=\"From Universal Analytics to Data Warehouse-small\" loading=\"lazy\" src=\"https:\/\/measurebit.com\/wp-content\/uploads\/From-Universal-Analytics-to-Data-Warehouse-small.jpg\" data-width=\"368\" data-link-wrap=\"true\"><\/a><\/span><\/p>\n<h4>Course Description<\/h4>\n<p><strong>Modules &#8211;<\/strong> 12 brief video lessons<\/p>\n<p><strong>Duration-<\/strong> 29 minutes<\/p>\n<p><strong>Fee &#8211;<\/strong> $50<\/p>\n<p><strong>Note &#8211;<\/strong> If you need one of our data engineers to do the setup for you, we offer this service for a modest $300 fee, available as an upgrade when purchasing the course (click the button below).<\/p>\n<p><strong>P.S.<\/strong> I know, it\u2019s odd to be introducing myself in the \u2018p.s.\u2019 but here goes.<\/p>\n<p><span><img decoding=\"async\" alt=\"\" data-id=\"934\" width=\"300\" data-init-width=\"588\" height=\"340\" data-init-height=\"340\" title=\"Wynne-course-1\" loading=\"lazy\" src=\"https:\/\/measurebit.com\/wp-content\/uploads\/Wynne-course-1.png\" data-width=\"300\" style=\"\"><\/span><span><img decoding=\"async\" alt=\"\" data-id=\"935\" width=\"300\" data-init-width=\"300\" height=\"172\" data-init-height=\"172\" title=\"Wynne-course-2\" loading=\"lazy\" src=\"https:\/\/measurebit.com\/wp-content\/uploads\/Wynne-course-2-300x172.png\" data-width=\"300\"><\/span><span><img decoding=\"async\" alt=\"\" data-id=\"934\" width=\"300\" data-init-width=\"588\" height=\"340\" data-init-height=\"340\" title=\"Wynne-course-1\" loading=\"lazy\" src=\"https:\/\/measurebit.com\/wp-content\/uploads\/Wynne-course-1.png\" data-width=\"300\" style=\"\"><\/span><span><img decoding=\"async\" alt=\"\" data-id=\"935\" width=\"300\" data-init-width=\"300\" height=\"172\" data-init-height=\"172\" title=\"Wynne-course-2\" loading=\"lazy\" src=\"https:\/\/measurebit.com\/wp-content\/uploads\/Wynne-course-2-300x172.png\" data-width=\"300\"><\/span><\/p>\n<p>Hi, I\u2019m Wynne Pirini and the first thing you ought to know about me is this:&nbsp;<\/p>\n<p dir=\"ltr\">I\u2019m not a twitter celebrity.&nbsp;<\/p>\n<p dir=\"ltr\">Heck, I got zero time to play a guru on Youtube because, over the past 6 years I\u2019ve been that mad scientist behind the scenes (at Measurebit.com) helping brands and media buyers like Kelvin, Dorothy, John and countless others untangle one hairy problem\u2026 <strong>\u2026pressing the breaks on wasted ad spend <\/strong>instead of watching the machine (Google or Facebook or whatever) push more budget towards subpar campaigns.&nbsp;<\/p>\n<p dir=\"ltr\">How?&nbsp;<\/p>\n<p dir=\"ltr\"><strong>By ensuring only clean data gets fed back to performance marketing campaigns \u2013<\/strong> without the need to upgrade your tech skills, stitching together APIs, manipulating third-party tags or even getting a grip on Google Tag Manager\u2019s &nbsp;data layer for each project.&nbsp;<\/p>\n<p dir=\"ltr\">Putting a brand\u2019s tracking stack under the microscope (scrutinizing gaps with our \u2018deep dive audit\u2019) would normally cost $5,000, and we have to get on a 15-minute call to see if your project is a good fit.<\/p>\n<p dir=\"ltr\">Now, because we\u2019re ticking down to less than 40 days before Google pulls the plug on UA, I\u2019ve decided to release the next best thing at a steal of a price:<\/p>\n<p dir=\"ltr\" style=\"\"><a href=\"https:\/\/cart.measurebit.com\/ua2bq\/?utm_content=concept_a_ps_link\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\"><span style=\"text-decoration: underline;\">Get started with \u201cFrom Universal Analytics to Data Warehouse in Under 30-minutes\u201d for only <\/span><span style=\"text-decoration: underline line-through;\"><\/span><span style=\"text-decoration: underline;\">$50 (normally $99)<\/span><\/a><strong><span style=\"text-decoration: underline;\">&nbsp;<\/span><\/strong>&nbsp;&nbsp;<\/p>\n<p dir=\"ltr\">Once you see the step-by-step, \u2018watch over my shoulder\u2019 video lessons you will understand why media buyers and brands like Kelvin, Dorothy and John are getting a leg up against their competitors.<\/p>\n<p dir=\"ltr\">Without accurate tracking, It\u2019s impossible to tell which campaigns are crushing it or crashing.<\/p>\n<p dir=\"ltr\">Horror stories\u2026&nbsp;<\/p>\n<p dir=\"ltr\">\u2026brands trapped by broken dashboards in almost every account we audit at measurebit.com<\/p>\n<p dir=\"ltr\">Everything looks green. Another profitable day. Yet the moment they scale paid media, cashflow goes negative. The culprit?&nbsp;<\/p>\n<p dir=\"ltr\">\u201cPhantom conversion events\u201d that misleading platforms like (or Facebook or whatever) by showing a green flag event when in reality no sale came through. Detecting and fixing these is a tale for another post.<\/p>\n<p><span style=\"width: 100%;\"><img decoding=\"async\" alt=\"\" title=\"Kelvin Parker\" data-id=\"914\" src=\"https:\/\/measurebit.com\/wp-content\/uploads\/Kelvin-Parker.jpeg\" style=\"\" width=\"170\" height=\"200\" data-width=\"170\" data-init-width=\"200\" data-init-height=\"200\" loading=\"lazy\"><\/span><\/p>\n<h1 style=\"text-align: center;\"><span style=\"font-family: &quot;Playfair Display&quot;; font-weight: 400;\"><span><span style=\"color: rgb(68, 66, 68);\">Kelvin Parker<\/span><\/span><\/span><span style=\"font-family: &quot;Playfair Display&quot;; font-weight: 400;\"><span>Custom Triggered Persuasion<\/span><\/span><\/h1>\n<h1><span style=\"font-weight: 400; font-family: Palanquin;\"><span>\u201c<\/span><\/span><\/h1>\n<p>I\u2019m responsible for improving client results with CRO at every level of their funnel. So I need good RELIABLE data to do my job. ABSOLUTE JAW DROP response to what Wynne delivered. Like WOW! Sophisticated, yet elegant\u2026 even I can drive this thing.<\/p>\n<p><span style=\"width: 100%;\"><img decoding=\"async\" alt=\"\" title=\"Dorothy Illson\" data-id=\"915\" src=\"https:\/\/measurebit.com\/wp-content\/uploads\/Dorothy-Illson-300x300.jpeg\" style=\"\" width=\"149\" height=\"300\" data-width=\"149\" data-init-width=\"300\" data-init-height=\"300\" loading=\"lazy\"><\/span><\/p>\n<h1 style=\"text-align: center;\"><span style=\"font-family: &quot;Playfair Display&quot;; font-weight: 400;\"><span style=\"color: rgb(68, 66, 68);\"><em>Dorothy Illson&nbsp;<\/em><\/span><span><span style=\"color: rgb(180, 138, 128);\">&#8211;&nbsp;<\/span><\/span><\/span><span style=\"font-family: &quot;Playfair Display&quot;; font-weight: 400;\"><span><span style=\"color: rgb(180, 138, 128);\">Needle&#8217;s Eye Media<\/span><\/span><\/span><\/h1>\n<h1><span style=\"font-weight: 400; font-family: Palanquin;\"><span>\u201c<\/span><\/span><\/h1>\n<p style=\"text-align: center;\"><span style=\"font-family: Hind; font-weight: 400;\">Our ability to deliver results depends on having clean, reliable data. MeasureBit takes the delivery of elegant &amp; effective tracking solutions off of my plate, allowing us to focus on we do best \u2013 media buying. The work they do is worth its weight in gold for us and for our clients. To MeasureBit, thanks for knowing GTM like the back of your hands, so that I don\u2019t have to!&nbsp;<\/span><\/p>\n<h4 style=\"\">John Estabrook<\/h4>\n<p style=\"\">Local2Online<\/p>\n<p><a href=\"https:\/\/cart.measurebit.com\/ua2bq\/?utm_content=concept_a_ps_link_2\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\"><span>Get started with \u201cFrom Universal Analytics to Data Warehouse in Under 30-minutes\u201d for only&nbsp;<\/span><span><\/span><span>$50 (normally $99)<\/span><\/a><strong><span>&nbsp;<\/span><\/strong>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>It\u2019s Friday, 30th of June and, in 22 hours the \u2018Universal Analytics\u2019 lights will be dimmed. Sunset. Gone.&nbsp; If it\u2019s your first time on this page, then you\u2019re in luck. You\u2019ve probably seen the slack posts. You\u2019ve also seen the tweets: You\u2019ve also heard that one friend describe his bumpy ride\u2026\u201cSwitching to GA4 feels like [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":844,"parent":845,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/measurebit.com\/wp-json\/wp\/v2\/pages\/859"}],"collection":[{"href":"https:\/\/measurebit.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/measurebit.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/measurebit.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/measurebit.com\/wp-json\/wp\/v2\/comments?post=859"}],"version-history":[{"count":62,"href":"https:\/\/measurebit.com\/wp-json\/wp\/v2\/pages\/859\/revisions"}],"predecessor-version":[{"id":960,"href":"https:\/\/measurebit.com\/wp-json\/wp\/v2\/pages\/859\/revisions\/960"}],"up":[{"embeddable":true,"href":"https:\/\/measurebit.com\/wp-json\/wp\/v2\/pages\/845"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/measurebit.com\/wp-json\/wp\/v2\/media\/844"}],"wp:attachment":[{"href":"https:\/\/measurebit.com\/wp-json\/wp\/v2\/media?parent=859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}