Dimension names are deceptive. Just because they have the same name both in GA4 and Ads, it does not mean they follow the same convention of data formatting. To blend successfully, you have to make sure both Dimensions have the same data format. Watch out for source data granularity.

There is an additional service named netplan.io that overrides it. If you get rid of it, systemd-networkd will function correctly, just as described in the documentation.

2023-09-08 UPDATE: It is no longer necessary to create custom Month of Year dimension. The new version of Google Data Studio (renamed to Looker Studio) now contains dimension called Year month. Additionally, my function is broken due to internal changes of Year dimension data formatting.

Updated formula that works - Credit to Manuel Garcia:

PARSE_DATE('%Y-%m', CONCAT(SUBSTR(Year, 1, 4), '-', IF(Month < 10, CONCAT('0', Month), CAST(Month AS TEXT ) ) ) )

It is not TODATE(Date, '%Y-%m').

Recently, we've received a request from one of our clients to convert the built-in Description field from one of their taxonomies into a mandatory field. Sounds easy, right?

UPDATE: Some people have reached out to me that the guide does not work for them. I've decided to re-do the guide with a clean install of Debian 11 Bullseye (stable as of August 2021).

MySQL Workbench is currently unavailable on Debian 10 and 11. Ubuntu packages seem to be incompatible. The only two remaining options for installation are: getting a Snap package or building the Workbench from source. This blog post deals with the latter.

Rozhodl jsem se doma vybočit z cyklu vaření v karanténě. Už mi začaly docházet nápady, co dalšího si udělat a měli jsme chuť na něco, co jiné restaurace nerozváží. Oběd jsme si proto objednali z [W Restaurant](https://www.wrbmprague.cz), což je nová restaurace v centru Prahy na Josefově.

S Novým rokem přichází také změna u nás ve WebMedea Services a Triton IT. Stěhujeme se z naší současné adresy ve Viktora Huga do větších prostor. Od ledna nás tak naleznete na Praze 1 v ulici Křemencova, hned vedle známé restaurace U Fleků.

The time has come for us in WebMedea to move away from the iptables firewall. While the software remains actively maintained by Netfilter, I've set my eyes upon the more recently developed nftables as it seems easier to administer and maintain rules. Nftables unifies all the separate utilities of arptables, ebtables, iptables and ip6tables into a single one. It has slightly different rule writing syntax, which can greatly shorten rules, but the principles of filtering practically remain the same.

While poking internet for a quick-to-explain guide, I've arrived (quite obviously) to the nftables wiki 10 minute guide. It literally takes 10 minutes for anyone with previous knowledge of iptables to adapt to the new syntax with this guide.