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?

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

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.

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.

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).

Introduction

Google Search Statistics: Google Search stands as the dominant global search engine, playing a crucial role in helping users find information, make informed decisions, and engage with online content. As digital habits evolve, Google remains at the forefront, influencing how people access websites, engage with brands, and discover new services.

Through advancements in AI, personalized results, and the growing trend of mobile searches, Google Search continuously refines its approach to deliver more relevant and efficient user experiences. Consequently, staying updated on Google Search trends and statistics is crucial for businesses, marketers, and analysts seeking to refine their strategies and increase visibility in a rapidly evolving digital landscape.

Key Google Play StatisticsGoogle Play App and Game RevenueGoogle Play Gaming App RevenueGoogle Play App RevenueGoogle Play App and Game DownloadsGoogle Play Game DownloadsGoogle Play App...

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.

In the first half of 2024, Google received over 82,000 requests for disclosure of user information from the U.S. federal agencies and other government entities. The Indian government ranked second by the number of requests about user information disclosure sent to Google, followed by Germany.

The most popular search query on Google in Czechia in 2024 was "Seznam". It was followed by "Počasí" with ** percent of the search volume of the leading query.

It starts with a simple habit: you open your browser and type a question. A few keystrokes later, Google gives you answers, videos, maps, and suggestions before you even finish your thought. For billions of people around the world, this daily interaction is second nature. But behind that blinking cursor...

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 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.

In this activity, students work together to analyze microbial diversity data to determine the effectiveness of using hand sanitizers versus hand-washing with soap. Student teams use Google Sheets to calculate summary statistics, visualize trends, and perform hypothesis testing, all while focusing on understanding the logic behind the formulas.

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.

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.

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.

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.

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.

Between January and July 2024, Google received ****** requests for disclosure of user information from the United States federal agencies and courts. This is a slight decrease in comparison to the second half of 2023, in which over ****** requests were issued.