7.7.8.6.1 How to structure CSV for generic Programmatic Revenue upload and how mapping is defined
Available with Version | 2.159 and up |
|---|---|
Role | Order Manager - Fulfilment |
ADvendio Edition | Programmatic Add-On |
- 1 Challenge
- 2 Solution
- 2.1 CSV files and formats we import into the ADvendio system
- 2.2 Where and how will the data be mapped in ADvendio? What do you receive in the file?
- 2.3 Outcome generation in Advertiser, Partners and Price and records in ADvendio
- 2.3.1 1-Programmatic Advertiser
- 2.3.2 2-Programmatic Partner
- 2.3.3 3-Programmatic Price
- 2.3.4 4-Programmatic Data Working Set
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 |
|---|---|---|
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: |
|---|---|---|
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 | 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 |
|---|---|
Advertiser Name | My Advertiser |
Advertiser ID: | ADV__002 |
2-Programmatic Partner
Programmatic Partner Name | example |
|---|---|
Partner Name |
3-Programmatic Price
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 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 |