> For the complete documentation index, see [llms.txt](https://docs.roivenue.com/roivenue-resources/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.roivenue.com/roivenue-resources/roivenue-training/roivenue-app/umm/mmm-data-upload.md).

# MMM Data Upload

Upload the results of your MMM model to Roivenue from an Excel template. The uploaded data is the starting point for UMM models.

MMM Data Upload is where you bring the results of your marketing mix model (MMM) into Roivenue. UMM combines this data with your MTA data, so the upload is the first step of every UMM setup.

Use MMM Data Upload when you want to:

* upload MMM results for the first time
* add data for a new period
* replace data for a period you uploaded before
* check which drivers and weeks already have data

The page has 2 parts:

1. **Toolbar:** **Download Template**, **Download Data**, **Upload Data**, and **Previous Period** and **Next Period** to move in time.
2. **Overview grid:** one row for each driver and site, one column for each week. A filled cell means data exists for that week.

To open the page, go to **UMM → Data Upload** in the left navigation.

***

### How to prepare the file

1. Click **Download Template**. The template is an Excel file with a **Template** sheet and an **Instructions** sheet.
2. Fill in one row for each site, driver and period.
3. Put all sites in one file. Each site can have only one model per period.

| Column | Header       | What to fill in                                                         | Required                                      |
| ------ | ------------ | ----------------------------------------------------------------------- | --------------------------------------------- |
| A      | site         | The site the row belongs to. It must match a site in Roivenue.          | Yes                                           |
| B      | periodType   | `daily` or `weekly`.                                                    | Yes                                           |
| C      | startDate    | The first day of the period. A weekly row covers 7 days from this date. | Yes                                           |
| D      | driverName   | The name of the MMM driver, for example "TV" or "Generic Search".       | Yes                                           |
| E      | conversions  | Conversions attributed to the driver.                                   | At least one of E and F                       |
| F      | netRevenue   | Net revenue attributed to the driver.                                   | At least one of E and F                       |
| G      | currencyCode | Currency of the money values, for example `EUR`.                        | Yes, if F or another money value is filled in |
| H      | source       | Source for the driver. If empty, it is set to "umm-{driverName}".       | No                                            |
| I      | medium       | Medium for the driver. If empty, it is set to "umm-{driverName}".       | No                                            |
| J      | campaign     | Campaign for the driver. If empty, it is set to "umm-{driverName}".     | No                                            |
| K      | costs        | Cost of the driver in the period.                                       | No                                            |
| L      | impressions  | Impressions in the period.                                              | No                                            |
| M      | clicks       | Clicks in the period.                                                   | No                                            |

{% hint style="info" %}
**Tip:** To change data you uploaded before, click **Download Data**. You get the current data in the template format, so you can edit it and upload it again.
{% endhint %}

***

### How to upload the data

1. Click **Upload Data**.
2. Click **Upload File** and select your `.xlsx` file.
3. Check **Uploaded Period**. **From** and **To** are filled in automatically from the dates in the file.
4. Click **Continue To Preview**.
5. Review the data. Data that overlaps with existing records is highlighted in orange.
6. Confirm the upload, or cancel if the data is not correct.
7. Click **Go to Driver Categorization** and categorize any new drivers.

New uploads for a period you already uploaded overwrite the existing data.

You can extend the uploaded period manually. Data for dates that the file does not cover is then deleted. You cannot shorten the period beyond the dates in the file.

***

### How to fix upload errors

| Error                                                    | What to do                                                                |
| -------------------------------------------------------- | ------------------------------------------------------------------------- |
| The uploaded file is empty                               | Fill in the **Template** sheet and upload again.                          |
| Some of the required fields are NOT filled               | Fill in columns A to D in every row, and at least one of E and F.         |
| Some of the inputs do NOT have correct type              | Use numbers for metrics, text for names and real dates for **startDate**. |
| The period Type was NOT defined as day or week           | Use `daily` or `weekly` in **periodType**.                                |
| The column headers are missing / Duplicate columns       | Keep the header row from the template and do not repeat columns.          |
| The file contains overlapping periods in rows            | Remove rows where the same site and driver cover the same days twice.     |
| Some sites are not valid                                 | Use site names exactly as they are in Roivenue.                           |
| Some currencies are not valid / Currency code is missing | Fill in a valid currency code in **currencyCode**.                        |

***

#### FAQ

<details>

<summary>1. Do I need to upload all sites at once?</summary>

Yes. All sites must be in one file.

</details>

<details>

<summary>2. What happens if I upload a period that already has data?</summary>

The new data overwrites the existing data for that period. The preview highlights the overlapping data in orange before you confirm.

</details>

<details>

<summary>3. Why don't I see my uploaded data in UMM?</summary>

Every driver must have a category in [Driver Categorization](https://docs.roivenue.com/roivenue-resources/roivenue-training/roivenue-app/umm/driver-categorization). Drivers without a category are excluded from UMM. After that, the model recalculates, which usually takes a few hours.

</details>

<details>

<summary>4. Should I upload daily or weekly data?</summary>

Use the granularity your MMM model produces. Set it in **periodType** for every row.

</details>

<details>

<summary>5. What are source, medium and campaign for?</summary>

They are optional labels for the driver's data. If you leave them empty, Roivenue fills them in as "umm-{driverName}".

</details>

<details>

<summary>6. Can I upload money values in another currency than EUR?</summary>

Yes. Fill in the currency in **currencyCode** for every row with money values.

</details>
