All Questions
Tagged with google-analytics google-bigquery
622 questions
0
votes
1
answer
83
views
How to identify GA4 key events in Google BigQuery (to correctly calculate engaged sessions)?
I'm exporting GA4 event data to Google BigQuery to later analyze the data.
In the GA4 property settings, you can mark specific events as "key events", which you can later use to optimize you ...
- 86
0
votes
1
answer
107
views
in GA4，the daily exported events are about to exceed 1 million. What should I do next?
I am using the Daily Export method to export some GA events to BigQuery, but the daily event volume is about to exceed 1 million. If I switch to the Streaming method, I might lose information such as ...
- 1
0
votes
0
answers
257
views
BigQuery and Google Analytics 4 channel grouping
I am experiencing a problem with the differences between the data I see in BigQuery and the data GA4 shows. Although sessions and events appear the same, I am having trouble categorizing channels. I ...
- 1
0
votes
2
answers
178
views
Huge Discrepancy in Total Users Between BigQuery and GA4
I'm experiencing a significant discrepancy in the total user count between BigQuery and GA4. I'm using Shopify and Elevar for server-side tracking. Over one week, there is a 15% discrepancy, and over ...
- 539
1
vote
0
answers
366
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
1
answer
100
views
promote Bigquery table replica to primary
I have a dataset in Bigquery which has a connection to Google Analytics so that the GA-data is loaded into a Bigquery sharded table called events_YYYYMMDD. This happens automatically in the background....
- 17
0
votes
0
answers
99
views
BigQuery and GA4 total users cant match
I'm trying to find out how many distinct user records there are for an event between certain dates with BigQuery.
The results of BigQuery query does not match with the Google Analytics and Firebase ...
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 ...
- 337
0
votes
0
answers
60
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
2
answers
122
views
Which schema / table structure should I use to back up Google Analytics (UA) data to BigQuery?
We've written a JAVA application that pulls data from the Google Analytics API and pushes all client data into this BigQuery table (see current schema). We are then using Materialized views in our ...
0
votes
0
answers
27
views
Apply an Event Label Filter to the Product Revenue metric in GBQ using Universal GA Data in Looker
I've got an event cat/action/label filter for my Authenticated vs Non-Authenticated users (written into the data layer and working in Universal Analytics) and I am trying to apply it to the product ...
1
vote
0
answers
212
views
BigQuery user_pseudo_id strange format
I know that user_pseudo_id format in BigQuery is usually 123456.654321. However, I found user_pseudo_ids like this one: zzlrlIWWmuO2pGInTOt8ayOT3Gq7LXiyD7jU4ayH+4M=.1835253951.
I am testing server-...
1
vote
0
answers
59
views
INFORMATION_SCHEMA.PARTITIONS query very slow
I am using BigQuery to access Google Analytics 4 data. I need to have a list of all days available and I need the number of records for each day.
I know that PARTITIONS query is still preview but I ...
- 2,404
2
votes
0
answers
586
views
Google BigQuery Analytics Hub exchange vs Data Clean room
I have been exploring Analytics Hub exchanges and Data clean rooms in google big query. From the docs:
BigQuery data clean rooms are built on the Analytics Hub platform. While standard Analytics Hub ...
- 1,092
0
votes
0
answers
42
views
SQL on BigQuery and Google Analytics - Queries Merging
I'm trying to combine two queries in BigQuery to fetch data from Google Analytics.
Query 1: Give me the number of users on my website per URL & per day.
Query 2: Give me the count of events per ...
- 373