дивіться, як тепер можна в bigquery - автоматичний group by по всім елементам struct:
https://x.com/Lukaslo/status/1828832806090490271

X (formerly Twitter)

Luka Cempre (@Lukaslo) on X

#BigQuery now allows the usage of the GROUP BY and SELECT DISTINCT with arrays and structs! In the screenshot below I GROUP BY all session traffic source fields with using a singlestruct.

в зсу потрібен аналітик на power bi
https://lobbyx.army/tor/analityk-danykh-medychnoi-informatsiynoi-systemy-do-syl-oborony/?fbclid=IwY2xjawE6Y5FleHRuA2FlbQIxMQABHZ1HLh3UMy7nVCtcyKPdDws3fzcavif8sJUO8I-De5QPwKSQ0xlpR4dmdQ_aem_bvDRigTQifXYspZqSLINzw

Lobby X

Аналітик даних медичної інформаційної системи - Lobby X

GA4 is fun they said

тепер легше розбиратися, чого ваші запити такі дорогі і повільні:

#BigQuery release notes, Jun 12, 2023.

✔️The query execution graph is now generally available (GA). You can use the query execution graph to diagnose query performance issues, and to receive query performance insights.

cloud.google.com/bigquery/docs/…

Google Cloud

BigQuery documentation  |  Google Cloud

Interactively analyze large datasets.

гугл серйозно проапгрейдив сервер-сайд таг менеджер:
https://www.simoahava.com/analytics/transformations-server-side-google-tag-manager/

Simo Ahava's blog

Transformations In Server-side Google Tag Manager

Transformations in server-side Google Tag Manager allow you to modify the event data object before it becomes available to tags. They are a governance and data enrichment tool, and this article explains how transformations work.

база від Сімо: https://www.simoahava.com/analytics/dear-google-analytics-4/

спойлер: GA4 - погана.

Simo Ahava's blog

Dear Google Analytics 4

A rant of an article about Google Analytics 4 and Google's track record with analytics tools.

тепер навіть в розширеннях Chrome - оновлена аналітика