How your data flows
These source categories line up with how Connect is organized; see all available integrations for the current platform list. Each transformation stage has its own page: cleaning handles quality, enrichment handles completeness, and modeling philosophy explains the table shapes you end up querying. Our data model integrates and cleans your platforms’ data into the fact, dimension, OBT, and report tables shown above, and each dashboard module reads the ones that suit its purpose. We use data from your connected sales platforms (Shopify, Amazon, etc.) as the transactional backbone for sales-based reporting.Default data cleaning includes separating your sales into different channels. The Channel
filter on each module is defaulted to Online DTC (excluding Exchanged, Draft, and Wholesale
orders to avoid skewing composite metrics such as Average Order Value).
If you notice any mismatch between your Shopify Sales Report and your Executive Summary,
see this article for possible explanations.