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 (source code):

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.

Message Sent

Thank you for registering.

Cardinal Path hosted a live session to connect with you and answer all your questions on Google Analytics.
Get all the expertise and none of the consultancy fees in this not-to-be-missed, rapid-fire virtual event.

Thank you for submitting the form.

Thank you for submitting the form.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you.

Click here to download access the tool.

Message Sent

Thank you for registering.

Message Sent

Thank you.

Message Sent

Thank you.

Message Sent

Thank you

Message Sent

Thank you

Message Sent

Thank you.

Message Sent

Thank you

Message Sent

Thank you.

Message Sent

Success!
Your message was received.

Thank you.

Thank you for registering.

Cardinal Path is continuing with its series of free training. Next we are conducting training on Google Data Studio. Check it out here.

Message Sent

Thank you for registering.

Thank you for your submission.

Your request has been submitted and a rep will reach out to you shortly.

Message Sent

Thank you for your interest.

Thank you for registering.

You should receive a confirmation email from GoToWebinar with your unique webinar login information. If you do not receive this email or have trouble logging in to the event, please email asmaa.mourad@cardinalpath.com.

Thank you for subscribing!

You're now looped into the world's largest GMP resource hub!

Thank you for your submission.

Thank you for your submission.

Thank you for your submission.

Thank you for your submission.

Message Sent

Thank you for registering.

Message Sent

Thank you for your submission.

Thank you for your submission.

Message Sent

Thank you for registering.

Thank you for registering.​

Paid media spend by Government websites increased a whopping 139% YoY in 2020.

2020 Online Behavior Live Dashboard

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

2020 Online Behavior Live Dashboard

Thank you for your submission.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Success! Thank you
for reaching out.