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.
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 LCBO 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.
LCBO 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 Store Rank

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

Combined with the LCBO and TBS Store Rank, visualize which locations carry your products and identify top performing locations for your subsets that don’t.
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.
LCBO & TBS Licensee Sales

Display LCBO & TBS sales and shipments to all licensee locations throughout the province with details on products and quantities.
LCBO 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.

Sales Management

Supporting three channels: LCBO, TBS, & Direct Sales

Now with GMS, DDVP and TBS Purchase Order support

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 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 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.
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 Lading

Select Retail and Direct orders and generate PDF Packing Slips / Bill of Ladings consolidated into a single PDF with the click of a button.
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.
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 Product

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.
Locations Map

Find LCBO, LCBO Agency, Grocery, and TBS locations near you instantly with our GPS location aware interactive map.
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.
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 LCBO 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 LCBO Product Data Included

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

LCBO & TBS Industry Support

Perform market research an analysis on data available from both TBS and the LCBO.
All LCBO Industry Data Included, Free of Charge

DigThisData includes industry data for every product in the LCBO 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 LCBO – including Vintages.
Industry Overview

Displaying the top performing products for the Province, Region, and District, the overview is a glimpse into current industry trends. Filter by Product Subset and Date Range, and drill down to display performance graphs for individual products in specific locations.
Filter by Price Range

Available for LCBO and TBS Industry reporting, filter products based on customizable price ranges down to the penny.
Explore by Filtered Territory

Province, Region, District, 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 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.
LCBO Licensee Sales

Report on sales made to Licensees for all LCBO 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 store at the LCBO (by Subset) or The Beer Store. 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.
TBS Licensee Directory

DigThisData provides the complete update–to–date licensee list to all subscribers. The directory is updated daily and currently lists over 24,500 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.
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)
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 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.
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, LCBO period, and custom date range reporting.
Automated LCBO Data Ingestion

DigThisData automatically ingests your daily and weekly Sale of Data files without user intervention. LCBO credential required.
Automated TBS Data Ingestion

DigThisData automatically ingests your daily transactional and weekly Sale of Data files without user intervention. TBS SFTP credentials required.
Multiple File Upload

Upload an unlimited number of data files from 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 LCBO store defining the Manager, Additional Contacts, Contact Info, Delivery Dates, 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.