Implementation > Import Pipelines
- Chris Vo
- Kat Grinter
- Nicky Harvey
- Kye Hush
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.
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. | Text | No |
Active | Is the pipeline is active? | Number 1 = Active | 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.
| 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. | 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. | Text | No |
Department | Used to assign the Department dimension to the Pipeline. | Text | No |
Product | Used to assign the Product dimension to the Pipeline. | Text | No |
Job type | Used to assign the Job type dimension to the Pipeline. | Text | No |
Platform | Used to assign the Platform dimension to the Pipeline. | Text | No |
Country | Used to assign the Country dimension to the Pipeline. | Text | No |
Region | Used to assign the Region dimension to the Pipeline. | Text | No |
Quality level | Used to assign the Quality level dimension to the Pipeline. | Text | No |
Customer segment | Used to assign the Customer Segment dimension to the Pipeline. | Text | No |
Customer group | Used to assign the Customer Group dimension to the Pipeline. | Text | No |
Job sales manager | Used to assign the Job Sales Manager to the Pipeline. | Text | No |
Job production manager | Used to assign the Job production Manager to the Pipeline. | Text | No |
Profit center | Used to assign the Profit Centre dimension to the Pipeline. | Text | No |
Practice area | Used to assign the Practice Area dimension to the Pipeline. | Text | No |
Consulting center | Used to assign the Consulting Centre dimension to the Pipeline. | Text | No |
Technology | Used to assign the Technology dimension to the Pipeline. | Text | No |
Related articles
© Tangram 2022. All rights reserved.