Hello, this video is excellent! I do have a question, though. Given that the cost of using BigQuery data is usage-based, could you provide an estimate of the approximate cost for a standard digital marketing dashboard? Thank you!
The free tier gives you 10gb of storage and 1tb of processed query data per month for free so that’s quite a lot. But there are limitations. You get that with the paid plans as well after which it’s costs a few cents per GB used so not expensive at all. Just Google BigQuery pricing plans.
Hey Adam! Thanks for the video-it’s super helpful and great content. I’m curious why the calculated field for the Sessions metric in the video uses CONCAT, while the one suggested in the cheat sheet doesn’t. It seems like the version with CONCAT, as shown in the video, pulls the correct data into the scorecard. Thanks again!
Outstanding content as always Adam. This is my project for this month! Question though. One site, one BQ project? Or can I combine streams and filter them back out by stream ID in my Looker report?
Thanks for your feedback 🙂. One BQ project can be linked to multiple GA4 properties. A separate dataset will be created for each in the project. If you want to combine them together into a single BigQuery data source for Looker, you could just write a SQL query to UNION them (essentially stacking the data). Hope this helps.
The difference is that you are restricted by the limitations of the API in both the API call quota limits and that you do not have access to the full dataset. The latter means things like not being able to change the aggregator on metrics or mix dimensions and metrics in calculation formulas. Because you can only access the data the API allows you. When you export the data to BigQuery you have access to the full dataset to allow you to manipulate it in any way you like
And suggestions on how to get browser data from BigQuery into looker? The events_YYYYMMDD only has a device category and a device model, but nothing for browser.
Great explanation! I've got a quick question for you: How exactly do we go about using revenue metrics? 😄
Hello, this video is excellent! I do have a question, though. Given that the cost of using BigQuery data is usage-based, could you provide an estimate of the approximate cost for a standard digital marketing dashboard? Thank you!
The free tier gives you 10gb of storage and 1tb of processed query data per month for free so that’s quite a lot. But there are limitations. You get that with the paid plans as well after which it’s costs a few cents per GB used so not expensive at all. Just Google BigQuery pricing plans.
Hey Adam! Thanks for the video-it’s super helpful and great content. I’m curious why the calculated field for the Sessions metric in the video uses CONCAT, while the one suggested in the cheat sheet doesn’t. It seems like the version with CONCAT, as shown in the video, pulls the correct data into the scorecard. Thanks again!
Thanks for pointing this out, I’ll update accordingly.
How to calculate Avg session duration in looker studio from BigQuery?
Average session duration is total duration / total sessions
When will you drop the video on how to backfill GA4 data into BigQuery? I need it
I recommend using Windsor.ai or PowerMyAnalytics.com
Outstanding content as always Adam. This is my project for this month! Question though. One site, one BQ project? Or can I combine streams and filter them back out by stream ID in my Looker report?
Thanks for your feedback 🙂. One BQ project can be linked to multiple GA4 properties. A separate dataset will be created for each in the project. If you want to combine them together into a single BigQuery data source for Looker, you could just write a SQL query to UNION them (essentially stacking the data). Hope this helps.
How is this different from directly pulling date from GA4 to Looker without bigQuery?
Do you mean using the GA4 native connector in Looker?
Yes, 🙌
The difference is that you are restricted by the limitations of the API in both the API call quota limits and that you do not have access to the full dataset. The latter means things like not being able to change the aggregator on metrics or mix dimensions and metrics in calculation formulas. Because you can only access the data the API allows you. When you export the data to BigQuery you have access to the full dataset to allow you to manipulate it in any way you like
@@LearnBI wow! I did not know this. I always use native GA4 connector. I will try using Big Query. Thanks so much.
And suggestions on how to get browser data from BigQuery into looker? The events_YYYYMMDD only has a device category and a device model, but nothing for browser.
It has browser data as well. The field name is device.web_info.browser
Will you be doing a video on backfilling BigQuery with GA4 data?
I’m not sure tbh. If you’re looking to do it, you’ll need to use a data hub like Power My Analytics.