# View: advertising_campaigns

**View Name:** advertising_campaigns
**Table Source:** `"INTELLIGENCE"."DBT_PROD"."ORCHARD_NEW_ADVERTISING_CAMPAIGNS"`
**File Path:** `advertising_campaigns.view.lkml`

## Overview

- **File Size:** 10670 bytes
- **Lines of Code:** 428
- **Dimensions:** 30
- **Measures:** 5
- **Dimension Groups:** 2
- **Filters:** 0

## Description

Label Name

## Comments & Notes

- #  dimension: invoice_number {
- #    description: "Invoice Number"
- #    view_label: "Advertising"

## Dimensions

| Name | Type |
|------|------|
| `label_name` | string |
| `label_id` | string |
| `UPC` | string |
| `territory_assignment` | string |
| `operational_rate` | string |
| `distro_fee` | string |
| `activity_invoices` | string |
| `quarter` | string |
| `artist_name` | string |
| `release_name` | string |
| `request_id` | string |
| `request_status` | string |
| `form_submitted` | string |
| `service_type` | string |
| `status` | string |
| `label_tier` | string |
| `assigned_to_name` | string |
| `support_assigned_to_name` | string |
| `media_buy_assigned_to_name` | string |
| `review_assigned_to_name` | string |
| `report_assigned_to_name` | string |
| `form_version` | string |
| `range_months` | string |
| `link_to_ad_plan` | string |
| `cta_link` | string |
| `campaign_objective` | string |
| `campaign_phase` | string |
| `platform` | string |
| `campaign_reference` | string |
| `request` | string |

## Measures

| Name | Type |
|------|------|
| `allocated_budget` | sum |
| `total_fees` | sum |
| `total_label_amount` | sum |
| `platform_budget` | sum |
| `platform_balance` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `start_date` | time |
| `end_date` | time |