Context

The Google Merchandise Store sells Google branded merchandise. The data is typical of what you would see for an ecommerce website.

Content

The sample dataset contains Google Analytics 360 data from the Google Merchandise Store, a real ecommerce store. The Google Merchandise Store sells Google branded merchandise. The data is typical of what you would see for an ecommerce website. It includes the following kinds of information:

Traffic source data: information about where website visitors originate. This includes data about organic traffic, paid search traffic, display traffic, etc. Content data: information about the behavior of users on the site. This includes the URLs of pages that visitors look at, how they interact with content, etc. Transactional data: information about the transactions that occur on the Google Merchandise Store website.

Fork this kernel to get started.

Acknowledgements

Data from: https://bigquery.cloud.google.com/table/bigquery-public-data:google_analytics_sample.ga_sessions_20170801

Banner Photo by Edho Pratama from Unsplash.

Inspiration

What is the total number of transactions generated per device browser in July 2017?

The real bounce rate is defined as the percentage of visits with a single pageview. What was the real bounce rate per traffic source?

What was the average number of product pageviews for users who made a purchase in July 2017?

What was the average number of product pageviews for users who did not make a purchase in July 2017?

What was the average total transactions per user that made a purchase in July 2017?

What is the average amount of money spent per session in July 2017?

What is the sequence of pages viewed?

Introduction

Google Workspace Statistics: Google Workspace, which was previously denoted as G Suite, is an all-inclusive collection of cloud-based productivity and teamwork applications that are developed by Google. The application contains Gmail, Google Drive, Docs, Sheets, Slides, Meet, and other applications that can help an individual or the organization improve productivity levels and facilitate communication. Cloud access, seamless collaboration, and tight security make Google Workspace suitable for businesses and teams.

This increases productivity easily and supports broad types and complexities of technologies with highly advanced security in addition to seamless integration with other applications to provide enhanced flexibility and efficiency. Google Workspace has transformed into one of the top platforms in today's digital space of collaboration, introducing billions of users to the world in 2024. This article will highlight the important Google Workplace statistics.

Introduction

Google Drive Statistics: Google Drive, which was launched by Google in 2012, currently serves as the biggest pillar of cloud storage and collaboration. It has enabled users to access and keep files on a single platform that is made portable and synchronised across devices. By the end of 2024, its adoption rates will reflect users' inclination toward the integral roles it has assumed in their personal and professional lives.

The article discusses the Google Drive statistics, including user engagement and market presence, along with data security and performance in terms of finances.

Google Gemini Statistics: In 2023, Google unveiled the most powerful AI model to date. Google Gemini is the world’s most advanced AI leaving the ChatGPT 4 behind in the line. Google has 3 different sizes of models, superior to each, and can perform tasks accordingly. According to Google Gemini Statistics, these can understand and solve complex problems related to absolutely anything. Google even said, they will develop AI in such as way that it will let you know how helpful AI is in our daily routine. Well, we hope our next generation won’t be fully dependent on such technologies, otherwise, we will lose all of our natural talent! Editor’s Choice Google Gemini can follow natural and engaging conversations. According to Google Gemini Statistics, Gemini Ultra has a 90.0% score on the MMLU benchmark for testing the knowledge of and problem-solving on subjects including history, physics, math, law, ethics, history, and medicine. If you ask Gemini what to do with your raw material, it can provide you with ideas in the form of text or images according to the given input. Gemini has outperformed ChatGPT -4 tests in the majority of the cases. According to the report this LLM is said to be unique because it can process multiple types of data at the same time along with video, images, computer code, and text. Google is considering its development as The Gemini Era, showing the importance of our AI is significant in improving our daily lives. Google Gemini can talk like a real person Gemini Ultra is the largest model and can solve extremely complex problems. Gemini models are trained on multilingual and multimodal datasets. Gemini’s Ultra performance on the MMMU benchmark has also outperformed the GPT-4V in the following results Art and Design (74.2), Business (62.7), Health and Medicine (71.3), Humanities and Social Science (78.3), and Technology and Engineering (53.00).

As of June 2024, global Google searches for the word "ChatGPT" increased again after a slight decline by the end of 2024. Interest in the chatbot, developed by the U.S.-based OpenAI and launched in November 2022, started rising in the week ending December 3, 2022. Recently, growing demand for information on ChatGPT made the keyword hit a peak of 100 index points during the week ending on June 2, 2024. ChatGPT, which stands for Chat Generative Pre-trained Transformer, is a chatbot and AI-powered auto-generative text system able to give human-sounding replies and reproduce human-like interactions when prompted.

Introduction

Google Classroom Statistics: Google Classroom is a free blended learning platform developed by Google to streamline the process of creating, distributing, and grading assignments. Since its launch in 2014, it has become a widely adopted tool in educational institutions worldwide. By the first half of 2024, Google Classroom had approximately 10 million daily active users on Android. This growth is attributed to its integration with Chromebooks and its role in facilitating remote learning during the COVID-19 pandemic.

In the United States, the platform is prevalent in K–12 schools, with an estimated 60,000 schools utilizing it as of 2022. Globally, Google Classroom is used in over 230 countries and territories, supporting millions of teachers and students in managing coursework and communication. The article explores market share, customers, and major developments concerning Google Classroom statistics in the year 2024.

Introduction

Google Analytics Statistics: Google Analytics is one of the most popular tools to monitor your website’s performance, as it gathers data regarding customer behaviour, engagement, and preferences. They are segmented into two different versions: Google Analytics 4 (GA4) and Google Analytics 360 (GA360). Google Analytics was developed by Google and was released on November 14, 2005.

This article includes several detailed analyses from different insights, including overall market analysis, user bases, visitors' interaction with a website, such as page views, session duration, traffic sources, and conversion rates.

This dataset provides the Austin Google Analytic. Google Analytics is a freemium web analytics service offered by Google that tracks and reports website traffic.

Introduction

Google Chrome Statistics: According to the web-tracking firm Stat Counter, Chrome is the world’s number one internet browser. Between the period of July and August 2023, Chrome was used by almost 63.6% of the internet population all over the globe. Chrome is mainly famous in South America, where it has an internet browser share of almost 78.9% of the market.

In North American and European countries, the share of Google Chrome is low compared to 53.1% and 58.6%, respectively. Google Chrome was launched in 2008, but it became the most popular web browser across the world in 2012. In this article, we will shed more light on Google Chrome statistics.

The dataset provides 12 months (August 2016 to August 2017) of obfuscated Google Analytics 360 data from the Google Merchandise Store , a real ecommerce store that sells Google-branded merchandise, in BigQuery. It’s a great way analyze business data and learn the benefits of using BigQuery to analyze Analytics 360 data Learn more about the data The data includes The data is typical of what an ecommerce website would see and includes the following information:Traffic source data: information about where website visitors originate, including data about organic traffic, paid search traffic, and display trafficContent data: information about the behavior of users on the site, such as URLs of pages that visitors look at, how they interact with content, etc. Transactional data: information about the transactions on the Google Merchandise Store website.Limitations: All users have view access to the dataset. This means you can query the dataset and generate reports but you cannot complete administrative tasks. Data for some fields is obfuscated such as fullVisitorId, or removed such as clientId, adWordsClickInfo and geoNetwork. “Not available in demo dataset” will be returned for STRING values and “null” will be returned for INTEGER values when querying the fields containing no data.This public dataset is hosted in Google BigQuery and is included in BigQuery's 1TB/mo of free tier processing. This means that each user receives 1TB of free BigQuery processing every month, which can be used to run queries on this public dataset. Watch this short video to learn how to get started quickly using BigQuery to access public datasets. What is BigQuery

In 2024, "Google" was the most popular search query on Google. "You" ranked second, scoring an index value of 79 points. "YouTube" ranked third with an index value of 76 points relative to the top query, while "Facebook" ranked fifth, with an index value of 62.

As of March 2025, Google represented 79.1 percent of the global online search engine market on desktop devices. Despite being much ahead of its competitors, this represents the lowest share ever recorded by the search engine in these devices for over two decades. Meanwhile, its long-time competitor Bing accounted for 12.21 percent, as tools like Yahoo and Yandex held shares of over 2.9 percent each. Google and the global search market Ever since the introduction of Google Search in 1997, the company has dominated the search engine market, while the shares of all other tools has been rather lopsided. The majority of Google revenues are generated through advertising. Its parent corporation, Alphabet, was one of the biggest internet companies worldwide as of 2024, with a market capitalization of 2.02 trillion U.S. dollars. The company has also expanded its services to mail, productivity tools, enterprise products, mobile devices, and other ventures. As a result, Google earned one of the highest tech company revenues in 2024 with roughly 348.16 billion U.S. dollars. Search engine usage in different countries Google is the most frequently used search engine worldwide. But in some countries, its alternatives are leading or competing with it to some extent. As of the last quarter of 2023, more than 63 percent of internet users in Russia used Yandex, whereas Google users represented little over 33 percent. Meanwhile, Baidu was the most used search engine in China, despite a strong decrease in the percentage of internet users in the country accessing it. In other countries, like Japan and Mexico, people tend to use Yahoo along with Google. By the end of 2024, nearly half of the respondents in Japan said that they had used Yahoo in the past four weeks. In the same year, over 21 percent of users in Mexico said they used Yahoo.

The number of total desktop and mobile visits to Google.pl fluctuated over the observed period of time. Reaching over *** million reach in March 2024.

Introduction

Google Fit Statistics: Google Fit, since its launch in 2014, formed the major platform of fitness and health for Google, enabling users to track several health metrics and pool data from several fitness apps and devices. In its continued evolution were added unique features like Heart Points, developed under the auspices of WHO and AHA, aimed at inducing physical activity.

Changes of much significance are due in 2024, marking a change in Google's very own approach to health data-keeping. In this article, we will enclose the Google Fit statistics.

Introduction

Google Chrome Statistics: Google Chrome has established itself as the leading web browser globally, reflecting its widespread adoption across various platforms. As of February 2025, Chrome holds approximately 66% of the global market share across all devices, surpassing competitors such as Safari, Edge, and Firefox. This dominance translates to an estimated 3.45 billion internet users utilizing Chrome as their primary web browser in 2025, marking an increase from 3.06 billion users in 2020.

The browser's popularity is further highlighted by its extensive library of extensions, with nearly 137,345 available in the Chrome Web Store, enhancing user experience through additional functionalities. Chrome's integration with Google's suite of services and its cross-platform compatibility have contributed significantly to its widespread adoption. However, this dominance has attracted regulatory scrutiny; in November 2024, the U.S. Department of Justice proposed that Google divest its Chrome browser to address concerns over its search monopoly, estimating Chrome's valuation at approximately USD 20 billion.

These developments underscore Chrome's influential position in the web browser market and its impact on global internet usage patterns.

Introduction

Google Revenue Statistics: Google is usually the first name people think of when talking about the internet or technology. Since the digital age began, it has been the top search engine for both mobile and desktop users around the world. Google controls about 92% of the global search engine market.

However, Google is much more than just a search engine. The tech company also works in online advertising, hardware, software, and cloud computing, all contributing to its annual earnings of billions of dollars. Now, let's look at some of the latest Google Revenue Statistics.

Author: Víctor Yeste. Universitat Politècnica de Valencia.The object of this study is the design of a cybermetric methodology whose objectives are to measure the success of the content published in online media and the possible prediction of the selected success variables.In this case, due to the need to integrate data from two separate areas, such as web publishing and the analysis of their shares and related topics on Twitter, has opted for programming as you access both the Google Analytics v4 reporting API and Twitter Standard API, always respecting the limits of these.The website analyzed is hellofriki.com. It is an online media whose primary intention is to solve the need for information on some topics that provide daily a vast number of news in the form of news, as well as the possibility of analysis, reports, interviews, and many other information formats. All these contents are under the scope of the sections of cinema, series, video games, literature, and comics.This dataset has contributed to the elaboration of the PhD Thesis:Yeste Moreno, VM. (2021). Diseño de una metodología cibermétrica de cálculo del éxito para la optimización de contenidos web [Tesis doctoral]. Universitat Politècnica de València. https://doi.org/10.4995/Thesis/10251/176009Data have been obtained from each last-minute news article published online according to the indicators described in the doctoral thesis. All related data are stored in a database, divided into the following tables:tesis_followers: User ID list of media account followers.tesis_hometimeline: data from tweets posted by the media account sharing breaking news from the web.status_id: Tweet IDcreated_at: date of publicationtext: content of the tweetpath: URL extracted after processing the shortened URL in textpost_shared: Article ID in WordPress that is being sharedretweet_count: number of retweetsfavorite_count: number of favoritestesis_hometimeline_other: data from tweets posted by the media account that do not share breaking news from the web. Other typologies, automatic Facebook shares, custom tweets without link to an article, etc. With the same fields as tesis_hometimeline.tesis_posts: data of articles published by the web and processed for some analysis.stats_id: Analysis IDpost_id: Article ID in WordPresspost_date: article publication date in WordPresspost_title: title of the articlepath: URL of the article in the middle webtags: Tags ID or WordPress tags related to the articleuniquepageviews: unique page viewsentrancerate: input ratioavgtimeonpage: average visit timeexitrate: output ratiopageviewspersession: page views per sessionadsense_adunitsviewed: number of ads viewed by usersadsense_viewableimpressionpercent: ad display ratioadsense_ctr: ad click ratioadsense_ecpm: estimated ad revenue per 1000 page viewstesis_stats: data from a particular analysis, performed at each published breaking news item. Fields with statistical values can be computed from the data in the other tables, but total and average calculations are saved for faster and easier further processing.id: ID of the analysisphase: phase of the thesis in which analysis has been carried out (right now all are 1)time: "0" if at the time of publication, "1" if 14 days laterstart_date: date and time of measurement on the day of publicationend_date: date and time when the measurement is made 14 days latermain_post_id: ID of the published article to be analysedmain_post_theme: Main section of the published article to analyzesuperheroes_theme: "1" if about superheroes, "0" if nottrailer_theme: "1" if trailer, "0" if notname: empty field, possibility to add a custom name manuallynotes: empty field, possibility to add personalized notes manually, as if some tag has been removed manually for being considered too generic, despite the fact that the editor put itnum_articles: number of articles analysednum_articles_with_traffic: number of articles analysed with traffic (which will be taken into account for traffic analysis)num_articles_with_tw_data: number of articles with data from when they were shared on the media’s Twitter accountnum_terms: number of terms analyzeduniquepageviews_total: total page viewsuniquepageviews_mean: average page viewsentrancerate_mean: average input ratioavgtimeonpage_mean: average duration of visitsexitrate_mean: average output ratiopageviewspersession_mean: average page views per sessiontotal: total of ads viewedadsense_adunitsviewed_mean: average of ads viewedadsense_viewableimpressionpercent_mean: average ad display ratioadsense_ctr_mean: average ad click ratioadsense_ecpm_mean: estimated ad revenue per 1000 page viewsTotal: total incomeretweet_count_mean: average incomefavorite_count_total: total of favoritesfavorite_count_mean: average of favoritesterms_ini_num_tweets: total tweets on the terms on the day of publicationterms_ini_retweet_count_total: total retweets on the terms on the day of publicationterms_ini_retweet_count_mean: average retweets on the terms on the day of publicationterms_ini_favorite_count_total: total of favorites on the terms on the day of publicationterms_ini_favorite_count_mean: average of favorites on the terms on the day of publicationterms_ini_followers_talking_rate: ratio of followers of the media Twitter account who have recently published a tweet talking about the terms on the day of publicationterms_ini_user_num_followers_mean: average followers of users who have spoken of the terms on the day of publicationterms_ini_user_num_tweets_mean: average number of tweets published by users who spoke about the terms on the day of publicationterms_ini_user_age_mean: average age in days of users who have spoken of the terms on the day of publicationterms_ini_ur_inclusion_rate: URL inclusion ratio of tweets talking about terms on the day of publicationterms_end_num_tweets: total tweets on terms 14 days after publicationterms_ini_retweet_count_total: total retweets on terms 14 days after publicationterms_ini_retweet_count_mean: average retweets on terms 14 days after publicationterms_ini_favorite_count_total: total bookmarks on terms 14 days after publicationterms_ini_favorite_count_mean: average of favorites on terms 14 days after publicationterms_ini_followers_talking_rate: ratio of media Twitter account followers who have recently posted a tweet talking about the terms 14 days after publicationterms_ini_user_num_followers_mean: average followers of users who have spoken of the terms 14 days after publicationterms_ini_user_num_tweets_mean: average number of tweets published by users who have spoken about the terms 14 days after publicationterms_ini_user_age_mean: the average age in days of users who have spoken of the terms 14 days after publicationterms_ini_ur_inclusion_rate: URL inclusion ratio of tweets talking about terms 14 days after publication.tesis_terms: data of the terms (tags) related to the processed articles.stats_id: Analysis IDtime: "0" if at the time of publication, "1" if 14 days laterterm_id: Term ID (tag) in WordPressname: Name of the termslug: URL of the termnum_tweets: number of tweetsretweet_count_total: total retweetsretweet_count_mean: average retweetsfavorite_count_total: total of favoritesfavorite_count_mean: average of favoritesfollowers_talking_rate: ratio of followers of the media Twitter account who have recently published a tweet talking about the termuser_num_followers_mean: average followers of users who were talking about the termuser_num_tweets_mean: average number of tweets published by users who were talking about the termuser_age_mean: average age in days of users who were talking about the termurl_inclusion_rate: URL inclusion ratio

Since its launch in 2008, Google Chrome has come a long way in the world of web browsers. It started as a simple project but became the default browser for Android, to mention one accomplishment. This growth also means that Google Chrome has passed multiple milestones. So, it is a...

Introduction

Google Maps Statistics: Google Maps has changed how we used to navigate or explore the world. In 2024, it will most certainly become the ultimate mapping service, getting so much more than most other services and boasting so many more users. This article will discuss some of the Google Maps statistics its global coverage, technology achievements, and downloads.

Web traffic statistics for the several City-Parish websites, brla.gov, city.brla.gov, Red Stick Ready, GIS, Open Data etc. Information provided by Google Analytics.