Ben Kuehn

I likely won't be posting updates here anymore. You can find me at bsky.app/profile/thaton… or maybe I'll start posting on my LinkedIn

Google Analytics Utilities update! You can now modify BQ links and list/modify event edit rules. I'm also building out some Cloud functions that operate off of a CSV file. That isn't fully built, but you'll see some code has been added. github.com/google/google-…

If you run into any bugs, please let me know! If you use my tools, please fill out this survey to let me know! docs.google.com/forms/d/e/1FAI…

Hey folks! I just released a new feature for Google Analytics Utilities. You can now run user access reports in the spreadsheet as described here: #user-access-report" target="_blank" rel="nofollow noopener">github.com/google/google-…

As always, if you use any of the tools I've worked on, please fill out this survey! docs.google.com/forms/d/e/1FAI…

The sheets have also been arranged to more or less follow the same order as the menu. I've also added a calculated metrics sheet and fixed a bunch of bugs that people found while I was on leave.

I'm back and updating Google Analytics Utilities! With the deprecation of UA, all UA functionality has been removed. While this is bittersweet, it does make the spreadsheet a bit more manageable. The menu has been simplified to reflect the changes. github.com/google/google-…

Hey folks, I have an update for Google Analytics Utilities! You can now use the tool to create subproperties and roll-up properties. If you have a need to create a lot of subproperties, GA Utilities can now help! github.com/google/google-…

Hey everyone, the GA4 GTM Utilities tool is now fully compatible with how #GA4 event tags now work in #GTM. If you were having issues with the sheet recently, try making a new copy of the template! github.com/google/ga4-gtm…

As always, if you find this work helpful, please let me know by filling out this form: docs.google.com/forms/d/e/1FAI…

Please let me know if you see any bugs or have any suggestions for improving the migration flow! The best ways to raise those issues is posting in the Google Group or raising an issue on GitHub.

Big update for the GA4 GTM Migration tool! I've rebuilt the tool to work with the configuration and event settings variables and Google Tag. Version 2.0 allows you to create the above to migrate UA tags to GA4. github.com/google/ga4-gtm…

Let me know if you experience any bugs and please consider filling out my survey if you find this solution helpful! docs.google.com/forms/d/e/1FAI…

The main downloader function also no longer uses streaming insert and instead imports data from temporary json files. This should make the data more immediately available and make automation based on new data in the tables easier.

Another Analytics Settings Database update! I've updated the "health_settings" table to now be the "property_overview" table and included two different ways of getting that table, a scheduled query or a cloud function workflow. github.com/google/analyti…

I updated the Analytics Settings Database to include basically everything that the #GA4 Admin API interacts with. It should now be possible to use a gen 2 Google Cloud Function instead of gen 1 for this solution. Let me know if you run into any bugs! github.com/google/analyti…

I fixed some bugs in the latest release. It should be working properly now.

The variable usage feature looks at all tags in a workspace, not just GA4 event tags. It could be useful when trying to figure out which variables are used where in a workspace. Please let me know if you experience bugs!

Another tool update! This time for GA4 GTM Utilities. This includes various bug fixes and the introduction of the "Variable Usage" sheet. You can now list your variables and determine which tags, triggers, and variables use said variable. github.com/google/ga4-gtm…