Live Tap Analytics Model

These tables organize the real-time events data collected by Qubit into a single data model with clear, defined relationships between them. This model is designed for use with business intelligence tools such as Looker and Tableau.

TIP: This data model updates on a daily basis and is designed for historical analytics. For real-time data, query the events tables directly.

INFO: Contact your Qubit Customer Success Manager if you have not been onboarded onto this feature.

• Organizes events data into a single data model with clear, defined relationships between each table

• Combines data items from multiple events into single tables for segments, views, experiences, and other reporting entities.

  For example the product view combines the ecProduct (product views), ecBasketItem (basket items), and ecBasketItemTransaction (item purchases) event tables to enable easy funnel analysis

• Bakes in best practice joins between tables to ensure efficient data access and avoid double-counting of event activity

The model covers a common set of metrics and subject areas, with a selection of the most useful metrics and dimensions for analytics.

TIP: You can still directly query the event tables if a dimension or measure you require is not available in this model. It's also possible to expand the model by editing the model SQL - speak to your Qubit CSM for details.

The following table provides the underlying BigQuery object name, key columns, and contents for the core business views.