6.5.3.4 Revenue Distribution
Version | 2.158 and up |
---|
Revenue Distribution was enhanced with version 2.158 onwards. To see how distribution was done before, please check 6.5.3.5 Accounting record creation table. The processes and examples below represent this version of revenue distribution for the Accounting Record Creation Processes.
Revenue sharing / Revenue distribution is carried out 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 cost 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
IMPORTANT Note:
Ensuring accurate assignment of these IDs is crucial, as they must match with the fields in the Enhanced Delivery Data.
2. Identify which Ad Specs are relevant for Distribution and activate the Enable Distribution for Accounting checkbox.
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’ is a supported option.
4. To distribute based on Delivery Data, there should be an existing connection and a Delivery Data field. For non-CPM, CPC, CPM, and CPCV 'Accounting Distribution Quantity Type’ field should be chosen. 'Accounting Distribution Quantity Type' can be selected at the Ad Spec level.
Please Note: 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.