# View: orchard_mgmt_kpis

**View Name:** orchard_mgmt_kpis
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Releases, Dbt_Prod.Dt_Access_Filter_1091, Intelligence.Dbt_Prod, Prod.Dim_Country, Prod.Dim_Period + 3 more`
**File Path:** `orchard_mgmt_kpis.view.lkml`

## Overview

- **File Size:** 32333 bytes
- **Lines of Code:** 70
- **Dimensions:** 4
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `facts_prod_fact_sales_catalog_buckets` | string |
| `activity_period_activity_date` | string |
| `label_categ` | string |
| `facts_prod_fact_sales_gross_revenue_usd` | number |

## Measures

| Name | Type |
|------|------|
| `count` | count |

## Derived Table

```sql
sql: SELECT
      (CASE
                  WHEN (DATEDIFF(month, (TO_CHAR(TO_DATE(orch_app_ar_releases.release_date ), 'YYYY-MM-DD')), (TO_CHAR(TO_DATE(DATE_FROM_PARTS(activity_period.year, activity_period.month, '01')  ), 'YYYY-MM-DD'))) >= 18) AND (DATEDIFF(month, (TO_CHAR(TO_DATE(orch_app_ar_releases.ingestion_completed ), 'YYYY-MM-DD')), (TO_CHAR(TO_DATE(DATE_FROM_PARTS(activity_period.year, activity_period.month, '01')  ), 'YYYY-MM-DD'))) < 18)  THEN 'Newly Ingested Catalog'
                  WHEN DATEDIFF(month, (TO_CHAR(TO_DATE(orch_app_ar_releases.release_date ), 'YYYY-MM-DD')), (TO_CHAR(TO_DATE(DATE_FROM_PARTS(activity_period.year, activity_period.month, '01')  ), 'YYYY-MM-DD'))) < 18 THEN 'New Releases'
                  WHEN (DATEDIFF(month, (TO_CHAR(TO_DATE(orch_app_ar_releases.release_date ), 'YYYY-MM-DD')), (TO_CHAR(TO_DATE(DATE_FROM_PARTS(activity_period.year, activity_period.month, '01')  ), 'YYYY-MM-DD'))) BETWEEN 18 AND 47) AND (DATEDIFF(month, (TO_CHAR(TO_DATE(orch_app_ar_releases.ingestion_completed ), 'YYYY-MM-DD')), (TO_CHAR(TO_DATE(DATE_FROM_PARTS(activity_period.year, activity_period.month, '01')  ), 'YYYY-MM-DD'))) >= 18) THEN 'Catalog'
                  WHEN (DATEDIFF(month, (TO_CHAR(TO_DATE(orch_app_ar_releases.release_date ), 'YYYY-MM-DD')), (TO_CHAR(TO_DATE(DATE_FROM_PARTS(activity_period.year, activity_period.month, '01')  ), 'YYYY-MM-DD'))) >= 48) AND (DATEDIFF(month, (TO_CHAR(TO_DATE(orch_app_ar_releases.ingestion_completed ), 'YYYY-MM-DD')), (TO_CHAR(TO_DATE(DATE_FROM_PARTS(activity_period.year, activity_period.month, '01')  ), 'YYYY-MM-DD'))) >= 18) THEN 'Deep Catalog'
                  WHEN (TO_CHAR(TO_DATE(orch_app_ar_releases.release_date ), 'YYYY-MM-DD')) IS NULL THEN 'Catalog'
                  WHEN (TO_CHAR(TO_DATE(orch_app_ar_releases.ingestion_completed ), 'YYYY-MM-DD')) IS NULL AND (DATEDIFF(month, (TO_CHAR(TO_DATE(orch_app_ar_releases.release_date ), 'YYYY-MM-DD')), (TO_CHAR(TO_DATE(DATE_FROM_PARTS(activity_period.year, activity_period.month, '01')  ), 'YYYY-MM-DD'))) >= 48) THEN 'Deep Catalog'
                  WHEN (TO_CHAR(TO_DATE(orch_app_ar_releases.ingestion_completed ), 'YYYY-MM-DD')) IS NULL AND (DATEDIFF(month, (TO_CHAR(TO_DATE(orch_app_ar_releases.release_date ), 'YYYY-MM-DD')), (TO_CHAR(TO_DATE(DATE_FROM_PARTS(activity_period.year, activity_period.month, '01')  ), 'YYYY-MM-DD'))) BETWEEN 18 AND 47) THEN 'Catalog'
                  WHEN (TO_CHAR(TO_DATE(orch_app_ar_releases.ingestion_completed ), 'YYYY-MM-DD')) IS NULL AND (DATEDIFF(month, (TO_CHAR(TO_DATE(orch_app_ar_releases.release_date ), 'YYYY-MM-DD')), (TO_CHAR(TO_DATE(DATE_FROM_PARTS(activity_period.year, activity_period.month, '01')  ), 'YYYY-MM-DD'))) < 18) THEN 'New Releases'
                END) AS "facts_prod_fact_sales.catalog_buckets",
                
              (TO_CHAR(TO_DATE(DATE_FROM_PARTS(activity_period.year, activity_period.month, '01')  ), 'YYYY-MM-DD')) AS "activity_period.activity_date",
              
          (CASE WHEN facts_prod_fact_sales.labelid in (21786, 11872, 25464, 18655, 17291, 19510, 9005, 19734, 25622, 24823, 11494, 22290, 22431, 24976, 15362, 22061, 15045, 17103, 25233, 21069, 9935, 21902, 16970, 15065, 20530, 17005, 10610, 24648, 25203, 16714, 19857, 16769, 9429, 19209, 16695, 11637, 10989, 24099, 24981, 22867, 10867, 24839, 23681, 9159, 12059, 22295, 25643, 11249, 15236, 8568, 25486, 20308, 25501, 20107, 21506, 19098, 25381, 26079, 20990, 25205, 22814, 14110, 26760, 22010, 26497, 10988, 20873, 15982, 25385, 21318, 17142, 25644, 9426, 20232, 7549, 16320, 15979, 19576, 25472, 7514, 26307, 8504, 19559, 24965, 15126, 17919, 25444, 15919, 22547, 24581, 9287, 22414, 24499, 21929, 17690, 25973, 17011, 18946, 25426, 16503, 21309, 26799, 25465, 21217, 22564, 14252, 22123, 16976, 11010, 6801, 25172, 22609, 24847, 24551, 14676, 20790, 24493, 23064, 23402, 10987, 21625, 19211, 25434, 16096, 21583, 11055, 22569, 11533, 7982, 14030, 16381, 28336, 25149, 24503, 23812, 10893, 15796, 15860, 26100, 17210, 19775, 26539, 19860, 25602, 23867, 14007, 12639, 25299, 19936, 16344, 15798, 15873, 15925, 26836, 10627, 14250, 26182, 25431, 17045, 22879, 25836, 26687, 14358, 22592, 19212, 18041, 21042, 25388, 18513, 12708, 21772, 21876, 17044, 23104, 23413, 16634, 17482, 21539, 25850, 25397, 26698, 21445, 22050, 24593, 12615, 25334, 22327, 15390, 15375, 26726, 18011, 9079, 17436, 15759, 7554, 28316, 26292, 9157, 8564, 26007, 15872, 18802, 23052, 25348, 20065, 26584, 7548, 26682, 17950, 8337, 23689, 16956, 25635, 14267, 16480, 17165, 21420, 26423, 19896, 6800, 7841, 15760, 15727, 25496, 21669, 15082, 11938, 21721, 22822, 19320, 7807, 26513, 26512, 26257, 26427, 15681, 25540, 26218, 25499, 21206, 26619, 25962, 22023, 8859, 18662, 23170, 22871, 25409, 23253, 12667, 26636, 24520, 19659, 16838, 23440, 16974, 24042, 17051, 9427, 25960, 24557, 26050, 26691, 16218, 25835, 25196, 26686, 17285, 11836, 25427, 17711, 25020, 25642, 7555, 25830, 7506, 26037, 26001, 10608, 26020, 24939, 23519, 23400, 26075, 22870, 26275, 26039, 16864, 19979, 15951, 21453, 26853, 20870, 26673, 10882, 26295, 15678, 15746, 25979, 22779, 26375, 18717, 22590, 16761, 3987, 15060, 10614, 24845, 16635, 15774, 15250, 25430, 16689, 15984, 15808, 18707, 6703, 25452, 25466, 26186, 22553, 25180, 16806, 25838, 18395, 25610, 25050, 26590, 24876, 24904, 14703, 19455, 25019, 15728, 24878, 23340, 21916, 580, 24918, 24796, 15890, 21586, 19871, 24544, 26612, 21794, 26511, 26722, 26043, 26063, 15682, 21605, 8096, 7794, 26461, 25071, 24819, 17650, 25513, 26813, 23692, 9537, 22524, 14119, 17150, 17983, 23507, 23447, 17272, 25968, 25429, 9164, 25293, 26730, 26731, 15960, 26740, 22215, 26692, 19851, 26669, 16818, 15410, 15807, 28306, 19087, 25389, 25467, 24844, 25583, 12060, 26533, 24989, 17125, 11859, 26679, 8565, 26857, 26271, 26374, 25001, 24250, 17932, 17079, 7417, 18013, 21072, 21849, 19817, 19061, 23431, 24810, 22095, 3378, 16888, 16407, 22605, 26624, 19697, 26645, 28249, 28302, 24809, 11034, 17283, 15280, 9547, 26253, 24924, 16184, 22145, 25111, 24938, 15935, 9318, 17151, 26074, 9533, 21220, 12155, 17610, 23372, 25822, 25025, 798, 26635, 25100, 25428, 5752, 24988, 24430, 26791, 11066, 25093, 11845, 25143, 26000, 11570, 24997, 16416, 25141, 21787, 17390, 26509, 15383, 25832, 22878, 22601, 12502, 15780, 17435, 26193, 26875, 26527, 14022, 25280, 22820, 24896, 25295, 25647, 18273, 8194, 21330, 7893, 6158, 11353, 7119, 26595, 6917, 25269, 22868, 15701, 15229, 17034, 12246, 8864, 25982, 13623, 26613, 15457, 17032, 17053, 22607, 19691, 16415, 71, 8609, 21295, 16889, 19835, 98, 20136, 12313, 8790, 3650, 17276, 11092, 18015, 14411, 3046, 14970, 3621, 15237, 9428, 16398, 15243, 17017, 5716, 15949, 20099, 18016, 24014, 4261, 22602, 11571, 9725, 21495, 23997, 11453, 7960, 8569, 9495, 14213, 22245, 25479, 1967, 20277, 8887, 8718, 8988, 1102, 20100, 4114, 19033, 1700, 22723, 9083, 2562, 8567, 12435, 2826, 10841, 16549, 21048, 26510, 28501, 28504, 26359, 28502, 26251, 26246, 28509, 28505, 26358, 26235, 26233, 26247, 28497, 26343, 28507, 28506, 26243, 26244, 26356, 28499, 26282, 26351, 26234, 26666, 26746, 26354, 26355, 26361, 26344, 26363, 26353, 26245, 26249, 26365, 26242, 26216, 26448, 26360, 26364, 28624, 26515, 26758, 28557, 26352, 26806, 28631, 26575, 26250, 26667, 26248, 26601, 26279, 28444, 28492, 26080, 26357, 28809, 28569, 25998, 28372, 28440, 28604, 28610, 28627, 28639, 28645, 28641, 28457, 28649, 28655, 28368, 28661, 28665, 28664, 28676, 28682, 28683, 28696, 28694, 28705, 28706, 28714, 28715, 28720, 28721, 28736, 28710, 28756, 28751, 28750, 28762, 28779, 28777, 28798, 28812, 28806, 28795, 28788, 28761, 28790, 28817, 28789, 28825, 28838, 28853, 28864, 28859, 28863, 28293, 28840, 28889, 28904, 28891, 28886, 28888, 28919, 28906, 28921, 30491, 28914, 30469, 30477, 30486, 28892, 30502, 30487, 30512, 30523, 30490, 30551, 30553, 30529, 30538, 128, 294, 295, 350, 417, 548, 616, 757, 1353, 1543, 1626, 1812, 1838, 2180, 2230, 2559, 2560, 2561, 2587, 3084, 3197, 3589, 3616, 3688, 3720, 3729, 3856, 3913, 4101, 4123, 4188, 5336, 5758, 5981, 6089, 6165, 6262, 6590, 6619, 6694, 6871, 7012, 7325, 7358, 7946, 8208, 8250, 8300, 8341, 8418, 8435, 8479, 8550, 8566, 8777, 8818, 8860, 8984, 9042, 9070, 9338, 9391, 9474, 9540, 11509, 11643, 11717, 11837, 11858, 11941, 12005, 12620, 12625, 14039, 14132, 14134, 14405, 14496, 14506, 14568, 14884, 14953, 15049, 15054, 15292, 15386, 15482, 15624, 15716, 15802, 15964, 15985, 16119, 16120, 16132, 16152, 16314, 16525, 16602, 16626, 16647, 16789, 16952, 17078, 17271, 17768, 17803, 17931, 18489, 18530, 18853, 19015, 19205, 19322, 19488, 19504, 19701, 19726, 19987, 20187, 20371, 20799, 21027, 21032, 21038, 21078, 21290, 21392, 21609, 21645, 21665, 22331, 22405, 22545, 23019, 23269, 23731, 23908, 23978, 23995, 24139, 24143, 24207, 24215, 24527, 24747, 24754, 25314, 25393, 25531, 25617, 26113, 26130, 26180, 26362, 26491, 26508, 26678, 26685, 26713, 26721, 26849, 26927, 27102, 27162, 28233, 28234, 28270, 28295, 28305, 28332, 28358, 28359, 28369, 28375, 28403, 28446, 28453, 28462, 28477, 28481, 28498, 28539, 28552, 28559, 28565, 28568, 28606, 28763, 28811, 28843, 28862, 28876, 28897, 30484, 30503, 30556, 30558, 30562, 30564, 30644, 31023, 31828, 32048, 32092, 32098, 32124, 32151, 32155, 32298, 32194, 32212, 32210, 32218, 32237, 32225, 32235, 32247, 32255, 32256, 32250, 32262, 32252, 32273, 32289, 32284, 32536, 32548, 32544, 32546, 32564, 32561, 32554, 32556, 32557, 32641, 32647, 32646, 32660, 6827, 8526, 13265, 16168, 16383, 17029, 19221, 19428, 21796, 25162, 25372, 25981, 26034, 26192, 26269, 26484, 26633, 28361, 28362, 28663, 28719, 30233, 30541, 30563, 30566, 30589, 32105, 32138, 32169, 32191, 32192, 32258, 32285, 32334, 32335, 32340, 32352, 32361, 32362, 32364, 32373, 32381, 32398, 32406, 32407, 32412, 32447, 32469, 32472, 32513, 32533, 32550, 32570, 32574, 32576, 32579, 32581, 32599, 32606, 32608, 32676, 32677, 32678, 32690, 32692, 32701, 32718, 32723, 32737, 32745, 32756, 32762, 32773, 32797, 32799, 32812, 32821, 32825, 32826, 32834, 32836, 32844, 32858, 32867, 32869, 32871, 32892, 32897, 32913, 32929, 32936, 32975, 32986, 32997, 21739, 15961, 18854, 19381, 26473, 21200, 21589, 16751, 6671, 20986, 18406, 20669, 20533, 11920, 26123, 32516, 33636, 33839, 32422, 33208, 33921, 33089, 33645, 33772, 33555, 33171, 32136, 33838, 33675, 33860, 33879, 33287, 33690, 33478, 33421, 33623, 33937, 34036, 33941, 33742, 33532, 33554, 33257, 33835, 33665, 33293, 33588, 33575, 33387, 33976, 33234, 28364, 26579, 33084, 33656, 33975, 33940, 33808, 33283, 32849, 33837, 33833, 32983, 32840, 33127, 33360, 33075, 33947, 33943, 33481, 33094, 33248, 33781, 33870, 33792, 33753, 33858, 34001, 33497, 33908, 32332, 33778, 33994, 32698, 33713, 33076, 33670, 33715, 33934, 33101, 33773, 33591, 33740, 33206, 34009, 34028, 33746, 32444, 33913, 33684, 33157, 33946, 33691, 33618, 33205, 33619, 32841, 33743, 33586, 33780, 34047, 34043, 33467, 33973, 33679, 33783, 34060, 34056, 34027, 26462, 34020, 24579, 33339, 33589, 2401, 33744, 33521, 33883, 34122, 34024, 34042, 34150, 34121, 34089, 34093, 34183, 33933, 34141, 34147, 34149, 34130, 33183, 34167, 34161, 34100, 28671, 33666, 33995, 34156, 34216, 34215, 34198, 33960, 34087, 33950, 34197, 34221, 33959, 33948, 34224, 34240, 34286, 34627, 34281, 34184, 34282, 34617, 34245, 34048, 30594, 34091, 34164, 34254, 34616, 34641, 34264, 34279, 34615, 34623, 34860, 34853, 34868, 34642, 34858, 34892, 34611, 33784, 34838, 34876, 34267, 34910, 34917, 34945, 34896, 13265, 34860, 34838, 32794, 26799, 25381, 28565, 17044, 33380, 33986, 34213, 35005, 34991, 34791, 34916, 34983, 34907, 35025, 34686, 34117, 35028, 34800, 34879, 34954, 34992, 34955, 34010, 34880, 34995, 35062, 35011, 35085, 35027, 34998, 35074, 35056, 35012, 32679, 34925, 34259, 34989, 34957, 35013, 34987, 35083, 35104, 33151, 34980, 35125, 35082, 35140, 35102, 35139, 35164, 35168, 35106, 35127, 35092, 35113, 35179, 35145, 35130, 35143, 33672, 33255, 35153, 35248, 34974, 35249, 35233, 34647, 35215, 35205, 34840, 34283, 35026, 35277, 35225, 35310, 35330, 35276, 35346, 35274, 35268, 35337, 35311, 35161, 35075, 35177, 35329, 35211, 35264, 35354, 35350, 35163, 35231, 29158, 33733, 33820, 35280, 35386, 35422, 35403, 35349, 35313, 35377, 35390, 35407, 34312, 35426, 35333, 35388, 35400, 34640, 34973, 35458, 35162, 35451, 35474, 35459, 35492, 35453, 35457, 35452, 35272, 35187, 35387, 35427, 35502, 35519, 35527, 35515, 35450, 35529, 35498, 35497, 35531, 35530, 35361, 35561, 35588, 33621, 34650, 35419, 35534, 35552, 35666, 35602, 35575, 35417, 35617, 35619, 35622, 35607, 35495, 35584, 35571, 35600, 35672, 35564, 25581, 27582, 22567, 33312, 32973, 33069, 32964, 26095, 33172, 33196, 33061, 32959, 33668, 34046, 32592, 33425, 33531, 35293, 35554, 33294, 35137, 33286, 34016, 34013, 33680, 33210, 33897, 32782, 34195, 26525, 32954, 32123, 26222, 32976, 32955, 32609, 33556, 21349, 26814, 11223, 32129, 15417, 35014, 26657, 22567, 15174, 33678, 16957, 32518, 17132, 12242, 26022, 22566, 25082, 33662, 32851, 33965, 10883, 26810, 33682, 10888, 16150, 25837, 32371, 17595, 30591, 20838, 26199, 16151, 10900, 19287, 32973, 24807, 14835, 33830, 33777, 33868, 26095, 33431, 32501, 23688, 15354, 23540, 34304, 9545, 26003, 33640, 28555, 21678, 16571, 22731, 33275, 16085, 15940, 15384, 32754, 9464, 15168, 14133, 32998, 22568, 12574, 33910, 32282, 15293, 15950, 11395, 30592, 33797, 32695, 16530, 15499, 16538, 26220, 26086, 13973, 13662, 26382, 34894, 10887, 26712, 32732, 32552, 32419, 17181, 33058, 26277, 33178, 32743, 23464, 32171, 12109, 20603, 17223, 23159, 16143, 33699, 33263, 26724, 25551, 22482, 10843, 33607, 23648, 22621, 32964, 13663, 33356, 11394, 22613, 10885, 34003, 26630, 16090, 17388, 15948, 33502, 32182, 14092, 32241, 11579, 11923, 15902, 18063, 25581, 25231, 17062, 22563, 33463, 30520, 32966, 16924, 33069, 33262, 33067, 33702, 34177, 26010, 16446, 16520, 22872, 17127, 16900, 33264, 34069, 10891, 34125, 28235, 33072, 33764, 9558, 34163, 22515, 11783, 12063, 29833, 26781, 34890, 33073, 25312, 33209, 24848, 34097, 25260, 12575, 26201, 24893, 26611, 21474, 32280, 22591, 34296, 22689, 16213, 17251, 29996, 35297, 32448, 32493, 33534, 16961, 25248, 19456, 18050, 20837, 33782, 24898, 32343, 33066, 17128, 32420, 35237, 15879, 15650, 10880, 15957, 33383, 15741, 35167, 25346, 16316, 33048, 16481, 25509, 32918, 17226, 21227, 11918, 33399, 15989, 17728, 21422, 3644, 16233, 11704, 32864, 22807, 12361, 14323, 16272, 17097, 16144, 25475, 25283, 23539, 14091, 16833, 23524, 35275, 32817, 33100, 16434, 26166, 33403, 32481, 16830, 35472, 32157, 32356, 25356, 15861, 33110, 33531, 15697, 32878, 33560, 32693, 16543, 26054, 33752, 25328, 35015, 13625, 12699, 15962, 20094, 21677, 22236, 21228, 16095, 26559, 33590, 11666, 26662, 33408, 22212, 20850, 34086, 23474, 15729, 15936, 15294, 10878, 9536, 12183, 16013, 26210, 16142, 11110, 35327, 17286, 22565, 30573, 26821, 34843, 32959, 24957, 34196, 28478, 16115, 16070, 29698, 35061, 33196, 28263, 33639, 30569, 17252, 33330, 30586, 15198, 10879, 15757, 18010, 30057, 25268, 15938, 17002, 23356, 33416, 29802, 33052, 33123, 33288, 32784, 18051, 11532, 34306, 16384, 17124, 25627, 25197, 3201, 21216, 24817, 32281, 19611, 33441, 11721, 35016, 33584, 23038, 8317, 32751, 16391, 34994, 16801, 14452, 33258, 33282, 35401, 33880, 33595, 16736, 10986, 32783, 33122, 14089, 12624, 26098, 12591, 16693, 30499, 27750, 15805, 35413, 26750, 16111, 21836, 15563, 15717, 33898, 25282, 28674, 16640, 11578, 32384, 28467, 26496, 32728, 20529, 15976, 15471, 33945, 20115, 23642, 6986, 29989, 35293, 33312, 32369, 25267, 17959, 6968, 34151, 26893, 22554, 11943, 25446, 26505, 34085, 34232, 16960, 34092, 32164, 25825, 26917, 17373, 15987, 25000, 27253, 34911, 35294, 35158, 16553, 11591, 19367, 7925, 15387, 35129, 34174, 34846, 33942, 29810, 23465, 35076, 14285, 34046, 12026, 8128, 11609, 16343, 20067, 33936, 33985, 16102, 35325, 15837, 1862, 33074, 22004, 33968, 27994, 16097, 32607, 33935, 17510, 28294, 15238, 33832, 35296, 35430, 34986, 22585, 34041, 34854, 15737, 34648, 15263, 15877, 28246, 34026, 31431, 16580, 14334, 24012, 34307, 30574, 12318, 11669, 35363, 15926, 34175, 24877, 33620, 32996, 17355, 17592, 35114, 29967, 25939, 33818, 16590, 34045, 755, 17204, 25527, 9845, 12366, 26384, 21613, 35402, 26345, 14704, 29313, 34002, 16048, 15666, 27213, 24506, 23970, 35315, 11338, 28011, 34953, 19321, 34040, 16622, 31803, 30595, 32575, 33789, 14222, 16086, 22101, 33148, 32339, 33582, 32393, 22632, 34039, 35043, 9470, 27842, 30161, 13673, 26219, 33398, 13695, 33869, 30460, 35093, 26811, 35186, 33259, 10924, 15794, 32721, 32793, 16079, 16393, 4326, 32592, 25060, 25584, 15483, 3655, 23247, 14982, 15920, 33553, 15734, 26129, 34889, 20863, 25207, 6397, 34269, 23508, 34313, 27746, 35348, 25086, 33907, 16621, 28125, 26858, 32967, 15391, 3883, 31620, 33395, 15927, 15983, 16668, 34220, 20463, 34179, 16094, 7929, 32507, 20620, 22024, 33909, 16746, 14190, 35247, 31407, 14547, 24426, 19089, 19249, 14719, 17152, 22539, 15871, 33061, 34936, 35155, 25577, 11132, 35178, 26464, 25165, 35169, 32688, 26077, 33548, 24205, 33881, 12317, 35389, 24866, 32933, 2639, 22500, 23399, 34268, 16043, 16046, 8597, 23036, 17567, 33816, 13624, 10886, 22516, 15840, 32816, 11713, 33132, 25511, 19495, 25145, 23722, 11857, 32771, 33664, 17526, 8748, 11079, 20518, 8746, 33233, 22622, 32822, 23687, 35141, 11698, 11716, 34000, 33018, 21137, 35084, 21040, 34252, 8611, 6231, 16917, 20433, 35437, 16317, 16348, 2831, 35374, 34990, 5540, 20587, 12585, 32905, 11752, 14943, 7912, 21041, 17300, 8115, 32902, 33181, 27688, 11994, 33107, 34118, 9422, 16440, 11078, 5234, 26749, 14494, 32780, 20793, 4460, 32524, 35063, 32396, 21039, 11245, 33498, 35456, 10925, 11283, 9494, 33735, 11963, 32768, 25008, 26426, 9411, 11366, 35423, 15680, 17760, 16688, 11645, 15795, 7136, 16315, 16942, 18419, 23770, 20031, 9071, 28004, 17839, 9538, 16325, 16468, 33896, 14208, 12338, 16533, 12381, 11608, 16989, 10948, 24496, 26485, 3053, 6717, 32499, 33654, 28910, 34191, 34190, 34997, 23091, 33596, 34266, 33924, 33501, 33728, 33845, 33374, 34999, 26179, 35291, 8735, 8736, 8930, 9158, 10840, 11093, 11094, 11095, 11519, 11934, 11935, 15321, 15712, 16002, 16506, 16518, 16631, 16773, 16774, 17211, 17389, 17698, 17930, 22579, 22635, 22815, 22846, 23385, 23386, 24500, 24554, 24808, 24816, 25077, 25096, 25184, 25435, 25471, 25586, 26117, 26232, 26637, 26638, 26663, 26777, 26808, 26891, 26892, 28269, 28286, 28297, 28360, 28374, 28421, 28465, 32132, 32404, 32640, 32772, 32779, 32845, 32861, 32900, 33019, 33182, 33939, 33999, 34098, 34214, 34231, 34610, 35262, 35312, 35345, 35362, 35496, 35528, 35558, 35578, 35591, 35605, 35606, 35614, 35633, 35635, 35636, 35688, 35694, 35709, 35712, 35713, 35714, 35718, 35733, 35736, 35798, 1921, 8114, 9544, 9731, 9840, 9842, 9914, 10076, 10236, 10794, 10884, 10889, 10890, 10892, 10898, 10899, 10901, 10902, 10903, 10904, 10905, 10906, 10911, 10912, 10920, 10921, 10922, 10923, 10926, 10927, 10928, 10929, 10930, 10952, 11058, 11154, 11240, 11242, 11243, 11244, 11246, 11257, 11332, 11358, 11436, 11668, 11732, 11753, 11796, 11860, 11864, 11942, 11945, 11984, 12062, 12114, 12145, 12169, 12387, 12614, 12652, 14090, 14188, 14723, 14739, 14799, 14834, 14888, 14889, 15161, 15253, 15495, 15521, 15630, 15665, 15686, 15687, 15698, 15706, 15715, 15736, 15782, 15806, 15844, 15862, 15891, 15891, 15893, 15903, 15917, 15924, 15937, 16028, 16060, 16061, 16080, 16087, 16121, 16214, 16308, 16331, 16361, 16390, 16392, 16432, 16445, 16532, 16594, 16627, 16696, 16708, 16713, 16717, 16737, 16739, 16740, 16741, 16742, 16743, 16748, 16749, 16886, 16890, 16897, 16908, 16965, 17014, 17133, 17134, 17135, 17180, 17202, 17466, 17940, 18049, 18452, 19782, 20495, 20616, 20696, 20868, 21315, 21407, 21707, 22014, 22302, 22365, 22402, 22480, 22481, 22522, 22531, 22552, 22806, 22914, 22916, 23010, 23011, 23018, 23291, 23479, 23505, 23506, 23559, 23568, 23652, 23684, 23895, 24372, 24501, 24546, 24547, 24574, 24575, 24782, 24843, 24879, 24929, 24969, 24998, 25062, 25178, 25190, 25191, 25250, 25313, 25329, 25336, 25387, 25478, 25530, 25534, 25630, 25646, 25649, 25819, 25821, 25841, 26002, 26033, 26065, 26160, 26189, 26190, 26261, 26273, 26372, 26373, 26458, 26481, 26580, 26680, 26689, 26734, 26761, 26762, 26801, 26876, 27073, 27073, 27362, 27362, 27798, 27798, 28060, 28060, 28334, 28371, 28484, 28500, 28508, 28510, 28625, 28651, 28815, 30963, 31268, 31276, 31525, 31625, 31670, 31698, 31970, 31970, 32300, 32455, 32658, 32988, 33097, 33477, 33803, 33862, 33862, 33882, 34094, 34165, 34166, 34280, 34859, 34915, 35030, 35146, 35159, 35176, 35347, 35397, 35434, 35438, 35454, 35464, 35490, 35524, 35557, 35566, 35587, 35590, 35596, 35597, 35620, 35624, 35653, 35664, 35670, 35679, 35690, 35705, 35715, 35720, 35726, 35732, 35738, 35747, 35775, 35785, 35800, 35817, 35819, 35827, 35848, 35854, 35856, 35865, 35867, 35868, 35870, 35881, 35883, 35884, 35891, 35901, 35915, 35919, 35924, 35926, 35929, 35930, 35932, 35936, 35940, 35943, 35957, 35959, 35967, 35969, 66944, 66947, 66952, 66959, 66960, 66962, 66964, 69205, 70042, 70050, 70055, 70064, 70068, 70086, 70089, 70090, 70091, 70103, 70107, 70118, 70121, 70667, 70676, 70680, 70683, 70685, 70690, 70692, 70694, 70695, 70716, 70728, 70735, 70736, 70737, 70740, 70752, 70757, 70769, 70777, 70781, 70782, 70795, 70799, 70800, 70943, 70953, 70954, 70955, 70956, 70971, 70977, 71046, 71048, 71051, 71052, 71228, 71306, 71307, 71308, 71357, 71494, 71589, 71598, 71601, 71615, 71622, 72010, 72030, 72032, 72033, 72034, 72035, 72036, 72037, 72038, 72039, 72040, 72041, 72042, 72043, 72044, 72045, 72046, 72047, 72048, 72049, 72050, 72051, 72052, 72053, 72054, 72055, 72056, 72057, 72058, 72059, 72060, 72061, 72062, 72063, 72064, 72065, 72066, 72067, 72068, 72069, 72070, 72071, 72072, 72073, 72074, 72075, 72076, 72077, 72078, 72079, 72080, 72081, 72082, 72083, 72084, 72085, 72086, 72087, 72088, 72089, 72090, 72091, 72092, 72093, 72094, 72095, 72096, 72097, 72098, 72099, 72100, 72101, 72102, 72103, 72104, 72105, 72106, 72107, 72108, 72109, 72110, 72111, 72112, 72113, 72114, 72115, 72116, 72117, 72118, 72119, 72120, 72121, 72122, 72123, 72124, 72125, 72126, 72127, 72128, 72129, 72130, 72131, 72132, 72133, 72134, 72135, 72136, 72137, 72138, 72139, 72140, 72141, 72142, 72143, 72144, 72145, 72146, 72147, 72148, 72149, 72150, 72151, 72152, 72153, 72154, 72155, 72156, 72157, 72158, 72159, 72160, 72161, 72162, 72163, 72164, 72165, 72166, 72167, 72168, 72169, 72170, 72171, 72172, 72173, 72174, 72175, 72176, 72177, 72178, 72179, 72180, 72181, 72182, 72183, 72184, 72185, 72186, 72187, 72188, 72189, 72190, 72191, 72192, 72193, 72194, 72195, 72196, 72197, 72198, 72199, 72200, 72201, 72202, 72203, 72204, 72205, 72206, 72207, 72208, 72209, 72210, 72211, 72212, 72213, 72214, 72215, 72216, 72217, 72218, 72219, 72220, 72221, 72222, 72223, 72224, 72225, 72226, 72227, 72228, 72229, 72230, 72231, 72232, 72233, 72234, 72235, 72236, 72237, 72238, 72239, 72240, 72241, 72242, 72243, 72244, 72245, 72246, 72247, 72248, 72249, 72250, 72251, 72252, 72253, 72254, 72255, 72256, 72257, 72258, 72259, 72260, 72261, 72262, 72263, 72264, 72265, 72266, 72267, 72268, 72269, 72270, 72271, 72272, 72273, 72274, 72316, 72411, 72412, 72485, 72486, 73153, 73186, 73187, 73191, 73213, 73223, 73339, 73340, 73391, 73392, 73393, 73399, 73406, 73474, 73475, 73479, 73511, 73516, 73568, 73585, 73614, 73615, 73829, 73868, 73894, 73907, 73908, 74107, 74109, 74124, 74125, 74126, 74220, 74227, 74232, 74237, 74238, 74240, 74310, 74311, 74312, 74313, 74315, 74320, 74322, 74325, 74357, 74360, 74431, 74516, 74536, 74602, 74627, 74766, 74906, 74919, 74920, 74942, 74967, 74968, 74969, 74979, 75021, 75029, 75075, 75078, 75134, 75149, 75150, 75153, 75218, 75219, 75221, 75275, 75280, 75287, 75289, 75305, 75380, 75381, 75440, 75458, 75556, 75653, 75675, 75683, 75684, 75685, 75686, 75687, 75688, 75689, 75690, 75741, 76170, 76171, 76172, 76493, 76550, 76558, 76575, 76582, 76209, 76218, 76272, 76276, 76303, 76311, 76321, 76324, 76327, 76355, 76368, 76369, 76370, 76373, 76615, 76625, 76628, 76629, 76631, 76638, 76679, 76693, 76714, 76730, 76733, 76776, 76778, 76799, 76829, 76864, 76865, 76866, 76869, 76881, 76897, 76937, 76941, 76948, 76953, 76964, 73560, 76975, 76997, 76999, 77000, 77019, 77020, 77038, 77040, 77043, 77088, 77093, 77098, 77102, 77161, 77162, 77167, 77184, 77202, 77209, 77218, 77255, 77287, 77290, 33785, 70968, 35965, 70785, 33250, 34873, 35239, 66953, 32696, 34956, 35724, 70106, 33407, 35265, 32891, 74228, 33635, 35749, 35753, 35627, 35818, 35469, 33448, 35526, 35871, 33388, 35316, 35508, 34173, 75431, 76832, 28422, 35551, 74108, 76410, 35581, 35685, 33559, 35523, 35314, 35764, 74226, 33967, 35224, 70958, 73895, 35781, 35328, 35418, 33915, 33984, 34946, 28274, 33236, 33790, 9119, 74980, 35471, 32460, 34155, 29470, 34129, 35229, 28666, 70789, 76210, 32399, 32968, 33810, 69206, 18866, 32179, 17387, 34285, 7973, 16212, 34148, 11955, 9642, 9789, 9795, 9839, 9841, 9843, 9844, 9846, 9847, 9849, 9850, 9851, 9852, 9853, 9854, 9936, 9937, 10546, 10548, 10550, 10551, 10552, 10553, 10556, 10558, 10559, 10561, 10581, 10963, 10964, 10965, 10966, 13651, 14118, 14825, 15593, 77350, 77351, 77361, 77369, 77396, 77421, 77422, 77464, 77466, 77488, 77512, 77531, 77595, 77596, 77604, 77665, 77677, 77687, 77688, 77763, 77782, 77788, 77789, 77795, 77823, 77825, 77826, 77845, 78003, 78092, 78161, 78383, 78387, 78422, 78440, 78465, 78469, 78471, 78480, 78490, 78494, 78501, 78557, 78588, 78606, 78615, 78627, 78881, 79545, 79605, 79762, 79953, 79961, 80059, 80350, 81660, 81661, 81686, 81789, 81790, 81804, 81808, 81829, 81832, 81857, 81861, 81866, 81872, 81947, 82036, 82100, 82120, 82138, 82153, 82163, 82169, 82192, 82209, 82301, 82302, 82308, 82312, 82324, 82362, 82366, 82407, 82415, 82418, 82439, 82440, 82481, 82518, 82547, 82553, 82580, 82600, 82625, 82627, 82628, 82629, 82637, 82655, 82681, 82710, 82711, 82754, 82772, 82775, 82801, 82876, 82877, 82880, 82900, 82905, 82929, 82971, 83072, 83074, 83076, 83189, 83190, 83191, 83228, 83293, 83446, 83451, 83483, 83548, 83581, 83620, 83662, 83709, 83772, 777808, 777814, 777815, 777882, 777884, 777985, 778056, 778057, 778128, 778185, 778245, 778277, 778328, 778331, 778332, 778333, 778366, 778367, 778490, 778491, 778527, 778533, 778641, 778651, 778653, 778743, 778751, 778827, 778924, 778933, 778935, 778936, 778975, 779003, 779027, 779048, 779049, 779138, 779157, 779193, 779199, 779208, 779386, 779407, 779414, 779416, 779607, 779632, 779639, 779731, 779732, 779769, 779770, 779771, 779928, 779969, 779998, 779999, 780001, 780002, 780003, 780004, 780226, 780351, 780367, 780403, 780501, 780518, 780667, 780668, 780779, 780781, 780782, 780807, 780863, 780864, 780949, 781044, 781166, 781300, 781430, 781463, 781469, 781471, 781512, 781523, 781544, 781575, 2772, 4415, 4741, 7006, 7170, 7395, 7634, 9838, 10026, 10203, 10533, 10537, 10857, 10881, 10881, 10897, 10907, 10956, 10961, 11002, 11002, 11024, 11054, 11054, 11133, 11133, 11152, 11155, 11297, 11313, 11333, 11334, 11393, 11418, 11488, 11673, 11747, 11764, 11831, 11853, 11862, 11905, 11982, 11982, 12012, 12012, 12082, 12082, 12108, 12144, 12222, 12235, 12253, 12253, 12277, 12277, 12352, 12367, 12576, 12587, 13638, 13652, 13667, 13677, 13703, 14100, 14203, 14669, 14735, 14862, 14862, 14882, 14908, 14946, 15091, 15104, 15151, 15178, 15199, 15251, 15262, 15262, 15278, 15299, 15319, 15437, 15456, 15456, 15578, 15631, 15642, 15705, 15770, 15822, 15846, 15846, 15850, 15878, 16003, 16116, 16226, 16332, 16690, 16691, 16735, 16758, 16765, 16777, 16894, 16975, 17192, 17255, 17509, 17509, 18880, 19509, 19522, 19955, 19959, 20055, 20056, 20071, 21594, 22096, 22246, 22380, 22840, 22842, 23119, 23281, 23357, 23587, 24410, 24410, 24487, 24812, 24891, 24892, 25010, 25044, 25061, 25174, 25183, 25211, 25277, 25357, 25408, 25474, 25495, 25816, 26055, 26270, 26614, 26615, 26650, 26796, 26869, 27395, 27395, 27537, 27537, 27743, 28145, 28145, 28530, 28582, 29308, 29468, 29468, 30532, 30539, 32286, 32392, 32624, 32643, 32673, 32800, 33015, 33152, 33486, 33763, 33768, 33982, 34622, 35702, 35745, 35761, 35893, 66948, 70093, 70721, 70725, 70732, 70778, 73605, 74450, 74553, 74554, 75336, 76320, 76395, 76421, 76569, 76614, 76701, 76704, 76764, 76773, 76797, 76849, 77041, 77561, 77592, 78589, 82082, 82113, 82194, 82211, 82288, 82522, 82524, 82817, 82836, 82879, 83742, 778086, 778088, 778607, 779139, 779291, 779644, 779761, 780096, 780713, 781609, 781653, 781679, 781706, 781725, 781727, 781735, 781747, 781748, 781825, 781835, 781863, 781865, 790158, 790251, 790254, 790268, 790269, 790310, 790315, 790344, 790352, 790381, 790385, 790419, 790425, 790432,790446, 790461) then 'Latin' else 'Other' end) as label_categ,
          
          COALESCE(SUM(facts_prod_fact_sales.gross ), 0) AS "facts_prod_fact_sales.gross_revenue_usd"
      
      FROM facts.prod.fact_sales AS facts_prod_fact_sales
      
      INNER JOIN intelligence.dbt_prod.dt_access_filter_1091  AS dt_access_filter_1091 ON facts_prod_fact_sales.labelid = dt_access_filter_1091.vendor_id
      
      LEFT JOIN facts.prod.dim_country  AS facts_prod_dim_country ON facts_prod_fact_sales.countryid = facts_prod_dim_country.countryid
      LEFT JOIN facts.prod.dim_period  AS activity_period ON facts_prod_fact_sales.activityperiodid = activity_period.periodid
      LEFT JOIN facts.prod.dim_release  AS facts_prod_dim_release ON facts_prod_fact_sales.releaseid = facts_prod_dim_release.releaseid
      LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.releases  AS orch_app_ar_releases ON facts_prod_dim_release.product_id = orch_app_ar_releases.release_id
      LEFT JOIN facts.prod.dim_transactiontype  AS facts_prod_dim_transactiontype ON facts_prod_fact_sales.transactiontypeid = facts_prod_dim_transactiontype.transactiontypeid
      WHERE ((UPPER(( facts_prod_dim_country.country_code  )) = UPPER('US'))) AND (dt_access_filter_1091.access_control ) = 0 AND (((COALESCE( facts_prod_dim_transactiontype.transactiontypeabbr , '') != 'PS') AND (COALESCE( facts_prod_dim_transactiontype.transactiontypeabbr , '') != 'RE')) AND ((( (TO_DATE(DATE_FROM_PARTS(activity_period.year, activity_period.month, '01')  ))  >= CAST((CAST(CAST(2024 AS INT) AS VARCHAR) || CAST('-' AS VARCHAR) || CAST(LPAD(CAST(CAST(8 AS INT) AS VARCHAR), 2, '0') AS VARCHAR) || CAST('-' AS VARCHAR) || CAST(LPAD(CAST(CAST(31 AS INT) AS VARCHAR), 2, '0') AS VARCHAR) || CAST(' 00:00:00' AS VARCHAR)) AS TIMESTAMP)) AND ( (TO_DATE(DATE_FROM_PARTS(activity_period.year, activity_period.month, '01')  ))  <= CAST((CAST(CAST(2023 AS INT) AS VARCHAR) || CAST('-' AS VARCHAR) || CAST(LPAD(CAST(CAST(8 AS INT) AS VARCHAR), 2, '0') AS VARCHAR) || CAST('-' AS VARCHAR) || CAST(LPAD(CAST(CAST(31 AS INT) AS VARCHAR), 2, '0') AS VARCHAR) || CAST(' 00:00:00' AS VARCHAR)) AS TIMESTAMP))) OR (( (TO_DATE(DATE_FROM_PARTS(activity_period.year, activity_period.month, '01')  ))  >= CAST((CAST(CAST(2023 AS INT) AS VARCHAR) || CAST('-' AS VARCHAR) || CAST(LPAD(CAST(CAST(8 AS INT) AS VARCHAR), 2, '0') AS VARCHAR) || CAST('-' AS VARCHAR) || CAST(LPAD(CAST(CAST(31 AS INT) AS VARCHAR), 2, '0') AS VARCHAR) || CAST(' 00:00:00' AS VARCHAR)) AS TIMESTAMP)) AND ( (TO_DATE(DATE_FROM_PARTS(activity_period.year, activity_period.month, '01')  ))  <= CAST((CAST(CAST(2024 AS INT) AS VARCHAR) || CAST('-' AS VARCHAR) || CAST(LPAD(CAST(CAST(8 AS INT) AS VARCHAR), 2, '0') AS VARCHAR) || CAST('-' AS VARCHAR) || CAST(LPAD(CAST(CAST(31 AS INT) AS VARCHAR), 2, '0') AS VARCHAR) || CAST(' 00:00:00' AS VARCHAR)) AS TIMESTAMP)))))
      
      
      GROUP BY 1,2,3 ;;
```