/
Basic Sheet Management

Basic Sheet Management

Sheets can be used for a multitude of tasks, including lead lists for OBTM, the bulk upload of agent skills or campaign assignments via API feed, or for the storage of large amounts of data that can be called upon from within a script via integration or custom script object.

  1. Accessing the Sheets
  2. Creating Custom Columns
  3. Editing a Record
  4. Exporting Sheet Data


  1. Accessing the Sheets

  • Click Sheets in the left-hand navigation bar
  • A chronological list of all sheets that have been created will display here, with the most recent at the end of the list
  • To view/edit a sheet, click the blue # button, to the left of the sheet name



    • Sheet Details:
      • API URLsCreated automatically for every sheet, if you require an API call to be used in conjunction with your sheet, those can be copied from here.
      • Name
      • Description [optional]
      • Suspended [defaults to No] leave as-is, this option is used to take the sheet out of service
         Sheets cannot be deleted, only suspended.
  • To create a new sheet here (not associated with OBTM), click +New Sheet 

    • A note on sheet creation: When a new sheet is created from this location, it will not have any pre-populated columns, filters, etc. When a sheet is created for the purpose of leads (via an OB or CB campaign), the sheet will have the standard columns already in place. Sheets for use with OBTM should be created from within the campaign.
      *Lead Sheets are covered here



2. Creating Custom Columns

If you are uploading lead records from a spreadsheet that contains data that is not covered by the standard OBTM columns, or you are starting from a blank sheet, custom column types can be created.

From the Columns tab:

  • The standard column headers for lead lists are shown above. These are the most common parameters, and it is not mandatory that these be utilized.*
    *The exception being the "Locked" columns which are needed for CX Route to call on the records. These columns should not be unlocked or deleted. Doing so will negatively impact the OBTM functions of your campaign.

  • To create your own:
    • Scroll to the empty text box at the bottom of the list and type the name of the column you wish to add
    • Click the second column* to display a list of formatting options

       *Click on the text inside the dropdown to display the list. DO NOT click the down arrow to the right.
      • Alphanumeric [default]
      • Numeric
      • Date/Time
    • Enter the character limit (if required)

      *This field can be left blank if there is no limitation.

    • Click Add
    • The new column will now appear at the end of the list
      • The following can also be adjusted here:
        • Regular [default]/ Unique/ Lookup
          • Regular: column has no input restrictions on it and will allow for multiple records to have the same value.
          • Unique: column is indexed as a Primary key and duplicate entries will be rejected if attempted.
          • Lookup: Index which allows for faster searches in this database. Good for large datasets and does allow for duplicate entries.
        • Unlocked [default]/ Locked
          • When a Lead Sheet is created from an Outbound Campaign, the following columns are set to Locked because they are required for the Outbound Lead Management system:
            • Last Dial
            • Last Disposition
            • All Dials
            • Filter Available
            • Lead ID
            • Contact ID
              *As mentioned above and  in the Lead Sheet article, these default fields are required for OBTM and should not be unlocked or deleted.

    • To delete a column, click Delete (you will be prompted before the entry is removed)
    • To adjust the order the columns appear in this list, click the down/up arrows

      • This column order is reflected on the Records tab of the sheet:
  • Click Update to save and close the columns


    You do not need to delete unused columns if your sheet is not using them.



3. Editing a Record

Once records are imported into a sheet, they can be viewed on the Records tab:

  • Click Edit to bring up the Sheet Record Editor
  • Make any necessary changes in any of the available columns
  • Scroll down and click Update



4. Exporting Sheet Data

Importing data is covered here.

  • Click CSV 
  • A spreadsheet will download using the naming convention:
    sheet_name_mm_dd_yyyy_hh_mm.csv
    (SheetName and timestamp of export)