All Questions
66 questions
1
vote
0
answers
309
views
Data set not created for firebase analytics and Bigquery integration,
I recently linked my Firebase project with Google Big Query. My Firebase project has an active Android and iOS app and I can successfully retrieve data.
When I exported Crashlytics, Performance ...
- 125
0
votes
0
answers
13
views
Backfill Google Analytics (GA4) Data in Big Query [duplicate]
I enabled BigQuery export from Google Analytics GA4 yesterday, I understand that from now on I will get a daily export; which I confirm it works.
However, I am interested in exporting data from before ...
- 327
0
votes
0
answers
54
views
Big Query export not able to exclude Events
I have configured a BQ export to get app_remove event and exclude all.
But the firebase_campaign event is not getting filtered to be excluded. I have even excluded the same by specifying the event by ...
0
votes
0
answers
72
views
Firebase analytics MAUs and Google Play store statistics' MAUs has a difference of 4x
I am calculating monthly active users using my firebase app events table in BigQuery.
The queries below and the MAUs from the firebase analytics dashboard has around the same numbers with a delta of ...
0
votes
0
answers
28
views
Server Data Overflow
I work with Firebase and fill UserProperties with what player character wears(helmet, ring, boots). I have recently changed a name of a user property and now in BigQuery our analytics see that there ...
0
votes
0
answers
259
views
GA4 - Bigquery: How to get events by removing duplication based on user_pseudo_id?
I have a landing page and a button download. We added a firebase tag to know when a user clicks on the button.
In Google Analytics, we have two data, one Event count counting each time the button is ...
- 1,312
1
vote
1
answer
927
views
How to find users who logged in every single day to the app?
I'm trying to get the details of the power users of my app. So trying to fetch the list of users who have used the app every single day or N out of M days. (N < M)
I'm new to BigQuery and found ...
- 7,931
0
votes
1
answer
635
views
Query number of rooted android devices using the app
I've noticed Firebase Crashlytics has knowledge whether device is rooted or no:
Is it possible to get this data via query - minimum for devices that crashed, maximum for any device using Google ...
- 3,500
1
vote
0
answers
245
views
missing data firebase sync to bigquery sandbox
I use Bigquery Sandbox and export raw event data from Google Analytics to Bigquery. But The number of events 2 places are different.Bigquery much less Google Analytics.
My number of events per day ...
- 101
2
votes
1
answer
532
views
BigQuery stops importing data from Firebase Analytics
My second BigQuery project has stopped importing data from Firebase Analytics. The last import was succeeded 2 weeks ago. But intraday import continue works well. Crashlytics too.
The activity section ...
- 422
0
votes
1
answer
2k
views
How to deal with changing user_pseudo_id?
I have a mobile app and I use firebase and BigQuery to download data for analysis. Recently the 'user_pseudo_id' has been changing when 'app_remove' event is triggered. When I emailed firebase, they ...
0
votes
0
answers
1k
views
How to get count of active users grouped by version? (from Firebase using BigQuery)
Problem description
I'm trying to get the information of how many active users I have in my app separated by the 2 or 3 latest versions of the app.
I've read some documentations and other stack ...
- 83
2
votes
1
answer
163
views
How to stream Google Search console into Firebase Analytics into Google Cloud Bigquery?
From https://support.google.com/analytics/thread/160902664?hl=en
Hi, I have connected my Google Search Console with Firebase Analytics, and Firebase Analytics with Google Cloud Bigquery, after waiting ...
- 338
0
votes
0
answers
111
views
FOR SYSTEM_TIME AS OF is not supported with table wildcards
I just need to bring the deleted tables from Firebase tables. The problem is that I don't know the tables names. So I am using,
SELECT * FROM `MyProject.MyDataSet.events_*`
FOR SYSTEM_TIME AS OF '2022-...
0
votes
1
answer
1k
views
iOS Firebase Events Don't Show in BigQuery but do in Google Analytics and Firebase Console
I'm having an issue with Firebase Events from my iOS app in that they are missing from BigQuery (Events Table) but show up in the Firebase Console and Google Analytics dashboard. Android does not have ...
- 679