Welcome to my Encyclopedia

-
If you made it here, you found my notes page.  I read a lot of information and then I test out that information so I can put it in my own words.  After trying browser bookmarks, trello boards, evernote, plain old notebook, I'm trying this option to reference all the great stuff I read. I am not taking credit for the great content out there, I only needed a spot where I can find it again and again.   Never stop learning!

Data Engineering

-

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



Popular posts from this blog

SA360: Add Tracking Parameters to Landing Page URL (Final URL Suffix)

-
Image
  What parameter types to use to enable tracking on Search Ads Quick Notes Dynamic macros are called two different things depending on platform SA360 - custom parameters GAds - ValueTrack parameters custom parameters in Google Ads context are custom query parameters typically in {_name} format can be static or dynamic Google will always recognize Final URL Suffix (where you place your parameters) In SA360 you can find Final URL Suffix under Ad Builder Google with recognize the URL template for dartsearch under the URL template, this is only the redirect to get to the destination URL In Google Ads this is located when edit an ad Dynamic Search Ads Seem to setup in Google Ads Search Ads360 setup:  Dynamic search ads from Search Ads 360 default url is {unescapedurl} Instead of inheriting the engine account's URL template,  you can create a template at the  campaign or ad group  level. Or if you want to specify unique URL parameters for each  ad  or...
Read more

Daily Nugget: GA4 Client ID Globally

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