Work. Sport. Fun.

  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/

  Links Campaign Manager 360 Announcements Adobe Google Issue Tracker My Bug:  https://issuetracker.google.com/issues/193187537#comment1 Google Ads Status General Down Detector Google Analytics Releases

  Quick Notes My Drive notes are here Links Campaign Manager Macros:   https://support.google.com/campaignmanager/table/6096962?hl=en Landing page URL suffix:  https://support.google.com/campaignmanager/answer/3467782#zippy=%2Csteps

  Links Trailhead login:   https://trailhead.salesforce.com/en Krux, DMP email pixels:  https://konsole.zendesk.com/hc/en-us/articles/115002476168-Email-Campaign-Implementation-Guide Parameter Manager:  https://help.salesforce.com/s/articleView?id=000353527&type=1 Quick Tips Connecting GA360 & SFMC  https://youtu.be/dMaKjsUbv1o Click Edit Settings on the far right to get to the next screen SFMC and Audience:  https://youtu.be/lDxW7PTBQoI