Version | 2.158 and up |
|---|
| Note |
|---|
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 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).
...
To carry out your revenue and costs 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 Matching criteria
...
To create your records on Enhanced Delivery Data of Sites & Video Groups, create your rules with the relevant AdServer IDs as matching Matching criteria
AdServer ID - Site
Secondary AdServer ID - Video Groups
...
...
| Info |
|---|
IMPORTANT Note: Ensuring accurate assignment of these IDs is |
...
crucial, as they must match with the fields |
...
in the Enhanced Delivery Data. |
...
2. Flag Identify which Ad Specs are relevant for distribution by setting Delivery Data Based Revenue Distribution on Ad Spec level to true
...
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. ℹ️ Currently, only ‘Sites and Video Groups are supportedGroups’ is a supported option.
...
4. To distribute based on Delivery Data, there should be a an existing connection existing and as well a Delivery Data feelfield. For non-CPM, CPC, CPM, and CPCV distribution quantity types 'Accounting Distribution Quantity Type’ field should be chosen. 'Accounting Distribution Quantity Type' can be selected at the Ad Spec level.
| Info |
|---|
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.
...
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
...