7.7.10.2 Import Programmatic Data from Burt to ADvendio
Challenge:
How to start the import process, and how can I check if data has been imported?
Solution:
To do that, you can either schedule the import process or start it manually.
ADvendio does not import single Auctions / Deals, but will already aggregate the data to a certain extent. We will summarize the data by the following:
The Advertiser / Buyer
The part of the Inventory, which has been sold
The type of Deal and how it has been charged
Data will always be aggregated for full months
The Programmatic Partner (available for BURT)
Info Box
Programmatic Data will always be imported for a whole month. From the 1st to 10th day of a month, ADvendio will import / update data from the previous and the current month. After the 7th. day, data will only be imported for the current month and the previous month can be considered completed, and ready for further use.
BURT Mapping:
Here is an overview of the data mapping for the Burt integration
To understand how the Media Campaigns and Campaign Items are generated, check the following wiki section.
Keep in mind that ADvendio aggregates the number of sold impressions and revenue by month.
Programmatic Data | Burt | Example | Description |
---|---|---|---|
Ad Unit / Site Section Name | Site | news.com - homepage - ver1 | The name of the inventory that has been used. |
Advertiser Name | Mapped Advertiser | Media Corp Ltd. | The Name of the Advertiser/Buyer |
Clicks | N/A | N/A | N/A |
Cost Type (CPM as fixed value) | N/A | CPM | At the moment, all the data imported from Burt uses CPM as associated cost type. |
Creative Size | Creative Size | 300x300 | Which format has been used. |
Currency Code | Currency | EUR, CAD, etc | All data imported from Burt uses the USER Default Currency |
Deal Type | Transaction Type | Private Auction | The type of Auction, for example, Preferred Deal, Open Auction, and so on. |
Impressions | Impressions | 500 000 | The number of sold impressions. |
Month | Date | 2021-05-01 | The Month, for which the data has been aggregated. |
Programmatic Partner | Partner | Pubmatic | The Programmatic/SSP Partner associated to the respective programmatic data entry. |
Revenue | Net Revenue Eur | 25000 | The actual revenue generated for the Inventory / Size in that Month |
Matching
Now that the programmatic advertisers and prices are available in ADvendio, it is time to connect and match the data:
Connect Buyers / Advertisers to your ADvendio Accounts (Programmatic Advertiser Wizard)
Connect Ad Units / Placements/formats to your ADvendio Product (Programmatic Price Wizard)
Connect Programmatic Partners to your ADvendio Accounts (available starting with 2.150 and up)
Import Errors & Fixes
Certain programmatic prices are not getting imported - what can I do?
One reason why the import of some programmatic prices could fail is related to the missing picklist values from Deal Type (ADvendio__DealType__c; object Programmatic Prices).
We have supported initially only Open Auction and Private Auction. Starting with 2.144.1, the following values should be added as well:
First Look (for Values and API Name)
Preferred Deal (for Values and API Name)
Programmatic Guaranteed (for Values and API Name)