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

Data Upload

Data Upload lets you add cost and performance data from any marketing platform, even one Roivenue cannot connect to via API. Fill in an Excel template and upload it.

Some platforms have no API connection to Roivenue, for example a local ad network, an affiliate partner or offline media. Data Upload lets you bring their costs and results into Roivenue anyway. You download an Excel template, fill in the data and upload it back. Roivenue then uses the data like any other platform: in reports, attribution and dashboards.

Use Data Upload when you want to:

  • Add costs from a platform that Roivenue cannot connect to.

  • Add campaigns that you pay for outside the ad platforms, for example sponsorships or print.

  • Fix or complete data for a period, for example after a platform outage.

To open the page, go to Account Configuration → Data Upload in the left navigation.

Data Upload is for marketing platform data. To upload data for Marketing Mix Modeling, use MMM Data Upload in the MMM section. It has its own template and rules.


What the page shows

  1. Download Data and Upload Data: the two actions you need.

  2. Last Upload: the date of the last upload. When nothing is saved yet, the page says "You have no manual data saved online".

  3. Data Preview: the data already saved in Roivenue, by day. Each row is one combination of dimension values, for example one campaign on one site. Use Previous Period and Next Period to move in time. Click a cell to see the values for that day, or the errors found in it.


How to download the template

Click Download Data, choose the date range in From Date and To Date and select the sites. The date range is the last 28 days by default.

Roivenue downloads an Excel file with:

  • The Data sheet with the columns to fill in. If you already uploaded data for the selected dates and sites, the sheet contains it.

  • The Sites sheet with the site names for the upload. Do not change it.

The file name contains the account and the date range, for example MyAccount_01-01-2026_31-01-2026.xlsx. Keep the name. Roivenue reads the date range from it when you upload the file.

Tip: Always start from a freshly downloaded file. It already contains the data saved for the period, so you only add or change rows and do not lose anything.


How to fill in the template

Each row is one day, week or month of data for one combination of dimension values.

Required columns

Column
What to enter

site

The site name. Choose it from the list in the cell.

periodType

daily, weekly or monthly.

dateInPeriod

The date. For weekly and monthly rows, the first day of the week (Monday) or month.

dataSourceAccount

Your e-mail address.

platformName

The platform name, for example the name of the ad network.

adCampaign

The campaign name.

reach

Reach, as a whole number.

impressions

Impressions, as a whole number.

clicks

Clicks, as a whole number.

conversions

Conversions reported by the platform, as a whole number.

marketingInvestment

The cost, as a decimal number.

conversionValue

The value of the conversions reported by the platform, as a decimal number.

currencyCode

The currency code, for example EUR.

Required columns must not be empty. Enter 0 when you have no value, for example, when the platform does not report reach.

Weekly and monthly data

When you only have totals for a week or a month, use weekly or monthly in periodType and enter the first day of the period in dateInPeriod. Roivenue splits the values evenly across the days of the period. A monthly cost of EUR 3,100 in January becomes EUR 100 per day.


How to upload the file

  1. Click Upload Data and then Add a file.

  2. Choose the filled template and click Continue. Roivenue checks the file.

  3. If the data is valid, you see "Data looks good". Click Finish Upload.

  4. If Roivenue finds errors, it lists them with the line, the date, and the reason. Fix them in the file and upload it again. You cannot finish the upload while the file has errors.

After the upload, you see "Your data has been saved," and the data appears in Data Preview and in the reports.


Common errors

Error
What to do

The file name is invalid

Keep the name of the downloaded file, or make sure all rows have a valid date.

The workbook does not contain the required sheets

Do not delete or rename the Data and Sites sheets. Download a new template if needed.

The following columns are missing

Add the missing required columns with their exact names.

Value in column is required

Fill in the empty cell. Use 0 for metrics without a value.

Value in column is not a valid integer or decimal

Enter a number without text or units. Reach, impressions, clicks and conversions must be whole numbers.

The currency is not supported

Use a valid currency code, for example EUR.

Provided date is not the beginning of the week or month

For weekly and monthly rows, enter the first day of the period.

Data provided outside planned date range

The date is outside the range in the file name. Download a template for a longer range, or remove the row.

The workbook contains data for sites that do not exist in Roivenue

Use only site names from the Sites sheet.


FAQ

1. Why is Data Upload disabled in my menu?

Only users who can manage the account configuration can upload data. Ask an admin of your account. See Manage Users.

2. Does a new upload replace the data I uploaded before?

Roivenue saves the data for the date range and the sites in the file. Start from a freshly downloaded file for the same range, so the file contains everything that should stay saved, and add or change only the rows you need.

3. How do I fix a mistake in uploaded data?

Download the data for the affected dates and sites, correct the rows in the file and upload it again.

4. Can I upload data for several sites in one file?

Yes. Select all the sites when you download the template and fill in the site column in each row.

5. Can I upload data in another currency than my reports?

Yes. Enter the currency of the data in currencyCode in each row. The code must be one of the currencies Roivenue supports, for example EUR, CZK or USD.

6. The preview shows only part of my file. Is something missing?

No. When the file has more than 200 rows, the preview shows only the first 200 to keep the page fast. Roivenue still checks and uploads the whole file.

7. What is the difference between Data Upload and MMM Data Upload?

Data Upload adds marketing platform data, such as costs, clicks and conversions, which Roivenue uses in all reports. MMM Data Upload adds the input data for Marketing Mix Modeling and has its own template.

Last updated

Was this helpful?