Google Display & Video 360 Integration for Nodus
1. Introduction to the Google DV360 Integration
What Is This Integration?
The Google Display & Video 360 (DV360) integration connects your DV360 advertising platform data with Nodus, allowing you to extract, analyze, and transform campaign performance metrics, creative insights, audience targeting information, and inventory data. This integration functions as a source connector, bringing your DV360 data into the Nodus ecosystem for advanced analytics and business intelligence.
Prerequisites:
- An active Google DV360 account with appropriate access permissions
- DV360 Advertiser ID for the account you want to connect
- Optional: DV360 Partner ID (if working with a partner account)
- Authorization via Google Single Sign-On (SSO)
- Google Cloud OAuth client credentials with API access to DV360
Connection Overview:
The integration uses Google's Display & Video 360 API to extract advertising data and performance metrics. Authentication is handled through OAuth 2.0 with Google, and the connector extracts data based on predefined templates that specify which datasets to retrieve.
2. Platform Setup Documentation (Setup Form for Google DV360)
Purpose & Scope
This section covers how to set up the initial connection between Nodus and Google DV360 by providing the necessary authentication credentials and account details.
Field-by-Field Breakdown:
Integration Name
- Field Name & Label: Integration Name
- Description & Purpose: A descriptive name to identify this DV360 integration within your Nodus account.
- Validation Rules & Format: Text string, required field.
- Examples: "DV360 - Main Account", "Brand Marketing DV360"
- Troubleshooting Tips: Use a descriptive name that clearly identifies the specific DV360 account or purpose.
DV360 Partner ID
- Field Name & Label: DV360 Partner ID
- Description & Purpose: The Partner ID for which you want to access data.
- Validation Rules & Format: Numeric string, optional field.
- Examples: "12345678"
- Troubleshooting Tips: Found in DV360 UI next to partner name. This field is optional if you're only working with a single advertiser.
DV360 Advertiser ID
- Field Name & Label: DV360 Advertiser ID
- Description & Purpose: The Advertiser ID for which you want to access data.
- Validation Rules & Format: Numeric string, required field.
- Examples: "98765432"
- Troubleshooting Tips: Found in DV360 UI next to advertiser name. This is required to identify which advertiser's data to access.
External Link
- Link Label: "DV360 API Documentation"
- URL: https://developers.google.com/display-video/api/guides/getting-started
- Purpose: Provides access to official Google DV360 API documentation for additional help.
Step-by-Step Guide:
- Log in to Google DV360
- Identify your Partner ID (if applicable) and Advertiser ID from the UI
- Enter these values along with a meaningful Integration Name in the Nodus setup form
- Click Authorize to launch the Google SSO authorization flow
- Grant permissions when prompted by Google
- Verify connection and save the configuration
Reference Links:
3. Extraction/Query Configuration (Extraction Form for Google DV360)
Purpose & Overview
This section explains how to configure data extraction from Google DV360. The platform offers various templates for extracting different types of advertising data and analytics, as well as specialized packages that bundle related data extractions together.
Template & Field Documentation:
Template Selection
- Field Name & Label: Select a template
- Description & Purpose: Defines which type of DV360 data to extract
- Validation Rules & Format: Dropdown selection, required field
- Available Options:
- Advertiser Dimensions - Advertiser metadata and configuration
- Audience Performance - Performance metrics by audience segment
- Campaign Dimensions - Campaign structure and configuration data
- Campaign Performance - Performance metrics at the campaign level
- Creative Dimensions - Creative metadata and configuration
- Creative Performance - Performance metrics at the creative level
- Geo Performance - Performance metrics by geographic location
- Inventory Dimensions - Inventory source metadata
- Line Item Dimensions - Line item structure and configuration
- Line Item Performance - Performance metrics at the line item level
- Source of Truth - High-level account metrics
- Targeting Dimensions - Targeting criteria configuration
- Video Performance - Video-specific performance metrics
Lookback Range
- Field Name & Label: Lookback Range
- Description & Purpose: Specifies how many days back to extract data
- Validation Rules & Format: Dropdown selection, required field
- Available Options:
- 7-day Range
- 14-day Range
- 30-day Range (recommended)
- 90-day Range
- Troubleshooting Tips: Select a range appropriate for your analysis needs. Longer ranges provide more historical context but may increase processing time.
Historic Date Selection
- Field Name & Label: Historic Date
- Description & Purpose: For historical data extraction, specifies a custom date range
- Validation Rules & Format: Date picker, required field
- Troubleshooting Tips: DV360 typically maintains historical data, but there may be limitations on how far back certain metrics are available.
Available Packages
Package Name: Campaign Performance Package
Description: Complete view of campaign and line item performance metrics with dimension data
Included Templates:
- Campaign Performance
- Line Item Performance
- Campaign Dimensions
- Line Item Dimensions
Package Name: Creative Insights Package
Description: Analysis of creative and video performance across different formats
Included Templates:
- Creative Performance
- Video Performance
- Creative Dimensions
Package Name: Audience & Targeting Analysis Package
Description: Analyze audience performance and targeting strategies across segments and geographies
Included Templates:
- Audience Performance
- Targeting Dimensions
- Geo Performance
Package Name: Media Planning Package
Description: Analyze inventory allocation, campaign and line item performance for media planning
Included Templates:
- Inventory Dimensions
- Line Item Performance
- Campaign Performance
- Geo Performance
Package Name: Account Overview Package
Description: High-level account metrics and structure overview for executives and account managers
Included Templates:
- Source of Truth
- Advertiser Dimensions
- Campaign Performance
- Creative Performance
Workflow & Examples:
- Select an individual template or a package from the available options
- If using an individual template, select the appropriate template from the dropdown
- Choose a lookback period or specific historic date range
- Preview the query to confirm configuration
- Execute extraction
Example Use Cases:
Campaign Performance Analysis:
- Template: Campaign Performance
- Metrics: Impressions, clicks, revenue, conversions
- Lookback: 30-day Range
Creative Optimization:
- Package: Creative Insights Package
- Focus: Video completion rates, creative performance by format
- Lookback: 90-day Range
Audience Targeting Analysis:
- Package: Audience & Targeting Analysis Package
- Focus: Performance by audience segment and geographic location
- Historic Date: Custom range for specific campaign periods
4. Data Mapping & Underlying Models for Google DV360
Data Model Overview
The Google DV360 API returns structured data based on the selected template. Each template corresponds to specific report types and data structures within the DV360 Reporting API.
Schema & Field Mapping
Campaign Performance Schema
| Field | Description |
|---|---|
| date | The date for the metrics |
| advertiser_id | The advertiser account identifier |
| advertiser_name | The name of the advertiser |
| insertion_order_id | The campaign (insertion order) identifier |
| insertion_order_name | The name of the campaign |
| insertion_order_status | The status of the campaign |
| impressions | Number of impressions |
| clicks | Number of clicks |
| ctr | Click-through rate |
| revenue_advertiser | Revenue attributed to the advertiser |
| media_cost_advertiser | Media cost to the advertiser |
| total_conversions | Total number of conversions |
| conversions_per_mille | Conversions per thousand impressions |
| view_through_conversions | View-through conversions |
| extracted_at | Timestamp when the data was extracted |
Line Item Performance Schema
| Field | Description |
|---|---|
| date | The date for the metrics |
| advertiser_id | The advertiser account identifier |
| advertiser_name | The name of the advertiser |
| insertion_order_id | The campaign identifier |
| insertion_order_name | The name of the campaign |
| line_item_id | The line item identifier |
| line_item_name | The name of the line item |
| line_item_type | The type of line item |
| impressions | Number of impressions |
| clicks | Number of clicks |
| ctr | Click-through rate |
| revenue_advertiser | Revenue attributed to the advertiser |
| media_cost_advertiser | Media cost to the advertiser |
| total_conversions | Total number of conversions |
| extracted_at | Timestamp when the data was extracted |
Creative Performance Schema
| Field | Description |
|---|---|
| date | The date for the metrics |
| advertiser_id | The advertiser account identifier |
| advertiser_name | The name of the advertiser |
| creative_id | The creative identifier |
| creative_name | The name of the creative |
| creative_type | The type of creative |
| creative_size | The size of the creative |
| impressions | Number of impressions |
| clicks | Number of clicks |
| ctr | Click-through rate |
| revenue_advertiser | Revenue attributed to the advertiser |
| media_cost_advertiser | Media cost to the advertiser |
| extracted_at | Timestamp when the data was extracted |
Video Performance Schema
| Field | Description |
|---|---|
| date | The date for the metrics |
| advertiser_id | The advertiser account identifier |
| advertiser_name | The name of the advertiser |
| insertion_order_id | The campaign identifier |
| insertion_order_name | The name of the campaign |
| creative_id | The creative identifier |
| creative_name | The name of the creative |
| impressions | Number of impressions |
| video_quartile_25_rate | Rate of video views reaching 25% completion |
| video_quartile_50_rate | Rate of video views reaching 50% completion |
| video_quartile_75_rate | Rate of video views reaching 75% completion |
| video_quartile_100_rate | Rate of video views reaching 100% completion |
| viewable_impressions | Number of viewable impressions |
| revenue_advertiser | Revenue attributed to the advertiser |
| media_cost_advertiser | Media cost to the advertiser |
| extracted_at | Timestamp when the data was extracted |
Audience Performance Schema
| Field | Description |
|---|---|
| date | The date for the metrics |
| advertiser_id | The advertiser account identifier |
| advertiser_name | The name of the advertiser |
| audience_list | The audience list identifier |
| audience_type | The type of audience |
| audience_name | The name of the audience |
| gender | Audience gender |
| age | Audience age range |
| impressions | Number of impressions |
| clicks | Number of clicks |
| ctr | Click-through rate |
| total_conversions | Total number of conversions |
| media_cost_advertiser | Media cost to the advertiser |
| extracted_at | Timestamp when the data was extracted |
Geo Performance Schema
| Field | Description |
|---|---|
| date | The date for the metrics |
| advertiser_id | The advertiser account identifier |
| advertiser_name | The name of the advertiser |
| country | Country code |
| region_name | Region or state name |
| city_name | City name |
| targeted_location_dimension | Location targeting string |
| impressions | Number of impressions |
| clicks | Number of clicks |
| ctr | Click-through rate |
| total_conversions | Total number of conversions |
| media_cost_advertiser | Media cost to the advertiser |
| extracted_at | Timestamp when the data was extracted |
5. Troubleshooting & FAQs for Google DV360
Common Issues & Error Messages
Authentication Failures
- Error: "Invalid access token" or "Token expired"
- Solution: Re-authorize the integration through Google SSO. Google access tokens have limited lifetimes and may need to be refreshed.
Permission Issues
- Error: "Insufficient permissions" or "Access denied"
- Solution: Ensure the Google account used for authentication has appropriate access to the DV360 account. Verify the advertiser ID is correct and that your user has appropriate permissions for that advertiser.
Missing Data
- Common Causes:
- Date range outside of data retention period
- Insufficient account activity to generate data
- Permission issues for specific advertisers or report types
- Solution: Adjust template filters, check campaign dates, verify account permissions
Rate Limit Exceeded
- Error: "Rate limit exceeded" or "Quota exceeded"
- Solution: Google DV360 API has rate limits. Try reducing the frequency of extractions or implementing a backoff strategy.
Report Timeout
- Error: "Report generation timeout"
- Solution: DV360 reports with very large date ranges or complex filters may time out. Try reducing the date range or simplifying the report parameters.
Contact & Support Information
- Google DV360 Support: https://support.google.com/displayvideo
- Nodus Support: support@nodus.com
Best Practices for DV360 Connections
- Schedule regular extractions to maintain a current view of your advertising performance
- Use packages to extract related data sets together
- For large accounts, break up historical extractions into smaller date ranges
- Consider extracting dimension data less frequently than performance data as it changes less often
- Monitor API usage to avoid hitting rate limits