Google Analytics Sample Data

93 views

Skip to first unread message

Rohan Kataria

unread,

Aug 24, 2020, 5:05:34 PM8/24/20

to manipulatr

Hi! I'm working on Google Analytics Sample data, it comes straight from BigQuery.

Data Source -> https://support.google.com/analytics/answer/7586738?hl=en

The data has lots of nested columns, with type "list". How can I unnest those columns and shape the data for smooth analysis?

Using unnest() opens up the whole column in longer shape, and takes away the column names as well for the data in the list. It's hard to build my analysis and viz on data like that with no column names.

A snippet of columns and code that I used: https://drive.google.com/file/d/1ZnEp8KZjFRMakV7VosTOdnH84Sc2eSe3/view?usp=sharing