# View: advertising_requests

**View Name:** advertising_requests
**Table Source:** `"INTELLIGENCE"."DBT_PROD"."ORCHARD_NEW_ADVERTISING_REQUESTS"`
**File Path:** `advertising_requests.view.lkml`

## Overview

- **File Size:** 9191 bytes
- **Lines of Code:** 372
- **Dimensions:** 35
- **Measures:** 5
- **Dimension Groups:** 1
- **Filters:** 0

## Description

Label Name

## Comments & Notes

- # dimension: distribution_fee {
- #    description: "Distribution fee"
- #    view_label: "Advertising"

## Dimensions

| Name | Type |
|------|------|
| `label_name` | string |
| `label_manager` | string |
| `label_id` | string |
| `UPC` | string |
| `exceptions` | string |
| `artist_name` | string |
| `release_name` | string |
| `invoice_number` | string |
| `status` | string |
| `requester_name` | string |
| `requester_email` | string |
| `request_reference` | string |
| `strategy_assigned_to_name` | string |
| `priority` | string |
| `PO_number` | string |
| `territory_assignment` | string |
| `payment` | string |
| `admin_fee` | string |
| `distro_fee` | string |
| `support_assigned_to_name` | string |
| `service_tier` | string |
| `service_type` | string |
| `label_tier` | string |
| `ad_plan` | string |
| `total_campaign_number` | string |
| `orhard_label_manager_email` | string |
| `finance_approves` | string |
| `invoice_payment_status` | string |
| `label_manager_country` | string |
| `label_manager_email` | string |
| `manual_financial_trigger` | string |
| `finance_approves_fx` | string |
| `fee_exception` | string |
| `operational_rate` | string |
| `oa_genre` | string |

## Measures

| Name | Type |
|------|------|
| `allocated_budget` | sum |
| `budget` | sum |
| `total_adjusted_costs` | sum |
| `total_label_amount` | sum |
| `total_fees` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `form_submitted` | time |