Challenge:
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.
Solution:
Programmatic Media Campaign Generation feature
In order to generate the Media Campaigns from your BURT reporting data, we have a dedicated process. This can be started by using the ‘Programmatic Media Campaign Generation’ button on your Connection record or by scheduling an automated process, for example every day!
...
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.
...
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
...
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 patternspattern.
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 a “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. average CPM of your Programmatic Data, there is the a 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):
...
If multiple Programmatic Prices are assigned to one Ad Price, one Campaign Item will be created.
For each Connection, Account, Currency, Partner Account, Deal Type, and Month, a Media Campaign will be created.
In that way, each Media Campaign result will correspond to the associated Programmatic Partner.The Programmatic Partner Account information will be stored at the level of Media Campaign in the Programmatic Partner field.
The name of the Programmatic Media Campaign contains: Year-Month Programmatic Revenue PROGRAMMATIC PARTNER ACCOUNT - Advertiser/Buyer
Example:
Step 1: Confirm that all programmatic relevant data has been imported. For that, you can check the following objects: Programmatic Advertisers, Programmatic Price, and Programmatic Partner
Step 2: Assign (Partner) Accounts to the relevant Programmatic Partners
Step 3: Assign Ad Prices to the relevant Programmatic Prices
...
Step 5: Generate Programmatic Media Campaigns
...
Why no Programmatic Media Campaign is being generated?
To have programmatic media campaigns generated, confirm that the imported programmatic partners, prices, and advertisers have been correctly assigned (see Example section).
The Media Campaign Name field supports a maximum of 80 characters. If it contains more than 80 characters, no programmatic media campaign will be created.
More than 80 character Names are accepted and truncated automatically from version 2.169.xx onwards
Useful links:
if you wish to configure the Programmatic Media Campaign generation (set custom fields, Mapping, and other additional settings), check the following wiki section: 7.7.8.5 How to configure the Programmatic Media Campaign generation (Set custom fields, Mapping and other settings)
...