Whitespace

Whitespace Tab

The Whitespace Tab contains two sub tabs: Options and Import Data

Options Tab

The Options sub tab shows:

• Price Quantity Mode

  • Determines whether to use Price (Price Based) or Quantity (Quantity Based) as the primary data point and displays in the Whitespace Map accordingly.
    Price Based Example:

    

    Quantity Based Example:

    

• Available Attributes - List of available Product Lines and Metrics

  • These items are created in Custom Attributes (ClosePlan Admin Tab > Custom Attributes) or in deployed Templates.

• Selected Product Lines - List of selected Product Lines that will be added to the Template. Items can be reordered and deleted from the list.

• Selected Metrics - List of selected Metrics that will be added to the Template. Items can be reordered and deleted from the list.

Create Product Line Groups with Hierarchy

Product Lines can be grouped in a hierarchy.

Create the Parent

• Click on the Add Product Group button in the top right corner

  

• Name the Group and click Save or Save & New to create additional Groups

  

• Arrange the Groups and the Whitespace Product Line items as needed.
  Example:

  

 Import Data sub tab

The Import Data sub tab displays a list of jobs that have been run on the Template version selected.

The Import Data feature allows ClosePlan Admins to create, update or bulk upload Account Plan Whitespace items, Product Lines and Business Units/Groups using a CSV file.

• The Import Data sub tab is functional only in Active or Archived versions of Account Plan Templates.

• The Import Data sub tab is not active in Draft versions of Templates.

Example of Blank Import Data sub tab page:

Example of Import Data sub tab with previously run jobs:

• Import Data All Records - This page displays a list of processed jobs and related information.

• Upload Files - Uploads a CSV file (Based on the downloaded Template).

  • Note: Uploading the Template based CSV creates a new Account Plan or updates an existing Account Plan in the current Account.

    • See the section Bulk Upload Whitespace Items below

  • A new Account Plan is created in the Account when there is no Account Plan present
    OR

  • Existing Account Plans do not match all of the following:

    • Account ID

    • Template ID

    • Start/End Period Range

  • An existing Account Plan is updated when the Account Plan record matches all of the following:

    • Account ID

    • Template ID

    • Start/End Period Range.

• Download Template - Downloads a CSV file with sample Whitespace information based on the current Account Plan Template version

  • See below for information about the CSV file.

• Eye Icon - Click to view the CP: Async Job Log - This log provides additional information about the processed job and the associated files

• Start - Indicates the date and time the Upload Files process started

• End - Indicates the date and time the Upload Files process finished

• Status - Displays the status of the process

  • Finished: The process is finished with one or more errors that did not result in failure

  • Failed: The process was not completed for any reason

  • Processing: The process is in progress, not yet completed

  • Succeeded: The process finished successfully with no errors

• Uploaded File - Click icon to download the original uploaded file

• Results File - Click icon to download CSV information about the processed job

• Message - Provides a brief overview of processed jobs.

Bulk Upload Whitespace Items

To Bulk Upload Whitespace Items:

Go to ClosePlan Admin > Templates > Select the Account Plan Template you need > Whitespace tab > Import Data and click on ‘Download Template’

Sample of the Downloaded Template CSV

The CSV file that is downloaded from the Download Template button is used to create and assign Whitespace information that will update or create Account Plans in multiple Accounts.

Populate the Template with the Required information.

If needed, populate the Template with optional information

The fields are as follows:

• Account ID (Required*): This column holds the Salesforce Account ID.

  • Use the 15 or 18 character ID

  • Each Product or Metric item that is needed for a single Account will require that the Account ID cell is populated with the Account ID.

    • Example: If 3 product lines are entered, each line will require the corresponding Account ID

• Status (Optional): 

  • Assign Status:

    • Open

    • Deployed

    • Opportunity

    • Competitor

  • Updates the Product Line Status

  • Note: If you are building a file to upload the Whitespace Metrics, this field should be null

• Market Value (Optional): Applies to updating the Product Line “Market Value” in the Whitespace Map

• Our Share (Optional): Applies to updating the Product Line “Our Share” in the Whitespace Map

• Metric Value (Optional): Represents the value to be set if you are updating a Whitespace Metric (As Opposed to a Product Line Status)

• Product/Metric Name (Required*): The Product Line Name or Metric Name

• Business Unit (Required*): The Business Unit Name

• Business Unit Group (Optional): 

  • The Parent Group of the Business Unit 

  • Note: This field is only needed if you are creating a new Business Unit in your Whitespace map and you want to ensure it has a proper Parent Group

• Period Start Date (Optional): The Account Plan Period Start Date for the Account Plan you wish to create or update

  • NOTE: Format must be: YYYY-MM-DD

• Period End Date (Optional): The end date for the Account Plan Period

  • NOTE: Format must be: YYYY-MM-DD

• Currency (Optional):

  • Multicurrency must be enabled

  • If left null, will default to company currency 

Populate the Template with the required and optional information

Example:

Upload the Template

After the Template has been populated with the required and optional information return to the same template: ClosePlan Admin > Templates > Select the Account Plan Template you need > Whitespace tab > Import Data and click on Upload Files

Select the updated Template and click Open

The Job will process.

Click Done

When the upload is completed, you will see the job listed in the All Records section.

Success looks like this: