Available with Version	2.159 and up

Available with Version	2.159 and up
Role	Order Manager - Fulfilment
ADvendio Edition	Programmatic Add-On

Challenge

You intend to use our generic programmatic import features to streamline your programmatic revenue coming in from any SSP/Exchange/DSP to ADvendio, but now you need to know how to configure your import to bring in the right data to the right fields.

How would you structure your CSV file to upload programmatic revenue? How is this data mapped in Advendio?

Solution

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.

CSV files and formats we import into the ADvendio system

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

CSV column name	Data format	Description/ what the column means

CSV column name	Data format	Description/ what the column means
month	String	Month of the programmatic revenue
advertiserId	String	ID of the advertiser in your data source
advertiserName	String	Name of the advertiser in your data source
partnerName	String	Name of Partner in your data source
adUnitId	String	ID number of the Ad Unit in your data source
adUnitName	String	Name of the Ad unit in your data source
dealType	String	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	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

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

Each field needs to be comma-separated
Dates are expected in the format: YYYY-MM-DD (2022-06-01)
Currency needs to be in ISO format (The US dollar represented as USD, Euro as EUR)

Where and how will the data be mapped in ADvendio? What do you receive in the file?

Please see which Column of the file corresponds to which object and field in ADvendio:

Data imported	Data Exported/ received	How exported data might look:

Data imported	Data Exported/ received	How exported data might look:
month	Date and month	2022-05-01
advertiserId	Advertiser ID number generated automatically	ADV_002
advertiserName	Your Advertiser company name	My Advertiser
partnerName	Your Partner name	Google
adUnitId	Ad unit ID number generated automatically	AD_UNIT_001
adUnitName	Ad unit name where Ad is located	Website
dealType	type of the deal	Open Auction
costType	cost type of the Ad	CPM
creativeSize	size of AD	320x50
currencyCode	currency used	EUR
impressions	number of impressions received	50000
clicks	number of clicks received	100
revenue	profit received	2000.000

Outcome generation in Advertiser, Partners and Price and records in ADvendio

The system takes the CSV file, table data and columns provided and creates Programmatic Advertiser, Partners and Price records in ADvendio. Programmatic Advertiser, Partners and Price are generating and mapping data in ADvendio from the file provided:

See tables and screenshots below:

1-Programmatic Advertiser

Programmatic Advertiser Name	example

Programmatic Advertiser Name	example
Advertiser Name	My Advertiser
Advertiser ID:	ADV__002

2-Programmatic Partner

Programmatic Partner Name	example

Programmatic Partner Name	example
Partner Name	Google

3-Programmatic Price

Programmatic Price Name	example

Programmatic Price Name	example
Ad Unit / Site Section Name	Website
Ad Unit / Site Section ID	AD_UNIT_001
Creative Size	320x50
Cost Type	CPM
Currency	EUR
Deal Type	Open Auction

4-Programmatic Data Working Set

contains all information collected from Programmatic Advertiser, Partner and Price. It shows which advertiser made which revenue in particular months.

Programmatic Price Name	example

Programmatic Price Name	example
Programmatic Advertiser	Automatic Number
Programmatic Price	Automatic Number
Advertiser Name	My Advertiser
Advertiser ID	ADV__002
Ad Unit / Site Section Name	Website
Ad Unit / Site Section ID	AD_UNIT_001
Creative Size	320x50
Cost Type	CPM
Currency	EUR
Deal Type	Open Auction
Month	2022-06-01
Impressions	50000
Clicks	0
Revenue	20.00

ADvendio Knowledge Base

7.7.8.6.1 CSV structure for generic Programmatic Revenue upload and how mapping is defined