> 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/data/data-upload.md).

# 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.

{% hint style="info" %}
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.
{% endhint %}

***

### 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.

{% hint style="info" %}
**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.
{% endhint %}

***

### How to fill in the template

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

#### Required columns

<table data-search="false"><thead><tr><th>Column</th><th>What to enter</th></tr></thead><tbody><tr><td><strong>site</strong></td><td>The site name. Choose it from the list in the cell.</td></tr><tr><td><strong>periodType</strong></td><td><code>daily</code>, <code>weekly</code> or <code>monthly</code>.</td></tr><tr><td><strong>dateInPeriod</strong></td><td>The date. For weekly and monthly rows, the first day of the week (Monday) or month.</td></tr><tr><td><strong>dataSourceAccount</strong></td><td>Your e-mail address.</td></tr><tr><td><strong>platformName</strong></td><td>The platform name, for example the name of the ad network.</td></tr><tr><td><strong>adCampaign</strong></td><td>The campaign name.</td></tr><tr><td><strong>reach</strong></td><td>Reach, as a whole number.</td></tr><tr><td><strong>impressions</strong></td><td>Impressions, as a whole number.</td></tr><tr><td><strong>clicks</strong></td><td>Clicks, as a whole number.</td></tr><tr><td><strong>conversions</strong></td><td>Conversions reported by the platform, as a whole number.</td></tr><tr><td><strong>marketingInvestment</strong></td><td>The cost, as a decimal number.</td></tr><tr><td><strong>conversionValue</strong></td><td>The value of the conversions reported by the platform, as a decimal number.</td></tr><tr><td><strong>currencyCode</strong></td><td>The currency code, for example <code>EUR</code>.</td></tr></tbody></table>

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

<table data-search="false"><thead><tr><th>Error</th><th>What to do</th></tr></thead><tbody><tr><td>The file name is invalid</td><td>Keep the name of the downloaded file, or make sure all rows have a valid date.</td></tr><tr><td>The workbook does not contain the required sheets</td><td>Do not delete or rename the <strong>Data</strong> and <strong>Sites</strong> sheets. Download a new template if needed.</td></tr><tr><td>The following columns are missing</td><td>Add the missing required columns with their exact names.</td></tr><tr><td>Value in column is required</td><td>Fill in the empty cell. Use <code>0</code> for metrics without a value.</td></tr><tr><td>Value in column is not a valid integer or decimal</td><td>Enter a number without text or units. Reach, impressions, clicks and conversions must be whole numbers.</td></tr><tr><td>The currency is not supported</td><td>Use a valid currency code, for example <code>EUR</code>.</td></tr><tr><td>Provided date is not the beginning of the week or month</td><td>For weekly and monthly rows, enter the first day of the period.</td></tr><tr><td>Data provided outside planned date range</td><td>The date is outside the range in the file name. Download a template for a longer range, or remove the row.</td></tr><tr><td>The workbook contains data for sites that do not exist in Roivenue</td><td>Use only site names from the <strong>Sites</strong> sheet.</td></tr></tbody></table>

***

#### FAQ

<details>

<summary>1. Why is Data Upload disabled in my menu?</summary>

Only users who can manage the account configuration can upload data. Ask an admin of your account. See [Manage Users](https://docs.roivenue.com/roivenue-resources/roivenue-training/roivenue-app/account-configuration/manage-users).

</details>

<details>

<summary>2. Does a new upload replace the data I uploaded before?</summary>

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.

</details>

<details>

<summary>3. How do I fix a mistake in uploaded data?</summary>

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

</details>

<details>

<summary>4. Can I upload data for several sites in one file?</summary>

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

</details>

<details>

<summary>5. Can I upload data in another currency than my reports?</summary>

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`.

</details>

<details>

<summary>6. The preview shows only part of my file. Is something missing?</summary>

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.

</details>

<details>

<summary>7. What is the difference between Data Upload and MMM Data Upload?</summary>

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.

</details>
