The Daasity Data Model is actually a compilation of several data models that are grouped in logical subject areas for D2C brands.
Each subject area of data, for example, Order Information, has a model. The model is comprised of several tables of information that has either been extracted from a data source (I.e. Shopify, Facebook) or has been transformed with SQL to produce a new result.
Querying the data model is the way that users arrive at answers to their business questions. Querying is enabled by using Explores. Explores represent a business user view of the data housed in areas of the data model.
Typically Explores contain multiple tables that are joined to enable questions to be answered.
Model | Explore |
Customers | Customer Flags & Info |
LTV Time Series | |
Google Analytics | PDP Performance |
Shopping Stage | |
Traffic | |
Marketing | Marketing Performance |
Multi-Channel Transactions | |
Orders | Orders & Order Line Revenue |
Performance Trends | Daily Plan to Actual |
Shopify Reports | Sales Report |
Subscriptions | Subscribers |
Subscription Monthly Churn Rates |