Using Snowflake to Analyze Unstructured Data

Unstructured data stores a tremendous amount of information, but it is not easy to search, analyze, or query, especially on the fly— presenting more challenges to data architectures that are already complex. In this session, you will learn about Snowflake’s new support for unstructured data and how unstructured data can be used to analyze proprietary replay files for the Dota 2 video game. Dota 2 has a substantial esports presence and its developer hosts the world's largest endowed esports tournament.

How to Use and Interpret Google Analytics Time of Day Reports: Tips and Best Practices

The main ingredient of a successful business recipe is data. And what better way to obtain important data than by using Google Analytics. In the past, strategizing and updating content on your website required a ton of manpower and exceptional guessing abilities. Google Analytics has simplified this process by providing rock-solid data and removing the guess factor. This advanced tool has become one of the essential things that growing businesses simply have to incorporate.

Import Google Analytics 4 Data into Snowflake and Translate into SQL

Did you know that Google Analytics 4 now exports event data at the individual user level for free? In this episode of SnowFlake Bytes, Felipe Hoffa, Snowflake’s Data Cloud Advocate, shows you how to move this GA4 data into Snowflake and translate the sample queries into Snowflake SQL. His favorite part of the process? Creating a UDF that transforms the original schema nested data into a variant object that is easier to query.

4 pitfalls in your data strategy (and how to avoid them)

If you’re a data leader at an early-stage or high-growth company, you’re in a unique position to promote data appreciation. Don’t waste your golden window of opportunity. Take this moment to institute best practices, promote good habits, and build the foundation for a data-driven culture. There’s no universal data strategy that would work for all organizations — wouldn’t that be great? — but there are pitfalls that all organizations should watch out for.

What went wrong with customer 360

Three decades into the data revolution, my fellow technologists and I find ourselves asking an existential — and rather distressing — question: What happened to the promise of customer 360? The ability to get more customer data was supposed to fundamentally change the relationship between customers and brands. Companies were going to be able to offer targeted, meaningful engagements that would multiply average deal size and slash time to close.

How to Get Started With an E-Commerce Integration Platform

When getting started with an e-commerce integration platform, here's what you need to know: Whether you choose Shopify, BigCommerce, Magento, or WooCommerce, your e-commerce platform generates massive amounts of customer data. By collecting and analyzing all this information, you can glean valuable insights that help you improve the customer experience on your e-commerce website.