Work. Sport. Fun.

  How to get the GA4 Client ID in a few ways because you need to use the Client ID in some way ➡ ➡ ➡ 1. You are in the land of "I have little control and I'm desperate": The Client Id is cookie, and you could try to grab the cookie with two variables const cookieObjCid = new URLSearchParams(document.cookie.replaceAll("&", "%26").replaceAll("; ", "&")); const gaClientId = cookieObjCid.get("_ga").match(/[0-9]+\S[0-9]+$/g); 2. You have the power of the backend and call on the forces of gtag API: After you run the config tag, then do this or that... gtag("get", "G-MEASUREMENTID", "client_id", resolve); }); gtagClient.then((client_id) => { window.gtagClient1 = client_id; }); OR gtag("get", "G-MEASUREMENTID", "client_id", (client_id) => { window.gtagClient2 = client_id; }); 3. You think GTM is amazing and the people that create community templates are real...

  Stuck in the double-quoted abyss within the terminal? For Mac Users, use control+C... for Windows users, Godspeed. 😊 (Actually I think Ctrl+C works for Windows too.)

Common commands to update and create your repo:  https://github.com/jsabor/desktop-tutorial In basic terms: Create a Branch from the Master Create a commit to your Branch Create a Pull Request (PR) Comment on your PR Merge your Branch in Master

  Quick Notes Two categories of SQL statement s: Data Definition Language (DDL) used to describe a database, to define its structure, to create its objects and to create the table's sub-objects. The following list provides some examples of types of DDL statements: Creating tables (CREATE command) Modifying the structure of a table (ALTER command) without deleting and re-creating it, such as adding columns, removing columns or changing column definitions (for example, length or default values) Removing objects (such as tables) from the database (DROP command) Partitioning tables (PARTITION command) Data Manipulation Language (DML) used to control the information contained within the database. The following lists provides some examples of types of DML statements: Adding records to a table (INSERT command) Modifying information in a table (UPDATE command) Removing records from a table (DELETE command)

  Quick Notes Java Content Repository (JCR) - base level of the AEM stack  AEM node structure (credit to Brightspot ): Links Metadata Metadata profiles Import/Export metadata Metadata schemas Creating and managing offers AEM 6.5 Documentation AEM Tutorials

  GA4 Datasets Reminders when working with the GA4 datasets. Quick Notes Explorer Panel The numbers following a data table correspond with the GA Numbers following events correspond to the number of days of data event_intraday collect the streaming data Schema (Google Documentation):  https://support.google.com/analytics/answer/7029846?hl=en

Quick Notes Organize Snowflake Warehouse 3 main components of data warehouse where you ingest raw data (RAW) where data transformations occur (BASE/STAGING - basic casting and field name changes) where you store reporting and experimentation Reverse ETL Census Hub and Spoke model SCD - Slowly Changing Dimensions Type 0   - The passive method Type 1   - Overwriting the old value Type 2   - Creating a new additional record Type 3   - Adding a new column Type 4   - Using historical table Type 6   - Combine approaches of types 1,2,3 (1+2+3=6) Data Modeling Techniques Entity Relationship Diagrams (ERD) Unified Modeling Language (UML) Class Diagrams Data Dictionary Links How to Collect Behavioral Data?  A Guide for Data Engineers and Analysts. CDI: Customer Data Infrastructure https://airbyte.com/blog/collect-behavioral-data-guide Modern Data Stack examples:  https://future.a16z.com/emerging-architectures-modern-data-infrastructure/