@6:08 The actual start of the presentation. @14:55 Introduction to GA4+Big Query @18:35 First setup steps, create BQ project @19:46 Link created BQ project to GA @20:10 Setup data streams @24:35 Create API key in BQ for GA4 @25:20 Enable BigQuery API @26:10 Create API key @36:10 How to unnest to multiple columns @41:30 End, QA start
@optizent
3 жыл бұрын
Sign up for free courses, academy.optizent.com/f/free-web-and-digital-analytics-courses
@ointmentalforexport5657
3 жыл бұрын
hats off for you Anil
@darafebres3803
Жыл бұрын
Thank you for this terrific tutorial. Very helpful! I have one question. Now that I have BigQuery linked to GA4, moving forward I wish to use DataStudio(Looker Studio) as my visualization tool. My question is should I create a new table in BigQuery to hold all my website data? This would be similar to UA format and then update the new table with GA4 info. Or, would it be better to create queries (views) using the GA4 linked table. I'm looking for an easy solution to combine the UA historical data with the GA4 data with the least amount of time converting existing data studio dashboards over to GA4. Thank you again for this post and your time.
@optizent
Жыл бұрын
I am happy to learn that you liked the video. The best option will be to use views so that you don’t increase your storage cost and views work just like tables.
@tulasipothuganti4730
Жыл бұрын
Hi Anil, i have one question on selecting the Daily and streaming. If we are selecting both will the data duplicate. or how it works?
@optizent
Жыл бұрын
It does not duplicate. Streaming give up h live feed of the data for the day. At the end of the day it rolls into daily table.
@Subhashkannanchery
3 жыл бұрын
Dear Anil, Thanks for this video. It was very informative. I have a question - how can I stitch my Google analytics Anonymus data (Pageviews) with identifiable data (Data I have received after a goal conversion). Do u have any training videos to understand that in specific? Just wanted to know how we can analyze that after exporting the data to BigQuery. Thanks again for this very informative video session
@optizent
3 жыл бұрын
Yes I have that content but not on KZitem yet.
@danieljtwining
3 жыл бұрын
Useful video. How do I know that everything has been done correctly and the data is 'flowing'? Or do I just have to wait and hope it appears?
@optizent
3 жыл бұрын
Yes it is wait and see, if you follow all the steps correctly then it should show up in about 4-6 hours.
@nielsd9261
3 жыл бұрын
At what time is the daily export ready from the day before? I'm building a data pipeline from BQ --> Azure --> Power BI with a daily refresh. However when I trigger at 7:00 AM in Azure, the data from BQ isn't updated with the data from the day before yet. Can't find any times on Google or in the Google Console.
@optizent
3 жыл бұрын
My understanding is that is appears right after midnight but maybe it is dependent on your site volume. I don’t believe there is any stated SLA.
@nielsd9261
3 жыл бұрын
Does it only connect data from the day it's been set up between GA4 and BQ? or is there a way to get GA4 data since the day it's been collected in your GA4 property?
@optizent
3 жыл бұрын
It only starts from the day when you set it up. There is no way to go back.
@zahrasafdari7287
2 жыл бұрын
what if we only want specific metrics and dimensions from GA to be sorted on BQ?
@optizent
2 жыл бұрын
You have to send all of the data and the. select the specific ones in BQ using SQL queries.
@zahrasafdari7287
2 жыл бұрын
@@optizent thanks for your quick reply. And then we can create a table based on that? Like, if I want to have the interest data from GA and create a table only for that permanently on BG.
@optizent
2 жыл бұрын
You won’t find interest data in BQ.
@zahrasafdari7287
2 жыл бұрын
@@optizent Why not? how can I access that then? what about demographics or affinity groups?thanks
@nielsd9261
3 жыл бұрын
Does data sampling occur on big websites with the GA4 --> big query connection?
@optizent
3 жыл бұрын
Good question! I am not sure. Will check and get back to you.
@willchen9932
3 жыл бұрын
at 29:34 that doesn't seem the right place to put firebase-measurement@system.gserviceaccount.com, since it doesn't allow edit anything after @. thought?
@optizent
3 жыл бұрын
You put your firebase-measurement@system.gserviceaccount.com in the service account name field and it should work, it will automatically do the needful in the email field.
@madhurikashyap4884
3 жыл бұрын
I had 6 GA4 properties and i linked all of them the same way you showed but the issue is that out of 6 i can see only 3 of them, what could be reason for others not showing up?
@optizent
3 жыл бұрын
Is the issue still there?
@velamuruvarsha2234
Жыл бұрын
Hi madhuri
@fezanrasool2756
3 жыл бұрын
at 29:34 that doesn't seem the right place to put firebase-measurement@system.gserviceaccount.com, since it doesn't allow edit anything after @. thought? In my case after @ it is already appended firebase-measurement@shopcast-project.iam.gserviceaccount.com
@optizent
3 жыл бұрын
You put your firebase-measurement@system.gserviceaccount.com in the service account name field and it should work, it will automatically do the needful in the email field.
@user-oe5ki5to5v
3 жыл бұрын
This is working only for GA 360 which cost 150k annually. Is it true?
@optizent
3 жыл бұрын
No, it works with Google Analytics 4, the new free version.
Пікірлер: 32