7.7.8.4 How to generate Media Campaigns from your Programmatic Revenue Data

Why generate Media Campaigns? - Use Cases

Once the mapping of your Advertisers and Programmatic Prices is done, you can start generate Media Campaigns from your programmatic revenue data. But what’s the benefit of doing this?

  • Easily summarize your revenue by Buyer, SSP and Month, ready to use for your reporting and visualization in the analytics app

  • By using Media Campaigns and Campaign Items, the revenue from programmatic data is aligned with your regular Media Campaigns, making it easier to compare the revenue streams

  • Map to existing or new Products (Ad Prices) of your inventory, to enrich your programmatic revenue data with additional information. Together with our Deal Type mapping, you can easily create reports to see how you inventory and advertisers perform across each channel.

  • Use the List Price, to define a base price and see how your actual revenue and average eCPM compares to this base price.

  • The Media Campaigns are ready to use for ADvendio features, such as Publisher Payout or Sales Goals.

Structure of Programmatic Revenue Media Campaigns and Campaign Items

Bildschirmfoto 2024-04-26 um 10.17.58.png

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

Some of our integrations support additionally the Programmatic Partner, this is currently included for:

  • BURT Analytics

  • Generic CRM Upload

 

Based on your defined and mapped programmatic prices, Campaign Items are generated for the Media Campaign.

 

The Programmatic Media Campaign generation process for BURT is slightly modified. For more information, please visit the BURT wiki section: https://advendio.atlassian.net/wiki/spaces/SO/pages/2807169057 .

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.

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.

How to generate Media Campaigns? - Manually via button

If you want to generate Media Campaigns there are two ways to do so. First one will be manually per SSP/Exchange.

You will need to go to the detail page of the AdServer Login and click the button “Create Programmatic Media Campaigns”.

 

Then you will be ask to set a date for the run. This decides which month to consider. You can use this to test the feature.

Once you click start, the process will run and you will receive an email when it’s finished.

Schedule automatic Media Campaign Generation

Of course you don’t want to go into each of your SSPs / Exchanges and click the Media Campaign Button to gather all your data. That’s why you can schedule the process to run at your desired intervals.

To do so, you will need to go to setup → apex classes

Click the button Schedule Apex:

Enter a name of your choice as job name, and select the following Apex Class:

ProgrammaticDataProcessController

Select a day and a time when the process should be done and click save to confirm your settings.

Now your Media Campaign generation will run automatically at your configured schedule.

Set your own custom information / fields

During the process ADvendio sets some fixed values for the generated Media Campaigns (see mapping list below), besides these you have to possibility to define how fields will be set. You can do this, to support the usage in other features or set your own criteria, to differentiate the programmatic revenue Campaigns from others.

To see how to change this configurations have a look here: https://advendio.atlassian.net/wiki/spaces/SO/pages/1387561027