Firebase tracks various app events, such as user interactions, app lifecycle events, and custom-defined events, through Firebase Analytics. These events are stored within Firebase's real-time database or Firestore, and are subsequently exported to BigQuery for detailed analysis and reporting.

The integration with BigQuery allows for the storage of event data in a standardized schema that can be queried and analyzed.

Firebase events tracking:

1. Intra-Day Firebase Events Data

• Definition:

  Intra-day event data is exported from Firebase to BigQuery in near real-time. It captures event data as it is generated and writes it into a temporary events_intraday_* table.

• Characteristics:

  • Data in these tables is not final and can be subject to change (e.g., late-arriving events or updates).
  • Useful for real-time monitoring and analysis of event trends within the same day.
  • Typically replaced or overwritten when the day-end export is completed.

2. Day-End Firebase Events Data

• Definition:

  Day-end event data is the finalized, immutable dataset for any day earlier than

  (today - 2 days), exported from Firebase to BigQuery. It is written into a new table named

  events_* with the date as the suffix (e.g., events_20250108 for January 8, 2025).

• Characteristics:

  • Immutable: Once written, it cannot be modified, ensuring data integrity and reliability.
  • Aggregates all events that occurred on a particular day, including late-arriving or updated events.
  • Suitable for historical analysis and reporting.
  • Helps maintain a complete and consistent record of daily activity.

How Firebase Handles Exports:

• Firebase automatically updates the intra-day tables in real-time and finalizes the data by writing it to day-end tables after the end of each day.
• Partitioning:
  • Day-end tables are partitioned by event_date for efficient querying.
  • Intra-day tables do not typically follow a partitioning structure, as they are temporary.

Export to BigQuery:

Firebase Analytics automatically exports event data to BigQuery when integrated. The events are stored in BigQuery tables, and the schema adheres to a standardized format that allows for efficient querying and reporting. The schema includes key fields for both event-level data and user-level information.

Architecture of how Auxia integrates Firebase Data with Bigquery:

Standard BigQuery Schema:

The following is the standard schema of how Firebase exports app event data into BigQuery:

• https://firebase.google.com/docs/perf-mon/bigquery-export#detailed_data_schema