> For the complete documentation index, see [llms.txt](https://help.daasity.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.daasity.com/core-concepts/contribution-margin-beta/contribution-margin-bsd.md).

# Contribution Margin - BSD

## Brand Supplied Data (BSD) Configuration

The BSD is a Google Sheet that tells the Contribution Margin model how to apply your costs. You configure it once — after that, the pipeline runs automatically every morning without any additional input.

This guide covers each tab and what it controls.

***

### What You Need to Get Started

Not all tabs are required to run the model. The source mapping and marketing tabs are essential — without them, the model can't connect your data to contribution channels. The cost tabs improve accuracy but are optional.

**Required:**

* **Digital Sales Source Mapping** — maps your digital stores to contribution channels
* **Retail Sales Source Mapping** — maps your retail partners to contribution channels
* **Marketing Sources to Sales Sources** — links your marketing spend to the correct sales sources

**Optional (improve margin accuracy):**

* **Top-Line COGS** — We attempt to pull in your COGS from the SKU Cost BSD or from a custom data source if you have one connected.  This is an optional way to add the cost of goods if you do not have use one of these other options
* **Payment Processing** — add to capture processing fees per sales source
* **Other Costs** — add to capture 3PL, fulfillment, or other operational costs if they are currently not present for your Direct to Consumer (Shopify, Amazon, etc.) sales

**UMS Campaign Name to Product ID** is optional but recommended if any of your campaigns are tied to a single product and you want that spend attributed directly rather than distributed.

**Jump to:**

* [Merchant Settings](#merchant-settings)
* [Digital Sales Source Mapping](#retail-sales-source-mapping)
* [Retail Sales Source Mapping](#retail-sales-source-mapping)
* [Marketing Sources to Sales Sources](#marketing-sources-to-sales-sources)
* [UMS Campaign Name to Product ID](#ums-campaign-name-to-product-id)
* [Top-Line COGS](#top-line-cogs)
* [Other Costs](#other-costs)
* [Payment Processing](#payment-processing)

***

### Merchant Settings

Controls global allocation methods and which COGS source the model uses. These settings apply across all channels.

<figure><img src="/files/E5iiXJ6I47JmaS6hZck8" alt=""><figcaption></figcaption></figure>

| Field                                 | Description                                                    | Options                                                   |
| ------------------------------------- | -------------------------------------------------------------- | --------------------------------------------------------- |
| Allocation Metric For Marketing Spend | How marketing spend is distributed across products             | <ul><li>gross\_sales</li><li>gross\_units\_sold</li></ul> |
| Allocation Metric for Other Costs     | How other operational costs are distributed                    | <ul><li>gross\_sales</li><li>gross\_units\_sold</li></ul> |
| Allocation Metric for Top-Line COGS   | How COGS is distributed across products                        | <ul><li>gross\_sales</li><li>gross\_units\_sold</li></ul> |
| Preferred COGS                        | Which COGS source the model pulls from (`custom` or `default`) | <ul><li>custom</li><li>from\_source</li></ul>             |

**Preferred COGS options:**

* `custom` — uses the COGS values entered in the Top-Line COGS tab
* `default` — falls back to Daasity's system-calculated cost

***

### Digital Sales Source Mapping

Maps your digital sales sources — Shopify stores, Amazon, and other DTC channels — to contribution channels in the CM model.

<figure><img src="/files/g97YH4wYtEGX1AuZ7bek" alt=""><figcaption></figcaption></figure>

| Field                | Description                                                                      |
| -------------------- | -------------------------------------------------------------------------------- |
| Store Name           | Display name for the sales source                                                |
| Shop ID              | Unique identifier tying the row to your order data                               |
| Sales Channel        | The channel classification for this source (e.g., Amazon.com, Non-Amazon)        |
| Include              | Whether this source is included in CM calculations (`TRUE` or `FALSE`)           |
| Contribution Channel | The named channel this source rolls up to in your dashboards (e.g., DTC, Amazon) |

> Sources marked `FALSE` will not appear in CM output. Use this for test stores or inactive sources you don't want affecting margin data.

***

### Retail Sales Source Mapping

Maps your retail and distributor POS sources to contribution channels.<br>

<figure><img src="/files/ob2h0yy1NU028iWaPqTP" alt=""><figcaption></figcaption></figure>

| Field                | Description                                                                      |
| -------------------- | -------------------------------------------------------------------------------- |
| Retail Source        | Name of the retail partner or data source (e.g., Costco Circana, Kroger, Target) |
| Include              | Whether this source is included in CM calculations (`TRUE` or `FALSE`)           |
| Contribution Channel | The named channel this source rolls up to in your dashboards (e.g., Retail)      |

***

### Marketing Sources to Sales Sources

Links your marketing data sources to your sales sources so spend can be attributed correctly in the model.

<figure><img src="/files/DUL9Td29UoEGDtbWosA0" alt=""><figcaption></figcaption></figure>

| Field            | Description                                                           |
| ---------------- | --------------------------------------------------------------------- |
| Marketing Source | The ad platform or marketing data source identifier                   |
| Sales Source     | The corresponding sales source this marketing spend should be tied to |

***

### UMS Campaign Name to Product ID

Enables direct campaign-to-product attribution for spend that should not distribute across the full catalog.

<figure><img src="/files/Vf0ajy5xK15LQXsnRfzp" alt=""><figcaption></figcaption></figure>

| Field         | Description                                                    |
| ------------- | -------------------------------------------------------------- |
| Campaign Name | The exact campaign name as it appears in your ad platform      |
| Product ID    | The product this campaign's spend should attribute to entirely |

> Use this tab any time a campaign is promoting a single product. Without an entry here, campaign spend distributes proportionally by gross sales across all products in the mapped sales source.

***

### Top-Line COGS

Defines aggregate cost of goods sold over time. Supports date ranges so cost changes don't affect historical data retroactively.

<figure><img src="/files/4FgE3IKoNCADgC0k0L71" alt=""><figcaption></figcaption></figure>

| Field      | Description                                   |
| ---------- | --------------------------------------------- |
| Start Date | Date this COGS value takes effect             |
| End Date   | Date this COGS value stops applying           |
| COGS       | The aggregate cost amount for this date range |

> This tab captures COGS at an aggregate level, not per-SKU. See Merchant Settings to control whether the model uses these values or falls back to Daasity's system-calculated default.

***

### Other Costs

Covers operational costs not captured elsewhere — 3PL fees, fulfillment costs, platform fees, and similar items.

<figure><img src="/files/Qd5Ih3tY0HkjtVMEu6HL" alt=""><figcaption></figcaption></figure>

| Field       | Description                       |
| ----------- | --------------------------------- |
| Start Date  | Date this cost takes effect       |
| End Date    | Date this cost stops applying     |
| Cost Name   | Label or description for the cost |
| Cost Amount | Total cost for this date range    |

> Trade and TPM commitments are currently entered here as manual line items. A dedicated Trade/TPM tab with direct platform integration is on the roadmap.

***

### Payment Processing

Defines the processing fee applied per sales source.

<figure><img src="/files/l0akGmsGb0BRRZSrDIZO" alt=""><figcaption></figcaption></figure>

| Field          | Description                          |
| -------------- | ------------------------------------ |
| Sales Source   | The sales source this fee applies to |
| Percentage Fee | Processing fee as a percentage       |


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.daasity.com/core-concepts/contribution-margin-beta/contribution-margin-bsd.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
