> ## Documentation Index
> Fetch the complete documentation index at: https://data-foundation.rockerbox.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Yahoo DSP

> Learn how to set up Yahoo DSP integration with Rockerbox for display and OTT tracking

## Setup Process

1. Contact [support@rockerbox.com](mailto:support@rockerbox.com) to enable the integration. Let the team know the launch date and the [tier structure](https://help.rockerbox.com/article/obce43haen-1-hierarchy-mappings) you'd like applied
2. Append click-through URL parameters to your landing page URLs and apply the impression pixel to all active ads using the instructions below. Parameters use macros and do not need to be manually replaced
3. Set up automated spend reporting from Yahoo to Rockerbox (see Batch Spend section below). This should be completed before launch
4. Allow at least one full day of data collection after launch, then let Rockerbox know you have launched so they can QA your URL and impression pixels

## DSP (Most Common)

### URL Tracking Parameters

**Example Parameter String:**

```text wrap theme={null}
y_campaignid=${ORDERID}&y_adgroupid=${PLACEMENTID}&y_creativeid=${LIBRARYADID}&y_auctionid=${REQUESTID}&y_referrer=${PAGE_URL_ENC}&y_type=display
```

<Accordion title="Parameter Details">
  | Parameter      | Macro             | Description                   |
  | -------------- | ----------------- | ----------------------------- |
  | `y_campaignid` | `${ORDERID}`      | Order/Campaign ID (required)  |
  | `y_adgroupid`  | `${PLACEMENTID}`  | Placement ID (required)       |
  | `y_creativeid` | `${LIBRARYADID}`  | Library Ad ID (required)      |
  | `y_auctionid`  | `${REQUESTID}`    | Request/Auction ID (required) |
  | `y_referrer`   | `${PAGE_URL_ENC}` | Page URL, encoded (required)  |
</Accordion>

### Impression Pixel

```text wrap theme={null}
https://metrics.getrockerbox.com/track/v5?source=[SOURCE]&tier_one=yahoo-ott&tier_two=${ORDERID}&tier_three=${PLACEMENTID}&tier_four=${LIBRARYADID}&auction_id=${REQUESTID}&referrer=${PAGE_URL_ENC}
```

**Note:** `[SOURCE]` is a hardcoded value that must be obtained from Rockerbox. It's your company's [Account ID](https://app.rockerbox.com/v3/settings/account).

<Accordion title="Parameter Details">
  | Parameter    | Macro             | Description                       |
  | ------------ | ----------------- | --------------------------------- |
  | `tier_one`   | `yahoo-ott`       | Platform identifier (hardcoded)   |
  | `tier_two`   | `${ORDERID}`      | Campaign/Order ID (required)      |
  | `tier_three` | `${PLACEMENTID}`  | Placement ID (required)           |
  | `tier_four`  | `${LIBRARYADID}`  | Creative/Library Ad ID (required) |
  | `auction_id` | `${REQUESTID}`    | Auction ID (required)             |
  | `referrer`   | `${PAGE_URL_ENC}` | Page URL (required)               |
</Accordion>

## Reserved Ad Platform (Takeover Campaigns)

For Takeover campaigns run as managed service through Yahoo. Send the below pixels to your Yahoo Account Manager for placement.

### URL Tracking Parameters

**Example Parameter String:**

```text wrap theme={null}
y_campaignid=_ADMCID_&y_adgroupid=_ADADID_&y_creativeid=_ADALIAS_&y_auctionid=_ADTIME_&y_referrer=_PAGEURL_&y_type=display
```

<Accordion title="Parameter Details">
  | Parameter      | Macro       | Description            |
  | -------------- | ----------- | ---------------------- |
  | `y_campaignid` | `_ADMCID_`  | Campaign ID (required) |
  | `y_adgroupid`  | `_ADADID_`  | Ad ID (required)       |
  | `y_creativeid` | `_ADALIAS_` | Ad Alias (required)    |
  | `y_auctionid`  | `_ADTIME_`  | Timestamp (required)   |
  | `y_referrer`   | `_PAGEURL_` | Page URL (required)    |
</Accordion>

### Impression Pixel

```text wrap theme={null}
https://metrics.getrockerbox.com/track/v5?source=[SOURCE]&tier_one=yahoo-ott&tier_two=_ADMCID_&tier_three=_ADADID_&tier_four=_ADALIAS_&auction_id=_ADTIME_&referrer=_PAGEURL_
```

**Note:** `[SOURCE]` is a hardcoded value that must be obtained from Rockerbox. It's your company's [Account ID](https://app.rockerbox.com/v3/settings/account).

## Batch Spend

Set up automated spend reporting using Yahoo DSP's Report Builder:

1. In the Yahoo DSP platform, go to the **Report Builder** tool
2. Add the dimensions and metrics listed below to your report
3. For the date range, select the previous day
4. Click **Schedule Report**
5. Contact [support@rockerbox.com](mailto:support@rockerbox.com) to obtain the Rockerbox endpoint email address and add it as the email recipient
6. Set Frequency to **Daily** with an indefinite end date (or far in the future)
7. Format should be **.xlsx**

**Required Columns** (must match exactly, including capitalization and spacing):

```
Day
Campaign ID
Campaign Name
Line ID
Line Name
Creative ID
Creative Name
Advertiser Spending
Ad ID
Ad Name
```

## Verification

After setup:

1. Verify impression pixels are firing correctly
2. Validate click tracking parameters are populating
3. Check spend data appears in Rockerbox dashboard after at least one full day
4. Contact [support@rockerbox.com](mailto:support@rockerbox.com) for QA assistance