Yahoo DSP Private Previewlink
Updated August 16, 2023
Yahoo DSP is a management platform that gathers marketing data. Read the Yahoo DSP documentation to learn more about the platform.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | ACCOUNT_GROUP, AD_HISTORY, AD_SCHEDULE_HISTORY, AD_COUNTDOWN_HISTORY, ADVERTISER_HISTORY, BEACON_HISTORY, BEACON_CONDITION_HISTORY, BUDGET_SCHEDULE_HISTORY, CAMPAIGN_HISTORY, CONTEXTUAL_HISTORY, CREATIVE_HISTORY, EXCHANGE, LINE, ORDER_FREQUENCY_CAP_HISTORY, PACKAGE, PIXEL, SEAT, SITE_LIST_HISTORY, TARGETING_CONTEXTUALS_HISTORY and USER_GROUP tables. |
| Custom data | ||
| Data blocking | check | Column level |
| Column hashing | check | |
| Re-sync | check | Connector level |
| History | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | Reporting tables |
| Fivetran data models | ||
| Private networking |
Setup guidelink
Follow our step-by-step Yahoo DSP setup guide to connect Yahoo DSP with your destination using Fivetran connectors.
Schema informationlink
Schema for General Tables on the Traffic API:
To zoom, open ERD in new window.
Schema for Audience Tables on the Traffic API:
To zoom, open ERD in new window.
Schema for Targeting Tables on the Traffic API:
To zoom, open ERD in new window.
Schema for Reporting Tables:
To zoom, open ERD in new window.
Report schema informationlink
We provide two types of reports:
- Prebuilt Report
- Custom Report
To configure any report you must specify report name, and then select report currency and date interval.
To get a Custom report, you must select dimensions and metrics.
Prebuilt reports have predefined sets of dimensions and metrics, you only need to select type of prebuilt report.
The destination table contains the seat, advertiser, and date columns. The exact name of date column is specific for each interval type.
Syncing empty tables and columnslink
The Yahoo DSP connector doesn't support the creation of empty tables and columns in your destination.
We create a table in the destination only if we can retrieve the relevant data from the source. If Yahoo DSP doesn’t return data for the source table, we don’t create the table in your destination.
Syncing metadatalink
Beacon Instrumentation Codelink
Since beacons don't support updates, we only sync instrumentation codes once for each beacon.