Challenge

Your business is using programmatic revenues and connecting them with the Media Campaigns and revenue managed in ADvendio?

If you do not use direct integration to bring these data automatically into salesforce this feature allows you to import programmatic revenue data flexibly from the external system.

You can enable the Generic Import of Programmatic Data in ADvendio using CSV files. And create Media Campaigns and Campaign Items from the data uploadedYou 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 is mapped in Advendio?

users can use this revenue upload feature to flexibly get the programmatic data

when you don't have the direct integration to bring the data automatically into salesforce this feature can help you to upload your revenue data

you can use this feature to flexibly get this programmatic data

What kind of Campaigns do you want to generate, and which revenue do you want to aggregate?

Solution

...

Solution

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

CSV

...

files and formats we import into the 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

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

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

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: The file Each 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)

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:

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

...

The system takes the CSV filesfile, 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 CSV received the file provided:

See tables and screenshots below:

1-Programmatic Advertiser

...

Programmatic Advertiser Name

Automatic Number

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.

...