Aggregate REP_SHARE_OF_VOICE Metrics by Reporting Date for Repatha

Requirements: Develop SQL Logic, Read the table 'stitched_pmr_consolidation_data' and extracts Share of Voice (SoV) metrics specifically for the product Repatha. The logic must filter the dataset to include only records where metric = 'REP_SHARE_OF_VOICE', frequency = 'QUARTERLY', speciality = 'ALL', and product_name = 'REPATHA'. Additionally, the results must be restricted to reporting dates on or after September 1, 2023. After applying these filters, the SQL logic should group the dataset by product_name and time_stamp, and compute the SUM(value) for each group to derive the total Share of Voice for Repatha per reporting period. The final transformed output should expose three fields — product_name, time_stamp, and total_share_of_voice — and must be published through a finalized view named stitched_pmr_consolidation_data_vw.

 

Final Output: Show the results.

 

Unity Catalog: stitched_pmr_consolidation_data_vw