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.
Did this answer your question?