...
Now that my programmatic data is available in ADvendio storage, and programmatic prices, advertisers, and partners are mapped accordingly, I need to have the data organized per Media Campaigns and/or Campaign Items.
...
To find out more information about the Media Campaign generation process, please check the following wiki section: 7.7.8.4 How to generate Media Campaigns from your Programmatic Revenue Data
Structure of Programmatic Revenue Media Campaigns and Campaign Items
...
You might wonder how you identify the Programmatic Revenue Campaigns in between your regular Media Campaigns.
That’s fairly simple, because the Media Campaigns follow a specific format:
Year-Month Programmatic Revenue PLATFORM - Advertiser/Buyer
...
When you look at such a Media Campaign the following key information are set:
Advertiser = The Advertiser / Buyer from the SSP
SSP = the Connection that represents the SSP / Exchange of which the data is coming
Programmatic Partner = The Platform from which revenue came in (if you combine multiple sources in one connection like BURT) Or the Buyer/Agency involved
Quantity = The number of Impressions sold in that month
Amount net/net = The total revenue you made with that buyer, in that month via that SSP/Exchange
| Info |
|---|
Some of our integrations support additionally the Programmatic Partner, this is currently included for:
|
Based on your defined and mapped programmatic prices, Campaign Items are generated for the Media Campaign.
...
How do Campaign Items for Programmatic Campaigns look? Which fields are set?
The individual Campaign Items generated for your Programmatic Media Campaigns follow a fixed patterns.
You will notice there is a couple of fields that are automatically set by ADvendio, these are required to display the programmatic revenue in the desired way. The following key information are set:
Campaign Item Name: The Name, based upon the mapped Ad Price.
From (Date) & Until (Date): Represents the month for which the revenue is aggregated (our module always aggregates per month!)
Ad Price: The Ad Price that was defined via the Programmatic Price Mapping
Quantity: The number of Impressions or Clicks from your Imported Programmatic Data.
Sales Price: Defined by the mapped Ad Price.
Special Discount: Automatically calculated according to the Ad Price vs. the actual imported Programmatic Revenue
Amount: The Revenue from your Imported Programmatic Data
Pay Factor: (OPTIONAL) You can use this formula to compare the avg. CPM price of your import with the rate of your Ad Price, to get a better feeling of the performance of your Programmatic Inventory.
...
| Info |
|---|
Why is special discount required? As of right now, ADvendio calculates the Amount by Quantity * Sales Price. Due to the nature of the incoming data, if we would try to set the Sales Price to the avg. CPM of your Programmatic Data, there is the higher risk of rounding issues (since the sales price only allows limited decimals). We instead set a Special Discount, in order to achieve the correct Amount, which represents the incoming Programmatic Revenue. |
Burt specific settings
In Burt, the Media Campaign generation process has been slightly adjusted to better emphasize the data that will be received from various Adservers. Let’s start with the default scenario (any other integration but Burt):
...