Business Intelligence, Sales, and Management Features: DigThisData

Reporting & Metrics

Clear, concise Business Intelligence reporting adds clarity to your decision making.

Digestible Charts

Transform your data files into beautiful dynamic charts instantly.

Tabular Data

Filter and sort colour coded data. Export to Excel™ and PDF.

Weekly Performance

Automatically calculate aggregated weekly performance values including Units, Litres, Stores, and Total Performance. Filter by Product and Date Range. Segment by Channel.
Location / Customer Performance

An aggregate report providing Total Unit Sales and Sales Rep for each location filterable by Product, Product Group, Region and Date Range.
Location / Customer Trend Drill–Down

Displayed in both Graphical and Tabular formats, view Weekly Unit, Cases, and Volume Sales over a specified time–frame for all your products at a specific retail location or customer.
Distribution

Review distribution points by District, Product, Product Group, and Territory.
Sales By Location / Customer

A detailed report indicating List/De–List Status, Unit, and Litre Sales by Store filterable by Product and Date Range.
Location Analysis

List locations with all products sold ranked within their specific subset (category).
Sales By Product

An aggregate report of Product Sales indicating Store, Licensee, Agency, TBS, Grocery, and Other sales. Report by Unit, Cases, or Volume and filterable by Custom Product Group, General or Vintages Listing Type, and Sales Representative.
Vintages Sell Through Targets

Measure percentage case sales from release date at 8 Week / 75% target and 12 Week / 100% target. Use this feature for any product, even general list.
LCBO/TBS/BCLS/SLGA/Liquor Connect Daily Sales

A rolling report listing daily product sales by location. Updated daily with data as recent as yesterday, the system will calculate Daily Sales, a 30 day Mean, and Standard Deviation. Indicators are present for figures above or below the standard deviation.
LCBO & TBS / BLCS Store Rank

List LCBO and TBS locations in order of performance by Product Subset and Style. Select a single or multiple subsets and display a ranked report of the best performing stores together with total unit sales.
Product Gap Report

Either ombined with Store Rank or as a standalone, visualize which locations carry your products and identify top performing locations for your subsets that don’t.
Ontario Grocery Sell–Through

Rank Grocery Sell through figures with Price, Units, Cases, Volume, and Revenue. Select individual products to spawn a window containing a graphical chart with the ability to compare to your own products.
Agency Sales

List LCBO Agency Sales in Units and Volume filterable by Custom Product Group and Sales Representative.
LDB, SLGA, MBLL, LCBO & TBS Licensee Sales

Display LCBO & TBS sales and shipments to all licensee locations throughout the province with details on products and quantities.
Period Sales

Similar to Sales By Product, Period Sales provides an aggregate report of Product Sales indicating Store, Licensee, Agency, TBS, Grocery, and Other sales per LCBO Periods 1 through 13. Report by Unit, Cases, or Volume and filterable by Custom Product Group and General or Vintages Listing Type.
Year to Date Sales

A rolling Year to Date Sales report organized by LCBO Period. This report includes individual product’s Aggregated Period Sales and End of Period Inventory. Report by Unit, Volume, or Cases and filter by Custom Product Group and General or Vintages Listing Type
Year to Date LCBO Targets

A rolling Year to Date Sales Target report organized by LCBO Period. This report calculates a product’s sales performance against targets set by the LCBO.
Year Over Year Sales

A rolling annual report comparing LCBO Period Sales per Product with the same period of the previous year. Report by Unit, Volume, or Cases and filter by Custom Product Group and General or Vintages Listing Type.
Year Over Year Weekly Sales Velocity

A 12 week customizable report listing Weekly Unit Sales and Weekly Sales Velocity by location for any product. Current and previous years are show for comparison.
Unit Product Sales

A graphical chart displaying Product Sales by Unit over time. Up to eight products can be selected with a customizable Date Range and formatted as either a Bar or Line chart.
Volume Product Sales

A graphical chart displaying Product Sales by Volume over time. Up to eight products can be selected with a customizable Date Range and formatted as either a Bar or Line chart.
ACD National and Provincial Data Support

Ingest ACD files for distributed reporting on a National basis.
Unlimited Saved Queries / Shortcuts

Save and recall any report criteria instantly for fast and efficient reporting. Apply multiple shortcuts per report in any channel.
Custom Reports

A–la–Cart Custom Reports enables users of an account to subscribe to available report on demand. Reports are emailed either Weekly, Monthly, or at Period End as desired.

Production Management

Multi–Facility scheduling and management for any producer

Numerous schedule views including Gantt, Calendar, and Resoure Allocation.

Full Cost of Goods tracking

Traceability

Manage Product Batches and Lots with seemless flowthrough to Orders

First–In–First–Out methodology

Reverse search customer orders by Lot or Batch for instant Traceability

Production Schedule

Multi–Facility scheduling and management for any producer with numerous views and flexible tools. Seemless integration with DTD sales tools for forecasting and planning.
Batch Managamenet

Produce and track Product Batches both for Consignment and Direct Sales
Lot Management

Create multiple Lots from Batches and assign to specific warehouses / retail outlets
Reverse Batch / Lot Trace

Identify the sales distribution of any Lot instantly to comply with strict regulatory Traceability requirements.
Fixed Asset Management

Manage and track all fixed assets in multiple locations / facilities.
Raw Goods & Supplies

Track and Manage Raw Goods to calculate Cost of Goods Sold and manage supply requirements.

Sales Management

Supporting multiple channels in Ontario, BC, Alberta, Saskatchewan, and Manitoba: LCBO, TBS, BCLS, LDB, SLGA, MBLL, Liquor Connect & Direct Sales

Now with GMS, DDVP and TBS Purchase Order support in Ontario

Leverage daily updated retail inventory levels and mobilize your sales force with industry standard tools.

Define Sales Territories

Assign Sales Reps to stores and organize and monitor their daily activities.

Place and Track Orders on the Road

View Current Inventory Levels

Updated daily, inventory is listed for each of your products in all LCBO & TBS stores. Colour coding identifies stores that have low inventory, de–listed products, and open orders. Filter inventory by Store, Product, or Sales Representative
Inventory History

Display daily Inventory Levels for each product in all MBLL, LCBO & TBS locations and monitor sales pace and product depletion rates.
Stale & Out of Stock Inventory

Display Stale and Out of Stock Inventory issues with durations for each product in all LCBO locations.
Stock Out & Lost Revenue Reporting

Stock Out defines the number of days left before inventory runs out based on historical sales data. Stock Out calculations are configurable and defaults can be set by Admins and Managers in the Account Settings.
Low Inventory Threshold

Set a Low Inventory Threshold for each location. If inventory levels approach or break through the threshold, visual indicators alert users.
Ingest Grocery Management System (GMS) Files

Get all your GMS orders into DigThisData with a simple CSV upload. All generated orders are compatible with Warehouse Inventory and Accounting Integrations and provide Location Level history. Once orders are generated in DigThisData, they are fully compatible with existing Warehouse Inventory Management as well as integrating seamlessly with QuickBooks, Sage and Xero accounting connections.
Ingest Direct Delivery Vendor Portal (DDVP) Files

Get all your DDVP orders into DigThisData with a simple CSV upload. All generated orders are compatible with Warehouse Inventory and Accounting Integrations. Once orders are generated in DigThisData, they are fully compatible with existing Warehouse Inventory Management as well as integrating seamlessly with QuickBooks, Sage and Xero accounting connections.
Ingest TBS Purchase Orders (XML)

Ingest The Beer Store Purchase Orders in XML format automatically. If the system locates XML Purchase Orders in your account’s SFTP site, DTD will automatically ingest the files and create Pre–Orders. Once complete, a message will be added to your notifications indicating the number of Purchase Orders ingested. Additionally, XML Purchase Orders can be ingested through the Data → Import Data Files upload widget.
Shopify Direct to Consumer Integration

Connect your Shopify Store to DigThisData and process and report on Shopify Orders.
Install the DigThisData Shopify App.
Place Retail Orders

Easily place orders when low inventory levels are identified. Submit multiple products in a single order with current inventory levels displayed for each product.
Place Licensee Orders

Use the same familiar interface to place and manage orders for Licensees and other Direct Sales customers.
View and Post Orders to Accounting Systems

Change the status of an order after entry into accounting systems. Once posted, and order will be automatically flagged when fulfilled.
Generate PDF Packing Slips / Bill of Ladings

Select Retail and Direct/On–Premise orders and generate PDF Packing Slips / Bill of Ladings consolidated into a single PDF with the click of a button. Various templates are predefined for different destinations including LCBO, TBS, On–Premise, Grocery, and Agency. BoLs also include a Picklist and Summary table for logistics staff.
Up–To–Date Grocery Location List

Assign and manage any Grocery location in the province. All locations are available for Call Days and Pipeline management in the CRM.
Call Days

Assign LCBO, Agency, Grocery, TBS, and Licensee locations to Sales Reps and each day, a custom list of priority stores are presented to each individual Rep. Detailed views of each store gives you Contact Info, Current Sales Figures, Previous Year Sales Figures, Open Orders, and a running thread of Notes. Place an order directly from the Call Day view and flag the store as Pending, In–Progress, or Complete.
Set Follow–Up Date & Time

DigThisData combines CRM features allowing you to set a date and time indicating when you should next communicate with a particular location. Fully customizable, Follow–Up Date and Time values can be set with ease, altering the priority of daily location listings.
Weekly & Bi–Weekly Logistics Schedules

Assign multiple–day schedules on a Weekly or Bi–Weekly 1/2 recurrance.
Logistics Cut Off Times

Set customizable Shipping Cut Off Times for each location so staff are aware of ordering deadlines and order priority inventory items based on priority Cut Off Times.
5 Day Hyperlocal Weather Forecast

View hyperlocal weather forecasts for any retail or on–premise location to better predict demand.
Product Bundles

Roll multiple products into a single selectable item for easy ordering. Combine deposits with the sale of a keg and track both SKUs independently.
Virtual Products

Create multiple versions of the same product to add to orders at varying price points. Deplete warehouse inventory for the same origin product with the sale of associated Virtual Products.
Order Fulfillment Notification

DigThisData automatically checks inventory levels for active orders and marks them as fulfilled once inventory is detected.
TBS Logistics Reporting

DigThisData updates daily with precise TBS logistics movements. Brewer shipments, transfers, & returns. Validate your orders are delivered and track TBS warehouse inventory.
List / De–List Notifications

Updated daily and available as a report per period, LCBO List / De–List Status notifies users of changes in their products listing status.
LCBO Consignment Customer / Order Management

Manage multiple LCBO Consigment Agent numbers and Agent Specific Customer Numbers all referncing the same customer/client. Easily create a combined agent/customer number order and export orders for quick upload to LCBO systems (Elite).
Day Planner with Mileage Tracking

Easily add accounts to a day plan and organize a travel route. Check–in at each location to track mileage and compare planned vs. actual route taken.
Locations Map

Find LCBO, LCBO Agency, Grocery, and TBS locations near you instantly with our GPS location aware interactive map. View a heatmap of any Sales Rep Territory.
Google Maps Integration

View locations or plan daily routes and send directions to Google Maps for Android Auto / Car Play integration.
QuickBooks™ Online Integration

Enable QuickBooks™ Integration and create invoices directly from DigThisData when posting orders.
Xero™ Accounting Integration

Enable Xero™ Integration and create invoices directly from DigThisData when posting orders.
Sage™ Business Cloud Integration

Enable Sage™ Integration and create invoices directly from DigThisData when posting orders.

Online Licensee Sales

Fully integrated with DigThisData

Accept Credit Cards and EFT Payments

Advanced accounting

Two–way integration with your accounting software

Market to licensees throughout the province

Accept Credit Cards

Accept all major credit cards including Visa, MasterCard, and American Express.
Process Electronic Funds Transfers

Process EFT payments in batches for efficient and cost effective payment
Reduce AR Collections

Pre-authorize credit cards to ensure funds availability and automatically process EFT payments.
3 to 7 Day Payouts

Receive your money faster with three to seven day payouts.
Monitor Payment Status

Receive indicator of successful and failed payments.
Mark Invoices as Paid in Bulk

Push up to 50 payments to your accounting software as a batch to mark invoices as paid and close out AR.
Promote Products

Expose your products to licensees in new territories even without feet on the ground.

Industry Analysis

Get in–depth insights into BCLS, LCBO, SLGA and TBS industry trends with competitor data.

Focused Reporting

Dive into analysis throughout the Province or filter down by Region, District, and even individual locations.

All BCLS & LCBO Product Data Included

DigThisData includes industry data for every product in the BCLS and LCBO without the need for a costly Sale of Data subscription.

Industry Support

Perform market research an analysis for competative data available from the BCLS, SLGA, MBLL, Liquor Connect, ANBL, NSLC, NLLC, PEILCC, TBS, and the LCBO.
All BCLS, NSLC, & LCBO Industry Data Included, Free of Charge

DigThisData includes industry data for every product in the LCBO (Ontario), NSLC (Nova Scotia), and BCLS (BC) without the need for a costly Sale of Data subscription. Need to look at Australian Shiraz compared to Argentinian Malbec? See a correlation between Chardonnay and Pale Ale? DTD allows users of all plans to view, rank, and compare any product sold through the BCLS and LCBO – including Vintages.
Industry Overview

See Year–Over–Year Growth, New Products, Top Gainers, Delisted Products, and Style Leaders for up to a fiscal year.
Industry Leaders

Displaying the top performing products/lines/brands/suppliers for the Province, Region, and District, the Leaders Report is a glimpse into current industry trends. Filter and group by Product Subset, Style, Container, Price Range, Buyer, and Date Range, and drill down to display performance graphs for individual products in specific locations.
Product Styles

Segment competitive reports by granular user defined product style. View top selling IPA Craft Beers, Caesar Based Coolers, Crisp Light White Wine, or Pear Cider.
Filter by Price Range

Available for LCBO, SLGA, BCLS, and TBS Industry reporting, filter products based on customizable price ranges down to the penny.
Segment by Buyer

Available for LCBO, segment products/line/brand/supplier based on LCBO Buyer to identify various Vintages trends or Direct Delivery vs Warehouse.
Explore by Filtered Territory

Province, Region, District, Sales Rep Territory, and individual stores can be analyzed.
LCBO Category/Subset Trend

A detailed rolling Year-Over-Year report listing figures for LCBO Category (Subset) Sales in Units, Volume, Revenue, and the Percentage Change.
Sales Trend By Product / Supplier

A detailed rolling Year–Over–Year report listing figures for competitive Unit Sales, Volume Sales, Revenue, Distribution, and Market Share.
Industry Compare Tool

The Industry Compare Tool allows user to search and select up to 12 products, brands, or producers for comparison. Units, Volume, Performance, Distribution, and Market Share are displayed in either graphical chart format or a scrollable data table.
Product Overview

Product Overview displays a detailed view on any product in the LCBO. View Rank, Product Details, Distribution, Average Weekly Sales (Units / Volume), Year Over Year Sales, Top Locations, and Recent Sales over time for products in any Subset.
Compare Product Performance

DigThisDate allows you to compare the performance of one of your own products with that of a competitors —by Region, District, or Provincially. See where other vendors are excelling and understand which locations your product is best suited.
LCBO & BCLS Promotions

View complete weekly product promotions of all types over time to better understand sudden spikes in competitor sales. Monitor the success of a promotion and its impact on product movement.
Licensee Sales

Report on sales made to Licensees for all products —filterable by Subset in specific Districts, or Provincially.
LCBO Vintages Sales

Locate LCBO Vintages competitor sales and chart out channel performance —filterable by Subset in specific Stores, Districts, or Provincially.
Compare Competitors Sales per Location

Dig deeper into competitors sales and identify locations where performance is strong —by Region, District, or Provincially.
Location Detail Trend Comparison

Select up to 6 competitors over a time span of up to a year and generate a trend chart comparing Units, Cases, Volume, and Revenue. Additionally, add one of your own products to the mix to see how you’re performing. Available for both LCBO and TBS.
Product Rankings per Store

DigThisData ranks product performance for any location. View which products lead the pack by week or customize the reporting date range to your needs.
Pricing Trend & Analysis

Available for all LCBO products, view Volume Unit Sales by Price Point with Mean, Max and Min pricing by week with Standard Deviation for specified product categories.
Licensee Directory

DigThisData provides the complete update–to–date licensee list to all subscribers for each Province. The directory is updated daily and currently lists tens of thousands of licensees.

Integrated CRM

Manage Accounts, Tasks, & Contacts.

View Pipeline Status

Set sales pipeline statu and monitor progress over time

Accounts

Assign and set Account priority status for potential customers.
Pipelines

Set Pipeline status for all Accounts and monitor progression.
Tasks

Assign tasks to any team member with priorities from Top to Low. Create repeating tasks and have the system create and email calendar invites for your staff.
Calendar Integration

Generate calendar events using Google Calendar, Apple Mail, Microsoft Exchange, or any other calendar client.
Contacts

Easily manage account contacts and define phone numbers and email addresses.
Activity Logging

Log all interaction activity categorised by activity type (Meeting, Voice Call, Email, etc)
Tagging

Custom Tag any account, task, activity or note easily for quick searhing and segmentation.
Day Planner

For sales reps on the road, click to add accounts to your Day Plan and view your route on a dynamic map. Start your day and then check in at each location to auto–calculate mileage for reimbursement.
Mileage Tracking

Track mileage used by your sales reps as they move through their Day Plan. Using check–ins at each location, the system will calculate mileage from point to point for gas reimbursement.
Document Management (Image/Camera Uploads)

Upload images for any retail or on-premise account. Found either in the Call Day Store Detail (Document Management) or dedicated CRM (Docs) view, photos can be uploaded and stored quicly and simply. The mobile experience launches the embedded camera for easy photo logging. Both title and descriptions are available for each upload.
Manager’s Dashboard

Monitor your team and report on pipeline movement, current pipeline distribution, notes, order, recent activity, mileage and more.

Warehouse Management

Have line–of–sight into Owned, 3rd Party, LCBO, and TBS warehouses.

Owned & 3rd Party

Real–time inventory availability for owned and 3rd party warehouses.

Prevent Over Ordering

DigThisData updates and alerts sales reps instantly of available warehouse inventory changes.

Add and Manage Warehouses

Add an unlimited number of Owned and 3rd Party warehouses including your logistics company’s
Manage Warehouses Inventory

Easily add, adjust, transfer, or remove inventory for all your products and include notes and date stamps.
View SLBA, Liquor Connect, LCBO & TBS Warehouses Inventory

Daily updated inventory levels from all LCBO and TBS warehouses combined with a 30 day history.
Owned, 3rd Party, LCBO, & TBS Warehouse Stock Out

Predict warehouse inventory stock out based on shipment history.
Inventory History

Designed to make calculating excise taxes a little easier, DigThisData provides granular warehouse inventory history that reports on additions, transfers, damaged products, adjustments and orders.
SLBA, Liquor Connect, LCBO & TBS Warehouse History

Weekly warehouse level snapshots gives you line–of–sight into inventory depletion rates and re–stocks.
Real–Time Inventory Feeds

DigThisData updates and alerts sales reps instantly of available warehouse inventory changes.
Instantly Switch Warehouses

Swap one supply warehouse for another for individual order with ease.
Pre Order Override

Place pre–orders prior to having inventory available.
Non Inventory Items

Mix non–inventory items with inventory tracked items and combine them in orders.

System Wide

Organize, filter, and segment.

Compatible with all devices including phones, tablets, laptops, and desktops.

Unlimited Users

No seat licenses, no limitation. Invite as many users to your account as you want.

Four User Roles

Grant granular access to your team.

Granular Date Selection

All reports contain configurable date range selections enabling week, month, year, sales period, and custom date range reporting.
Automated SLGA, MBLL, Liquor Connect, BCLS, TBS, and LCBO Data Ingestion

DigThisData automatically ingests your daily and weekly data files without user intervention. Credentials required.
Multiple File Upload

Upload an unlimited number of data files from LDB, LCBO, and TBS at once. DigThisData works through the queue and updates you on progress. Have data for the past year? No problem. Select all files and with the single click of a button, reporting can be provided for the year.
Product Groups

Create an unlimited number of Custom Product Groups to easily filter reports. Act as an agent for other vendors? Create reports specific to each of your vendors with ease.
Customer Groups

Create an unlimited number of Custom Customer Groups to easily filter reports.
Filter by Sales Representatives

Assign specific retail locations to individual users for quick reporting on Sales Representative performance.
Define Store Meta Data

Easily create profiles for each SLGA, MBLL, Liquor Connect, BCLS, LDB, TBS, or LCBO location defining the Manager, Additional Contacts, Contact Info, Delivery Dates (weekly or bi–weekly), Inventory Threshold, Call Day, Logistics Company, and Notes. Once defined, order will automatically pull information during the order process.
Litre, Hectolitre, or 9 Litre Case Reporting

Set a global setting to report volume in either Litres, Hectolitres or 9 Litre Cases.
Unlimited Users

DigThisData supports unlimited users. As your team grows, add them to the system at no additional cost.
4 Users Roles

DigThisData supports 4 user roles that allow you to grant access to your staff in a granular way. Besides the default Admin role, Managers can invite users, Full Staff can see numbers company wide, and Limited Staff are restricted to their own defined store locations and sales figures.
Multiple Agent Number Support (LCBO & TBS)

Have more than one LCBO Agent Code? More than one TBS Brewer Code? No problem. Add Agent Codes to your account and toggle between them with ease.
The Beer Store Reporting

Optionally enable TBS reporting and receive full reporting for TBS sales, industry, and performance.
Export Reports to Excel & PDF

Distribute reports to stakeholders easily by exporting reports to PDF and Microsoft Excel formats.
Mobile and Tablet Compatible

DigThisData can be installed as a cutting edge PWA application on all mobile phones and tablet devices for instant on–the–road access. Tested on iPhone 5 and older Samsung Android products.
Account Usage Reporting

Admin level roles have access to recorded login and page view activity of all users.
Bank Level Security

DigThisData establishes direct communications with our servers using industry standard 256 bits SSL encryption. We prioritize security measures to keep your critical data safeguarded.
Cloud Based Infrastructure

With a cloud based infrastructure, there are no installation requirements or IT expenses on the customer’s part. Upgrades and feature enhancements are rolled out frequently without the need for software upgrades.
No Upfront Costs, Cancel Any Time

We’re so confident you’ll love DigThisData, we offer a 14 day free trial that converts to paid plan without any set up fees or contractual obligations.