Today, BigQuery is impossible to ignore. But it also means that in order to use it, you have to learn SQL programming. This has stopped many people from benefiting from its powerful analytics capabilities. However, with ChatGPT, this problem might become a thing of the past.
🔗 Links:
console.cloud.google.com/
developers.google.com/analyti...
chat.openai.com/
Are you a reader more than a video person? Check this out 👉measureschool.com/bigquery-wi...
📚📚 Courses and Resources ⏬⏬
Join our premium membership for exclusive content 🦸♀️🦸♂️ bit.ly/measuremasters
GTM, GA4, and GDS FREE Courses 💸 bit.ly/measureschool-courses
Need Personalized Help? Contact Us 📞 bit.ly/measureschool-services
👍 FOLLOW US 👍
LinkedIn: / measureschool
Twitter: / measureschool
Instagram: / measure.school
Facebook: / measureschool
OUTLINE
00:00 Introduction
01:25 Creating a BigQuery Project
02:01 Accessing BigQuery Public Datasets
03:25 Managing costs
04:50 Retrieving all columns with ChatGpt
05:25 Retrieving specific columns & rows
06:50 Filter records
07:27 SQL dates
08:11 Retrieving GA4 Event parameters
09:30 Unnesting fields (getting GA4 event parameters)
11:23 Outro
Негізгі бет RIP SQL? Use BigQuery with ChatGPT!
Пікірлер: 6