Shanon Chan, Digital Optimisation & Analytics Manager, Aussie
Have you ever wanted Google Analytics’ “User Explorer” data in a aggregated flat table? This type of data is useful for answering questions like “What content do users view before conversion vs after conversion?” and “How many sessions do users of different segments spend on site before conversion?” to help provide the insights to power personalisation. Come along to see the analysis and some of the code used to pull the data that you can use yourself.
BigQuery Scripting - SQL Magic Spells
Pawel Kapuscinski, Data Analyst, Adswerve
Imagine enhancing SQL with loops. Want more? Let’s go one step further, imagine your query can decide if it should run based on a provided variable. Not enough? How about constructing queries on the fly and executing them using nothing more than the BigQuery UI. Welcome to the magic world of BigQuery scripting.