For the complete documentation index, see llms.txt. This page is also available as Markdown.

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

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.


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

1. Do I need to upload all sites at once?

Yes. All sites must be in one file.

2. What happens if I upload a period that already has data?

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

3. Why don't I see my uploaded data in UMM?

Every driver must have a category in Driver Categorization. Drivers without a category are excluded from UMM. After that, the model recalculates, which usually takes a few hours.

4. Should I upload daily or weekly data?

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

5. What are source, medium and campaign for?

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

6. Can I upload money values in another currency than EUR?

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

Last updated

Was this helpful?