Manufacturer Reporting
Keyword Association
| Keyword | Definition |
|---|---|
| Looker Studio | Reporting analytics platform where data teams and regular users can visualize and build reports, dashboards, and analytical components |
| SLA | Service Level Agreement |
| Filter | Specific component utilized to screen data from a data source to determine whether the data should be included in or excluded from the calculations of the report results |
| Lineage | Origin of the data source and/or underlying table object in which the calculation is being driven |
| Cross Filtering | Feature within Looker Studio giving data teams the ability to share datasets and filters across numerous or all reporting components giving a seamless reporting experience |
| ### Lineage | |
| Lineage Definition | Description |
| -------------------- | ---------------------------------------------------------------------------- |
| Cross Filtering | Turned ON - see here for information on Cross Filtering |
| Table Origin | reporting_us.manufacturer_reporting_v2 |
| ### Shared Filters |
| Filter Name | Description |
|---|---|
| Manufacturer | Allows a user to multi-select and single select specific drug Manufacturers and filter the context page data |
| Product | Allows a user to multi-select and single select drug Products relative to a specific manufacturer. |
| Date Range Picker | Custom date picker that extends master level date shares for all metrics on the contextual page, and comes with built in Quick Dates giving the user the ability to customize metrics for common ranges and advanced use cases. |
BI Invoicing
| Overview of the overall Benefit Inquiry invoice metrics
Filter(s)
| Page Filters | Description |
|---|---|
| Plan Type | Relative to a Cost Category that is either Commercial or Government |
| Speciality | area of medical speciality in which eBlu services area |
Benefit Inquiry Invoicing
| Visualization relative to Benefit Inquiries invoicing by product for relative date dimensions by month
| Legend Key | Description |
|---|---|
| Benefit Inquiry | Running aggregate total of Benefit Inquiries for the specific date range selected |
| Table visualizing distinct Benefit Inquiry count by Manufacturer, Plan Type, and Year month
PA Invoicing
| Overview of the overall Prior Authorization invoice metrics
Filter(s)
| Page Filters | Description |
|---|---|
| Practice Managing | Relative to a Prior Authorization where Practice Managing is true or false |
| Speciality | area of medical speciality in which eBlu services area |
Prior Authorization Invoicing
| Visualization relative to Prior Authorization invoicing by product for relative date dimensions by month
| Legend Key | Description |
|---|---|
| Prior Authorization | Running aggregate total of Prior Authorizations for the specific date range selected |
| Table visualizing distinct Prior Authorization count by Manufacturer and Prodcut
PAAM Invoicing
| Overview of the overall Prior Authorization Active Monitoring invoice metrics
Filter(s)
| Page Filters | Description |
|---|---|
| Speciality | area of medical speciality in which eBlu services area |
PAAM Invoicing
| Table visualizing distinct Prior Authorization Monitoring count by Manufacturer and Prodcut
CoPay Invoicing
| Overview of the overall CoPay Enrollment invoice metrics
Filter(s)
| Page Filters | Description |
|---|---|
| Practice Managing | Relative to a Prior Authorization where Practice Managing is true or false |
| Speciality | area of medical speciality in which eBlu services area |
CoPay Invoicing
| Visualization relative to CoPay invoicing by product for relative date dimensions by month
| Legend Key | Description |
|---|---|
| CoPay Enrollment | Running aggregate total of CoPay Enrollment for the specific date range selected |
| Table visualizing distinct CoPay Enrollment count by Manufacturer and Product
SLA
| Overview of the overall SLA relative metrics
Filter(s)
| Page Filters | Description |
|---|---|
| Practice | Extends the user the ability to multi-select and single select Practice(s) to reflect on the entire page |
| Practice Location | Extends the user the ability to multi-select and single select Practice Location(s) to reflect on the entire page |
SLA
| Table Visualization relative to SLA for relative date dimensions
| Legend Key | Description |
|---|---|
| Patient | EDI reference for Patient with Linked URL |
| Product | Specific Product associated with the Benefit Inquiry |
| Practice or Location | Displays Practice Name when Practice Location is NULL |
| Benefit Inquiry Status | Status associated with the Benefit Inquiry |
| Create Date | Benefit Inquiry created date |
| Work Hours Against SLA | Benefit Inquiry turn around time in hours against SLA |
| Benefit Inquiry | EDI reference for Benefit Inquiry with Linked URL |
Practice Utilization
| Overview of the overall Practice Utilization metrics
Filter(s)
| Page Filters | Description |
|---|---|
| Practice | Extends the user the ability to multi-select and single select Practice(s) to reflect on the entire page |
| Speciality | area of medical speciality in which eBlu services area |
Practice Utilization
| Visualization relative to Benefit Inquiry by Practice for relative date dimensions by month
| Legend Key | Description |
|---|---|
| Benefit Inquiry | Running aggregate total of Benefit Inquiry for the specific date range selected |
| Pivot Table visualizing total aggregated Benefit Inquiry by Practice (Drilled into Practice Location) by month year