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.

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

Item List & Item Promotion attribution are now independent of each other.
Search Term can be attributed on Item Level.
If you are using SGTM and Firestore, no more Cloud Functions to write TTL.

GA4 - Item List, Promotion & Search Term Attribution with GTM - Savio.no GA4 has Item List & Promotion reports, but no attribution. This solution for GTM Web or Server-side GTM fixes the missing attribution.

Here is my original blog post about the solution from February 2023:
www.savio.no/google-tag-m...

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'm using it on 2 different projects, and it seems to work nice. Adding it to 2 more projects later this week that has more volume, and they are using the Timestamp + Cloud Functions hack. Curious how much this would reduce Firestore reads and writes.

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.

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.

I had some logic based on the old format, which broke.

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

Firestore Writer Server-side Tag Template with Time To Live

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

Nice twist with GTM pipeline.

Is also on the annotation bandwagon, so made this sheet as a testing solution. Going to be integrated somewhere else later on.

Will update the "GA4 documentation solution" that uses this concept eventually (after I have written some other updates to the solution as well).

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.

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.

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.

📣 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

One client is about to start to use Growthbook. Looks promising.

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

BigQuery Experiment Analyzer

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.

He is a ruzzian asset.

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.

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.

I bought my first electric car 6 years ago. On my checklist was no Tesla because Elon.
Already then he was a disgusting person which I wouldn't support with my money.

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.