Yahoo DSP API Connector | Bright Analytics Help Centre

Overview

Yahoo DSP (Demand-Side Platform) enables programmatic buying across display, video, native, and CTV inventory. The Yahoo DSP API provides programmatic access to campaign, placement, creative, and audience performance metrics, supporting advertisers in monitoring, reporting, and optimising campaigns across multiple channels.

Data handled by the integration:

Account & Campaign Data

Advertiser accounts and account IDs
Campaigns, campaign types (display, video, native, CTV)
Campaign objectives (awareness, engagement, conversions)
Budgets, bids, pacing, and flight dates
Campaign status (active, paused, completed)

Creative & Ad Data

Creative metadata: ad ID, format, type, and size
Associated campaign and placement
Media assets (images, video), headlines, descriptions, and call-to-actions
Approval status and policy compliance

Performance Metrics

Impressions, clicks, CTR
Cost, CPC, CPM, spend
Conversions and conversion value
Engagement metrics (video completions, interactions)
Frequency and reach

Audience & Targeting

Demographics (age, gender, location)
Interests, behaviours, and custom audiences
Device type and platform (desktop, mobile, tablet, CTV)
Contextual targeting and publisher segments

Metadata & Reference Tables

Account, campaign, and placement hierarchy
Creative format and ad type taxonomy
Device, geographic, and demographic mappings
Conversion action definitions

Granularity:

This integration retrieves data at: Account, Campaign, Ad group, Ad and Creative Levels which can be broken down by device type, location and demographic.

Purpose:

Analyse placement and creative effectiveness
Optimise audience targeting and bidding strategies
Track conversions and engagement metrics
Integrate Yahoo DSP metrics into multi-channel dashboards
Conduct historical audits and performance analysis

Refresh Cadence:

Data is refreshed daily.

Update Modes:

Append (for data table), Refresh (for metadata)

For more information on this integration, please follow the link here.

Connection Options

Key	Type	Required	Description	Hint	Size
yahoo_advertiser_ids	text	Yes	Oath-Brightroll Advertiser ID	This is a numeric value next to your username in the dropdown	30
yahoo_client_id	text	Yes	Yahoo DSP API Client ID	Yahoo Client ID generated in the UI for API integrations	30
yahoo_client_secret	text	Yes	Yahoo DSP API Client Secret	Yahoo Client Secret generated in the UI for API integrations	30

For more information on how to access these credentials please follow this link.
It should give you detailed guide on how to find the advertiser IDs and generate a Client ID and Secret.

Jobs

1. Oath-Brightroll Data Import

Feed: oath_brightroll
Type: Data
Target Table: oath_data_delivery
Description: Oath Data Import
Update Mode: Append
Date Column: day
Lookback: 5 days
Run Hour: 6
Poll Frequency: 24 hours

2. Oath-Brightroll Meta Refresh

Feed: oath_brightroll
Type: Lookup
Targets:
- oath_meta_campaign – Campaign Meta (Priority 1)
- oath_meta_creative – Creative Meta (Priority 2)
Update Mode: Refresh
Lookback: 1 day
Run Hour: 6
Poll Frequency: 24 hours

Dimensions

Name	Source Field
Advertiser [Yahoo]	`oath_data_delivery.advertiser`
Order [Yahoo]	`oath_data_delivery.order`
Publisher [Yahoo]	`dcm_meta_site.publisher`
Campaign [Yahoo]	`oath_meta_campaign.value`
Creative [Yahoo]	`oath_meta_creative.name`

Base Metrics

Name	Formula	Format
Spend [Yahoo]	`SUM({oath_data_delivery.advertiser_spending_advertiser_currency})`	£, 2dp
Clicks [Yahoo]	`SUM({oath_data_delivery.clicks})`	int
Impressions [Yahoo]	`SUM({oath_data_delivery.impressions})`	int
Video Views Quartile - 25% [Yahoo]	`SUM({oath_data_delivery.25pct_complete})`	int
Video Views Quartile - 50% [Yahoo]	`SUM({oath_data_delivery.50pct_complete})`	int
Video Views Quartile - 75% [Yahoo]	`SUM({oath_data_delivery.75pct_complete})`	int
Video Completes [Yahoo]	`SUM({oath_data_delivery.100pct_complete})`	int
Video Views [Yahoo]	`SUM({oath_data_delivery.start_views})`	int
Measurable Impressions [Yahoo]	`SUM({oath_data_delivery.measurable_impressions})`	int
Non Measurable Impressions [Yahoo]	`SUM({oath_data_delivery.nonmeasurable_impressions})`	int
Conversions [Yahoo]	`SUM({oath_data_delivery.conversion})`	int
VT Conversions [Yahoo]	`SUM({oath_data_delivery.view_through_conversion})`	int
CT Conversions [Yahoo]	`SUM({oath_data_delivery.click_through_conversion})`	int

Composite Metrics

Name	Formula	Format
CTR [Yahoo]	`({Clicks [Yahoo]}/{Impressions [Yahoo]})*100`	%, 2dp
CPM [Yahoo]	`({Spend [Yahoo]} / {Impressions [Yahoo]}) * 1000`	£, 2dp
CPC [Yahoo]	`{Spend [Yahoo]} / {Clicks [Yahoo]}`	£, 2dp
VCR [Yahoo]	`({Video Completes [Yahoo]} / {Video Views [Yahoo]}) * 100`	%, 2dp
VTR [Yahoo]	`({Video Completes [Yahoo]} / {Impressions [Yahoo]}) * 100`	%, 2dp
CPCV [Yahoo]	`{Spend [Yahoo]} / {Video Completes [Yahoo]}`	£, 2dp

Data Joins

Left Table Field	Right Table Field
`creative_id` (delivery)	`oath_meta_creative.id`