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:
Toolbar: Download Template, Download Data, Upload Data, and Previous Period and Next Period to move in time.
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
Click Download Template. The template is an Excel file with a Template sheet and an Instructions sheet.
Fill in one row for each site, driver and period.
Put all sites in one file. Each site can have only one model per period.
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
How to upload the data
Click Upload Data.
Click Upload File and select your
.xlsxfile.Check Uploaded Period. From and To are filled in automatically from the dates in the file.
Click Continue To Preview.
Review the data. Data that overlaps with existing records is highlighted in orange.
Confirm the upload, or cancel if the data is not correct.
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
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
Last updated
Was this helpful?