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?

Various population statistics, including structured demographics data.

As of April 2024, it was found that men between the ages of 25 and 34 years made up Facebook largest audience, accounting for 18.4 percent of global users. Additionally, Facebook's second largest audience base could be found with men aged 18 to 24 years. Facebook connects the world Founded in 2004 and going public in 2012, Facebook is one of the biggest internet companies in the world with influence that goes beyond social media. It is widely considered as one of the Big Four tech companies, along with Google, Apple, and Amazon (all together known under the acronym GAFA). Facebook is the most popular social network worldwide and the company also owns three other billion-user properties: mobile messaging apps WhatsApp and Facebook Messenger, as well as photo-sharing app Instagram. Facebook usersThe vast majority of Facebook users connect to the social network via mobile devices. This is unsurprising, as Facebook has many users in mobile-first online markets. Currently, India ranks first in terms of Facebook audience size with 378 million users. The United States, Brazil, and Indonesia also all have more than 100 million Facebook users each.

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.

As of February 2025, there were 5.56 billion internet users worldwide, which amounted to 67.9 percent of the global population. Of this total, 5.24 billion, or 63.9 percent of the world's population, were social media users. Global internet usage Connecting billions of people worldwide, the internet is a core pillar of the modern information society. Northern Europe ranked first among worldwide regions by the share of the population using the internet in 2024. In The Netherlands, Norway and Saudi Arabia, 99 percent of the population used the internet as of April 2024. North Korea was at the opposite end of the spectrum, with virtually no internet usage penetration among the general population, ranking last worldwide. Asia was home to the largest number of online users worldwide – over 2.93 billion at the latest count. Europe ranked second, with around 750 million internet users. China, India, and the United States rank ahead of other countries worldwide by the number of internet users. Worldwide internet user demographics As of 2023, the share of female internet users worldwide was 65 percent, five percent less than that of men. Gender disparity in internet usage was bigger in the Arab States and Africa, with around a ten percent difference. Worldwide regions, like the Commonwealth of Independent States and Europe, showed a smaller gender gap. As of 2023, global internet usage was higher among individuals between 15 and 24 years across all regions, with young people in Europe representing the most significant usage penetration, 98 percent. In comparison, the worldwide average for the age group 15–24 years was 79 percent. The income level of the countries was also an essential factor for internet access, as 93 percent of the population of the countries with high income reportedly used the internet, as opposed to only 27 percent of the low-income markets.

Contains Gallup data from countries that are home to more than 98% of the world's population through a state-of-the-art Web-based portal. Gallup Analytics puts Gallup's best global intelligence in users' hands to help them better understand the strengths and challenges of the world's countries and regions. Users can access Gallup's U.S. Daily tracking and World Poll data to compare residents' responses region by region and nation by nation to questions on topics such as economic conditions, government and business, health and wellbeing, infrastructure, and education.

The Gallup Analytics Database is accessed through the Cornell University Libraries here. In addition, a CUL subscription also allows access to the Gallup Respondent Level Data. For access please refer to the documentation below and then request the variables you need here.

Before requesting data from the World Poll, please see the Getting Started guide and the Worldwide Research Methodology and Codebook (You will need to request access). The Codebook will give you information about all available variables in the datasets. There are other guides available as well in the google folder. You can also access information about questions asked and variables using the Gallup World Poll Reference Tool. You will need to create your user account to access the tool. This will only give you access to information about the questions asked and variables. It will not give you access to the data.

For further documentation and information see this site from New York University Libraries. The Gallup documentation for the World Poll methodology is also available under the Data and Documentation tab.

In addition to the World Poll and Daily Tracking Poll, also available are the Gallup Covid-19 Survey, Gallup Poll Social Series Surveys, Race Relations Survey, Confidence in Institutions Survey, Honesty and Ethics in Professions Survey, and Religion Battery.

The process for getting access to respondent-level data from the Gallup U.S. Daily Tracking is similar to the World Poll Survey. There is no comparable discovery tool for U.S. Daily Tracking poll questions, however. Users need to consult the codebooks and available variables across years.

The COVID-19 web survey began on March 13, 2020 with daily random samples of U.S. adults, aged 18 and older who are members of the Gallup Panel. Before requesting data, please see the Gallup Panel COVID-19 Survey Methodology and Codebook.

The Gallup Poll Social Series (GPSS) dataset is a set of public opinion surveys designed to monitor U.S. adults’ views on numerous social, economic, and political topics. More information is available on the Gallup website: https://www.gallup.com/175307/gallup-poll-social-series-methodology.aspx As each month has a unique codebook, contact CCSS-ResearchSupport@cornell.edu to discuss your interests and start the data request process.

Starting in 1973, Gallup started measuring the confidence level in several US institutions like Congress, Presidency, Supreme Court, Police, etc. The included dataset includes data beginning in 1973 and data is collected once per year. Users should consult the list of available variables.

The Race Relations Poll includes topics that were previously represented in the GPSS Minority Relations Survey that ran through 2016. The Race Relations Survey was conducted November 2018. Users should consult the codebook for this poll before making their request.

The Honesty and Ethics in Professions Survey – Starting in 1976, Gallup started measuring US perceptions of the honesty and ethics of a list of professions. The included dataset was added to the collection in March 2023 and includes data ranging from 1976-2022. Documentation for this collection is located here and will require you to request access.

Religion Battery: Consolidated list of items focused on religion in the US from 1999-2022. Documentation for this collection is located here and will require you to request access.

As global communities responded to COVID-19, we heard from public health officials that the same type of aggregated, anonymized insights we use in products such as Google Maps would be helpful as they made critical decisions to combat COVID-19. These Community Mobility Reports aimed to provide insights into what changed in response to policies aimed at combating COVID-19. The reports charted movement trends over time by geography, across different categories of places such as retail and recreation, groceries and pharmacies, parks, transit stations, workplaces, and residential.

The present dataset is generated in the frame of the Horizon 2020 project "InnORBIT: Empowering innovation intermediaries to generate sustainable initiatives to accelerate the commercialisation of space innovation" (innorbit.eu).

This dataset describes the InnORBIT project's dissemination and communication plan and also includes the data collected from dissemination and communication activities to measure the progress against the project's targets for outreach during the first 18 months of project implementation (January 1st, 2021 - June 30th, 2022). This dataset will be updated in a second and final version, after the end of InnORBIT's grant duration in July 2023. The final version will provide a full dataset accounting for the project's outreach activities.

This first version of the dataset contains the following files and documents:

• [InnORBIT-DisseminationCommunicationPlan_v2_20220929.pdf]: Final version of the project's Dissemination, Awareness raising and Communication Plan (DACP), that describes the key target audiences, key messages and value offered by InnORBIT through in terms of knowledge, services and solutions boosting entrepreneurship in the space industry and the digital tools offered via the InnORBIT digital toolbox. The InnORBIT DACP also describes the channels, tools and activities employed to reach out effectively the project's target groups. The core Key Performance Indicators (KPIs) that indicate the performance level of the project's strategy and indicates areas for improvement are outlined. The updated version also outlines the achievements of the project's dissemination for the first 18 months of implementation (January 2021 - June 2022).
• [InnORBIT_DisseminationActivities_Data_20220929. xlsx]: A spreadsheet used to collect raw data about the project's dissemination activities, calculate the InnORBIT's KPIs for Dissemination and Communication to track progress against targets. The data span from January 1st, 2021 to June 30th, 2022.
• [InnORBIT-WebsiteAnalytics-AudienceOverview_20220929.pdf]: A Google Analytics report summarising InnORBIT website's audience demographics and overall page performance (visits, sessions, users). The data span from January 1st, 2021 to June 30th, 2022.
• [InnORBIT-WebsiteAnalytics-AudienceAcquisition_20220929.pdf]: A Google Analytics report summarising the main sources generating traffic for the InnORBIT website and the bahaviour of users coming from each source. The data span from January 1st, 2021 to June 30th, 2022.
• [InnORBIT-WebsiteAnalytics-AudienceBehaviour_20220929.pdf]: A Google Analytics report providing further insight on users' behaviour when using the InnORBIT website. The data span from January 1st, 2021 to June 30th, 2022.

This data set contains COVID-19 hospital incidence, temperature and human mobility and contact data recorded between 2020-03-24 and 2021-03-30 used in the paper:

Selinger et al. 2021: Predicting COVID-19 incidence in French hospitals using human contact network analytics. 10.1016/j.ijid.2021.08.029

See methods in the article for detailed descriptions and the data curation process.

1) cov_mob_tst_national.csv contains national-level data

The columns comprise:

incid_hosp: hospital admission incidence

incid_rea: ICU admission incidence

incid_dc: hospital death incidence

incid_rad: incidence of those returned home

within_departement_colocation_X%: X%-quantile of colocation probabilities with départements

between_departement_colocation_X%: X%-quantile of colocation probabilities between départements

fb_population_coverage_X%: X%-quantile of ratio of fb_population over census population in département

null_links_X%: X%-quantile of null links across départements

clustering_X%: X%-quantile of clustering coefficients across départements

ricci_X%: X%-quantile of curvature across départements

ricci_min_X%: X%-quantile of minimum curvature across départements

ricci_mean_X%: X%-quantile of average curvature across départements

ricci_max_X%: X%-quantile of maximum curvature across départements

strength_X%: X%-quantile of network strengths across départements

betweenness_centrality_X%: X%-quantile of betweenness_centrality scores across départements

positive_test_ratio_weekly: ratio of weekly cumulated positive tested over weekly cumulated tests

retail_and_recreation_percent_change_from_baseline: Google Mobility Reports

grocery_and_pharmacy_percent_change_from_baseline: Google Mobility Reports

parks_percent_change_from_baseline: Google Mobility Reports

transit_stations_percent_change_from_baseline: Google Mobility Reports

workplaces_percent_change_from_baseline: Google Mobility Reports

residential_percent_change_from_baseline: Google Mobility Reports

mean_temperature_X%: X% quantile of mean daily temperatures averaged over the week across départements

min_temperature_X%: X% quantile of minimum daily temperatures averaged over the week across départements

max_temperature_X%: X% quantile of maximum daily temperatures averaged over the week across départements

2) cov_mob_dep.csv contains département-level data

The columns comprise:

dep: département code

incid_hosp: hospital admission incidence

incid_rea: ICU admission incidence

incid_dc: hospital death incidence

incid_rad: incidence of those returned home

week: week (matched to colocation data recording usually on Tuesdays)

dep_name: name of the département

null_links: number of null links

betweenness_centrality: betweenness centrality

clustering: clustering coefficient

strength: network strength

ricci_mean: minimum curvature among all edges incident to a département

ricci_min: mean curvature across all edges incident to a département

ricci_X%: X%-quantile curvature among all edges incident to a département

fb_population: number of facebook users

facebook_colocation_within_dep: colocation probability within département

fb_population_coverage: ratio of fb_population over census population in département

facebook_colocation_between_dep_X%: X%-quantile of facebook colocation among all edges incident to the département

min_temperature: minimum daily temperature averaged over the week

max_temperature: maximum daily temperature averaged over the week

mean_temperature: mean daily temperature averaged over the week

incid_hosp_Y: incidence of hospital admission from Ynd most colocated département

incid_rea_Y: incidence of ICU admission from Ynd most colocated département

incid_dc_Y: incidence of hospital deaths from Ynd most colocated département

incid_rad_Y: incidence of returned home from Ynd most colocated département

As of January 2025, online search engine Bing accounted for 12.23 percent of the global desktop search market, while market leader Google had a share of around 78.83 percent. Meanwhile, Yahoo's market share was 3.07 percent. Google in the global 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 2023, with a market capitalization of 1,6 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 2023 with roughly 305.6 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 were nearly 36 percent. Meanwhile, Baidu was the most used search engine in China, despite a strong percentage decrease of internet users in the country accessing it. In other countries, like Japan and Mexico, people tend to use Yahoo along with Google. In the first quarter of 2022 nearly 56 percent of the respondents in Japan said that they had used Yahoo in the past four weeks. In the same year, over 27 percent of users in Mexico said they used Yahoo. Another search engine, Bing, operated by Microsoft, was the second most popular search engine in the United Kingdom after Google.

Facebook is one of the most popular social networks in the United States and as of January 2025, 53.8 percent of U.S. Facebook users were women. Facebook usage in the United StatesThanks to its wide reach and vast range of products including Facebook Messenger, Instagram and WhatsApp, many internet users would find it hard to imagine an online experience without the company that arguably made social media mainstream. In 2021, 93 percent of the U.S. population were aware of Facebook, an all-time high and still improving on years of consistently high ranking in this area. In May 2024, Facebook had over 236 million unique visitors from the United States, making it the seventh most popular multi-platform web property in the United States. Facebook usage concernsDespite near universal Facebook awareness and wide-ranking adoption, many consumers are wary of the social network’s influence on their digital experience and life. In 2018, the company was plagued by scandals, ranging from being a tool in the alleged foreign influence of the U.S. elections in 2016, to being utilized in spreading misinformation by bad actors due to lax content policies, to the mishandling of user data. During a March 2018 survey, 50 percent of internet users in the United States stated that large digital platforms such as Facebook (and also Google and Twitter) should be regulated.

As of February 2025, India was the country with the largest YouTube audience by far, with approximately 491 million users engaging with the popular social video platform. The United States followed, with around 253 million YouTube viewers. Brazil came in third, with 144 million users watching content on YouTube. The United Kingdom saw around 54.8 million internet users engaging with the platform in the examined period. What country has the highest percentage of YouTube users? In July 2024, the United Arab Emirates was the country with the highest YouTube penetration worldwide, as around 94 percent of the country's digital population engaged with the service. In 2024, YouTube counted around 100 million paid subscribers for its YouTube Music and YouTube Premium services. YouTube mobile markets In 2024, YouTube was among the most popular social media platforms worldwide. In terms of revenues, the YouTube app generated approximately 28 million U.S. dollars in revenues in the United States in January 2024, as well as 19 million U.S. dollars in Japan.