Skip to main content
Feedback

Display & Video 360 walkthrough

info

Currently supported APIs:

You can integrate data from the Display & Video 360 API (version 2) into Data Integration by setting up connections, creating queries, and managing reports efficiently.

Connection

To connect Display & Video 360 API with your destination, follow the step-by-step tutorial. After creating the connection, choose a Source connection.

Working with Display & Video 360 integration

You can pull data using these options:

  • Creating a new query in Data Integration
  • Run existing query
  • Entity

Creating a new query in Data Integration

  1. Click on the option to create a new query.

  2. Configure query parameters.

    Report type

    Select a Report type:

    • REPORT_TYPE_UNSPECIFIED

    • STANDARD

    • INVENTORY_AVAILABILITY

    • AUDIENCE_COMPOSITION |

    • FLOODLIGHT

    • YOUTUBE

    • GRP

    • YOUTUBE_PROGRAMMATIC_GUARANTEED

    • REACH

    • UNIQUE_REACH_AUDIENCE

    Partners

    Select the Auto Complete Partners option to view a list of all partners. Choose one or more partners, or leave the field empty to pull data for all partners.

    If an error prompts you to enter partner IDs manually, find your partner IDs.

    Filters

    Add filters and select a filter name and value. Enable Add filter to result columns (group by) to include the filter as a column in the results.

    Dimensions

    Use Dimensions to group data by the filters in the field.

    Metrics

    Select the Metrics to include as columns in your report. Refer to the metrics documentation.

  3. Set the Query time period.

    Date range

    • Pull data between the start and end dates provided.
    • The start date is required.
    • Leave the end date empty to pull data up to the current time.
    • Optionally, set the timezone offset.

Predefined date

You can select the predefined ranges such as Yesterday, Week to date, Previous week, Month to date, Previous month, or Year to date.

Interval chunk size

  • Don't Split: Pulls data in one bulk.
  • Daily: Chunks: data daily.
  • Monthly: Chunk data monthly.
  • Yearly: Chunk data yearly (less recommended).

Keep query

You can keep the query in Display & Video 360:

  • If Keep report is enabled, provide a query title.
  • The query saves in "Display & Video 360" with the same configuration after each run.

Scheduling and running queries

When scheduling the River:

  • A new query will be created and executed at each scheduled interval.
  • If keep query is enabled, a new query will be saved in Display & Video 360 for each run.
  • Disable keep query when scheduling recurring reports to avoid excessive queries.

Run an existing query

Load and select a predefined saved query from your Display & Video 360 console.

Entity

Data Integration supports entity reports such as SDF (Structured Data Files) and Line item entities:

SDF report

Select the file type and filters. At least one ID is required, and only one ID is allowed for ADVERTISER_ID.

Line items report

Filter and retrieve line items by specifying filter types and IDs.

Validating combinations of metrics and dimensions

You must validate combinations of metrics and dimensions in Display & Video 360.

  • Access the Display & Video 360 user interface: Navigate to the reporting section.
  • Create a demo report: Initiate creating a report where you can select your desired combination of fields.
  • Select fields and set options: Choose the metrics and dimensions you want to include in your report, and configure any additional options as necessary.
  • Validate selections: If any invalid combinations are selected, the system will notify you when you attempt to save the report.
  • Correct invalid options: Adjust your selections according to the feedback provided by Display & Video 360. The report cannot be saved until all chosen options are valid.
On this Page