Search
Clear search
Close search
Google apps
Main menu
true

  Not available in DFP Small Business.

Bulk upload forecast adjustments

Note: This feature is currently in beta release to a few customers.

In order to bulk upload forecast adjustments, we recommend that you first download and import existing adjustments, or the sample CSV file, make any edits, and then upload that file to DoubleClick for Publishers.

  1. Sign in to DoubleClick for Publishers.
  2. Click Inventory and then Forecast adjustments.
  3. Click Download active adjustments to use the existing CSV file as the basis for the bulk upload.
    If you don't yet have any adjustments, click Bulk upload new adjustments and then Download sample CSV file, which you can use as the basis for you new bulk adjustments.

  4. Import the downloaded CSV file:

    1. From Excel, use the "import" option for a CSV file, using commas as delimiters. Dates are displayed in the YYYYMMDD format. Please don't change this format.

    2. After importing the file, save it and use it as a basis for a new bulk adjustment file.

  5. Define the new forecast adjustments in the CSV file, keeping all formatting intact. Note that if you use older bulk adjustment files in which dates are formatted as YYYY-MM-DD, they'll continue to work.

  6. Click Bulk upload new adjustments.

  7. Click Choose file to find the file.

  8. Click Upload and validate.

  9. Verify that the forecast adjustments are correct and click Confirm upload to upload the new adjustments.

What forecast adjustment values can I bulk upload?

With a properly-formatted .csv file (see Step 2 above to download an example), you can bulk upload any of the following values:

Value Definition and format
Name The name you use to identify the adjustment. This field is optional; if you don't include a name, we'll generate one that includes a unique ID and timestamp.
Inventory unit ID The ad unit ID to which the adjustment applies. To find the ad unit ID, navigate to the ad unit in DFP and then look for adSlotId= in the URL.
Start date The date the adjustment takes effect—must be in the future. Format: YYYYMMDD.
End date The date the adjustment finishes—for manual adjustments, must be the same as or later than the start date; for historical adjustments, must be in weekly increments and a minimum of one week later than the Start date. Format: YYYYMMDD.
Adjustment type

Can be one of: manual or historical.

Historical start date The start date of the historical basis period—must be in the past. Format: YYYYMMDD.  This is required if the Adjustment type is set to historical.
Historical end date The end date of the historical basis period—must be in the past, in weekly increments, and a minimum of one week later than the Historical start date. Format: YYYYMMDD. This is required if the Adjustment type is set to historical.
Potential volume This has different meanings depending on the value of Adjustment type and Volume distribution type.
Volume distribution type daily (Manual adjustments only.) Potential volume = number of impressions per day.

periodTotal

(Manual adjustments only.) Potential volume = number of impressions per adjustment period.

weekly

(Historical adjustments only.) Potential volume = percent of historic impressions per week to be used when calculating future impressions (i.e., trend):

  • A value less than 100 indicates the adjustment will use a percentage of impressions that is less than the historic level.
  • A value of 100 indicates the adjustment will use the actual historical level of impressions.
  • A value greater than 100 indicates the adjustment will use a percentage of impressions that is greater than the historical level.
Sizes Specifies the size overrides for the adjustment—for single ad size adjustments, each size requires a unique row. For multi-size ad tags, must be a semicolon-delimited list of size strings matching the standard size format. Example: 300x200;4:3;250x300v.
How do I upload run-of-network adjustments?

You can upload run-of-network bulk adjustments by entering your root network inventory ID as the Inventory unit ID in the csv file. Please contact support if you need help locating this ID.

Was this article helpful?
How can we improve it?