All Questions
Tagged with google-analytics-4 google-bigquery
158 questions
0
votes
1
answer
23
views
Why traffic_source is different for the same user_id?
I am using Google Analytics on my website, but I am experiencing behavior that, in my understanding, seems strange.
According to Google’s documentation, the traffic_source contains the origin of the ...
- 11
0
votes
1
answer
39
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
-1
votes
1
answer
85
views
Do Google Analytics events_intraday_$date tables get deleted from Big Query?
We are using the Big Query export from Google Analytics. The export type is Streaming (we don't have Daily checked). Do the events_intraday_$date tables ever get deleted when Daily is not enabled?
...
- 31
0
votes
1
answer
51
views
Discrepancy in totalUsers Metric between Google Analytics and API Integration
I’ve been struggling for days to integrate Google Analytics with Power BI. Here’s what I’ve tried so far:
Linkind via BigQuery: It creates a table per day in Power BI, which isn’t suitable for my ...
0
votes
0
answers
38
views
Querying for multiple keys from user_properties (nested) BigQuery - GA4 data
I would like to create a new table with multiple user property keys, but for some reason im getting an error. The code that I was trying
SELECT
event_date,
(select value.string_value from unnest(...
0
votes
0
answers
62
views
BigQuery wrong row count inside google cloud storage parquets
I'm transfering data from BigQuery project to google cloud storage parquets (GA4 events table).
What I'm doing :
First of all i use source script to count rows which I transfer to parquets
SELECT * ...
- 91
0
votes
2
answers
167
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 ...
- 519
0
votes
1
answer
155
views
Google Analytics's Custom Dimension Shows NULL Value in BigQuery
I have Google Analytics UA linked to BigQuery and I see there are lots of generated data having NULL value in a specific custom dimension.
I was trying to understand under what circumstance this could ...
- 37
0
votes
1
answer
77
views
How to handle new fields in a STRUCT when dynamically adding using union on all tables in BigQuery
Process
In BigQuery, Google Analytics data is linked to a BigQuery project. Each site corresponds with a dataset, and each day an events_* table is added to that dataset. My query dynamically iterates ...
- 490
0
votes
0
answers
44
views
Create a STRUCT that returns true for IS NULL if all values are NULL
When I create a column of type STRUCT in a query then IS NULL always returns false, even through all values in the struct are NULL.
Example:
with tmp as(
SELECT
STRUCT( NULL as field_1, null as ...
0
votes
0
answers
126
views
Tracking Event Sequence in GA4 for User Actions
The event_bundle_sequence_id variable in GA4, which is used to track the sequence of events, can assign the same value to all events in the same session because the events are sent in batches. This is ...
0
votes
0
answers
14
views
GA4 BigQuery SQL - replicating a categorical value to a common key
inside GA4 there is a session_id which is used to identify the set of events that a user has made on site, I am using a case function to define my location names so I can merge it with a dataset of ...
- 1
0
votes
0
answers
17
views
Google analytics link to BigQuery is policy Org sensitive?
I tried linking Google Analytics 360 to BigQuery project in GCP but I had error related to policy Organization. When I disbaled the Policy Org : "resource locations : europe" ( I allowed all ...
- 45
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
35
views
Big query, GA4 data export
I want to do section "Peaople saw also this items" on my web page - online shop. I have data from GA4 stored in BigQuery.
I thought about extraxting users with info about view_items that ...
- 1