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...

BigQuery A/B Analyzer: Automate A/B Analysis in BigQuery - Savio.no

Run A/B analysis in BigQuery without writing SQL. Built with Google Sheets, BigQuery & Looker Studio. Open-source. For GA4, Amplitude, Mixpanel & Posthog.

savio.no

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.

Write TTL (Time To Live) to Firestore using Server-side GTM - Savio.no

Write Firestore TTL from Server-side Google Tag Manager using the Firestore Writer with TTL Template. Reduce costs and simplify setup.

savio.no

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.

GitHub - gtm-templates-knowit-experience/gtm-ga4-ecom-item-list-promo-attribution: Variable Template (Web) for Google Tag Manager that makes it possible to Attribute GA4 Item List, Promotion & Search ...

Variable Template (Web) for Google Tag Manager that makes it possible to Attribute GA4 Item List, Promotion & Search Term to revenue or ecommerce Event's (ex. purchase). - gtm-templates-kno...

github.com

Eivind Savio@savio.no · last yr.

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

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.

How Do I Trigger A Scheduled Query When The GA4 Daily Export Happens?

In this article, I'll show you how you can trigger a BigQuery scheduled query as soon as the Google Analytics 4 daily export job is complete.

teamsimmer.com

📣 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

Clarification On GTM Auto-Loading Google Tag For Ads And Floodlight Events

Google will update GTM containers on April 10 by automatically loading a Google Tag when an Ads or Floodlight event fires without a preceding Google Tag.

simoahava.com

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

BigQuery - What permissions do I need? - Analytics Ninja

BigQuery permissions can be complicated, we're breaking down what the roles do, what users need to have and how to secure your project with IAM.

analytics-ninja.com

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

Jamie Schler@lifesafeast.bsky.social · 2y ago

As a Norwegian, I support this.

Brian Tyler Cohen@briantylercohen.bsky.social · 2y ago

One of Norway's largest fuel companies just announced that they will no longer refuel US Navy vessels after Trump’s treatment of Zelenskyy. “It made us sick... We encourage all Norwegians and Europeans to follow our example.”

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.

Jim Sciutto@jimsciutto.bsky.social · 2y ago

Trump has not uttered a critical word about Putin but he and his VP publicly belittled the leader of the nation Putin invaded.

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.

Lukas Oldenburg@lukasoldenburg.bsky.social · 2y ago

It has really happened. America treating a democratic ally in the most belittling and ignorant manner possible, shoving him right into the claws of Putin (to then get ready to plunder Ukraine's resources). What an insane disgrace!!!!!!

This! youtu.be/Jk0nUUqG_Ag?...

The Art of The Deal

YouTube video by Jonathan Pie

youtu.be

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...

Sicherheit im Fokus - Angebot für Motorradfahrer auf dem Nürburgring neu aufgestellt

Der Nürburgring hat das Angebot für Motorradfahrer neu strukturiert. Die wichtigste Neuerung ist, dass Motorräder und Autos nicht mehr gleichzeitig auf den Strecken unterwegs sein werden.

nuerburgring.de

🐵 🎉 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...

From the ClimateOffensive community on Reddit

Explore this post and more from the ClimateOffensive community

reddit.com

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...

GitHub - Knowit-Experience-MarTech/ga4-documentation-administration-solution: Solution for documenting & administration Events, Parameters & Annotations for Google Analytics 4 (GA4) using Google Sheet...

Solution for documenting & administration Events, Parameters & Annotations for Google Analytics 4 (GA4) using Google Sheet, BigQuery & Looker Studio. - Knowit-Experience-MarTech/ga4-doc...

github.com

Superweek Analytics Summit@superweek.bsky.social · 2y ago

Congrats to Siavash who wins this year's Golden Punchcard Prize 🏆 with his Sherlock solution! Runner-ups Vlad and Matthew win silver and bronze 🥈 🥉 #spwk #superweek

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

Superweek 2025 Golden Punchcard

Please submit your information

docs.google.com