BigQuery is playing an increasingly vital role in the data strategy of many organizations. In addition to importing your own data sources, BigQuery allows you to easily configure automated imports of Google data sources, including AdWords, DoubleClick Bid Manager, DoubleClick for Publishers, YouTube Analytics, and as key data sources – Google Analytics and Firebase.

With your Google Analytics 360 or Firebase data in BigQuery, you run advanced queries to understand, as one example, conversions across multiple sessions, and you can also integrate with CRM data to measure, as another example, customer lifetime value by traffic source of the user’s original conversion.

As you query your Google Analytics or Firebase data in BigQuery, you can use this view of the schema as a quick reference. We hope that it will prove useful for beginners and experts alike.

Collapsible tree visualization of the Google Analytics 360 BigQuery Export Schema.

Click to explore and expand the live visualization.

Collapsible tree visualization of the Firebase BigQuery Export Schema.

Click to explore and expand the live visualization.

Solution Map

This visual was built by doing the following with R:

Solution Diagram for building the visualization of the Google Analytics 360 BigQuery Export Schema.

Automation

This solution can be taken one step further and process can be automated by hosting and scheduling the refresh of the R scripts on a Google Compute Engine instance of this can be converted to R Shiny app so that the BigQuery schema data is scraped/refreshed each time a user accesses the app.

Visualizing Other Schemas

Additionally, one could use this approach to visualize and explore the following schemas and nominal data (e.g. – categorical or dimensional):

Need support for data engineering, interactive visualizations, and advanced analysis? Contact E-Nor to learn how our Data Intelligence Services can help you gain insights and drive improvement.