Where is google analytics code in database ?

Hi there,
If you used the auth method, it cannot be changed from the database, it would have to be done via the admin because changing the ua code also would require corresponding public and secret key changes which have to be issued during the Google oAuth flow and thus only in the admin can it be done.

If you used a filter or constant to set it, then you would need to adjust the corresponding code as it wouldn’t be stored in the database.

If you used the manual method, it would be in the monsterinsights_settings option in the world options table. Regular auth is in there or in dedicated keys depending on the version you have, but again you’d have to complete the auth flow again from the admin to make it work else all of the numbers will be off and the auth won’t work.

• This reply was modified 7 years, 1 month ago by chriscct7.

It should also be noted if any sort of caching is enabled, database level changes won’t work for any method, you have to do it from the admin so the caches are cleared.

We heavily don’t recommend changing database values and in most cases it’s not going to work the way you are going to think it will.

Thanks a lot !