> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sourcemedium.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# How your data gets from point A to B

> High-level overview of how SourceMedium ingests, transforms, and delivers data for reporting

<img src="https://mintcdn.com/sourcemedium/ui0hKAc0Yk4Nw3Bz/images/article-imgs/how-your-data-gets-from-point-a-to-b/point1.webp?fit=max&auto=format&n=ui0hKAc0Yk4Nw3Bz&q=85&s=82e1a673a0d77bb5a0803f832efa0b76" alt="" width="1920" height="2213" data-path="images/article-imgs/how-your-data-gets-from-point-a-to-b/point1.webp" />

Our **data model** integrates and cleans your platforms’ data into a master table that each module of the
dashboard interacts with differently depending on the purpose of the module.

We use **Intelligent Data Aggregation** to build this model—merging first-party signals from all your platforms to ensure your data is as usable, trustworthy, and high-quality as possible.

* **Sales Reporting**: We use data from your connected sales platforms (Shopify, Amazon, etc.) as the transactional backbone for financial reporting.
* **Attribution**: We aggregate signals from all connected sources to resolve the most accurate last-click and multi-touch attribution.

<CardGroup cols={2}>
  <Card>
    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).
  </Card>

  <Card>
    <img src="https://mintcdn.com/sourcemedium/ui0hKAc0Yk4Nw3Bz/images/article-imgs/how-your-data-gets-from-point-a-to-b/point2.avif?fit=max&auto=format&n=ui0hKAc0Yk4Nw3Bz&q=85&s=0d9530427c30bc9eb10ca46a342c73bb" alt="" width="640" height="805" data-path="images/article-imgs/how-your-data-gets-from-point-a-to-b/point2.avif" />
  </Card>
</CardGroup>

<Note>
  If you notice any mismatch between your Shopify Sales Report and your Executive Summary,
  see [this article](/help-center/faq/data-faqs/why-dont-the-executive-summary-and-shopifys-sales-report-match) for possible explanations.
</Note>