Implementation > Import Pipelines

When first setting up your WorkBook system, a starting set of data can be imported, including your Pipelines. To import data successfully it is important to understand the data structures and the format required in the import data sheet.

Things to note:

  • Data is imported once, so it is important to ensure accuracy and consistency prior to uploading.

  • Not all fields are required at import, optional fields can be added to the system manually at a later date when/as required.


IMPORT PIPELINE

Download the Pipeline import file below.

  File Modified

Microsoft Excel Spreadsheet PipelineImplementationImport.xlsx

Apr 28, 2021 by Chris Vo

COLUMN HEADER

FIELD DESCRIPTION

FORMAT

REQUIRED

COLUMN HEADER

FIELD DESCRIPTION

FORMAT

REQUIRED

Company

Company number: The company ID that the pipeline should be created under.

If you only have 1 company the ID is always 1. Reach out to your Consultant if you are not sure what to enter.

Number

 

Yes

PipelineRefNum

Unique ID to identify the pipeline in the database.

This is not used in the interface.

Number & Letter

Yes

PipelineName

Name of the pipeline.

Text

Yes

Resource

Use the unique code that you used for the Prospect/Clients in the “Prospect” and “Clients & Debtors” import. This is how WorkBook knows which prospect/customer the pipeline applies to.

Text

Yes

ResourceType

Type of resource: identify if the resource is a Prospect or Customer

Text

 

Yes

Responsible

ID of the person responsible for managing the pipeline. Use the same number used in the employee import.

 

Number & Letter

Yes

ResourceContact

The name of the client contact for this pipeline. 
Refer to the contacts you have entered in Import > Contacts

Text

No

Active

Is the pipeline is active?

Number

1 = Active
0 = Inactive

Yes

Rating

To identify the rating of the pipeline.

Text

Yes

Status

To identify the status of the pipeline

Text

Yes

Stage

To identify the Stage of the pipeline. The following status can be selected.

  • Cold: When the Net Revenue/Gross Profit is zero

  • Lead: When Net Revenue/Gross Profit is greater than zero and below break percentage set under system variable 679

  • Opportunity: When Net Revenue/Gross Profit is greater than zero and above break percentage set under system variable 679

  • Lost: to mark this opportunity is lost

Text

Yes

StartDate

The date when the Pipeline is expected to be started.

Date

Yes

Months

How many months the project is expected to run for.

Number

No

Probability

The probability percentage of winning this Pipeline and convert this into a job.

Number

Yes

Currency

The currency used on the pipeline.
Must use the ISO code. E.g. EUR, AUD, SGD, USD, GBP

Text

Yes

GrossProfit

The expected Net Revenue/Gross Profit you believe you would be receiving on this Pipeline.

Number

Yes

GrossRevenue

The Gross Revenue value is used for reference purpose only. This value will not be used any where in WorkBook.

Number

No

Comment

Internal note / remarks on the pipeline.

Text

No

JAN

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to the client in this X-month of the current year.

Number

No

FEB

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to the client in this X-month of the current year.

Number

No

MAR

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to the client in this X-month of the current year.

Number

No

APR

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to the client in this X-month of the current year.

Number

No

 MAY 

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to the client in this X-month of the current year.

Number

No

 JUN 

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to the client in this X-month of the current year.

Number

No

 JUL 

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to the client in this X-month of the current year.

Number

No

 AUG 

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to the client in this X-month of the current year.

Number

No

 SEP 

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to the client in this X-month of the current year.

Number

No

 OCT 

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to the client in this X-month of the current year.

Number

No

 NOV 

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to the client in this X-month of the current year.

Number

No

 DEC

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to the client in this X-month of the current year.

Number

No

 JAN+1 

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to the client in this X-month of the next year.

Number

No

FEB+1

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the next year.

Number

No

MAR+1

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the next year.

Number

No

APR+1

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the next year.

Number

No

MAY+1

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the next year.

Number

No

JUN+1

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the next year.

Number

No

JUL+1

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the next year.

Number

No

AUG+1

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the next year.

Number

No

SEP+1

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the next year.

Number

No

OCT+1

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the next year.

Number

No

NOV+1

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the next year.

Number

No

DEC+1

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the next year.

Number

No

 JAN+2 

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the year after next year.

Number

No

FEB+2

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the year after next year.

Number

No

MAR+2

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the year after next year.

Number

No

APR+2

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the year after next year.

Number

No

MAY+2

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the year after next year.

Number

No

JUN+2

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the year after next year.

Number

No

JUL+2

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the year after next year.

Number

No

AUG+2

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the year after next year.

Number

No

SEP+2

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the year after next year.

Number

No

OCT+2

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the year after next year.

Number

No

NOV+2

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the year after next year.

Number

No

DEC+2

If using Billing Plan on Pipeline (System Variable 962 is enabled), this field is used for identifying the amount that will be billed to client in this X-month of the year after next year.

Number

No

Dim1

Name of desired custom dimension (reporting parameter).

Text

No

Dim2

Name of desired custom dimension (reporting parameter).

Text

No

Dim3

Name of desired custom dimension (reporting parameter).

Text

No

Dim4

Name of desired custom dimension (reporting parameter).

Text

No

Dim5

Name of desired custom dimension (reporting parameter).

Text

No

Dim6

Name of desired custom dimension (reporting parameter).

Text

No

Dim7

Name of desired custom dimension (reporting parameter).

Text

No

Dim8

Name of desired custom dimension (reporting parameter).

Text

No

Dim9

Name of desired custom dimension (reporting parameter).

Text

No

Dim10

Name of desired custom dimension (reporting parameter).

Text

No

Division

Used to assign the Division dimension to the Pipeline.
Leave blank if not used.

Text

No

Department

Used to assign the Department dimension to the Pipeline.
Leave blank if not used.

Text

No

Product

Used to assign the Product dimension to the Pipeline.
Leave blank if not used.

Text

No

Job type

Used to assign the Job type dimension to the Pipeline.
Leave blank if not used.

Text

No

Platform

Used to assign the Platform dimension to the Pipeline.
Leave blank if not used.

Text

No

Country

Used to assign the Country dimension to the Pipeline.
Leave blank if not used.

Text

No

Region

Used to assign the Region dimension to the Pipeline.
Leave blank if not used.

Text

No

Quality level

Used to assign the Quality level dimension to the Pipeline.
Leave blank if not used.

Text

No

Customer segment

Used to assign the Customer Segment dimension to the Pipeline.
Leave blank if not used.

Text

No

Customer group

Used to assign the Customer Group dimension to the Pipeline.
Leave blank if not used.

Text

No

Job sales manager

Used to assign the Job Sales Manager to the Pipeline.
Leave blank if not used.

Text

No

Job production manager

Used to assign the Job production Manager to the Pipeline.
Leave blank if not used.

Text

No

Profit center

Used to assign the Profit Centre dimension to the Pipeline.
Leave blank if not used.

Text

No

Practice area

Used to assign the Practice Area dimension to the Pipeline.
Leave blank if not used.

Text

No

Consulting center

Used to assign the Consulting Centre dimension to the Pipeline.
Leave blank if not used.

Text

No

Technology

Used to assign the Technology dimension to the Pipeline.
Leave blank if not used.

Text

No


Related articles

 

© Tangram 2022. All rights reserved.