Major changes. Bug fixes, rewritten functionality. Anomaly detection.

Whats new and instructions.

Upgrading instructions

This is a major upgrade, with bug fixes and lot's of functionality upgrades.

• For complete upgrading instructions and changes, see Upgrading to Version 3.0
• After you have made all the changes, go to Settings in the Google Sheet. Scroll down to Version, and add 3.0 as the new version.

Whats new

Google Sheet

• Settings sheet
  • Added more parameters for exclusion to the Exclude Params from SQL Query field.
    • Parameters are documented in the Google Sheet Settings section.
  • Added Exclude Events from SQL Query field.
    • Events are documented in the Google Sheet Settings section.
  • Events sheet: Added info about what you are querying; API or BigQuery.
  • Parameters sheet: Added info what you you are querying; API or BigQuery.
• Advanced Settings
  • New Sheet for BigQuery settings

Apps Script

• Rewritten some scripts, and added more functionality.

Google Cloud / BigQuery

• Rewritten existing SQL queries
• Added Anomaly Detection for Events & Parameters
• SQL Query settings is now controlled from the Google Sheet
• New setup for Log Router & Cloud Functions
• Added Cloud Scheduler to the setup
• Restructured some BigQuery tables

Looker Studio

• Daily count for Events and Parameters
• Anomaly reports for Events and Parameters

Major update because of GA4 Key Events

GA4 changed Conversion Events into Key Events a while ago, and this change has also reached the API. This small wording change has trickled down as a major update to this solution.

What's new?

• Rewritten Apps Script in Google Sheet from Conversion Events to Key Events.
• Rewritten Named Ranges in Google Sheet from Conversion Events to Key Events.
• Changed BigQuery tables to use key_event in Field Name(s) instead of conversion_event.
• Added Fist Seen date for Event Names and Parameters to BigQuery documentation status tables.
• Updated both Basic and Advanced versions of Looker Studio.
• Improved documentation on GitHub.

If you are upgrading from the previous solution, here is what you have to do:

Google Sheet

• You must start using the new Google Sheet. It's simply not possible to explain all the changes needed to upgrade the existing Google Sheet.
• You can copy your existing documentation to the new Google Sheet by using copy + paste. Make sure you paste values only.

BigQuery

• Delete existing tables created by the previous documentation solution.
• Replace the SQL queries ga4_documentation_events_and_documentation_status.sql and ga4_documentation_parameters_and_documentation_status.sql with the new queries.
• Run BigQuery -> Export Event & Parameter Documentation from the GA4 Documentation menu in the Google Sheet. This will recreate the tables again.

Looker Studio

• Basic version: Connect to the new Google Sheet as a data source, or use the new Looker Studio report. Changes are mainly Field Name changes (Conversion Event -> Key Event & Conversion Event Counting -> Key Event Counting).
• Advanced version: Use the new Looker Studio report because of new fields and changed fields.

Updates to Apps Script 08_Annotations-GTM.gs

It's now possible to get the correct GTM Container Version Date as Annotation Date.

Copy 08_Annotations-GTM.gs Apps Script and replace that Apps Script in the Google Sheet:
https://github.com/Knowit-Experience-MarTech/ga4-documentation-administration-solution/blob/main/Apps-Script/08_Annotations-GTM.gs

After you have replaced the Apps Script, go to Settings in the Google Sheet. Scroll down to Version, and add 1.11 as the new version.

Added support for Basic Looker Studio documentation report

Added support for Basic Looker Studio documentation report using Google Sheet as Data Source.

Copy 01_Generic-&-Definitions.gs Apps Script and replace that Apps Script in the Google Sheet:
https://github.com/Knowit-Experience-MarTech/ga4-documentation-administration-solution/blob/main/Apps-Script/01_Generic-%26-Definitions.gs

Copy 02_Parameter-Functionality.gs Apps Script and replace that Apps Script in the Google Sheet:
https://github.com/Knowit-Experience-MarTech/ga4-documentation-administration-solution/blob/main/Apps-Script/02_Parameter-Functionality.gs

Copy 11_Event-Parameter-Join-Google-Sheet.gs Apps Script and replace that Apps Script in the Google Sheet:
https://github.com/Knowit-Experience-MarTech/ga4-documentation-administration-solution/blob/main/Apps-Script/11_Event-Parameter-Join-Google-Sheet.gs

See https://github.com/Knowit-Experience-MarTech/ga4-documentation-administration-solution/tree/main/Looker-Studio for more information.

After you have replaced the Apps Script, go to Settings in the Google Sheet. Scroll down to Version, and add 1.1 as the new version.

Initial release

If you are using a pre-relase version of the Google Sheet, replace all the scripts / code that can be found in the Apps Script folder: https://github.com/Knowit-Experience-MarTech/ga4-documentation-administration-solution/tree/main/Apps-Script just to be sure you have the latest version.

In your Google Sheet, go to Extensions -> Apps Script. Replace code.

Then go to Settings in the Sheet, and update Version to 1.0