{"id":8095,"date":"2021-05-18T10:53:01","date_gmt":"2021-05-18T10:53:01","guid":{"rendered":"https:\/\/xpon.ai\/?p=8095"},"modified":"2023-12-03T23:09:33","modified_gmt":"2023-12-03T23:09:33","slug":"the-modern-google-data-stack","status":"publish","type":"post","link":"https:\/\/xpon.ai\/au\/resources\/the-modern-google-data-stack\/","title":{"rendered":"The Modern Google Data Stack"},"content":{"rendered":"

For any business in the 21st century, having a reliable data ecosystem and infrastructure, preferably using the Google Data Stack, is critical for making correct business decisions.<\/p>\n

There is currently an industry shift of business moving from proprietary do-it-all-in-one tools to a data stack composed of modular components, with each component responsible for different steps in the data lifecycle.<\/p>\n

In this blog article, we explore what a typical data lifecycle looks like and what potential Google Data Stack products for smaller and medium-sized enterprises can look like, and how they interact with each other.<\/p>\n

The Google Data Lifecycle<\/strong><\/h4>\n

The Google data lifecycle consists 4 main steps:<\/p>\n

    \n
  1. Ingest<\/strong>: This step involves capturing raw data from a source such as web and app analytics.<\/li>\n
  2. Store<\/strong>: After the raw data has been pulled from a source, it typically needs to be stored in a location and format that is both durable and can be easily accessed.<\/li>\n
  3. Process<\/strong> and Analyse<\/strong>: In this step, transformations are done on the stored data to transform them into actionable insights which can then be effectively used by a business.<\/li>\n
  4. Explore<\/strong> and visualise<\/strong>: The final step is conducted in order to better understand the results of the processing and analysis we completed in the Process & Analyze step.<\/li>\n<\/ol>\n

    Advantages of the Google Cloud Platform<\/strong><\/h4>\n

    The advantage of Google Cloud Platform (GCP)<\/a> is that there is a massive number of tools that can be integrated with each other and custom-fit to a business\u2019s requirements.<\/p>\n

    The even better thing is that as the amount of data increases for a business, Google\u2019s data infrastructure can scale as needed. I mean just look at the number of different tools GCP offers for each step of the data lifecycle.<\/p>\n

    \"Graphic<\/p>\n

    The Google Data Stack Solution<\/strong><\/h4>\n

    For many smaller and medium-sized businesses starting out, building a complex infrastructure may not be the best solution.<\/p>\n

    For example, many businesses don\u2019t need their infrastructure to handle billions of hits, and something smaller scale is enough. While these businesses don\u2019t need a data behemoth built, data is still critical to making the correct business decisions.<\/p>\n

    Below we introduce a Google Data Stack infrastructure that can handle the data and business requirements for smaller and medium-sized enterprises that are at the start of their data journey, at a fraction of the cost of a full data stack.<\/p>\n

    Store<\/h4>\n

    While we can keep data in just Google Analytics, it is often a good idea to export Google Analytics data to a data warehouse where more complex analysis can be conducted on the data at a raw, hit-level instead of being aggregated by session-level. And why not just use a Google product to do this?<\/p>\n

    BigQuery is Google\u2019s cloud data warehouse product offering designed specifically for allowing users to run high-performance queries against large datasets using SQL.<\/p>\n

    While Google Analytics Export to BigQuery is only available to Google Analytics 360<\/a> clients, Analytics 4 offers free export to BigQuery with no billing charges. You just need to pay for storage and processing of queries if you exceed the free tier usage limits.<\/p>\n

    Therefore Internetrix recommends you get started with Google Analytics 4 today to take advantage of the built-in Export to BigQuery integration.<\/p>\n

    Process and Analyse<\/h4>\n

    A good thing about exporting our Google Analytics data to BigQuery, is that BigQuery itself can be used to transform the raw Google Analytics data to usable and actionable data, without having to add any other tool.<\/p>\n

    Explore and Visualise<\/h4>\n

    Once we have ingested, stored, and transformed our data, we are ready to create some powerful visualisations and insights. Google Looker Studio<\/a> is a great entry-level dashboarding solution and is both easy to use and free.<\/p>\n

    What\u2019s even better is that it seamlessly connects with a number of different data sources including Google Analytics, Google Analytics 360, Google Ads, BigQuery, and even spreadsheets that may contain data for your business.<\/p>\n

    Looking for more information? XPON is a dual-stack Google Marketing Platform and Google Cloud partner. Please get in touch with our team with any further questions.\u00a0<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

    For any business in the 21st century, having a reliable data ecosystem and infrastructure, preferably using the Google Data Stack, is critical for making correct business decisions. There is currently an industry shift of business moving from proprietary do-it-all-in-one tools to a data stack composed of modular components, with each component responsible for different steps […]<\/p>\n","protected":false},"author":12,"featured_media":4695,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_yoast_wpseo_focuskw":"Google Data Stack","_yoast_wpseo_title":"","_yoast_wpseo_metadesc":"For any business in the 21st century, having a reliable data ecosystem, preferably using the Google Data Stack, is critical.","_yoast_wpseo_meta-robots-noindex":"","_yoast_wpseo_meta-robots-nofollow":"","_yoast_wpseo_canonical":"","_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[389],"tags":[390],"class_list":["post-8095","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog-au","tag-cloud-technology-au"],"acf":[],"yoast_head":"\nThe Modern Google Data Stack | XPON Technologies | XPON Australia<\/title>\n<meta name=\"description\" content=\"For any business in the 21st century, having a reliable data ecosystem, preferably using the Google Data Stack, is critical. | XPON Australia\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/xpon.ai\/au\/wp-json\/wp\/v2\/posts\/8095\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Modern Google Data Stack | XPON Australia\" \/>\n<meta property=\"og:description\" content=\"For any business in the 21st century, having a reliable data ecosystem, preferably using the Google Data Stack, is critical. | XPON Australia\" \/>\n<meta property=\"og:url\" content=\"https:\/\/xpon.ai\/au\/resources\/the-modern-google-data-stack\/\" \/>\n<meta property=\"og:site_name\" content=\"XPON Technologies\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/xpongroup\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-18T10:53:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T23:09:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/xpon.ai\/wp-content\/uploads\/2023\/02\/datastack.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1845\" \/>\n\t<meta property=\"og:image:height\" content=\"1045\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"XPON Technologies Group\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@xpontech\" \/>\n<meta name=\"twitter:site\" content=\"@xpontech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"XPON Technologies Group\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/xpon.ai\/au\/resources\/the-modern-google-data-stack\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/xpon.ai\/au\/resources\/the-modern-google-data-stack\/\"},\"author\":{\"name\":\"XPON Technologies Group\",\"@id\":\"https:\/\/xpon.ai\/au\/#\/schema\/person\/aa8c496cc9248f72a86ab557e0bed6e1\"},\"headline\":\"The Modern Google Data Stack\",\"datePublished\":\"2021-05-18T10:53:01+00:00\",\"dateModified\":\"2023-12-03T23:09:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/xpon.ai\/au\/resources\/the-modern-google-data-stack\/\"},\"wordCount\":675,\"publisher\":{\"@id\":\"https:\/\/xpon.ai\/au\/#organization\"},\"keywords\":[\"Cloud Technology\"],\"articleSection\":[\"Blog\"],\"inLanguage\":\"en-AU\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/xpon.ai\/au\/resources\/the-modern-google-data-stack\/\",\"url\":\"https:\/\/xpon.ai\/au\/resources\/the-modern-google-data-stack\/\",\"name\":\"The Modern Google Data Stack | XPON Technologies\",\"isPartOf\":{\"@id\":\"https:\/\/xpon.ai\/au\/#website\"},\"datePublished\":\"2021-05-18T10:53:01+00:00\",\"dateModified\":\"2023-12-03T23:09:33+00:00\",\"description\":\"For any business in the 21st century, having a reliable data ecosystem, preferably using the Google Data Stack, is critical.\",\"breadcrumb\":{\"@id\":\"https:\/\/xpon.ai\/au\/resources\/the-modern-google-data-stack\/#breadcrumb\"},\"inLanguage\":\"en-AU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/xpon.ai\/au\/resources\/the-modern-google-data-stack\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/xpon.ai\/au\/resources\/the-modern-google-data-stack\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/xpon.ai\/au\/?page_id=2678\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Modern Google Data Stack\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/xpon.ai\/au\/#website\",\"url\":\"https:\/\/xpon.ai\/au\/\",\"name\":\"XPON Technologies\",\"description\":\"Technology & cloud solutions to modernise marketing operations\",\"publisher\":{\"@id\":\"https:\/\/xpon.ai\/au\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/xpon.ai\/au\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-AU\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/xpon.ai\/au\/#organization\",\"name\":\"XPON Technologies\",\"alternateName\":\"XPON\",\"url\":\"https:\/\/xpon.ai\/au\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\/\/xpon.ai\/au\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/xpon.ai\/wp-content\/uploads\/2026\/03\/XPON_logomark_RGB_medium.png\",\"contentUrl\":\"https:\/\/xpon.ai\/wp-content\/uploads\/2026\/03\/XPON_logomark_RGB_medium.png\",\"width\":212,\"height\":212,\"caption\":\"XPON Technologies\"},\"image\":{\"@id\":\"https:\/\/xpon.ai\/au\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/xpongroup\/\",\"https:\/\/twitter.com\/xpontech\",\"https:\/\/www.youtube.com\/@xpon\/videos\",\"https:\/\/au.linkedin.com\/company\/xpon-technologies\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/xpon.ai\/au\/#\/schema\/person\/aa8c496cc9248f72a86ab557e0bed6e1\",\"name\":\"XPON Technologies Group\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\/\/xpon.ai\/au\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/038bb62ee334e679305b3c014dd2e35151d0bb7f0c8350fe0f981035fdc10195?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/038bb62ee334e679305b3c014dd2e35151d0bb7f0c8350fe0f981035fdc10195?s=96&d=mm&r=g\",\"caption\":\"XPON Technologies Group\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"The Modern Google Data Stack | XPON Technologies | XPON Australia","description":"For any business in the 21st century, having a reliable data ecosystem, preferably using the Google Data Stack, is critical. | XPON Australia","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/xpon.ai\/au\/wp-json\/wp\/v2\/posts\/8095","og_locale":"en_US","og_type":"article","og_title":"The Modern Google Data Stack | XPON Australia","og_description":"For any business in the 21st century, having a reliable data ecosystem, preferably using the Google Data Stack, is critical. | XPON Australia","og_url":"https:\/\/xpon.ai\/au\/resources\/the-modern-google-data-stack\/","og_site_name":"XPON Technologies","article_publisher":"https:\/\/www.facebook.com\/xpongroup\/","article_published_time":"2021-05-18T10:53:01+00:00","article_modified_time":"2023-12-03T23:09:33+00:00","og_image":[{"width":1845,"height":1045,"url":"https:\/\/xpon.ai\/wp-content\/uploads\/2023\/02\/datastack.jpg","type":"image\/jpeg"}],"author":"XPON Technologies Group","twitter_card":"summary_large_image","twitter_creator":"@xpontech","twitter_site":"@xpontech","twitter_misc":{"Written by":"XPON Technologies Group","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/xpon.ai\/au\/resources\/the-modern-google-data-stack\/#article","isPartOf":{"@id":"https:\/\/xpon.ai\/au\/resources\/the-modern-google-data-stack\/"},"author":{"name":"XPON Technologies Group","@id":"https:\/\/xpon.ai\/au\/#\/schema\/person\/aa8c496cc9248f72a86ab557e0bed6e1"},"headline":"The Modern Google Data Stack","datePublished":"2021-05-18T10:53:01+00:00","dateModified":"2023-12-03T23:09:33+00:00","mainEntityOfPage":{"@id":"https:\/\/xpon.ai\/au\/resources\/the-modern-google-data-stack\/"},"wordCount":675,"publisher":{"@id":"https:\/\/xpon.ai\/au\/#organization"},"keywords":["Cloud Technology"],"articleSection":["Blog"],"inLanguage":"en-AU"},{"@type":"WebPage","@id":"https:\/\/xpon.ai\/au\/resources\/the-modern-google-data-stack\/","url":"https:\/\/xpon.ai\/au\/resources\/the-modern-google-data-stack\/","name":"The Modern Google Data Stack | XPON Technologies","isPartOf":{"@id":"https:\/\/xpon.ai\/au\/#website"},"datePublished":"2021-05-18T10:53:01+00:00","dateModified":"2023-12-03T23:09:33+00:00","description":"For any business in the 21st century, having a reliable data ecosystem, preferably using the Google Data Stack, is critical.","breadcrumb":{"@id":"https:\/\/xpon.ai\/au\/resources\/the-modern-google-data-stack\/#breadcrumb"},"inLanguage":"en-AU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/xpon.ai\/au\/resources\/the-modern-google-data-stack\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/xpon.ai\/au\/resources\/the-modern-google-data-stack\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/xpon.ai\/au\/?page_id=2678"},{"@type":"ListItem","position":2,"name":"The Modern Google Data Stack"}]},{"@type":"WebSite","@id":"https:\/\/xpon.ai\/au\/#website","url":"https:\/\/xpon.ai\/au\/","name":"XPON Technologies","description":"Technology & cloud solutions to modernise marketing operations","publisher":{"@id":"https:\/\/xpon.ai\/au\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/xpon.ai\/au\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-AU"},{"@type":"Organization","@id":"https:\/\/xpon.ai\/au\/#organization","name":"XPON Technologies","alternateName":"XPON","url":"https:\/\/xpon.ai\/au\/","logo":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/xpon.ai\/au\/#\/schema\/logo\/image\/","url":"https:\/\/xpon.ai\/wp-content\/uploads\/2026\/03\/XPON_logomark_RGB_medium.png","contentUrl":"https:\/\/xpon.ai\/wp-content\/uploads\/2026\/03\/XPON_logomark_RGB_medium.png","width":212,"height":212,"caption":"XPON Technologies"},"image":{"@id":"https:\/\/xpon.ai\/au\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/xpongroup\/","https:\/\/twitter.com\/xpontech","https:\/\/www.youtube.com\/@xpon\/videos","https:\/\/au.linkedin.com\/company\/xpon-technologies"]},{"@type":"Person","@id":"https:\/\/xpon.ai\/au\/#\/schema\/person\/aa8c496cc9248f72a86ab557e0bed6e1","name":"XPON Technologies Group","image":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/xpon.ai\/au\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/038bb62ee334e679305b3c014dd2e35151d0bb7f0c8350fe0f981035fdc10195?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/038bb62ee334e679305b3c014dd2e35151d0bb7f0c8350fe0f981035fdc10195?s=96&d=mm&r=g","caption":"XPON Technologies Group"}}]}},"_links":{"self":[{"href":"https:\/\/xpon.ai\/au\/wp-json\/wp\/v2\/posts\/8095","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xpon.ai\/au\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xpon.ai\/au\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xpon.ai\/au\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/xpon.ai\/au\/wp-json\/wp\/v2\/comments?post=8095"}],"version-history":[{"count":0,"href":"https:\/\/xpon.ai\/au\/wp-json\/wp\/v2\/posts\/8095\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xpon.ai\/au\/wp-json\/wp\/v2\/media\/4695"}],"wp:attachment":[{"href":"https:\/\/xpon.ai\/au\/wp-json\/wp\/v2\/media?parent=8095"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xpon.ai\/au\/wp-json\/wp\/v2\/categories?post=8095"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xpon.ai\/au\/wp-json\/wp\/v2\/tags?post=8095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}