New Google Analytics doesnt get tables, old one does

aljaz · December 29, 2020, 5:49pm

I have been trying to set up Metabase and connect our GA project. I have been over and over the process and everytime I connected a project there was no DB schema found and consequently no data. Wehn looking over the logs, I could not find out anything usefull except that apperantly no data was pulled. When going over the forum I found out that there were some cases when GA stopped working with new projects, so I tested and connected one of our legacy GA accounts and there I got the data.

Is there any trick how to get data from new Google Analytics?

This is the log for the new Google Analytics project:

[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:19+01:00 INFO metabase.sync.util     STARTING: Sync metadata for googleanalytics Database 4 'Mobile app data'
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:19+01:00 INFO metabase.sync.util STARTING: step 'sync-timezone' for googleanalytics Database 4 'Mobile app data'
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:19+01:00 INFO metabase.sync.util FINISHED: step 'sync-timezone' for googleanalytics Database 4 'Mobile app data' (112,1 µs)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:19+01:00 INFO metabase.sync.util STARTING: step 'sync-tables' for googleanalytics Database 4 'Mobile app data'
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:19+01:00 INFO metabase.sync.util FINISHED: step 'sync-fields' for googleanalytics Database 4 'Mobile app data' (499,0 µs)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:19+01:00 INFO metabase.sync.util FINISHED: step 'sync-tables' for googleanalytics Database 4 'Mobile app data' (659,8 ms)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:19+01:00 INFO metabase.sync.util STARTING: step 'sync-fields' for googleanalytics Database 4 'Mobile app data'
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:19+01:00 INFO metabase.sync.util FINISHED: step 'sync-fks' for googleanalytics Database 4 'Mobile app data' (369,3 µs)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:19+01:00 INFO metabase.sync.util STARTING: step 'sync-fks' for googleanalytics Database 4 'Mobile app data'
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:19+01:00 INFO metabase.sync.util STARTING: step 'sync-metabase-metadata' for googleanalytics Database 4 'Mobile app data'
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:21+01:00 INFO metabase.sync.util FINISHED: step 'sync-metabase-metadata' for googleanalytics Database 4 'Mobile app data' (1,3 s)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:21+01:00 INFO metabase.sync.util FINISHED: Sync metadata for googleanalytics Database 4 'Mobile app data' (1,9 s)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:21+01:00 INFO metabase.sync.util STARTING: Analyze data for googleanalytics Database 4 'Mobile app data'
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:21+01:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for googleanalytics Database 4 'Mobile app data' (57,8 µs)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:21+01:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for googleanalytics Database 4 'Mobile app data' (71,9 µs)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:21+01:00 INFO metabase.sync.util FINISHED: step 'fingerprint-fields' for googleanalytics Database 4 'Mobile app data' (160,2 µs)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:21+01:00 INFO metabase.sync.util STARTING: step 'classify-fields' for googleanalytics Database 4 'Mobile app data'
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:21+01:00 INFO metabase.sync.util STARTING: step 'classify-tables' for googleanalytics Database 4 'Mobile app data'
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:21+01:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for googleanalytics Database 4 'Mobile app data'
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:21+01:00 INFO metabase.sync.util FINISHED: Analyze data for googleanalytics Database 4 'Mobile app data' (2,4 ms)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:27+01:00 DEBUG metabase.middleware.log GET /api/database/4/schemas 200 2,2 ms (4 DB calls) App DB connections: 1/7 Jetty threads: 5/50 (1 idle, 0 queued) (56 total active threads) Queries in flight: 0 (0 queued)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:30+01:00 DEBUG metabase.middleware.log GET /api/setup/admin_checklist 200 4,6 ms (13 DB calls) App DB connections: 0/7 Jetty threads: 5/50 (1 idle, 0 queued) (56 total active threads) Queries in flight: 0 (0 queued)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:30+01:00 DEBUG metabase.middleware.log GET /api/activity 200 13,4 ms (2 DB calls) App DB connections: 0/7 Jetty threads: 7/50 (0 idle, 0 queued) (56 total active threads) Queries in flight: 0 (0 queued)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:30+01:00 DEBUG metabase.middleware.log GET /api/activity/recent_views 200 11,4 ms (1 DB calls) App DB connections: 0/7 Jetty threads: 7/50 (0 idle, 0 queued) (56 total active threads) Queries in flight: 0 (0 queued)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:49+01:00 DEBUG metabase.middleware.log GET /api/setting 200 2,3 ms (0 DB calls) App DB connections: 0/7 Jetty threads: 5/50 (0 idle, 0 queued) (56 total active threads) Queries in flight: 0 (0 queued)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:49+01:00 DEBUG metabase.middleware.log GET /api/session/properties 200 3,3 ms (2 DB calls) App DB connections: 0/7 Jetty threads: 6/50 (0 idle, 0 queued) (56 total active threads) Queries in flight: 0 (0 queued)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:49+01:00 DEBUG metabase.middleware.log GET /api/setup/admin_checklist 200 5,1 ms (13 DB calls) App DB connections: 0/7 Jetty threads: 5/50 (0 idle, 0 queued) (56 total active threads) Queries in flight: 0 (0 queued)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:50+01:00 DEBUG metabase.middleware.log GET /api/util/bug_report_details 200 9,9 ms (1 DB calls) App DB connections: 1/7 Jetty threads: 5/50 (0 idle, 0 queued) (56 total active threads) Queries in flight: 0 (0 queued)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:53+01:00 DEBUG metabase.middleware.log GET /api/task 200 18,3 ms (2 DB calls) App DB connections: 0/7 Jetty threads: 5/50 (0 idle, 0 queued) (56 total active threads) Queries in flight: 0 (0 queued)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:27:53+01:00 DEBUG metabase.middleware.log GET /api/database 200 4,4 ms (3 DB calls) App DB connections: 0/7 Jetty threads: 5/50 (0 idle, 0 queued) (56 total active threads) Queries in flight: 0 (0 queued)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:28:16+01:00 DEBUG metabase.middleware.log GET /api/task/361 200 4,7 ms (1 DB calls) App DB connections: 0/7 Jetty threads: 5/50 (1 idle, 0 queued) (57 total active threads) Queries in flight: 0 (0 queued)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:28:20+01:00 DEBUG metabase.middleware.log GET /api/task/363 200 861,6 µs (1 DB calls) App DB connections: 0/7 Jetty threads: 5/50 (1 idle, 0 queued) (57 total active threads) Queries in flight: 0 (0 queued)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:28:34+01:00 DEBUG metabase.middleware.log GET /api/task/351 200 1,2 ms (1 DB calls) App DB connections: 0/7 Jetty threads: 5/50 (3 idle, 0 queued) (57 total active threads) Queries in flight: 0 (0 queued)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:28:37+01:00 DEBUG metabase.middleware.log GET /api/task/356 200 1,2 ms (1 DB calls) App DB connections: 0/7 Jetty threads: 5/50 (2 idle, 0 queued) (57 total active threads) Queries in flight: 0 (0 queued)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:28:45+01:00 DEBUG metabase.middleware.log GET /api/task/info 200 7,9 ms (0 DB calls) App DB connections: 0/7 Jetty threads: 5/50 (2 idle, 0 queued) (57 total active threads) Queries in flight: 0 (0 queued)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:28:53+01:00 DEBUG metabase.middleware.log GET /api/task/info 200 693,3 µs (0 DB calls) App DB connections: 1/7 Jetty threads: 5/50 (2 idle, 0 queued) (57 total active threads) Queries in flight: 0 (0 queued)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:35:08+01:00 DEBUG metabase.middleware.log PUT /api/database/4 200 2,0 s (4 DB calls) App DB connections: 0/7 Jetty threads: 5/50 (1 idle, 0 queued) (56 total active threads) Queries in flight: 0 (0 queued)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:35:08+01:00 DEBUG metabase.middleware.log GET /api/database 200 4,5 ms (3 DB calls) App DB connections: 0/7 Jetty threads: 5/50 (1 idle, 0 queued) (56 total active threads) Queries in flight: 0 (0 queued)
[39bf1e4a-9fc6-4fe5-adc1-edb7320cbc26] 2020-12-29T18:35:12+01:00 DEBUG metabase.middleware.log POST /api/database/4/sync_schema 200 1,4 ms (1 DB calls) App DB connections: 0/7 Jetty threads: 5/50 (1 idle, 0 queued) (56 total active threads) Queries in flight: 0 (0 queued)

And this is the one for the old one:

flamber · December 29, 2020, 6:06pm

Hi @aljaz
Post “Diagnostic Info” from Admin > Troubleshooting. Latest release is 0.37.4
I’m not sure what you mean about legacy and new accounts, but if your GA is App+Web, then it’s currently not supported:
https://github.com/metabase/metabase/issues/11396 - upvote by clicking on the first post

aljaz · December 29, 2020, 6:42pm

Hi @flamber

thank you for the quick reply. Yes, with new and legacy account I meant exactly what you wrote (app+Web). I will upvote the github issue.