Template

BigQuery event table template

Prepares event CSVs for BigQuery LOAD with typed columns, nested JSON handling, and partition-friendly timestamps.

Use this template

Column mapping

Source fieldTarget / rule
TIMESTAMP column normalizationTIMESTAMP column normalization
JSON propertiesSTRUCT mapping
PARTITION BY DATE(event_timestamp)PARTITION BY DATE(event_timestamp)
REQUIRED vs NULLABLE column rulesREQUIRED vs NULLABLE column rules
Duplicate detection before loadDuplicate detection before load

Select this template in the Fix wizard source dropdown, or upload your export and we'll auto-detect the schema.

Scan your analytics CSV before import.

Free preview on 10,000 rows ยท Human review before export to Mixpanel, Amplitude, or your warehouse.

Scan analytics CSVView sample report