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: https://advendio.atlassian.net/wiki/spaces/SO/pages/983564300/7.7.8.4+Generate+Programmatic+Media+Campaigns+from+your+Programmatic+Revenue+Data

Structure of Programmatic Revenue Media Campaigns and Campaign Items

Open

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

Open

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 (Column name Net_Revenue)

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 pattern.

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.

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, and Month, a Media Campaign will be created.

• The name of the Programmatic Media Campaign contains: Year-Month Programmatic Revenue PLATFORM - Advertiser/Buyer

However, with the Burt integration, you bring data from multiple third-party sources. Therefore, how is data from different AdServers being differentiated from each other? If Burt integration is being used, then the above scenario becomes the following one:

• 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 4: Assign (Advertiser) Accounts to the relevant Programmatic Accounts

Step 5: Generate Programmatic Media Campaigns

Why no Programmatic Media Campaign is being generated?

1. To have programmatic media campaigns generated, confirm that the imported programmatic partners, prices, and advertisers have been correctly assigned (see Example section).

2. 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.

   1. 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: https://advendio.atlassian.net/wiki/spaces/SO/pages/1387561027