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 in order 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

...

Info
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
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

Info
IMPORTANT: The csv 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)

...

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:
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

...

See tables and screenshots below:

1-Programmatic Advertiser

...

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

...

2-Programmatic Partner

...

3-Programmatic Price

...

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.

...