This article will show you how to format and upload your spend data into Adtriba.
Download this template as the first step to create and upload your data by using the Marketing Spend Uploader in the dashboard.
File format
The following columns must be included in the file.
- DATE
- CHANNEL
- SOURCE
- CAMPAIGN
- SPEND
File type
The Marketing Spend Uploader accepts only CSV files.
Column delimiter
Use one of the three delimiters.
- ,
- ;
- TAB (\t)
Column description
DATE
The date must be defined in the ISO 8601 YYYY-MM-DD format - e.g. 2018-01-31
Value required: yes
CHANNEL
A value must be present. Must be named exactly as defined in the Performance Report or Channel Mapper.
Value required: yes
SOURCE
A value must be present, if you want to match the marketing spend on the Channel & Source dimension. Must be named exactly as defined in the Performance Report or Channel Mapper.
Value required: no, optional - keep it empty if data is not available
CAMPAIGN
A value must be present, if you want to match the marketing spend on the Channel, Source & Campaign dimension. Must be named exactly as defined in the Performance Report or Channel Mapper.
Value required: no, optional - keep it empty if data is not available
SPEND
Use dots between the integer and decimal numbers of your spend values.
Value required: yes
Create the file
Ensure to enclose the columns with double quotes if the delimiter is used in one of the columns - e.g. in the CAMPAIGN column: "summer, retargeting".
Our system handles data on a daily basis, which means that all information in your custom marketing spend file needs to be uploaded with a daily resolution. Here are two best practices if you only have an aggregated spend report.
- If you have a weekly total spend report: Divide the spend by 7 days.
- If you have a monthly total spend report: Divide the spend by number of days in the month.