Google analytics 4 to BigQuery
Budget: $10 – $30 USD
We connected Google Analytics 4 (GA4) to BigQuery.
We a looking for someone who has experience connecting GA4 with BQ and working with data from GA4. There is a screenshot in the files names "analytics" - we need to get this data in BigQuery.
Now we are trying to create a table with the data as we see it in GA4: users, sessions, engage sessions, Average engagement time per session, Engaged sessions per user by sourse/medium and date.
Unfortunately, we can not get some data in the same way as we see in GA4 account.
What we need:
Milestones:
1. You should look at the data at BQ and our code and explain what is wrong with the code (SQL) .
2. Write a correct code that will yell correct results- which should be the same as we see in GA4 account.
attached herewith the code
and this is the data
https://docs.google.com/spreadsheets/d/1XnKPTVz5b_DOo_-W257hoLXLkENWgBTh30NPlndxGgI/edit?usp=sharing.
Access to BQ upon request. Please provide your google account for this.
It is important for us that you have experience with raw data from GA4.
We a looking for someone who has experience connecting GA4 with BQ and working with data from GA4. There is a screenshot in the files names "analytics" - we need to get this data in BigQuery.
Now we are trying to create a table with the data as we see it in GA4: users, sessions, engage sessions, Average engagement time per session, Engaged sessions per user by sourse/medium and date.
Unfortunately, we can not get some data in the same way as we see in GA4 account.
What we need:
Milestones:
1. You should look at the data at BQ and our code and explain what is wrong with the code (SQL) .
2. Write a correct code that will yell correct results- which should be the same as we see in GA4 account.
attached herewith the code
and this is the data
https://docs.google.com/spreadsheets/d/1XnKPTVz5b_DOo_-W257hoLXLkENWgBTh30NPlndxGgI/edit?usp=sharing.
Access to BQ upon request. Please provide your google account for this.
It is important for us that you have experience with raw data from GA4.