Will you be doing a video on backfilling BigQuery with GA4 data?
@LearnBI
2 ай бұрын
I’m not sure tbh. If you’re looking to do it, you’ll need to use a data hub like Power My Analytics.
@LuisMejia-fo5vy
Жыл бұрын
Great explanation! I've got a quick question for you: How exactly do we go about using revenue metrics? 😄
@paulschnellaag7897
Жыл бұрын
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?
@LearnBI
Жыл бұрын
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.
@user-ci7jc7od4b
7 ай бұрын
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!
@LearnBI
7 ай бұрын
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.
@joebasshd
9 ай бұрын
When will you drop the video on how to backfill GA4 data into BigQuery? I need it
@LearnBI
8 ай бұрын
I recommend using Windsor.ai or PowerMyAnalytics.com
8 ай бұрын
How to calculate Avg session duration in looker studio from BigQuery?
@LearnBI
8 ай бұрын
Average session duration is total duration / total sessions
@susanfishman2561
Ай бұрын
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.
@LearnBI
Ай бұрын
It has browser data as well. The field name is device.web_info.browser
Пікірлер: 13