Magnite - Update Budget Fields

Overview

The Magnite Campaign Budget Update Tool processes input data from a CSV file, validates it, and updates campaigns based on the specified method: Insert, Upsert, or Replace.

Bulk Updates

You can provide a CSV file to update multiple campaigns in one go.

Required Column:

• campaign_id: Identifies the campaign to be updated.

Optional Columns (depending on update needs):

• id: Unique identifier for a specific budget entry.
• budget_metric: Specifies the focus of the budget (e.g., costs, impressions).
• budget_period: Defines the time frame for the budget.
• budget_pacing: Determines how the budget is distributed over time.
• budget_value: The monetary value for the budget.

Valid Values for Optional Columns:

budget_metric:

• net_cost
• gross_cost
• requests
• revenue
• impressions
• completes
• clicks

budget_period:

• day
• lifetime
• month
• week
• hour

budget_pacing:

• asap: Spend as quickly as possible.
• smooth: Spend evenly over the period.
• front_loaded: Spend more at the beginning.
• even: Spread spending evenly.

Additional Considerations

Each budget item in the file is validated against the following rules:

1. Valid Values:

   • budget_metric, budget_period, and budget_pacing must use the valid options listed above.
   • budget_value must be numeric.

2. Unique Budget Periods:

   • No duplicate budget periods are allowed for the same campaign.

3. Pacing Constraints for Lifetime Budgets:

   • If budget_period is lifetime, only asap and smooth are valid pacing options.

4. No Invalid Ad Caching Adjustments:

   • Certain metrics (revenue, requests) cannot have caching adjustments.

Example Input File

Below is an example of how your CSV file should be formatted:

```csv campaignid,id,budgetmetric,budgetperiod,budgetpacing,budgetvalue 12345,,netcost,day,smooth,500 12345,,revenue,lifetime,smooth,2000 67890,1,impressions,month,even,10000