Supported file format: .CSV only. Please convert all your files into a .CSV before attempting to import data to the web application.
There are 4 important things that you'd need to know about when you import sales goals from a .CSV file. They are described in detail below:
Preparing your CSV file
The first row of the CSV file will be treated as the header. Make sure the header rows have all the mandatory columns.
Fields available for mapping
User email- Email of the user to whom the goal will be assigned
Goal type- Specify whether it is a User goal or a Team goal
Goal metric- Should be either Deal Value or Deal Count based on whether the goal is measured based on the Deal value of won deals or the number of won deals respectively.
Goal period- Whether it is a Weekly, Monthly, Quarterly, or Yearly goal.
Goal start date- This should be either the first day of the week, month, quarter, or year depending on whether the period is weekly, monthly, quarterly, or yearly.
Goal end date- This should be either the last day of the week, month, quarter, or year depending on whether the period is weekly, monthly, quarterly, or yearly.
Target- What the target of this goal. (Must be a number)
Team- This field is mandatory when the row contains a team goal
Product- Specify the products if you want to set the goal for only specific products. Leave blank to have the goal for all products.
Territory- Specify the products if you want to set the goal for only specific territories. Leave blank to have the goal for all territories.
Pipeline- Specify the products if you want to set the goal for only specific pipelines. Leave blank to have the goal for all pipelines.
Note: The difference between the Goal start date & Goal end date should be one week, one month, one quarter, or one year depending on the goal period. Ex.: If you are setting a Goal for the month of July 2020, then the Goal start date should be 01-July-2020 and the Goal end date should be 31-July-2020.
To import team goals:
You would need to have value as Team under the Goal type column and the team name under the Team column.
You need to have a row for each team member. In case you miss adding a team member in the CSV, the user won’t be considered as part of the team goals
Summation of individual team members goals will be the team goal
Importing the file
Go to Profile picture > Sales Goals
Click on Add Goals dropdown and select Import goals.
Upload the CSV file and click This . presents you with a mapping screen where you can map the fields in the CSV file with the fields of your web application.
Click to commence importing the goals.
Why did some of my data not get imported? (Reasons for failure of data import)
When importing sales goals, these are the possible reasons for the failure of data import:
Invalid user email: If the user is not present in your system or the email is in incorrect
Wrong goal start date: If the Goal start date is greater than the Goal end date
Wrong goal end date: If the Goal end date is in the past
Long-range: When the Goal start date and Goal end date is greater than the goal period