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.
What the page shows
Download Data and Upload Data: the two actions you need.
Last Upload: the date of the last upload. When nothing is saved yet, the page says "You have no manual data saved online".
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.
How to fill in the template
Each row is one day, week or month of data for one combination of dimension values.
Required columns
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
Click Upload Data and then Add a file.
Choose the filled template and click Continue. Roivenue checks the file.
If the data is valid, you see "Data looks good". Click Finish Upload.
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
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
Last updated
Was this helpful?