In 2023, Google's ad revenue amounted to 264.59 billion U.S. dollars. The company generates advertising revenue through its Google Ads platform, which enables advertisers to display ads, product listings and service offerings across Google’s extensive ad network (properties, partner sites, and apps) to web users. Google advertising Advertising accounts for the majority of Google’s revenue, which amounted to a total of 305.63 billion U.S. dollars in 2023. The majority of Google's advertising revenue comes from search advertising. Google market share These revenue figures come as no surprise, as Google accounts for the majority of the online and mobile search market worldwide. As of September 2023, Google was responsible for more than 84 percent of global desktop search traffic. The company holds a market share of more than 80 percent in a wide range of digital markets, having little to no domestic competition in many of them. China, Russia, and to a certain extent, Japan, are some of the few notable exceptions, where local products are more preferred.

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?