BigQuery
Ask about GA4 events, billing exports and app data in BigQuery.
Dot writes the BigQuery SQL for each question and shows it with the answer.
Ryan Ortiz9:41 AM
@Dot Which GA4 traffic sources brought the most first-time buyers last month?
1 reply
DotAPP9:42 AM
6 steps · 36s · Access Online
Organic search: 3,120 first purchases, converting at 2.8%.
Source: BigQuery’s ga4.events_*.
Chart
Today
Ryan Ortiz9:41 AM
Dot Which GA4 traffic sources brought the most first-time buyers last month?
Dot9:42 AM
6 steps · 36s · Access online
Organic search: 3,120 first purchases, converting at 2.8%.
Source: BigQuery’s ga4.events_*.
Priya Shah9:41 AM
@Dot Which projects drove this month’s jump in our cloud bill?
1 reply
DotAPP9:42 AM
9 steps · 56s · Access Online
Spend rose $18K to $142K. The data-pipeline project accounts for $12K of it.
Source: BigQuery’s billing_export.
Here is the data.
| Project | This month | Change |
|---|---|---|
| data-pipeline | $58K | +$12K |
| web-prod | $41K | +$4K |
| ml-training | $22K | +$2K |
Today
Priya Shah9:41 AM
Dot Which projects drove this month’s jump in our cloud bill?
Dot9:42 AM
9 steps · 56s · Access online
Spend rose $18K to $142K. The data-pipeline project accounts for $12K of it.
Source: BigQuery’s billing_export.
- data-pipeline: $58K this month, +$12K change
- web-prod: $41K this month, +$4K change
- ml-training: $22K this month, +$2K change
Daniel Weber9:41 AM
@Dot Which app version crashes most since Monday’s release?
1 reply
DotAPP9:42 AM
8 steps · 45s · Access Online
5.2 on Android, mostly in the new photo picker.
Source: BigQuery’s crashlytics.
Chart
Today
Daniel Weber9:41 AM
Dot Which app version crashes most since Monday’s release?
Dot9:42 AM
8 steps · 45s · Access online
5.2 on Android, mostly in the new photo picker.
Source: BigQuery’s crashlytics.
More in Databases & spreadsheets
Snowflake
Redshift
Postgres
AWS Athena
Databricks SQL
Microsoft SQL
MySQL
MotherDuck
Connect your data.
Start for Free