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.
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:
|
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: 7.7.10.3 [Generate Media Campaigns] from your Programmatic Data . |
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. |
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.
The automatic Media Campaign Generation is a great solution to get the most up to date Revenue Media Campaigns without having to push the button each time. Please note our automatic Media Campaign Generation will always generate Campaigns for the current / running month. Except for the first 10 days of a month. During this time, the process will update Campaigns from the past month, as well as for the running month, so that we can make sure all data arrived in ADvendio, while already giving you the new Campaigns for your reporting needs! |
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.
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: 7.7.8.5 How to Configure Programmatic Media Campaign Generation (Set custom Fields, Mapping, and other Settings)