6.1.2 Flexible Pricing for Campaigns

ADvendio now offers initial support for Flexible Pricing, a feature that enables more accurate invoicing by using actual delivery metrics and media spend pulled from revenue schedules, instead of relying solely on predefined prices and quantities.

Key Benefits

• Improved Accuracy: Invoice based on actual delivery data, which might change monthly

Pre-Invoice Generation & Accounting Records

When generating invoices:

• Actual Media Spend from Revenue Schedules is used instead of Campaign Item price x quantity.

• Quantities and pricing are capped at the total amount defined on the Campaign Item.

• Absolute surcharges and discounts are distributed proportionally based on actual media spend.

• PDF previews reflect the monthly average sales price for each period.

Flexible Pricing Activation

A new checkbox field FlexiblePricing__c on Campaign Items allows you to opt into flexible pricing logic.

• When enabled, invoices will:

  • Use monthly average price derived from delivery data.

  • Apply actual delivered quantities for billing.

  • Cap the invoiced amount at the Campaign Item's total budget (Sales Price × Quantity).

New Fields Created

• Monthly Price (Average) (MonthlyPriceAverage__c):
  Formula field on Revenue Schedule:
  = Actual Media Spend / (Quantity Manual OR Delivered Quantity)
  (Multiplied by 1000 for CPM/vCPM categories.)

• Actual Media Spend (ActualMediaSpend__c):
  Stored on Invoice Items to reflect the true media costs based on delivery data.

Pre-Invoice Generation Adjustments

• Delta and non-delta invoice generations pull actuals from revenue schedules.

• Instead of Sales Price × Quantity, the invoice amount uses the capped total of Actual Media Spend.

• Invoiced quantity is taken from uncapped delivery (or manual quantity), except when total media spend needs capping—then adjusted accordingly.

Validation Rules

Validations and Limitations

To ensure reliable calculations, the following rules apply:

If validations fail, clear error messages guide users through misconfigurations in Campaign Builder, Media Config, and Campaign Item pages.

Example Use Case

A Campaign Item with:

• Quantity: 100,000

• Sales Price: $10.00

• Runtime: 3 months

• Billing Category: CPM

• Flexible Pricing: Enabled

If actual delivery shows:

• Month 1: $100 media spend on 10,000 impressions

• Month 2: $750 on 50,000

• Month 3: $127.50 on 25,500

Invoices will reflect:

• Actual delivery quantities

• Calculated monthly prices (e.g., $10.00, $15.00, $5.00)

• A capped total invoice amount not exceeding $1,000,000

Out of Scope (For Now)

• CPA billing category

• Payment intervals other than monthly

• Linear distribution campaigns

• Sales Price Surcharge logic

• Unlimited invoicing logic

• Accounting Records

Key Fields