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 Programmatic Revenues and connected Media Campaigns and revenue managed in ADvendio ? If but you do not want to use direct integration to bring these data automatically into salesforce this feature allows into Salesforce?
The programmatic CSV import option will allow you to import programmatic revenue data flexibly from the external system. You can enable the Generic Import of Programmatic Data in to ADvendio using CSV files . And and the ability to create Media Campaigns and Campaign Items from the data uploaded.
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
In order to 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 file and formats we import into
...
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:
|
...
Data imported | Data Exported/ received | Data examples/ how 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 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 |
|---|---|
Advertiser Name | My Advertiser |
Advertiser ID: | ADV__002 |
...
2-Programmatic Partner
Programmatic Partner Name | Automatic Number |
|---|---|
Partner Name |
...
3-Programmatic Price
Programmatic Price Name | Automatic Number |
|---|---|
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.
...