Pinned Loading

1. Bigquery SQL Function to obtain the ... Bigquery SQL Function to obtain the value of a given parameter (as a string) from a Google Analytics 4 event and its original value type in case it's needed

   1

   CREATE OR REPLACE FUNCTION `YOUR_PROJECT.YOUR_DATASET.GA4_parameter_value_and_type`(

   2

     parameter_key_to_be_queried STRING, 

   3

     event_params ARRAY<STRUCT<key STRING, 

   4

                               value STRUCT<

   5

                                           string_value STRING, 

2. Using SQL FIRST_VALUE() window funct... Using SQL FIRST_VALUE() window function to replicate GA4 traffic source attribution behavior

   1

   2

   FIRST_VALUE(

   3

     (SELECT 

   4

        value.string_value

   5

      FROM 

3. Using SQL window functions to replic... Using SQL window functions to replicate Google Analytics custom dimensions behavior

   1

   LAST_VALUE(

   2

     (SELECT 

   3

        value.string_value --value.int_value, value.float_value, value.double_value

   4

      FROM 

   5

      	 UNNEST(event_params)

4. GTAG-GA4-custom-tag-builder GTAG-GA4-custom-tag-builder Public

   Provide additional customization options to Google Tag's own native template

   Smarty 14