Yahoo DSP Private Preview
Yahoo DSP is a management platform that gathers marketing data. Read the Yahoo DSP documentation to learn more about the platform.
Features
| 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. |
| History mode | check | _HISTORY suffix |
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | |
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Setup guide
Follow our step-by-step Yahoo DSP setup guide to connect Yahoo DSP with your destination using Fivetran connectors.
Sync overview
Rollback sync
A rollback sync is a sync that automatically runs once a day. Rollback syncs capture the changes that happen outside the incremental sync time frame.
Fivetran does not automatically capture the rollback window size. The rollback window depends on your reports' interval:
- Cumulative - 30 days
- Day - 30 days
- Month - 60 days
- Week - 35 days
- Hour - 3 days
Schema information
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 information
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 columns
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 metadata
Beacon Instrumentation Code
Since beacons don't support updates, we only sync instrumentation codes once for each beacon.