WouterNieuwerth’s gists

WouterNieuwerth / google_workflow_with_retry.jaml

Last active January 11, 2024 09:08

Google Workflow with Retry

	main:
	params: [event]
	steps:
	- init:
	assign:
	- parent: projects/[your-project]/locations/europe-west4/repositories/[your-repo]
	- extract_tableId_step1: '${json.decode(base64.decode(event.data.message.data))}'
	- extract_tableId_step2: '${extract_tableId_step1.protoPayload.metadata.tableCreation.table.tableName}'
	- extract_tableId_step3: '${text.split(extract_tableId_step2, "/")}'
	- extract_tableId_step4: '${extract_tableId_step3[len(extract_tableId_step3) -1]}'

WouterNieuwerth / example.sql

Last active August 24, 2023 18:59

Example SQL with incremental tables

	config {
	type: "incremental",
	description: "Counts the amount of specific events per session per day.",
	schema: "monitoring",
	tags: ["ga4"],
	bigquery: {
	partitionBy: "event_date",
	}
	}

WouterNieuwerth / ga4_events.sqlx

Last active August 26, 2023 09:33

Datafrom config declaration

	config {
	type: "declaration",
	database: "your-database",
	schema: "analytics_123456789",
	name: dataform.projectConfig.vars.GA4_TABLE,
	}

WouterNieuwerth / dataform.json

Created August 24, 2023 18:39

GA4_TABLE variable for dataform.json

	{
	"defaultSchema": "dataform",
	"assertionSchema": "dataform_assertions",
	"warehouse": "bigquery",
	"defaultDatabase": "your-database",
	"defaultLocation": "EU",
	"vars": {
	"GA4_TABLE": "events_*"
	}
	}

WouterNieuwerth / google_workflow.jaml

Created August 24, 2023 18:26

Google Workflow

	main:
	params: [event]
	steps:
	- init:
	assign:
	- parent: projects/[your-project]/locations/europe-west4/repositories/[your-repo]
	- extract_tableId_step1: '${json.decode(base64.decode(event.data.message.data))}'
	- extract_tableId_step2: '${extract_tableId_step1.protoPayload.metadata.tableCreation.table.tableName}'
	- extract_tableId_step3: '${text.split(extract_tableId_step2, "/")}'
	- extract_tableId_step4: '${extract_tableId_step3[len(extract_tableId_step3) -1]}'

WouterNieuwerth / ssgtm_tag_template_complete_example.js

Created February 28, 2022 21:01

	// An example tag template that makes a request to OpenWeatherMap.org
	// and sends data about the weather to both GA4 and Universal Analytics.

	const getAllEventData = require('getAllEventData');
	const getEventData = require('getEventData');
	const JSON = require('JSON');
	const sendEventToGoogleAnalytics = require('sendEventToGoogleAnalytics');
	const sendHttpRequest = require('sendHttpRequest');

	const client_id = getEventData('client_id');

WouterNieuwerth / ssgtm_tag_template_sendEventToGoogleAnalytics_UA.js

Created February 28, 2022 20:50

	// Send data to Universal Analytics
	const getEventData = require('getEventData');
	const sendEventToGoogleAnalytics = require('sendEventToGoogleAnalytics');

	const client_id = getEventData('client_id');

	const events = {
	'x-ga-measurement_id': 'UA-XXXXXX-1', // Replace with your own GA UA ID
	'v': 1,
	't': 'event',

WouterNieuwerth / ssgtm_tag_template_sendEventToGoogleAnalytics_GA4_extra_data.js

Created February 28, 2022 20:44

	// Send data to GA4
	const getAllEventData = require('getAllEventData');
	const sendEventToGoogleAnalytics = require('sendEventToGoogleAnalytics');

	const events = getAllEventData();

	// Add extra fields to the events object:
	events.firstname = 'Wouter';

	sendEventToGoogleAnalytics(events, (response) => {

WouterNieuwerth / ssgtm_tag_template_sendEventToGoogleAnalytics_GA4.js

Created February 28, 2022 20:41

	// Send data to GA4
	const getAllEventData = require('getAllEventData');
	const sendEventToGoogleAnalytics = require('sendEventToGoogleAnalytics');

	const events = getAllEventData();

	sendEventToGoogleAnalytics(events, (response) => {
	data.gtmOnFailure();
	});

WouterNieuwerth / ssgtm_tag_template_sendHttpRequest.js

Created February 27, 2022 13:00

This Server-side GTM tag template makes a request to openweathermap.org and parses the JSON response.

	// An example tag template that makes a request to OpenWeatherMap.org

	const JSON = require('JSON');
	const sendHttpRequest = require('sendHttpRequest');

	sendHttpRequest('https://api.openweathermap.org/data/2.5/weather?lat=52.3746027&lon=6.6810724&appid=[enter_api_key_here]&units=metric&lang=nl', (statusCode, headers, response) => {

	response = JSON.parse(response);

	// Do something with the response.

Wouter Nieuwerth WouterNieuwerth