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
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.
All visitor page and view events, the base "event" to which all other events are linked
Product Interaction and Sales
Views where products were displayed, interacted with, or purchased
Views that happened on or after a visitor entered a segment
Details every transaction
Details every session for users
Details every entrance for users
Entrances which took place before the visitor completed a transaction
Details visitor survey results
Similar to the Product table offered for retail schemas, this includes details on viewed & purchased package items such as a flight or hotel