Ben Kuehn

Googler. Dog Person. Opinions are my own.

[Ben Kuehn @That_One_Ben]

I likely won't be posting updates here anymore. You can find me at https://t.co/QkbzFfLreo or maybe I'll start posting on my LinkedIn

[Ben Kuehn @That_One_Ben]

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. https://t.co/9wZCRy6tG8

[Ben Kuehn @That_One_Ben]

If you run into any bugs, please let me know! If you use my tools, please fill out this survey to let me know! https://t.co/Flc9tHfFlJ

[Ben Kuehn @That_One_Ben]

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: https://t.co/yk9p8YpvAT

[Ben Kuehn @That_One_Ben]

As always, if you use any of the tools I've worked on, please fill out this survey! https://t.co/Flc9tHf7wb

[Ben Kuehn @That_One_Ben]

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. https://t.co/9wZCRy6tG8

[Ben Kuehn @That_One_Ben]

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.

[Ben Kuehn @That_One_Ben]

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!

https://t.co/9wZCRy6tG8

[Ben Kuehn @That_One_Ben]

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!
https://t.co/mDwtwGPj73

[Ben Kuehn @That_One_Ben]

As always, if you find this work helpful, please let me know by filling out this form: https://t.co/Flc9tHf7wb

[Ben Kuehn @That_One_Ben]

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.

https://t.co/LTZ9CnTpDb

[Ben Kuehn @That_One_Ben]

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.

[Ben Kuehn @That_One_Ben]

Let me know if you experience any bugs and please consider filling out my survey if you find this solution helpful! https://t.co/Flc9tHf7wb

[Ben Kuehn @That_One_Ben]

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. https://t.co/g22P6cHv3A

[Ben Kuehn @That_One_Ben]

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.

[Ben Kuehn @That_One_Ben]

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!
https://t.co/g22P6cHv3A

[Ben Kuehn @That_One_Ben]

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

[Ben Kuehn @That_One_Ben]

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.
https://t.co/mDwtwGPj73

[Ben Kuehn @That_One_Ben]

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!