Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To upload your programmatic revenue with our generic CSV import, you need to make sure you provide a CSV file with the correct columns and structure.

The following columns are expected:

CSV file and formats we import into ADvendio system:

Info

NOTE: it is important to have exact CSV file column headers name and formats mentioned provided below:

CSV column name

Data format

Description/ what the column means

month

String

The month of the programmatic revenue

advertiserId

String

The ID of the advertiser in your data source

advertiserName

String

The Name of the advertiser in your data source

partnerName

String

The Name of Partner in your data source

adUnitId

String

The ID number of the Ad Unit in your data source

adUnitName

String

The Name of the Ad unit in your data source

dealType

String

The type of the deal in your data source

costType

String

Type of the cost used in your data source

creativeSize

String

Size of Ad used in your data source

currencyCode

String

The currency used in your data source

impressions

Number

Number of impressions used in your data source

clicks

Number

Number of clicks used in your data source

revenue

Number

Reveniue involved in your data source

Info

IMPORTANT: The csv files provided will need to have certain format:

  • Each csv file field needs to be comma separated

  • Dates are expected in the format: YYYY-MM-DD (2022-06-01)

  • Currency needs to be in certain ISO format (The US dollar represented as USD, Euro as EUR)

...