Version | 2.158 and up |
|---|
Revenue Distribution was enhanced with version 2.158 onwards. To see how distribution was done before, please check https://advendio.atlassian.net/wiki/spaces/SO/pages/3180757098/Revenue+distribution+enhancement. The processes and examples below represent this version of revenue distribution for the Accounting Record Creation Processes.
Revenue sharing / Revenue distribution is carried in ADvendio through the Distribution Accounting Record Creation Process. Revenue is distributed when revenue distribution is enabled on revenue Ad Spec. The amount of Delivery Data or amount based on Linear Distribution presented determines how much of the collected revenue and costs will be distributed across the relevant sites. Any excess revenue which cannot be distributed can be created as a deferral record. Any delivery which cannot be distributed can be created as an accrual (see examples below).
Revenue can be distributed monthly when invoiced revenue exists and Ad Spec is enabled for distribution. Once an item has completed its runtime, the Distribution process will also carry out an adjustment to ensure that the distributed amount is proportionate to the overall distribution of the item (see examples below).
Setup
To carry out your revenue and costs distribution you need to:
Create your Distribution Accounting Rules. There are different approaches to distributing revenue:
Based on Site based Delivery Data
Enhanced Delivery Data of Sites & Video Groups
Linearly distributed on Delivery Data
Linearly distributed on Amount
To create your records on Site based Delivery Data, create your rules with the relevant Advertising Medium/Site as matching criteria
To create your records on Enhanced Delivery Data of Sites & Video Groups, create your rules with the relevant AdServer IDs as matching criteria
AdServer ID - Site
Secondary AdServer ID - Video Groups
Correctly assigning these IDs is very important as it needs to match with the fields on the Enhanced Delivery Data.
2. Flag which Ad Specs are relevant for distribution by setting Delivery Data Based Revenue Distribution on Ad Spec level to true
3. If you want to use Enhanced Delivery Data, ensure the correct Accounting Delivery Data Breakdown Type is set on your Campaign Item - currently, only Sites and Video Groups are supported
4. To distribute based on Delivery Data, there should be a connection existing and as well a Delivery Data feel. For non-CPM, CPC, CPM, and CPCV distribution quantity types should be chosen. Account distribution quantity type can not be changed if accounting records have been created.
5. Ensure delivery data imports are scheduled for Delivery Data and Enhanced Delivery Data.
6. Ensure you have revenue and costs distributed (invoiced invoices for the relevant Line Items).
Distribution Process
When the Distribution process is started from the Legal Entity, the revenue and costs from the Invoices will be distributed according to the last full month of delivery. Revenue will be distributed across the sites or sites & video groups in proportion to how much has been delivered or linearly distributed if no connection exists. Where an item over or under delivers overall, an adjustment may need to take place to ensure the total amounts distributed remain proportionate.
Distribution Example
Campaign Item with 100,000 quantity (CPM) sales price of 27 Euro and a runtime of 01.01-28.02
Under Delivery
With the following Delivery across four sites over two months
Site 1 | Site 2 | Site 3 | Site 4 | Total delivery per month | |
January | 13000 | 14500 | 27500 | ||
February | 30000 | 37500 | 67500 | ||
Total delivery per site | 13000 | 14500 | 30000 | 37500 | 95000 |
You would see the following Distribution Records created on a month-to-month basis
Site 1 | Site 2 | Site 3 | Site 4 | Total revenue per month | |
January | 351.00 | 391.50 | 0.00 | 0.00 | 742.50 |
February | 18.47 | 20.61 | 852.63 | 1065.79 | 1957.50 |
Total revenue | 369.47 | 412.11 | 852.63 | 1065.79 | 2700.00 |
Over Delivery
With the following Delivery across four sites over four months
Site 1 | Site 2 | Site 3 | Site 4 | Total delivery per month | |
|---|---|---|---|---|---|
January | 15000 | 9500 | 24500 | ||
February | 6000 | 15000 | 10000 | 31000 | |
March | 6000 | 9500 | 15500 | ||
April | 8000 | 10000 | 15000 | 33000 |
You would see the following Distribution Records created on a month-to-month basis
Site 1 | Site 2 | Site 3 | Site 4 | Total revenue per month | |
January | 405.00 | 256.50 | 0.00 | 0.00 | 661.50 |
February | 162.00 | 0.00 | 405.00 | 270.00 | 837.00 |
March | 0.00 | 162.00 | 0.00 | 256.50 | 418.50 |
April | 185.88 | - 16.10* | 244.04 | 369.17 | 783.00 |
Total revenue | 752.88 | 402.40 | 649.04 | 895.67 | 2700.00 |
* This is a minus adjustment record which redistributes some revenue from Site 2 to other sites
Distribution and cancellations
If Invoice or Campaign Items are cancelled where revenue/costs have already been distributed, then cancellation distribution records will be created on the next distribution process, once the cancellation invoices have been invoiced.
If Invoices or Campaign Items are cancelled where revenue/costs have not yet been distributed, no records will be created on the next run.