I have been silent about "BigQuery A/B Analyzer" since Superweek. Things to improve. Things to add. Now I think/hope it is ready for the public: www.savio.no/analytics/bi...

New Google advertisement parameters: gad_campaignid and gad_source I detected gad_campaignid 4 days ago for the first time. support.google.com/google-ads/a...

I think I was the first to create a GA4 Item List & Promotion attribution solution for more than 2 years ago. It was time to do some upgrading: * Simplified setup * Improved attribution * Reduced Read & Writes for SGTM solution using Firestore github.com/gtm-template...

I decided to make a Server-side GTM Template that can write Time To Live (TTL) directly to Firestore since I don't know about any generic solution that can do this. No more hacks with Timestamp and Cloud (Run) functions to delete documents. It's open source.

This change made me do some updates to my "GA4 - Item List & Promotion Attribution - GTM Variable (Web)": github.com/gtm-template... It now supports both GA cookie formats. I also improved the attribution logic, and added the possibility to add "search_term" to Items for easier reporting.

The GA cookie value is now stored in different format. I have seen the format changes from one Event to another within the same session. Old format: GS1.1.1746298084.1.1.1746298084.0.0.1109558877 New format: GS2.1.s1746298084$o1$g1$t1746298857$j0$l0$h1109558877

I have really been missing the possibility to write Time To Live to Firestore from Server-side GTM. And because of that, I decided to make the Template myself. #gtm #sgtm #GoogleTagManager

I have been using the Cloud Functions concept from this blog post from @teamsimmer.com in many different ways: www.teamsimmer.com/2022/12/07/h... But since Google is moving to Google Cloud Run Functions instead, I tried to see if I could make it work with Cloud Run Functions. I could.

📣 Blog post that clarifies Google Tag Manager's upcoming April 10th update 📣 In this article, I'll explain what Google will actually do on April 10th in containers that run Ads and Floodlight events. The change isn't as dramatic as many feared. www.simoahava.com/analytics/cl... #measure

Enhanced setup funnels with improved instructions and step-by-step videos.

Fixed a small, but irritation bug in my GA4 Documentation solution: github.com/Knowit-Exper...

Still a long way to go, but working on making it easier to analyse A/B-tests using BigQuery.

Do the Hungarian people agree with the Putin puppet Orban? Asking for a friend.

Quite a comprehensive guide on setting permissions when using Big Query - by James Cottril on the @analytics-ninja.com blog

In the meeting there was a man without a suit, and some suits without men.

As a Norwegian, I support this.

FBI, CIA and the US Army exist to protect USA. If they don't take down Trump, Vance and others that are in Putins pocket, they have failed their mission. Then there are only 3 options left. The people of the USA stands up, dictatorship, or a civil war. Staying silent will not help.

Zelensky is a wartime leader watching his people suffer and die under Russian attacks every day. To be lectured and lied to by Trump and Vance, as they defend the war criminal dictator committing these atrocities, is unimaginable agony. An everlasting shame for America.

Donated now and then to Veteran Aid Ukraine, but now made a recurring donation. Their equipment makes a difference on the front line. Norwegian Army Veterans are behind the organization, and I have met them in person. vaukraine.com

Trump and his administration are traitors to the USA, a danger to the USA and the world, and the most disgusting persons ever in the White House. They are in Putins pocket.

This! youtu.be/Jk0nUUqG_Ag?...

In other news, motorcycles are not allowed on Nürburgring Tourist Drives anymore. Did my first laps there on a mororcycle more than 20 years ago: nuerburgring.de/news/sicherh...

🐵 🎉 My new tool is out: #PiwikPro Manager is a free Google Sheets Extension that makes Admin work scale. It saves countless hours, minimizes redundancy, and ensures transparency. Get started in 5 minutes: www.youtube.com/watch?v=yXKH... or go to the guide on GitHub: github.com/loldenburg/p...

New blog post! 📣 Server-side GTM now fetches GA4 configs automatically when you override the Measurement ID. No more manual enrichment—key settings like conversions are applied automatically! Splitting those data streams without losing critical details. 👉 www.simoahava.com/gtmtips/sgtm...

📣 Server-side GTM and Container Registry deprecation 📣 If you've received email about Container Registry deprecation, and you're wondering if you need to do something about your SGTM deployment – don't worry. Google has migrated the Docker image to Artifact Registry – you don't need to do anything.

In nazi germany they burned books. Today they drop databases. www.reddit.com/r/ClimateOff...

You don't need enemies when you have friends like the USA. Yes, the toll tariffs is the orange clown, but he just delivered what he promised, and the USA elected him. Someone said no politics here, but this is simply data. The President of the USA doesn't understand data.

Many really awesome solutions presented this year. Congratulations to the winners. I competed with the GA4 Documentation 3.0 solution. It can be found here: github.com/Knowit-Exper...

If you intend to participate in the Superweek Golden Punchcard Prize, please fill in the form at docs.google.com/forms/d/e/1F... #spwk #superweek

So, my GA4 was hammered with bot/spam traffic again. But my duplicate GA4 Property was not. This filter works because this bot/spam traffic doesn't go through Server-side GTM.

Wanna play ?

Dumb and dangerous is now president again, and Elonia celebrates with a Nazi salute.

GA4Dataform is Open Source! If you want to turn Google Analytics Big Query exports into efficient, easy and cheap to query tables: there's Free code here: ga4dataform.com/were-open-so...

Awesome news! Make sure to check in with reg [at] superweek.hu

(yes set) with my colleagues. Looking forward to @superweek.bsky.social 2025.

A contribution to the highly recommended GA4Dataform project with this free #LookerStudio Template Sample All the story and the access to the template in this post: how.withlookerstudio.com/data-sources...

At least this was a real test for my anomaly detection in BQ. Testing both Standard Deviation and BQ ML.

Xit from my last account on Elonias platform (had 2). Created in 2008.

F*ck! Someone have been hammering the page_view Event on my personal site today. It's not bot traffic to the site since the "traffic" haven't passed through Server-side GTM.

Had 2 accounts on Elonia's train wreck. One created in 2009, deleted. It was my Norwegian account. Will not delete my English account yet, just because I want to see what the 2nd lady is doing.

Writing some SQL queries for personal usage and learning: This is good, this will do. Next day: I should also do this. Next, next day: But also this. Next, next, next day: This is even smarter.

By coincidence, I disocvered a new event and some incorrect parameters showing up in a GA4 property today. Had to waste some time figuring out where this came from (app). Time to ramp up my anomaly detection + new events & parameters detection solution. #GA4

Making dynamic queries based on availability of BigQuery tables. If events_fresh_ exist, only query this table. Else, query events_ & events_intraday_ (if it exist). If yesterday doesn't exist in events_, query events_intraday_ against yesterday + today, else only against today. #BigQuery #GA4

Teaching ChatGPT some SQL and Apps Script, but at the same time, learning a lot myself. Doing dynamic table selection based on table availability and date. Both Apps Script and pure SQL. #AppsScript #BigQuery #ChatGPT

Do you remember the W3C Digital Data Data Layer "standard"? www.w3.org/2013/12/cedd... You shouldn't use it. But - travel uses it (I will not be more specific). I converted this to GA4 Ecommerce using GTM. These are the most complicated javascript I have written in my life.

💊 Adaptation, improvisation & your weakness is no more the short-text SoMe. The community is growing! Now on Bluesky & in the #Analytics Starter Pack, Welcome to: @brieeanderson.bsky.social @savio.no @rickdronkers.bsky.social @jillquick.bsky.social @poulton.bsky.social go.bsky.app/Huxv35J

So, Gemini in BQ will now cost money. Must admit I haven't used it much, used ChatGPT instead. You have to torture ChatGPT to get things in the right direction, but I found ChatGPT to be more helpful than Gemini in BQ. Just me?