# View: analytics_aggregated

**View Name:** analytics_aggregated
**Table Source:** `BI.ANALYTICS_AGGREGATED`
**File Path:** `analytics_aggregated.view.lkml`

## Overview

- **File Size:** 188981 bytes
- **Lines of Code:** 6713
- **Dimensions:** 130
- **Measures:** 39
- **Dimension Groups:** 9
- **Filters:** 0

## Comments & Notes

- X# Note: failed to preserve comments during New LookML conversion
- dimension: release_artist_UPC_concat {
- view_label: "Release"

## Dimensions

| Name | Type |
|------|------|
| `aggregate` | string |
| `release_artist_UPC_concat` | string |
| `activity_week_release_week` | yesno |
| `effective_units_calc_cat` | number |
| `image` | string |
| `label_is_sme` | string |
| `Store_Country_Combo_Chad` | string |
| `chadleys_favorite_trans_types` | string |
| `usa_uk_fr_gsa_nordics_row` | string |
| `release_genre_subgenre` | string |
| `release_genre_classical` | string |
| `itunes_spotify_deezer_rhapsody_amazon_google_other` | string |
| `itunes_applemusic_spotify_amazon_youtube_googleplay_other` | string |
| `itunes_spotify_deezer_pandora_amazon_googleplay_youtube_other` | string |
| `activity_quarter` | string |
| `label_client_manager_group` | string |
| `store_name_separating_am` | string |
| `itunes_applemusic_spotify_youtube_other` | string |
| `itunes_spotify_deezer_pandora_amazon_google_youtube_other` | string |
| `units_cat` | number |
| `itunes_spotify_other` | string |
| `label_is_red_essential` | yesno |
| `label_is_red` | yesno |
| `track_name_short` | string |
| `coremarkets` | string |
| `coremarkets_eurocentric` | string |
| `currency_code` | string |
| `sd_or_hd` | string |
| `accounting_days_in_month` | number |
| `accounting_days_missing` | number |
| `accounting_days_present` | number |
| `accounting_max_date_by_group` | string |
| `activity_week_fri_to_thurs` | date |
| `activity_month544_end` | string |
| `activity_month544_name` | string |
| `activity_month544_start` | string |
| `activity_month_name` | string |
| `release_months_since_release` | number |
| `thisrow_last_updated` | string |
| `is_in_label_country` | yesno |
| `music_vs_video` | string |
| `music_vs_video_by_product` | string |
| `music_vs_video_by_tracktype` | string |
| `music_vs_video_by_transac` | string |
| `film_tv_vs_music_by_product` | string |
| `stream_vs_download` | string |
| `store_group` | string |
| `store_id` | number |
| `store_is_in_analytics` | yesno |
| `is_store_itunesusa` | yesno |
| `store_name` | string |
| `store_name_full` | string |
| `store_uses_royaltydollar` | yesno |
| `label_client_manager` | string |
| `label_id` | number |
| `label_is_dthree` | yesno |
| `label_is_ioda` | yesno |
| `label_is_o_and_o` | yesno |
| `label_name` | string |
| `label_owner` | string |
| `label_owner_id` | number |
| `label_priority` | number |
| `label_sc_group` | string |
| `upc` | string |
| `upc_audiogram_change_of_distro` | string |
| `album_vs_track` | string |
| `release_catalog_id` | number |
| `release_front_mid_or_cat` | string |
| `release_front_mid_or_cat_spotify_definition` | string |
| `release_front_mid_or_cat_today` | string |
| `release_genre` | string |
| `release_genre_group` | string |
| `release_genre_group_less` | string |
| `release_id` | number |
| `release_imprint` | string |
| `release_is_compilation` | yesno |
| `release_is_deleted` | yesno |
| `release_is_digital_only` | yesno |
| `release_is_itunes_previewable` | yesno |
| `release_marketing_priority` | string |
| `release_name` | string |
| `release_new_release_type` | string |
| `release_parent_name` | string |
| `release_parent_upc` | number |
| `release_product_type` | string |
| `release_product_videosubtype` | string |
| `release_subgenre` | string |
| `release_version` | string |
| `release_video_channel` | string |
| `release_video_is_vod` | yesno |
| `artist_id` | number |
| `artist_name` | string |
| `transac_type` | string |
| `transac_type_abbr` | string |
| `transac_type_group` | string |
| `transac_type_id` | number |
| `transac_group_for_units` | string |
| `artist_country` | string |
| `country_code` | string |
| `continent` | string |
| `coremarkets_country_code` | string |
| `coremarkets_eurocentric_country_code` | string |
| `country_id` | number |
| `country_name` | string |
| `label_continent` | string |
| `label_country` | string |
| `country_name_or_row` | string |
| `region_group` | string |
| `videoservices_region_group` | string |
| `gpuest_categorically` | number |
| `paidunits_expected_ratio` | number |
| `royaltydollar_categorically` | number |
| `from_errors_table` | yesno |
| `thisrow_max_fact_processeddaytime` | string |
| `thisrow_min_fact_processeddaytime` | string |
| `days_since_release_raw` | number |
| `days_since_release` | number |
| `weeks_since_release` | number |
| `video_store_name` | string |
| `video_transaction_type` | string |
| `image1` | string |
| `image2` | string |
| `image3` | string |
| `image4` | string |
| `image5` | string |
| `image6` | string |
| `image7` | string |
| `image8` | string |
| `image9` | string |
| `image10` | string |

## Measures

| Name | Type |
|------|------|
| `estimated_revenue` | sum |
| `estimated_revenue_lw` | sum |
| `estimated_revenue_tw` | sum |
| `effective_units_calc` | sum |
| `max_activity_date_with_diff_from_today` | string |
| `max_activity_date_with_diff_from_today_unformatted` | string |
| `today` | date |
| `streaming_revenue` | sum |
| `simple_effective_units` | sum |
| `simple_effective_album_units` | sum |
| `lifetime_revenue_usd` | sum |
| `units` | sum |
| `units_7_days_ago` | sum |
| `units_14_days_ago` | sum |
| `units_21_days_ago` | sum |
| `units_28_days_ago` | sum |
| `units_percent_change_14_to_7` | number |
| `units_percent_change_21_to_14` | number |
| `change_score_by_units_14_to_7` | number |
| `change_score_by_units_21_to_14` | number |
| `change_score_by_units_score_to_score_21_to_14` | number |
| `change_score_by_units_score_to_score_21_to_14__new` | number |
| `units_streaming` | sum |
| `number_of_rows` | count |
| `min_activity_date` | string |
| `count_distinct_stores` | count_distinct |
| `count_distinct_label_owners` | count_distinct |
| `count_distinct_labels` | count_distinct |
| `count_distinct_releases` | count_distinct |
| `count_distinct_releases_by_catalogids` | count_distinct |
| `count_distinct_artists` | count_distinct |
| `count_distinct_transac_types` | count_distinct |
| `count_distinct_countrys` | count_distinct |
| `freeunits` | sum |
| `gest` | sum |
| `gest_net_of_sc` | sum |
| `gpuest` | sum |
| `paidunits` | sum |
| `royaltydollar` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `activity_date` | time |
| `activity_month544` | time |
| `release_date_added` | time |
| `release_date` | time |
| `release_sale_physical_date` | time |
| `release_sale_preorder_date` | time |
| `release_sale_start_date` | time |
| `release_theatrical_release_date` | time |
| `release_vod_start_date` | time |