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!

SQL

-

 

Quick Notes

  • Two categories of SQL statements:
    • 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)

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