Customer_360 - Data Unavailability for Metric ‘Rep Share of Voice’ in C360 PMR Consolidation View

Introduction: C360 PMR Consolidation View provides consolidated brand-level metrics such as _Rep Share of Voice_, _Call Frequency_, _Coverage_, and other HCP engagement indicators across multiple specialties. During validation, it was observed that for the speciality_name "BREATH PCPS", the metric “Rep Share of Voice” data was missing for April 2025.

 

Requirement: Develop SQL logic, perform validation on the Unity Catalog table c360_pmr_consolidation_data to identify specialties missing “Rep Share of Voice” data for April 2025. The query should return the last available date for the metric and flag whether April 2025 data is missing. This helps ensure metric consistency across specialties in the consolidated C360 PMR view.

 

Final Output: Display the results for the speciality_name “BREATH PCPS“ with metric_name “Rep Share of Voice“.

 

Unity catalog: c360_pmr_consolidation_data_vw