Reports show GA4's view of the data. The BigQuery export gives you the raw events, one row per event, in your own Google Cloud project, where you can query them with SQL and join them to other data.
Set it up in Admin > BigQuery links:
- Project ID: the Cloud project that receives the data, such as
larkspur-analytics. Project IDs use lowercase letters, digits and hyphens.
- Data location: where the dataset lives. It can't be changed once the link is made.
- Frequency: Daily writes one complete table a day,
events_YYYYMMDD. Streaming writes events_intraday_YYYYMMDD within minutes, and BigQuery bills streaming inserts.
- Excluded events: events you don't need in the export.
The export starts from the day you link; it does not fill in earlier days. A standard property can export up to 1 million events a day in the daily export. Then practice the SQL in the BigQuery course's GA4 lessons.