Available with Version: | 2.159 and up |
|---|---|
Role | Order Manager - Fulfilment |
ADvendio Edition | Programmatic Add-On |
Challenge
Your business is using programmatic revenues and connecting them with the Media Campaigns and revenue managed in ADvendio?
...
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
In order to upload your programmatic revenue with our generic CSV import, you need to make sure you provide a CSV file with the right columns and structure.
The following columns are expected:
CSV file and formats we import into the ADvendio system:
| Info |
|---|
NOTE: it is important to have exact CSV file column headers and formats mentioned: |
...
| Info |
|---|
IMPORTANT: The csv files provided will need to have certain format:
|
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 | Data examples/ 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 | |
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 | 50,000 |
clicks | number of clicks received | 100 |
revenue | profit received | 2,000.000 |
Outcome generation in Advertiser, Partners and Price and records in ADvendio.
The system takes CSV files, table data and columns 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 file:
...