# View: facts_prod_fact_ad_spend

**View Name:** facts_prod_fact_ad_spend
**Table Source:** `Derived Table (Custom SQL)`
**File Path:** `facts_prod_fact_ad_spend.view.lkml`

## Overview

- **File Size:** 2690 bytes
- **Lines of Code:** 131
- **Dimensions:** 13
- **Measures:** 2
- **Dimension Groups:** 1
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `featurefmcampaignid` | string |
| `featurefmcampaignname` | string |
| `ingestion_datetime` | date_time |
| `platformid` | number |
| `platformaccountid` | string |
| `platformcampaignid` | string |
| `labelid` | number |
| `artistid` | number |
| `subaccountid` | number |
| `upc` | number |
| `trackid` | number |
| `stagingrawid` | number |
| `last_updated` | number |

## Measures

| Name | Type |
|------|------|
| `boost_amount` | sum |
| `budget_amount` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `accounting` | time |

## Derived Table

```sql
sql:
      SELECT * FROM (
        SELECT *,( ROW_NUMBER() OVER (
        partition by
        FEATUREFMCAMPAIGNID,
        ACCOUNTINGMONTH,
        ACCOUNTINGYEAR,
        ACCOUNTINGDAY
        order by last_updated desc)) as row_num
      FROM "FACTS"."PROD"."FACT_AD_SPEND")
      WHERE row_num = 1;;
```