Empty Tables on Google Analytics

Get Help
1

HI, I've followed all steps to conect on Google Analytics. The connection was made succesfully, but there is no tables inside de DataBase. I saw that all the datas are in a property inside the GA account.

Here is my troule-shooting:

{
"browser-info": {
"language": "pt-BR",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.5112.102 Safari/537.36 Edg/104.0.1293.63",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.16+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.16",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.16+8",
"os.name": "Linux",
"os.version": "5.10.0-14-amd64",
"user.language": "en",
"user.timezone": "America/Sao_Paulo"
},
"metabase-info": {
"databases": [
"postgres",
"googleanalytics",
"mysql"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "13.2 (Debian 13.2-1.pgdg100+1)"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.4.1"
}
},
"run-mode": "prod",
"version": {
"date": "2022-08-16",
"tag": "v0.44.1",
"branch": "release-x.44.x",
"hash": "112f5aa"
},
"settings": {
"report-timezone": null
}
}
}

I see that the property has a different ID than the account itself.

image
image782×123 8.93 KB

and when a try to connect in the property a got access denied.

Can someone help me? Tnx.

2

Hi @Jessezyn
So you have followed this?:
https://www.metabase.com/docs/latest/databases/connections/google-analytics.html

Metabase currently only works with Web properties, and GAv3.

3

Yes, i've followed these steps properlly. But i hope this information you gave me is suficient to show my bosses that it's not possible to work on this task. Tnx.

4

Is there any prediction of when Metabase will be working with GA v4?

5

@Jessezyn I cannot give you any timeline:
https://github.com/metabase/metabase/issues/12905 - upvote by clicking :+1: on the first post

1 Like
6

I am also facing the same issue where Metabase is considering my Google Analytics accounts as Tables and Tables as Values.
And when I go to preview a value (which is actually a table) I get an error
Plus the queries are also returning an error