BigQuery, a web service lets developers and businesses conduct interactive analysis of big data sets and tap into powerful data analytics. When paired with Google Analytics it offers new business insights through session and hit level data and combining it with separate data sets which can be analyzed in seconds.
Today, Google made available a new Analytics sample dataset accessible through BigQuery UI and includes data from Google Merchandise Store and let you query typcial data such as AdWords, Goals and Enhanced Ecommerece data.
In this image below, you can see Google Analytics Sample Dataset for BigQuery:
This sample data can be use to teach or self-learning through practical experience. More specifically, it can be use to learn how granular information can be extracted from analytics data in BigQuery. Or, better check out the Google guide that helps in creating queries to find answers, such as:
- What is the average number of transactions per purchaser?
- What is the percentage of stock sold per product?
- What is the average bounce rate per marketing channel segmented by purchasers?
- What are the products purchased by customers who previously purchased a particular product?
- What is the average number of user interactions before a purchase? More information at this link.
Additionally, you can also refer to Analytics Academy’s introduction to BigQuery in this Getting Started with Google Analytics 360 course. And, for an in-depth look at BigQuery with practical exercises, check out this Google Cloud team’s Data Insights course. Or, learn more about the dataset including how to get access in this help article.
In addition, Google also introducing a new feature in Google Optimize that helps make sure if Optimize is set up and working correctly on your site. At a glance, it’ll help you see “if your Optimize setup is correct and if you’re ready to run a test.”
First up, the Installation Diagnostics tool automatically alerts you about potential issues with the Optimize code each time a new test is created. Also, it alert on issues, including “if Google Analytics code isn’t installed on a page,” or “if an old version of Analytics code is installed.”
For example, “when a new test page is created on your site, but you are forget to add the Optimize code. Later, when you are creating a test for that page, Optimize will tell you that the necessary code isn’t installed. And, gives you an opportunity to fix the issue and then launch your test.”
Lastly, Google Surveys is now available across the globe and lets you survey people in over 50 countries.
First launched in 2012, Google Surveys was then called as (Google Consumer Surveys) with an goal to put quality market research in the hands of businesses of all sizes.
Since then, improvements were made to the product along with a new version Google Surveys 360 for enterprises with advanced targeting, reporting, and sharing features was launched as well.
Now both of these versions are available to people in more than 50 countries.