Google Analytics connection

Hi,

I connected my Google Analytics account with Metabase, but Metabase is not able to retrieve any tables. No tables found is the message I get when I want to view the data.

What am I doing wrong?

Thanks a lot!

Hi @ropraet
Post "Diagnostic Info" from Admin > Troubleshooting.
Check if the sync process has finished syncing successfully - Admin > Troubleshooting > Logs.
Perhaps you are using App+Web, which is currently not supported:
https://github.com/metabase/metabase/issues/11396 - upvote by clicking :+1: on the first post

{
"browser-info": {
"language": "nl-NL",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.82 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.11+9-Ubuntu-0ubuntu2.20.04",
"java.vendor": "Ubuntu",
"java.vendor.url": "https://ubuntu.com/",
"java.version": "11.0.11",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.11+9-Ubuntu-0ubuntu2.20.04",
"os.name": "Linux",
"os.version": "5.4.0-73-generic",
"user.language": "en",
"user.timezone": "Etc/UTC"
},
"metabase-info": {
"databases": [
"h2",
"postgres",
"googleanalytics"
],
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "1.4.197 (2018-03-18)"
},
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "1.4.197 (2018-03-18)"
}
},
"run-mode": "prod",
"version": {
"date": "2021-07-14",
"tag": "v0.40.1",
"branch": "release-x.40.x",
"hash": "ed8f9c8"
},
"settings": {
"report-timezone": null
}
}
}

I am using Desktop as mentioned in the documentation.

@ropraet

  1. Check if the sync process has finished syncing successfully - Admin > Troubleshooting > Logs.
  2. You are misunderstanding. Correct, you need to use "Desktop", since Google removed the "Other" type, but I'm talking about the "App + Web properties", which is something completely different. See the issue for more details.

I can't find this setting. Can you give a bit more explanation please. Thanks a lot and sorry to bother you with it!

@ropraet Which setting?

I mean the App + Web properties.

@ropraet Okay, so please provide the information I'm asking for:

  • Check if the sync process has finished syncing successfully - Admin > Troubleshooting > Logs.

I have no idea which type of GA you are using. Metabase only support GA version 3 and only Web properties.
References that you should read:
https://github.com/metabase/metabase/issues/12905
https://github.com/metabase/metabase/issues/11396

The sync process finished I think:

[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:53+02:00 INFO metabase.sync.util STARTING: Sync googleanalytics Database 6 'Smartendr Website'
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:53+02:00 INFO metabase.sync.util FINISHED: stap "sync-timezone" voor googleanalytics Database 6 'Smartendr Website' (302.8 µs)
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:53+02:00 INFO metabase.sync.util STARTING: Sync metadata for googleanalytics Database 6 'Smartendr Website'
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:53+02:00 INFO metabase.sync.util STARTING: stap "sync-timezone" voor googleanalytics Database 6 'Smartendr Website'
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:53+02:00 INFO metabase.sync.util STARTING: stap "sync-tables" voor googleanalytics Database 6 'Smartendr Website'
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:53+02:00 DEBUG metabase.server.middleware.log GET /api/database 200 2.4 ms (3 DB-aanroepen) Applicatieverbindingen met DB: 0/15 Jetty-threads: 3/50 (4 wachtend, 0 in wachtrij) (108 totaal actieve threads) Querys actief nu: {0} (0 in wachtrij)
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:54+02:00 INFO metabase.sync.util FINISHED: stap "sync-tables" voor googleanalytics Database 6 'Smartendr Website' (381.4 ms)
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:54+02:00 INFO metabase.sync.util STARTING: stap "sync-fields" voor googleanalytics Database 6 'Smartendr Website'
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:54+02:00 INFO metabase.sync.util FINISHED: stap "sync-fields" voor googleanalytics Database 6 'Smartendr Website' (628.7 µs)
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:54+02:00 INFO metabase.sync.util FINISHED: stap "sync-fks" voor googleanalytics Database 6 'Smartendr Website' (363.7 µs)
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:54+02:00 INFO metabase.sync.util STARTING: stap "sync-fks" voor googleanalytics Database 6 'Smartendr Website'
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:54+02:00 INFO metabase.sync.util STARTING: stap "sync-metabase-metadata" voor googleanalytics Database 6 'Smartendr Website'
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:54+02:00 INFO metabase.sync.util FINISHED: stap "sync-metabase-metadata" voor googleanalytics Database 6 'Smartendr Website' (697.2 ms)
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:54+02:00 INFO metabase.sync.util FINISHED: Sync metadata for googleanalytics Database 6 'Smartendr Website' (1.1 s)
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:54+02:00 INFO metabase.sync.util STARTING: Analyze data for googleanalytics Database 6 'Smartendr Website'
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:54+02:00 INFO metabase.sync.util FINISHED: stap "fingerprint-fields" voor googleanalytics Database 6 'Smartendr Website' (330.5 µs)
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:54+02:00 INFO metabase.sync.util STARTING: stap "classify-fields" voor googleanalytics Database 6 'Smartendr Website'
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:54+02:00 INFO metabase.sync.util STARTING: stap "fingerprint-fields" voor googleanalytics Database 6 'Smartendr Website'
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:54+02:00 INFO metabase.sync.util FINISHED: stap "classify-fields" voor googleanalytics Database 6 'Smartendr Website' (171.4 µs)
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:54+02:00 INFO metabase.sync.util FINISHED: stap "classify-tables" voor googleanalytics Database 6 'Smartendr Website' (166.5 µs)
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:54+02:00 INFO metabase.sync.util STARTING: stap "classify-tables" voor googleanalytics Database 6 'Smartendr Website'
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:54+02:00 INFO metabase.sync.util FINISHED: Analyze data for googleanalytics Database 6 'Smartendr Website' (3.1 ms)
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:54+02:00 INFO metabase.sync.util FINISHED: stap "update-field-values" voor googleanalytics Database 6 'Smartendr Website' (413.8 µs)
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:54+02:00 INFO metabase.sync.util STARTING: Cache field values in googleanalytics Database 6 'Smartendr Website'
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:54+02:00 INFO metabase.sync.util STARTING: stap "update-field-values" voor googleanalytics Database 6 'Smartendr Website'
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:54+02:00 INFO metabase.sync.util FINISHED: Cache field values in googleanalytics Database 6 'Smartendr Website' (1.4 ms)
[f77da145-da57-4db1-9ef9-242a67f0895e] 2021-09-20T14:07:54+02:00 INFO metabase.sync.util FINISHED: Sync googleanalytics Database 6 'Smartendr Website' (1.1 s)

I recently added my property, so I guess I am using the newest Google Analytics.

@ropraet Yes, the sync finished without finding any "tables", so I'm guessing that one of the issues I referenced is causing the problem.

What can I do about it? I don't see the solution in the issues.

@ropraet Since I don't know what problem you might be seeing, then it's close to impossible for me to answer.
When Metabase supports GA v4 and "App + Web" properties, then it might be solved.