> ## 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.

# Pandora

> Learn how to set up Pandora streaming audio integration with Rockerbox

## Overview

The tracking and required reporting for Pandora will differ depending on the ad server Pandora is using for your campaigns (Audiomatic/Audioserve or Google Ad Manager).

## Setup Process

1. Confirm with Pandora which ad server(s) they are using for your ads
2. Contact your Rockerbox representative confirming the ad server. Rockerbox will provide email endpoint details based on the ad server
3. Append click tracking parameters and apply the impression pixel to all active ads (see below)
4. Contact [support@rockerbox.com](mailto:support@rockerbox.com) with the launch date and the [tier structure](https://help.rockerbox.com/article/obce43haen-1-hierarchy-mappings) you'd like applied
5. The day after launch, confirm tracking is applied on the [Advertising Platforms](https://app.rockerbox.com/v3/data/marketing/advertising_platforms/main) page

These parameter values use macros and do not need to be manually replaced. Their values will be dynamically filled by the platform when the ad is served.

## Audiomatic / Audioserve

### Example Parameter String

```text wrap theme={null}
pd_campaignid={orderid}&pd_lineitemid={campaignid}&pd_creativeid={bannerid}&pd_type=streaming
```

<Accordion title="Parameter Details">
  | Parameter       | Macro          | Description                   |
  | --------------- | -------------- | ----------------------------- |
  | `pd_campaignid` | `{orderid}`    | Order ID (required)           |
  | `pd_lineitemid` | `{campaignid}` | Campaign ID (required)        |
  | `pd_creativeid` | `{bannerid}`   | Banner/Creative ID (required) |
  | `pd_type`       | `streaming`    | Campaign type (required)      |
</Accordion>

### Impression Pixel

Contact [support@rockerbox.com](mailto:support@rockerbox.com) for your account-specific `[SOURCE]` value (your company's pixel\_source\_name).

```text wrap theme={null}
https://metrics.getrockerbox.com/track/v5?source=[SOURCE]&tier_one=pandora-streaming&tier_two={orderid}&tier_three={campaignid}&tier_four={bannerid}&auction_id={cb}
```

<Accordion title="Impression Pixel Details">
  | Parameter    | Value               | Description                                                |
  | ------------ | ------------------- | ---------------------------------------------------------- |
  | `source`     | `[SOURCE]`          | Your company's pixel\_source\_name (provided by Rockerbox) |
  | `tier_one`   | `pandora-streaming` | Vendor and campaign type identifier (hardcoded)            |
  | `tier_two`   | `{orderid}`         | Order ID                                                   |
  | `tier_three` | `{campaignid}`      | Campaign ID                                                |
  | `tier_four`  | `{bannerid}`        | Banner/Creative ID                                         |
  | `auction_id` | `{cb}`              | Cache buster                                               |
</Accordion>

## Google Ad Manager (GAM)

### Example Parameter String

```text wrap theme={null}
gam_campaignid=%ebuy!&gam_adgroupid=%eaid!&gam_creativeid=%ecid!&gam_type=audio
```

<Accordion title="Parameter Details">
  | Parameter        | Macro    | Description              |
  | ---------------- | -------- | ------------------------ |
  | `gam_campaignid` | `%ebuy!` | Campaign ID (required)   |
  | `gam_adgroupid`  | `%eaid!` | Ad group ID (required)   |
  | `gam_creativeid` | `%ecid!` | Creative ID (required)   |
  | `gam_type`       | `audio`  | Campaign type (required) |
</Accordion>

### Impression Pixel

```text wrap theme={null}
https://metrics.getrockerbox.com/track/v5?source=[SOURCE]&tier_one=pandora-audio&tier_two=%ebuy!&tier_three=%eaid!&tier_four=%ecid!&auction_id=%n
```

<Accordion title="Impression Pixel Details">
  | Parameter    | Value           | Description                                                |
  | ------------ | --------------- | ---------------------------------------------------------- |
  | `source`     | `[SOURCE]`      | Your company's pixel\_source\_name (provided by Rockerbox) |
  | `tier_one`   | `pandora-audio` | Vendor and campaign type identifier (hardcoded)            |
  | `tier_two`   | `%ebuy!`        | Campaign ID                                                |
  | `tier_three` | `%eaid!`        | Ad group ID                                                |
  | `tier_four`  | `%ecid!`        | Creative ID                                                |
  | `auction_id` | `%n`            | Cache buster                                               |
</Accordion>

## Batch Spend

Pandora sends manual reporting from their platform to Rockerbox email endpoints. There are separate email endpoints for each ad server. If Pandora is using both, they will send 2 reports each week (one to each endpoint).

Contact [support@rockerbox.com](mailto:support@rockerbox.com) for endpoint details.

* Files should be sent on a **weekly** cadence
* Each file should contain the previous 7 days of spend data
* Row 1 must be the column headers
* The "totals" row must be deleted before sending

### Required Columns - Audiomatic / Audioserve

(must match exactly, including capitalization and spacing)

```
Time
Order ID
Order
Campaign ID
Campaign
Ad ID
Ad Total Spend (USD)
```

### Required Columns - Google Ad Manager (GAM)

(must match exactly, including capitalization and spacing)

```
Date
Order
Line item
Creative
Order ID
Line item ID
Creative ID
Ad server CPM and CPC revenue ($)
```

## Verification

After setup:

1. Confirm tracking is applied on the [Advertising Platforms](https://app.rockerbox.com/v3/data/marketing/advertising_platforms/main) page
2. Verify spend data appears in Rockerbox dashboard
3. Contact [support@rockerbox.com](mailto:support@rockerbox.com) for QA assistance