5 Things You Can Do with Your BigQuery Quota in Google Analytics 360

5 Things You Can Do with Your BigQuery Quota in Google Analytics 360
5 Things You Can Do with Your BigQuery Quota in Google Analytics 360

Many companies don’t know that by purchasing Google Analytics 360 suite, they get a free quota of monthly 500 USD. This quota can be used for Google BigQuery usage. Ta direct integration between the two services, so there are plenty of opportunities that an E-Commerce company can leverage. In this blog post, we’ll discover 5 things you can do with your BigQuery Quota in Google Analytics.

The integration allows you to automatically import unsampled, hit-level Google Analytics 360 logs to Google BigQuery, several times per day. This feature allows you to easily track every single activity of millions of users. You can execute in-depth, ad-hoc analysis in seconds, without having to worry about the scalability and availability of the data management platform.

We collected a couple of interesting use cases:

  1. Retarget more effectively. Connect your registered customers’ data (e.g. spending history, email address) with their buyer journey on the website. Then, retarget them with personalized recommendations and campaigns. Find out who the customers are with a certain spend history and without visiting your site for some time. Based on this information, contact them with relevant contents.
  2. Use machine learning techniques on top of your data to identify opportunities that lead to higher revenue streams or lower costs. For example, create customer segments. Predict the spendings and optimize your logistics or stock. Integrate public datasets (e.g. weather information), and find out whether there is any correlation with the users’ behavior.
  3. Drill down in your log data to investigate specific customers’ behavior. Integrate your Google Analytics data with other social data sources. Then, find out what the average customer spend was by source media (e.g. Search Ads, Social Ads, email, organic search) in the last marketing campaign.
  4. Finally, visualize the information you need. As a result, create reports on top of your data stored in BigQuery by using popular reporting tools, such as Tableau, Data Studio, Qlick.

(Sources: https://cloud.google.com/solutions/google-analytics-bigquery, https://cloud.google.com/products/calculator/)

The best thing about having your BigQuery Quota in Google Analytics 360 is that you don’t have to worry about the costs. For 500 USD per month, you get a BigQuery quota of about 25 terabytes of storage or 100 terabytes of queried data. It is really difficult to exceed for almost all the E-commerce companies, even with billions of hits per months.