Custom Extracts

Overview 

The Custom Extracts Dashboard allows users to build tailored datasets by selecting desired metrics, product attributes, and granularity options. This tool provides a customizable data table for in-depth analysis, supporting strategic decision-making across products, brands, and territories. 

 

Key Features 

  • Customizable Data Table
    • Build a custom extract by selecting: 
      • Metrics: Total Retail Sales, Total Pack Units, Pack ARP, EQ Units, etc. 
      • Attributes: Category, State, Channel, Brand, Product, THC/CBD Ranges, Pack Size, and more. 
      • Time Period: Filter data by month or other selected timeframes. 
  • Flexible Row Selection
    • Choose the granularity of the data by including up to four row selections such as: 
      • Category Levels (e.g., Level 1, Level 2) 
      • State 
      • Month 
      • Brand/Brand House 
  • Metric Options
    • Include any of the following metrics: 
      • Total Retail Sales: Aggregate sales revenue for selected products. 
      • Total Pack Units: Total units sold for selected products. 
      • Pack ARP: Average Retail Price per pack. 
      • EQ Units: Equivalent units for volume normalization. 
  • Geographic and Product Filters
    • States & Regions: Select regions or specific territories. 
    • Product Attributes: Filter by: 
      • Pack Size 
      • Total Item Weight 
      • Strain 
      • Cannabinoid Mix 
      • THC/CBD Ranges 
    • Brand & Channel: Focus on specific brands or sales channels. 

 

Insights 

  • Granular Data Analysis: Build tailored reports to analyze product, brand, and geographic performance at the most detailed levels. 
  • Sales and Pricing Trends: Monitor key performance indicators like Pack ARP, Total Sales, and Units Sold across time periods. 
  • Category and Attribute Insights: Evaluate product performance by Category Levels and attributes like Cannabinoid Mix and Strain
  • Geographic Analysis: Assess sales and pricing performance across states, counties, and territories. 

 

Pro Tips 

  • Select 4 attributes for rows to maintain granularity while avoiding performance issues. 
  • Use Pack ARP alongside Units Sold to identify high-performing price points. 
  • Combine Category Filters and THC/CBD Ranges for detailed product-level insights. 

 

Support 

For additional help or tutorials, access the Metric Glossary & Video Tutorials link available within the dashboard.