Cardinal Path’s response to COVID-19 Cardinal Path is sharing all we know to help marketers during COVID-19.  Learn more.

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.

Sharing is caring!

Popular

COVID-19 Crisis Navigator​

In partnership with Dentsu, Cardinal Path helps you distill the overwhelming news and information into a bi-weekly report highlighting emerging trends and insights during the pandemic.

EXPLORE THE REPORT

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Success!
Your message was received.

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

Thank you.

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 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.

2020 Online Behavior Live Dashboard

Message Sent

Thank you for registering.

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

Thank you for your submission.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

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.
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

Success! Thank you
for reaching out.