Beards Analytics 🇺🇦

Marketing/product analytics based on Google Cloud platform

[Beards Analytics 🇺🇦 @beardsanalytics]

Google Optimize and Optimize 360 will no longer be available after September 30, 2023. Your experiments and personalizations can continue to run until that date. Any experiments and personalizations still active on that date will end.

[Andrey Osipov @snegir]

We are not having a good morning today in Kyiv, and now there is an air siren in all of Ukraine.
But we continue to work, volunteer, and plan the future.
Please support our CMO Sasha Osypova as a speaker at the Berlin conference.
https://t.co/xi6imGwjKX

[Andrey Osipov @snegir]

Recently, a new Application Integration product appeared in GCP. It is something like Make, but with close integration with other Google products.

I created a transfer of the fact of conversion from GBQ to Facebook with my logic for the test.

https://t.co/aMQnzjwBNP

[Beards Analytics 🇺🇦 @beardsanalytics]

4/4

Using DBT, we can take all the data, process it, create a 3-levels data system, and then visualize it or send it to different systems in the required form. #bigquery #googlecloud #dwh #analytics #dataengineering

[Beards Analytics 🇺🇦 @beardsanalytics]

1/4

This scheme is a simplified version of our system. We use Google Cloud for storage and processing. AirByte + Perfect for ETLs, DBT, and Perfect for orchestration. Google Data Studio for visualization. Retool for makes and sends the audience S2S.

[Beards Analytics 🇺🇦 @beardsanalytics]

3/4
Our primary source is Google Analytics 4 or Firebase. They have data about users and events in the application or website. In addition, we collect a lot of different data that helps marketing. For example, it can be a CRM system, an internal database, or an ad platform.

[Beards Analytics 🇺🇦 @beardsanalytics]

2/4

The main goal of our approach is that by using GBQ, we have the opportunity to collect all the necessary data for building reports or marketing automation.

[Andrey Osipov @snegir]

Our Canadian friends from Masthead Data published the interesting article. What do you think about Data Mesh?

https://t.co/G53g2mAtC7

[Charles Farina @CharlesFarina]

GA4 has a few new releases rolling out

- Bounce Rate
- UTM Term and UTM Content
- Conversion Rates (Users and Session)

[Beards Analytics 🇺🇦 @beardsanalytics]

At the last 8P conference (Ukraine, Odesa), we discussed the future of web analytics due to the latest limitations and joked that we'd see when the query parameters will be limited. And now, this time has come.
https://t.co/1Ypm8vdyqk

[Beards Analytics 🇺🇦 @beardsanalytics]

If you have a considerable budget and think that you haven’t the possibility of increasing ROI, try to work with our data engineering and ML teams.

https://t.co/4nBiTnilMG

[Beards Analytics 🇺🇦 @beardsanalytics]

The new linking API helps automate the creation of new reports and the connection of data sources. And it all uses query parameters
https://t.co/Zbkf9eM89I

[David Hermann @DavidHer_mann]

It looks like that Dataform will be integrated in #BigQuery soon. Spotted that today the first time.

[Ralph Spandl (spandl.bsky.social) @ralph_spandl]

New article in the series of @supermetrics exclusive products:

The new bullet graph for #GoogleDataStudio is very versatile and implements a new concept of metric based colours. Very happy with the result!

https://t.co/IHrYc0hX6y

[Simo Ahava @SimoAhava]

In short:

- MP for GA4 has been designed to be a *partial* solution, augmenting existing client-side data collection.
- You CAN create new sessions and add to existing ones with the session_id parameter.
- You CAN’T collect reserved event names like session_start, first_visit...

[Krisjan Oldekamp @KrisjanOldekamp]

As promised, the full tutorial of my talk on #measurecamp. Leveraging the new Firestore Lookup variables in #GTM Server opens up a whole new world of possibilities.

How to export #BigQuery data into Google Firestore?

https://t.co/g7KG4VUqTF

#measurement

[Paul Koks @OnlineMetrics]

Marketers Guide to Sessions in Google Analytics 4 (GA4) https://t.co/0lzCkSBusP #ga4 #measure

[Beards Analytics 🇺🇦 @beardsanalytics]

@markalves @njmott we can use raw data, btw google BigQuery works great with data studio too

[Beards Analytics 🇺🇦 @beardsanalytics]

@Tommy0550 @njmott But they have native BigQuery integration)

[Beards Analytics 🇺🇦 @beardsanalytics]

@markalves @njmott yes, ga4 is more efficient working with the spoofed traffic, but cardinality is not good for big sites