How to: Configure sales rep territories and store details

How to: Configure sales rep territories and store details

Configuring Stores

For all account locations, you can define Sales Reps, Supply Warehouses, Low Inventory Thresholds (where applicable), Delivery Days, Cut Off Times, and more.


To assign variables to a specific store, click on the edit icon to open the Account Edit window. Fill in the fields accordingly and click Save.


Assigning Sales Reps

You can segment reports by Sales Rep territory once the territory is configured. DigThisData provides the ability to assign each retail location to a specific Sales Rep. Open the edit window for a specific location (Sales → Configure Stores for retail, Sales → Configure Customers for licensees) and select the desired Sales Rep from the pull-down menu. Sales Reps will first need to be invited and log in to the system prior to being included in the list.

Under Sales → Configure Customers, it is possible to adjust the Sales Rep from the paginated list. Simply edit the desired Sales Rep from the pull-down list available in each row.


Batch Editing

You can enable Batch Editing of stores by clicking on the checkbox next to the stores you'd like to edit. The topmost checkbox will select/deselect all locations visible. Once more than a single location is selected, a dark blue Batch Edit button will appear in the left Options Panel.

Please note, any field left empty will be ignored.


Bulk CSV Upload (new)

If desired, a Google Sheets or XLSX template is available to complete and ingest into DigThisData. Simply edit the appropriate fields and ingest them into DigThisData using Operations → Import Data Files. Field definitions are available on the second sheet of the template.  Please save a CSV of the first sheet as "territories.csv" for ingestion.

Please note, all reps for a location will be overwritten with values in the CSV. All Channel Acronyms are case-sensitive.


Sales Rep Replace Tool

To re-assign an entire existing territory, click on the Replace Tool in the left Options Panel. Select the Sales Rep that is currently assigned a territory and then the Sales Rep you'd like to acquire all locations. Clicking save will re-assign the entire territory.


Tip: Segment the list by District first, then select an entire region to assign to a Sales Rep.


Import Logistics Schedules

Download a spreadsheet template (either Google or Microsoft) located under the left Options Panel. Copy and paste a schedule by following the field instructions on the second sheet of the document. You can import Delivery Day, Default Delivery Method, and Cut Off Times for any LCBO and TBS location. Once complete, save the first sheet as a CSV (Comma Separated, TSV no longer supported) file and upload to DigThisData using Data → Upload Data Files.

    • Related Articles

    • How to: Assign territories for sales reps

      DigThisData supports multiple Sales Reps per location. A location can be any Retail customer account, or any Direct customer defined in your account. Assigning reps to individual locations is easy and can be accomplished one-by-one or in bulk. Please ...
    • How to: Set up and Configure Call Days

      Call Days is DigThisData's basic Customer Relationship Management (CRM) application. Available to both Advanced and Premium plan users, it provides a way for sales teams to organize their week and store and share critical information for future ...
    • FAQ: Why do the Provincial Leaders and Sales Trend Reports display different numbers?

      The Industry -> Overview / Provincial / Regional / District Leaders reports all contain data that is compiled from LCBO Store sales. Store sales include Counter Sales, Licensee Sales, Agency Sales etc, but do not include items sold through the LCBO ...
    • FAQ: Why do the Provincial Leaders and Sales Trend Reports display different numbers?

      The Industry -> Overview / Provincial / Regional / District Leaders reports all contain data that is compiled from LCBO Store sales. Store sales include Counter Sales, Licensee Sales, Agency Sales etc, but do not include items sold through the LCBO ...
    • FAQ: What is the Sales Velocity Report and how do I read it?

      Sales Velocity reports on weekly sales for 12 weeks ending at the selected date. The report contains four metrics per week: Sales: indicating the number of units sold for the given week in the current fiscal year Velocity: calculated as the ...